public class Conn { private Connection con; private final String driverName="sun.jdbc.odbc.JdbcOdbcDriver"; private final String urlsoftware="jdbc:odbc:software";
这是我的代码,运行后报错 java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:193) at com.huawei.netcb.Conn.getConn(Conn.java:18) at com.huawei.netcb.WriteExcel.getModcode(WriteExcel.java:84) at com.huawei.netcb.WriteExcel.writeExcel(WriteExcel.java:165) at com.huawei.netcb.WriteExcel.main(WriteExcel.java:226) java.lang.NullPointerException at com.huawei.netcb.WriteExcel.getModcode(WriteExcel.java:99) at com.huawei.netcb.WriteExcel.writeExcel(WriteExcel.java:165) at com.huawei.netcb.WriteExcel.main(WriteExcel.java:226)
con = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\a.mdb");
private Connection con;
private final String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
private final String urlsoftware="jdbc:odbc:software";
public Connection getConn(){
try {
Class.forName(driverName);
con=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\a.mdb");
//
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return con;
}
}
这样写有点错误,再看看
private final String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
public Connection getConn(String DBname){
try {
System.out.println(DBname);
// Class.forName(driverName);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=d://hgtyr.mdb;Persist Security Info=True;Jet OLEDB:Database Password=%$.<+-@8>m5_7"; System.out.println(url);
con=DriverManager.getConnection(url);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return con;
}
}
这是我的代码,运行后报错
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.huawei.netcb.Conn.getConn(Conn.java:18)
at com.huawei.netcb.WriteExcel.getModcode(WriteExcel.java:84)
at com.huawei.netcb.WriteExcel.writeExcel(WriteExcel.java:165)
at com.huawei.netcb.WriteExcel.main(WriteExcel.java:226)
java.lang.NullPointerException
at com.huawei.netcb.WriteExcel.getModcode(WriteExcel.java:99)
at com.huawei.netcb.WriteExcel.writeExcel(WriteExcel.java:165)
at com.huawei.netcb.WriteExcel.main(WriteExcel.java:226)