Advertisement

Connect_DB

Mar 4th, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.94 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class Connect
  4. {
  5.     static String driver = "oracle.jdbc.OracleDriver";
  6.     static String url = "jdbc:oracle:thin:@190.166.111.222:1521:ADSD";
  7.     static String user = "HH";
  8.     static String pass = "HH";
  9.  
  10.     static public void Connect_With_DB()
  11.     {
  12.         try
  13.         {
  14.             Class.forName(driver);
  15.             System.out.println("Sterownik załadowany!");
  16.  
  17.             Connection con = DriverManager.getConnection(url, user, pass);
  18.             System.out.println("Połączenie nawiązane!");
  19.  
  20.             Statement stmt = con.createStatement();
  21.             ResultSet rset = stmt.executeQuery("SELECT * FROM JOBS;");
  22.  
  23.             while(rset.next())
  24.             {
  25.                 System.out.println(rset.getInt(1) + " " + rset.getString(2));
  26.             }
  27.         }
  28.         catch (Exception error)
  29.         {
  30.             System.err.println("Błąd! " + error.getMessage());
  31.         }
  32.     }
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement