Jsp连接Access数据库问题,帮帮忙,急
//我想测试一下数据库边接,半天没有结果,头都大了,高手帮帮忙,急。
//下面是Default.jsp的内容,和数据库连接代码
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="connBean" scope="page" class="db.ConnAccess"/>
<html>
<head>
<title>bean测试</title>
</head>
<body>
<table width="327" border="1">
<tr align="center">
<td width="89"><div align="center">Id</div></td>
<td width="108"><div align="center">用户名</div></td>
<td width="97"><div align="center">密码</div></td>
</tr>
<%
ResultSet RS_result=connBean.executeQuery("select * from UserInfo");
String Name1="";
String Pwd1="";
while(RS_result.next())
{
Name1=RS_result.getString("userName");
Pwd1=RS_result.getString("userPassword");
%>
<tr align="center">
<td><div align="center"><%=Name1%></div></td>
<td><div align="center"><%=Pwd1%></div></td>
</tr>
<%
}
RS_result.close();
%>
</table>
</body>
</html>
//以下是我的数据库连接bean,生成的ConnAccess.class我放到了WEB-INF/classes/db目录下,可是打
//测试的时候总是提示
//The server encountered an internal error () that prevented it from fulfilling this request.
//请问是什么原因,我该怎么做?
package db;
import java.sql.*;
public class ConnAccess{
String DbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb";
Connection connect=null;
ResultSet rs=null;
public ConnAccess()
{
try {
Class.forName(DbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try {
connect=DriverManager.getConnection(ConnStr);
Statement stmt=connect.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql)
{
int result=0;
try {
connect=DriverManager.getConnection(ConnStr);
Statement stmt=connect.createStatement();
result=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return result;
}
}