Guest User

Untitled

a guest
Sep 3rd, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. Oracle java connection
  2. import java.sql.*;
  3.  
  4. public class SimpleOraJava {
  5. public static void main(String[] args) throws SQLException, ClassNotFoundException {
  6. // TODO Auto-generated method stub
  7. DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
  8. String serverName="10.20.228.67";
  9. String user="root";
  10. String password="root";
  11. String SID="abc";
  12. String URL="jdbc:oracle:thin:@"+serverName+":"+1520+":"+SID;
  13. Connection conn=DriverManager.getConnection(URL, user, password);
  14. String SQL="Select employeename from employee";
  15. Statement stat=conn.createStatement();
  16. ResultSet rs=stat.executeQuery(SQL);
  17. while (rs.next()){
  18. System.out.println(rs.getInt(1));
  19.  
  20. }
  21. stat.close();
  22. conn.close();
  23. }
  24. }
  25.  
  26. DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
  27.  
  28. DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
  29.  
  30. import java.sql.*;
  31. import oracle.jdbc.driver.*;
  32.  
  33. public class myjdbcapp
  34. {
  35. public static void main(String[] args) throws SQLException
  36. {
  37. DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
  38. String url = "jdbc:oracle:thin:@server:port:orcl";
  39. String userName = "scott";
  40. String password = "tiger";
  41. Connection conn = DriverManager.getConnection (url, userName, password);
  42. OracleCallableStatement myprocst = (OracleCallableStatement)
  43. conn.prepareCall ("begin myproc(?); end;");
  44. // ...
  45. }
  46.  
  47. }
Add Comment
Please, Sign In to add comment