Access数据库

Microsoft Office Access是由微软发布的关系数据库管理系统，一般下载Office全家桶可以看到，打开后与Excel类似。

Java连接使用jdbc连接即可，不用导入其他包。

import java.sql.*;

public class Connect {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
	
	Class.forName("com.hxtt.sql.access.AccessDriver");

        //数据库路径
        String dbPath = "F:\\database\\grade.accdb";
        Connection conn = DriverManager.getConnection("jdbc:Access:///"+dbPath);
        Statement stmt = conn.createStatement();

        String sql = "insert into year2017 values (5,\'尼德霍格\', \'中国\', \'特批\', \'999\', \'0\')";
        conn.prepareStatement(sql).executeUpdate();
        stmt.executeUpdate(sql);

        ResultSet rs = stmt.executeQuery("select * from year2017");

        while (rs.next()) {
            int id = rs.getInt(1);
            String n1 = rs.getString(2);
            String n2 = rs.getString(3);
            String n3 = rs.getString(4);

            System.out.println(id + " " + n1 + " " + n2 + " " + n3);
        }

        rs.close();
        stmt.close();
        conn.close();
    }
}