Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. Driver File(s): /Users/Kamil/glassfish4/jdk7/jre/lib/ext/ojdbc7.jar
  2. Driver Class: oracle.jdbc.OracleDriver
  3. // this is copied from Services/Databases/Drivers/ojdbc
  4.  
  5. try {
  6. Driver myDriver = new oracle.jdbc.driver.OracleDriver();
  7. DriverManager.registerDriver(myDriver);
  8. } catch (ClassNotFoundException ex) {
  9. System.out.println("Error: unable to load driver class!");
  10. System.exit(1);
  11. }
  12.  
  13. try {
  14. Class.forName("oracle.jdbc.OracleDriver");
  15. } catch (ClassNotFoundException ex) {
  16. System.out.println("Error: unable to load driver class!");
  17. System.exit(1);
  18. }
  19.  
  20. Class.forName("oracle.jdbc.driver.OracleDriver");
  21.  
  22. Connection DBconn;
  23. String USER = "root";
  24. String PASS = "root";
  25. System.out.println("Connecting to database...");
  26.  
  27. DBconn = DriverManager.getConnection("mysql://localhost:3306/RestToolDatabase", USER, PASS);
  28.  
  29. System.out.println("Creating statement...");
  30. Statement stmt = DBconn.createStatement();
  31. String sql;
  32. sql = "select surname, id, agen"
  33. + "from customers n"
  34. + "where name = "maria" n"
  35. + "order by id;";
  36. ResultSet rs = stmt.executeQuery(sql);
  37.  
  38. <dependency>
  39. <groupId>ojdbc</groupId>
  40. <artifactId>ojdbc</artifactId>
  41. <version>14</version>
  42. <type>pom</type>
  43. </dependency>
  44.  
  45. /Applications/NetBeans/NetBeans 8.0.app/Contents/Resources/NetBeans/ide/modules/ext/mysql-connector-java-5.1.23-bin.jar
  46.  
  47. </dependency>
  48. <dependency>
  49. <groupId>mysql</groupId>
  50. <artifactId>mysql-connector-java</artifactId>
  51. <version>5.1.23</version>
  52. </dependency>
  53.  
  54. Class.forName("com.mysql.jdbc.Driver");
  55.  
  56. Connection DBconn;
  57. String USER = "root";
  58. String PASS = "root";
  59. DBconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/RestToolDatabase?" + "user="+USER+"&password="+PASS);
  60.  
  61. Class.forName("oracle.jdbc.driver.OracleDriver");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement