《java访问access数据库》由会员分享，可在线阅读，更多相关《java访问access数据库（7页珍藏版）》请在金锄头文库上搜索。
1、（一）JAVA连接Access数据库博客分类： JDBCAccessJavaSQLJDBCMicrosoftAccesstest代码1. packagecom.yaku.access;2. 3. importjava.sql.Connection;4. importjava.sql.DriverManager;5. importjava.sql.PreparedStatement;6. importjava.sql.Statement;7. 8. publicclassAccessTest9. publicstaticvoidmain(Stringargs)10. try11. Class.f
2、orName(sun.jdbc.odbc.JdbcOdbcDriver);12. /Stringurl=jdbc:odbc:wombat;13. /stringurl=“jdbc:odbc:Driver=MicroSoftAccessDriver14. /(*.mdb);DBQ=“+application.getRealPath(“/Data/ReportDemo.mdb“);15. Stringurl=jdbc:odbc:Driver=MicroSoftAccessDriver(*.mdb);DBQ=C:Test.mdb;16. Connectionconn=DriverManager.ge
3、tConnection(url,);17. Statementstmt=conn.createStatement();18. /ResultSetrs=stmt.executeQuery(deletefromartswhereid=19. /2);20. /System.out.println(arowhasbeenninserted;);21. PreparedStatementps;22. for(inti=0;i1000;i+)23. Stringsex=;24. if(i%2=0)25. sex=M;26. else27. sex=F;28. 29. ps=conn.prepareSt
4、atement30. (insertintotestvalues(+i+,Yaku+i+,+sex+);31. ps.executeUpdate();32. ps.close();33. 34. /rs.close();35. stmt.close();36. conn.close();37. catch(Exceptionex)38. ex.printStackTrace();39. 40. 41. 查询Access数据Select代码1. packagecom.yaku.access;2. 3. importjava.sql.Connection;4. importjava.sql.Dri
5、verManager;5. importjava.sql.ResultSet;6. importjava.sql.Statement;7. 8. publicclassSelect9. publicstaticvoidmain(Stringargs)10. try11. Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);12. /Stringurl=jdbc:odbc:wombat;13. /stringurl=“jdbc:odbc:Driver=MicroSoftAccessDriver14. /(*.mdb);DBQ=“+application.get
6、RealPath(“/Data/ReportDemo.mdb“);15. Stringurl=jdbc:odbc:Driver=MicroSoftAccessDriver(*.mdb);DBQ=C:Test.mdb;16. Connectionconn=DriverManager.getConnection(url,);17. Statementstmt=conn.createStatement();18. ResultSetrs=stmt.executeQuery(SELECT*FROMtest);19. System.out.println(GotResultSetNow);20. /rs
7、.beforeFirst();21. while(rs.next()22. System.out.println(rs.getString(1)+t+rs.getString(2)+t+rs.getString(3);23. 24. rs.close();25. 26. stmt.close();27. conn.close();28. catch(Exceptionex)29. ex.printStackTrace();30. 31. 32. 删除Access数据Delete代码1. packagecom.yaku.access;2. 3. importjava.sql.Connection
8、;4. importjava.sql.DriverManager;5. importjava.sql.PreparedStatement;6. importjava.sql.Statement;7. 8. publicclassDelete9. publicstaticvoidmain(Stringargs)10. try11. Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);12. /Stringurl=jdbc:odbc:wombat;13. /stringurl=“jdbc:odbc:Driver=MicroSoftAccessDriver14.
9、/(*.mdb);DBQ=“+application.getRealPath(“/Data/ReportDemo.mdb“);15. Stringurl=jdbc:odbc:Driver=MicroSoftAccessDriver(*.mdb);DBQ=C:Test.mdb;16. Connectionconn=DriverManager.getConnection(url,);17. Statementstmt=conn.createStatement();18. /ResultSetrs=stmt.executeQuery(deletefromartswhereid=2);19. /Sys
10、tem.out.println(arowhasbeenninserted;);20. PreparedStatementps=conn.prepareStatement(deletefromtestwhereid=1);21. 22. ps.executeUpdate();23. /rs.close();24. ps.close();25. 26. stmt.close();27. conn.close();28. catch(Exceptionex)29. ex.printStackTrace();30. 31. 32. （二）import java.sql.*; class database public static void main(String args) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url=jdbc:odbc:Access2000; Connection connection=DriverManager.getConnection(url); Statement statement = connection.createStatement(); String sql=SELECT * FROM table1; ResultSet rs = statement.execute
