本人的配置是: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)
急!!!望各位大侠仗义相助,在下,在此先谢过!