java连接access数据库-问答-阿里云开发者社区-阿里云

public class ConnectAccess
{
    public static void main(String[] args) throws Exception
    {
        String driver="sun.jdbc.odbc.JdbcOdbcDriver";
        String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=./mytest.accdb";
        String user="";
        String pass="";
        //1.加载驱动。
        Class.forName(driver);
        //2.使用DriverManager获取数据库连接,
        Connection conn = DriverManager.getConnection(url,user,pass);
        //3.使用Connection来创建一个Statment对象
        Statement stmt = conn.createStatement();
        //4.执行SQL语句。
        ResultSet rs = stmt.executeQuery("select * from 学生信息表 ");

        while(rs.next())
        {
            System.out.println(rs.getInt(1) + "\t"
                + rs.getString(2) + "\t"
                + rs.getInt(3) + "\t"
                + rs.getDate(4));
        }
        if (rs != null)
        {
            rs.close();
        }
        if (stmt != null)
        {
            stmt.close();
        }
        if (conn != null)
        {
            conn.close();
        }

    }
}