dbcpÅäÖÃaccessÊý¾Ý¿â³ö´í

ÇëÎʸ÷λÓÐûÓÐͨ¹ýdbcpÁ¬½Ó¹ýaccessÊý¾Ý¿âµÄ£¬ÎÒÔÚÁ¬½ÓµÄʱºò³öÏÖ no suitable driver´íÎ󣬵«ÊÇÎÒͨ¹ýjdbcÈ¥Á¬½ÓµÄʱºòÊÇÕý³£µÄ
ÒÔÏÂÊÇÎҵĴúÂ룺

Java code:

public class TestConnection {
public static final String user="";
public static final String password="";
public static final String url="jdbc:Access:///D:/mydata/test.mdb?useUnicode=true&characterEncoding=utf-8";

public TestConnection(){
}


public static Connection getConnection(){
try {
Class.forName("com.hxtt.sql.access.AccessDriver");
return DriverManager.getConnection(url,user,password);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}

public static void test(){
Connection con=null;
PreparedStatement psmt=null;
ResultSet rs=null;

try{
con=getConnection();
String sql="select * from users";
psmt=con.prepareStatement(sql);
rs=psmt.executeQuery();
if(rs.next()){
System.out.println(rs.getInt("id"));
}else{
System.out.println("ûÓÐÕÒµ½Êý¾Ý");
}
}catch(Exception e){
e.printSt