<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%><%
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");
%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%><%
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");
%>
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");
%>
支持一下!
<%@ 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);
}
%>
我原来用jsp访问mysql的时候,要把mysqlconn.jar放在虚拟目录的WEB-INF\lib下面。