pom.xml引入
<!--Accaess数据库驱动-->
<!-- https://mvnrepository.com/artifact/net.sf.ucanaccess/ucanaccess -->
<dependency>
<groupId>net.sf.ucanaccess</groupId>
<artifactId>ucanaccess</artifactId>
<version>4.0.4</version>
</dependency>
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class AccaessTest {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
// mdb 数据库路径
String mdbPath = "G://sf.mdb";
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://" + mdbPath);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from Customer");
// 计算有多少条记录
// int count = 0;
// while(rs.next()){
// count++;
// }
while (rs.next()) {
long CustomerNo = rs.getLong("Customer_No");
String Name = rs.getString("Name");
String Sex = rs.getString("Sex");
// Date birthday = rs.getDate("Birthday");
// System.out.println("CustomerNo====="+CustomerNo);
// System.out.println("name====="+Name);
// System.out.println("Sex====="+Sex);
System.out.println(CustomerNo + "\t" + Name + "\t" + Sex);
}
rs.close();
stmt.close();
conn.close();
}
}