Guest User

Untitled

a guest
Mar 1st, 2018
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. public class OracleConnector {
  2.  
  3. public static void main(String[] args) throws ClassNotFoundException, SQLException {
  4. // Connection URL Syntax: "jdbc:mysql://ipaddress:portnumber/db_name"
  5. String dbUrl = "jdbc:oracle:thin:@10.5.12.116:1521:desenv01";
  6.  
  7. // Database Username
  8. String username = "bkofficeadm";
  9.  
  10. // Database Password
  11. String password = "bkofficeadmdesenv01";
  12.  
  13. // Query to Execute
  14. String query = "SELECT DS_ESTRATEGIA, ID_ESTRATEGIA" +
  15. " FROM TB_BKOFFICE_ESTRATEGIA" +
  16. "WHERE ";
  17.  
  18. // Load mysql jdbc driver
  19. Class.forName("oracle.jdbc.driver.OracleDriver");
  20.  
  21. // Create Connection to DB
  22. Connection con = DriverManager.getConnection(dbUrl, username, password);
  23.  
  24. // Create Statement Object
  25. Statement stmt = con.createStatement();
  26.  
  27. // Execute the SQL Query. Store results in ResultSet
  28. ResultSet rs = stmt.executeQuery(query);
  29.  
  30. // While Loop to iterate through all data and print results
  31. while (rs.next()) {
  32. String DS_ESTRATEGIA = rs.getString(1);
  33. String ID_ESTRATEGIA = rs.getString(2);
  34. System.out.println(DS_ESTRATEGIA + " " + ID_ESTRATEGIA);
  35. }
  36. // closing DB Connection
  37. con.close();
  38. }
Add Comment
Please, Sign In to add comment