根据网上写的不使用ODBC桥即可以连接ACCESS的方法,写了如下代码——import java.sql.*;
import java.io.*;
class Access{
private static Statement stmt=null;
private static String gvDriver="";
private static String message = "恭喜,数据库连接正常!";
private static Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver ");
Connection conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb");
return conn; }catch(Exception e){
message=e.toString();
}
return null;
}
public static void main(String args[]) throws Exception{
Access cc = new Access();
long lasting = System.currentTimeMillis();
Connection conn=cc.getConnection();
stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from books");
while(rs.next())
{
for(int i=1;i<4;i++)
System.out.print(rs.getString(i));
System.out.println();
System.out.println();
}
System.out.println("运行时间:" + (System.currentTimeMillis() - lasting) + "毫秒");
System.out.println("Connection Successful!");
}
}
但是运行时出现NullPointException异常,请看看错在哪?
提示是错在Main()中Statement行,数据库连接好像是正常de
import java.io.*;
class Access{
private static Statement stmt=null;
private static String gvDriver="";
private static String message = "恭喜,数据库连接正常!";
private static Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver ");
Connection conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb");
return conn; }catch(Exception e){
message=e.toString();
}
return null;
}
public static void main(String args[]) throws Exception{
Access cc = new Access();
long lasting = System.currentTimeMillis();
Connection conn=cc.getConnection();
stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from books");
while(rs.next())
{
for(int i=1;i<4;i++)
System.out.print(rs.getString(i));
System.out.println();
System.out.println();
}
System.out.println("运行时间:" + (System.currentTimeMillis() - lasting) + "毫秒");
System.out.println("Connection Successful!");
}
}
但是运行时出现NullPointException异常,请看看错在哪?
提示是错在Main()中Statement行,数据库连接好像是正常de
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货