连接access数据库的问题
一个简单的bean:
import java.sql.*;
public class userinf
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:userinf";
Connection conn = null;
ResultSet rs = null;
public void main userinf()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("userinf(): " + e.getMessage());
}
}
public ResultSet ExQry(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
java.sql.Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
}
编译通过,但是运行jsp页的时候,提示“No suitable driver”,不过我已经设置odbc数据源了,请高手帮忙