主题:  各位大侠!走过,路过不要错过!!!

karlor

职务:普通成员
等级:1
金币:0.0
发贴:52
注册:2002/10/25 19:04:21
#12003/3/27 1:03:46
本人的配置是:WINDOWS 2000+JDK1.3+TOMCAT+MYSQL+com.mysql.jdbc.Driver
在我用DREAMWEAVER MX(以下简称为MX)创建记录集时却无法预览(在连接数据库是没问题的,问题就出在预览上).
我的文件的源代码如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/cn.jsp" %>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_cn_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_cn_STRING,MM_cn_USERNAME,MM_cn_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM cktoo");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%>


创建简单记录集

















Name Password Number Weapon
<%=(((Recordset1_data = Recordset1.getObject("Name"))==null || Recordset1.wasNull())?"":Recordset1_data)%> <%=(((Recordset1_data = Recordset1.getObject("password"))==null || Recordset1.wasNull())?"":Recordset1_data)%> <%=(((Recordset1_data = Recordset1.getObject("nomber"))==null || Recordset1.wasNull())?"":Recordset1_data)%> <%=(((Recordset1_data = Recordset1.getObject("weapon"))==null || Recordset1.wasNull())?"":Recordset1_data)%>



<%
Recordset1.close();
StatementRecordset1.close();
ConnRecordset1.close();
%>

预览时的错误如下:
Error: 500
Location: /testdb/TMP2m6eocd8q5.jsp
Internal Servlet Error:

javax.servlet.ServletException: Column 'Name' not found.
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:449)
    at _0002fTMP_00032m_00036eocd_00038q_00035_0002ejspTMP2m6eocd8q5_jsp_0._jspService(_0002fTMP_00032m_00036eocd_00038q_00035_0002ejspTMP2m6eocd8q5_jsp_0.java:110)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:382)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
    at org.apache.tomcat.core.Handler.service(Handler.java:263)
    at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
    at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:786)
    at org.apache.tomcat.core.ContextManager.service(ContextManager.java:732)
    at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
    at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
    at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
    at java.lang.Thread.run(Thread.java:484)

Root cause:
java.sql.SQLException: Column 'Name' not found.
    at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2278)
    at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:1550)
    at _0002fTMP_00032m_00036eocd_00038q_00035_0002ejspTMP2m6eocd8q5_jsp_0._jspService(_0002fTMP_00032m_00036eocd_00038q_00035_0002ejspTMP2m6eocd8q5_jsp_0.java:74)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:382)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
    at org.apache.tomcat.core.Handler.service(Handler.java:263)
    at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
    at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:786)
    at org.apache.tomcat.core.ContextManager.service(ContextManager.java:732)
    at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
    at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
    at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
    at java.lang.Thread.run(Thread.java:484)
急!!!望各位大侠仗义相助,在下,在此先谢过!



karlor

职务:普通成员
等级:1
金币:0.0
发贴:52
注册:2002/10/25 19:04:21
#22003/3/27 1:17:33
快进来!



缺缺

职务:管理员
等级:8
金币:41.0
发贴:9620
注册:2004/1/14 19:14:47
#32003/3/27 12:20:13
Column 'Name' not found.



karlor

职务:普通成员
等级:1
金币:0.0
发贴:52
注册:2002/10/25 19:04:21
#42003/3/27 15:53:23
我知道啊!
问题是如何解决啊!!!



karlor

职务:普通成员
等级:1
金币:0.0
发贴:52
注册:2002/10/25 19:04:21
#52003/3/27 20:19:24
我知道是什么原因了!是com.mysql.jdbc.Driver的DUG,它上面的README是写的!
不过,我不知道如何解决啊!