Advertisement
Guest User

Untitled

a guest
Sep 12th, 2017
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. private String password = "";
  2. private String dbName = "dataHC.accdb";
  3. private String bd = dbName + ";PWD=" + password;
  4. String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+bd+";";
  5.  
  6. private Connection conn = null;
  7.  
  8. //Connect
  9. public void connect() {
  10. try{
  11. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  12. conn = DriverManager.getConnection(url);
  13. if (conn != null)
  14. System.out.println("Conexión a base de datos "+dbName+". listo");
  15. }catch(SQLException e){
  16. System.out.println(e);
  17. }catch(ClassNotFoundException e){
  18. System.out.println(e);
  19. }
  20. }
  21.  
  22. String database="C:/Users/GIRI/Desktop/fdsfkdsfj/abc.accdb";
  23. String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + database + ";DriverID=22;READONLY=true";
  24.  
  25. try
  26. {
  27. String conUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + filepath;
  28.  
  29. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  30. con=DriverManager.getConnection(conUrl);
  31. }
  32. catch(SQLException s)
  33. {
  34. System.out.println(s);
  35. }
  36.  
  37. package dbase.dbconnection;
  38.  
  39. import java.sql.*;
  40.  
  41. public class MSAccessDbConnect {
  42.  
  43. public static void main(String args[]) throws Exception {
  44.  
  45. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  46.  
  47. String password = "";
  48. String dbName = "D:/maven_ejb_train/DATA/EmpTest.accdb";
  49. String bd = dbName; // + ";PWD=" + password;
  50.  
  51. String connURL = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="
  52. + dbName;
  53. System.out.println("connURL ===== " + connURL);
  54.  
  55. String sql2 = "select * from Employees ";
  56.  
  57. Connection conn = DriverManager.getConnection(connURL, "", "");
  58. System.out.println("aaa 111");
  59. ResultSet rs = conn.createStatement().executeQuery(sql2);
  60. System.out.println("aaa 222");
  61.  
  62. while (rs.next()) {
  63. System.out.println("Name: " + rs.getString("EMP_NA") + " ID: "
  64. + rs.getString("EMP_NO"));
  65.  
  66. }
  67. rs.close();
  68. conn.close();
  69. }
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement