Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class OracleConnector {
- public static void main(String[] args) throws ClassNotFoundException, SQLException {
- // Connection URL Syntax: "jdbc:mysql://ipaddress:portnumber/db_name"
- String dbUrl = "jdbc:oracle:thin:@10.5.12.116:1521:desenv01";
- // Database Username
- String username = "bkofficeadm";
- // Database Password
- String password = "bkofficeadmdesenv01";
- // Query to Execute
- String query = "SELECT DS_ESTRATEGIA, ID_ESTRATEGIA" +
- " FROM TB_BKOFFICE_ESTRATEGIA" +
- "WHERE ";
- // Load mysql jdbc driver
- Class.forName("oracle.jdbc.driver.OracleDriver");
- // Create Connection to DB
- Connection con = DriverManager.getConnection(dbUrl, username, password);
- // Create Statement Object
- Statement stmt = con.createStatement();
- // Execute the SQL Query. Store results in ResultSet
- ResultSet rs = stmt.executeQuery(query);
- // While Loop to iterate through all data and print results
- while (rs.next()) {
- String DS_ESTRATEGIA = rs.getString(1);
- String ID_ESTRATEGIA = rs.getString(2);
- System.out.println(DS_ESTRATEGIA + " " + ID_ESTRATEGIA);
- }
- // closing DB Connection
- con.close();
- }
Add Comment
Please, Sign In to add comment