public static void main(String[] args) {
Connection dbCon=null;
Statement stmt=null;
try {
///加载驱动jar
Class.forName("com.hxtt.sql.access.AccessDriver");
//指定Access数据库文件的位置
String url = "jdbc:Access:/d:/school.mdb";
//建立连接
dbCon = DriverManager.getConnection(url, "username", "password");
if(dbCon!=null){
System.out.println("步骤2：连接数据库——成功！");
}
//步骤3：建立JDBC的Statement对象
stmt=dbCon.createStatement();
if(stmt!=null){
System.out.println("步骤3：建立JDBC的Statement对象——成功！");
}
String sSQL="SELECT * FROM Classes";
ResultSet rs=stmt.executeQuery(sSQL);
while(rs.next()){
System.out.print(rs.getString("ID")+" ");
System.out.print(rs.getString("classid")+" ");
// System.out.print(rs.getString("name"));
// System.out.print(rs.getString("sex"));
// System.out.println(" " +rs.getFloat("age"));
}
} catch (Exception e) {
e.printStackTrace();
}
finally{
try{
//关闭步骤3所开启的statement对象
stmt.close();
System.out.println("关闭statement对象");
}
catch(SQLException e){}
try{
//关闭数据库连接
dbCon.close();
System.out.println("关闭数据库连接对象");
}
catch(SQLException e){}
}
}
控制台消息：
步骤2：连接数据库——成功！
步骤3：建立JDBC的Statement对象——成功！
java.sql.SQLException: Failed to load database school! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.aw.int(Unknown Source)
at com.hxtt.sql.access.aw.for(Unknown Source)
at com.hxtt.sql.access.aw.<init>(Unknown Source)
at com.hxtt.sql.access.au.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.aw.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bc.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeQuery(Unknown Source)
at xml.AccessDBHelper.main(AccessDBHelper.java:34)
关闭statement对象
关闭数据库连接对象
求解答
