JDBC-ODBC连接access的问题

Question

http://61.131.30.54/123/Develop/Java/JDBCAccess.zip

Answer 1

<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%>
<%
String odbcQuery;
Connection odbcConn;
Statement odbcStmt;
Statement odbcStmtExtend;
Statement odbcStmtPage;
Statement odbcStmtUpdate;
ResultSet odbcRs;
ResultSet odbcRsExtend;
ResultSet odbcRsPage;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
odbcConn=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:\\Db_ColligateStatistic\\ColligateStatistic.mdb;","admin","");
odbcStmt=odbcConn.createStatement();
odbcStmtExtend=odbcConn.createStatement();
odbcStmtPage=odbcConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
odbcStmtUpdate=odbcConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
request.setCharacterEncoding("gb2312");
%>

Answer 2

大哥，你早说帐号是admin不就好了> <