81,122
社区成员




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){}
}
}