Connection con;
Statement stmt;
try{
//Load JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//注意DBQ的写法
String url="jdbc:odbc:driver={Microsoft Access Driver
(*.mdb)};DBQ=E://db1.mdb";
con = DriverManager.getConnection(url,"sa","");
stmt = con.createStatement();
String query = "select * from faq";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
String str=rs.getString("name");
out.print(str);
}
}
catch(Exception e){
e.printStackTrace();
}