官方:https://sourceforge.net/projects/ucanaccess/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* 不需DNS的Access数据库连接
*/
public class mdbDB {
public mdbDB() {
// 初始化操作
}
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = null;
String conStr = null;
String path = System.getProperties().getProperty("user.dir");// 当前目录路径
path = path + "\\test.mdb";
System.out.println("数据库所在目录:" + path);
System.out.println();
conStr ="jdbc:ucanaccess:///D:/eclipse/workspace/MyCode/test.mdb";
try {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); //jackcess-2.1.11.jar
conn = DriverManager.getConnection(conStr, "o", "struts");
stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO log4j (sdate,sthread,slevel,scategory,smessage) VALUES ('555','555','555','555','555')");
sql = "select * from mdb";
rs = stmt.executeQuery(sql);
System.out.println("编号" + " 姓名");
System.out.println("==========================");
while (rs.next()) {
System.out.print(rs.getInt("id") + " ");
System.out.print(rs.getString("aa"));
System.out.println();
}
rs.close();
stmt.close();
conn.close();
} catch (java.lang.Exception e) {
System.out.println(e);
}
}
}