<%@ page contentType="text/html; charset=" language="java" import="java.sql.*" errorPage="" %>
改为
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>CachedRowSet resultPage = stmt.getRowSet(SQL);
改为
ResultSet resultPage = stmt.executeQuery(SQL);
改为
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>CachedRowSet resultPage = stmt.getRowSet(SQL);
改为
ResultSet resultPage = stmt.executeQuery(SQL);
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1833)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:395)
at jsp_servlet._access.__liu._jspService(__liu.java:156)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:431)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
这句话中,这个字段名:uanme,是不是有错?
我也不能肯定了.变量的命名,各人都是不一样的.哈哈,,,,,,帮不了你了!
<td> <%=resultPage.getString("uanme")%></td>
<td> <%=resultPage.getString("pwd")%></td>
<td> <%=resultPage.getString("name")%></td>
<td> <%=resultPage.getString("sex")%></td>
<td> <%=resultPage.getString("class1")%></td>
<td> <%=resultPage.getString("email")%></td>
<td> <%=resultPage.getString("zy")%></td>
</tr>
就是在这里!
uanme、pwd、name、sex、class1、email、zy在user表里有这几个字段吗?
你查查看看不起
大小写也要一样!