Guest User

Untitled

a guest
Aug 17th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class DatabaseTestOne {
  4. public static void main(String[] args) {
  5. String url = "jdbc:oracle://127.0.0.1:8080";
  6. String username = "HR";
  7. String password = "samplepass";
  8.  
  9. String sql = "SELECT EMPLOYEE_ID FROM EMPLOYEES WHERE LAST_NAME='King'";
  10. Connection connection;
  11. try {
  12. connection = DriverManager.getConnection(url, username, password);
  13. Statement statement = connection.createStatement();
  14. System.out.println(statement.execute(sql));
  15. connection.close();
  16. } catch (SQLException e) {
  17. System.err.println(e);
  18. }
  19. }
  20. }
  21.  
  22. ...
  23. // jdbc:oracle:thin:@<hostname>:<port>:<sid>
  24. String url = "jdbc:oracle:thin:@GalacticAC:1521:xe";
  25. ...
  26.  
  27. url="jdbc:oracle:thin:@localhost:1521:orcl"
  28.  
  29. jdbc:oracle:thin:@[HOST][:PORT]:SID
  30.  
  31. jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
  32.  
  33. jdbc:oracle:thin:@<hostName>:<portNumber>:<sid>; (if you have sid)
  34. jdbc:oracle:thin:@//<hostName>:<portNumber>/serviceName; (if you have oracle service name)
  35.  
  36. jdbc:oracle:<drivertype>:<username/password>@<database>
  37.  
  38. DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  39. connection = DriverManager.getConnection("jdbc:oracle:thin:@machinename:portnum:schemaname","userid","password");
Add Comment
Please, Sign In to add comment