jsp连接access的问题

Question

1.<%@ page language="java" contentType="text/html" %>改成:
  <%@ page language="java" contentType="text/html;charset=GBK" %>
2.System.out.println( "Conneciton is sucessful" );改成:
  out.println( "Conneciton is sucessful" );
3.注意抛异常!
 
其他的再没什么了,再换别的数据源试试!!

Answer 1

<%
String odbcQuery;
Connection odbcConn;
Statement odbcStmt;
ResultSet odbcRs;

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();
//request.setCharacterEncoding("gb2312");
%>

Answer 2

<%
String odbcQuery;
Connection odbcConn;
Statement odbcStmt;
ResultSet odbcRs;

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();
//request.setCharacterEncoding("gb2312");
%>
支持一下！

Answer 3

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="sun.jdbc.odbc.JdbcOdbcDriver"%><%
                String dbPath=application.getRealPath("/");
                System.out.println(dbPath);
                System.out.println("test is ok");
String sql = "select login from user ";
String  url = "sun.jdbc.odbc.JdbcOdbcDriver";
String  dbU = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbPath+"/exam/db1.mdb";

try{
Class.forName(url);
Connection conn = DriverManager.getConnection(dbU);
Statement  stmt = conn.createStatement();

ResultSet  rs   = stmt.executeQuery(sql);
while (rs.next())
{
System.out.println(rs.getString("login"));
}

}catch(Exception ex){
System.out.println("ex ==="+ex);
}
%>