Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Driver File(s): /Users/Kamil/glassfish4/jdk7/jre/lib/ext/ojdbc7.jar
- Driver Class: oracle.jdbc.OracleDriver
- // this is copied from Services/Databases/Drivers/ojdbc
- try {
- Driver myDriver = new oracle.jdbc.driver.OracleDriver();
- DriverManager.registerDriver(myDriver);
- } catch (ClassNotFoundException ex) {
- System.out.println("Error: unable to load driver class!");
- System.exit(1);
- }
- try {
- Class.forName("oracle.jdbc.OracleDriver");
- } catch (ClassNotFoundException ex) {
- System.out.println("Error: unable to load driver class!");
- System.exit(1);
- }
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection DBconn;
- String USER = "root";
- String PASS = "root";
- System.out.println("Connecting to database...");
- DBconn = DriverManager.getConnection("mysql://localhost:3306/RestToolDatabase", USER, PASS);
- System.out.println("Creating statement...");
- Statement stmt = DBconn.createStatement();
- String sql;
- sql = "select surname, id, agen"
- + "from customers n"
- + "where name = "maria" n"
- + "order by id;";
- ResultSet rs = stmt.executeQuery(sql);
- <dependency>
- <groupId>ojdbc</groupId>
- <artifactId>ojdbc</artifactId>
- <version>14</version>
- <type>pom</type>
- </dependency>
- /Applications/NetBeans/NetBeans 8.0.app/Contents/Resources/NetBeans/ide/modules/ext/mysql-connector-java-5.1.23-bin.jar
- </dependency>
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>5.1.23</version>
- </dependency>
- Class.forName("com.mysql.jdbc.Driver");
- Connection DBconn;
- String USER = "root";
- String PASS = "root";
- DBconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/RestToolDatabase?" + "user="+USER+"&password="+PASS);
- Class.forName("oracle.jdbc.driver.OracleDriver");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement