jdk 1.8 怎么链接access数据库

2024-11-20 17:11:09

1、首先下载驱动包:Access_JDBC30.jar,网上有很多资源下载,可以自行百度

jdk 1.8 怎么链接access数据库

3、输入代码:publicvoidconnectionAccess()throwsException{ Class.forName("com.hxtt.sql.access.AccessDriver") Connectionconn=DriverManager.getConnection("jdbc:Access:///d:/a1.mdb"); Statementstmt=conn.createStatement(); ResultSetrs=stmt.executeQuery("select*fromstudent"); while(rs.next()){ System.out.print(rs.getString(1)+""); System.out.print(rs.getString(2)+""); System.out.print(rs.getString(3)+""); System.out.print(rs.getString("class")+""); System.out.print(rs.getString("stuNumber")+""); System.out.println(rs.getString("time")); } rs.close(); stmt.close(); conn.close(); }

4、运行测试

jdk 1.8 怎么链接access数据库
猜你喜欢