import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 纯java代码实现 连接access数据库
* @author xuyl
*
*/
public class ConnectAccessDatabase2 {
public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.access.AccessDriver");
Connection con = DriverManager.getConnection("jdbc:Access:/E://demo.mdb","","");
Statement sta = con.createStatement();
ResultSet rst = sta.executeQuery("select * from email");//demoTable为access数据库中的一个表名
if(rst.next()){
System.out.println("纯java代码实现:" + rst.getString("title"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
链接:https://pan.baidu.com/s/188ITs15chKrWN3hNMF27ZA
提取码:6s1k
--来自百度网盘超级会员V4的分享