我想知道jsp如何通过 不设置数据源来连接access数据库;
<%
ResultSet rs = null ;
Connection conn = null ;
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=a.accdb" ;
String user = "sa" ;
String pass = "" ;
String pp = request.getRealPath(". ") ;
out.print(pp);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
conn = DriverManager.getConnection(url,user,pass) ;
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ;
rs=stmt.executeQuery( "select * from student") ;
out.print( "access 连接成功 ") ;
rs.close() ;
stmt.close() ;
conn.close() ;
}
catch(ClassNotFoundException e){
out.print(e.getMessage()) ;
}
catch (SQLException e){
out.print(e.getMessage()) ;
}
catch(Exception e){
out.print(e.getMessage()) ;
}
%>
页面报错是:[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序