一个很菜的问题
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"><strong>用户名</strong></td>
<td width="11%"><strong>密码</strong></td>
<td width="15%"><strong>真实姓名</strong></td>
<td width="9%"><strong>性别</strong></td>
<td width="12%"><strong>班级</strong></td>
<td width="17%"><strong>email</strong></td>
<td width="24%"><strong>个人主页</strong></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>