java连接Accaess数据库测试demo

pom.xml引入

		
        
        
            net.sf.ucanaccess
            ucanaccess
            4.0.4
        

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();
    }
}