Guest User

Untitled

a guest
Aug 28th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. How to connect java to Ms Access 2010?
  2. public void loadDb(){
  3. try{
  4. Class.forName("sun.jdbc.JdbcOdbcDriver");
  5. File f = new File(System.getProperty("user.dir"))
  6. con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
  7. st = con. createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
  8. }catch(ClassNotFoundException e){e.printStackTrace();
  9. }catch(SQLException e){e.printStackTrace();}
  10. }
  11.  
  12. //con and st are already defined
  13.  
  14. public static Connection getConnection() {
  15. String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
  16. String url = "jdbc:odbc:anime"; //anime is the database
  17. String username = "ipieluser"; //leave blank if none
  18. String password = "ipielpassword"; //leave blank if none
  19. try {
  20. Class.forName(driver);
  21. } catch (ClassNotFoundException e) {
  22. e.printStackTrace();
  23. }
  24. try {
  25. return DriverManager.getConnection(url, username, password);
  26. } catch (SQLException e) {
  27. // TODO Auto-generated catch block
  28. e.printStackTrace();
  29. }
  30. return null;
  31. }
  32.  
  33. public static void main(String args[]) {
  34. try {
  35. Connection conn = getConnection();
  36. Statement st = conn.createStatement();
  37. st = conn.createStatement();
  38. ResultSet rs = st.executeQuery("SELECT * FROM localTable");
  39.  
  40. //get and displays the number of columns
  41. ResultSetMetaData rsMetaData = rs.getMetaData();
  42. int numberOfColumns = rsMetaData.getColumnCount();
  43. System.out.println("resultSet MetaData column Count=" + numberOfColumns);
  44.  
  45. st.close();
  46. conn.close();
  47. } catch(Exception e) {
  48. System.out.println(e.getMessage());
  49. }
  50. }
  51.  
  52. con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
  53.  
  54. con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
Add Comment
Please, Sign In to add comment