一个很菜的问题

ys333 2004-05-05 10:22:26

我用jsp连接access,提交已经做出来了，可是从数据库读取却总是出错，下面是数据库读取的代码—>

<%@ page import="java.sql.*"%>
<%@ page contentType="text/html; charset=" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>浏览用户</title>
</head>
<body>
<table width="71%" border="1">
<tr align="center">
<td width="12%" height="30">用户名</td>
<td width="11%">密码</td>
<td width="15%">真实姓名</td>
<td width="9%">性别</td>
<td width="12%">班级</td>
<td width="17%">email</td>
<td width="24%">个人主页</td>
</tr>
<%
request.setCharacterEncoding("GBK");
String url=new String();
url="jdbc:odbc:access";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String SQL=new String();
SQL = "select * from user";
CachedRowSet resultPage = stmt.getRowSet(SQL);
while(resultPage.next() )
{%>
<tr>
<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>
<%}%>
<%resultPage.close();%>
</table>
</body>
</html>

...全文

9 6 打赏收藏举报

写回复

6 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

ys333 2004-05-05

还是不行呀，它又出现下面这个错误，顺便说一下我用得是weblogic平台：

Error 500--Internal Server Error
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)

打赏
举报

回复赞

fuzuyuan 2004-05-05

<%@ 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);

打赏
举报

回复赞

ys333 2004-05-05

哈哈，楼上(过街老鼠) 说对了，就是这个错误，非常感谢呀

打赏
举报

回复赞

jiankou2001 2004-05-05

你的数据库里的表的字段名和你程序里的定义的不一致！
<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表里有这几个字段吗？
你查查看看不起
大小写也要一样！