public AccessDb(){
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft Access Driver " +
"(*.mdb, *.accdb)};DBQ=F:\\dome.accdb";
Connection con = DriverManager.getConnection(url);
System.out.println("Connected!");
String sql = "select * from numinfo";
pstmt.executeQuery();
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(2));
}
pstmt.close();
rs.close();
con.close();
}
catch (SQLException e)
{
System.out.println("SQL Exception: "+ e.toString());
}
catch (ClassNotFoundException cE)
{
System.out.println("Class Not Found Exception: "+ cE.toString());
}
执行这段代码报错了,如下:
Connected!
Exception in thread "main" java.lang.NullPointerException
at com.db.AccessDb.(AccessDb.java:24)
at com.db.AccessDb.main(AccessDb.java:44) 那位大哥帮我好好看看啊,急用!