Advertisement
Guest User

Untitled

a guest
Jul 24th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.23 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6.  
  7. public class BegliConnect {
  8.  
  9. public static void main(String[] args) {
  10. Connection con = null;
  11. Statement stmt = null;
  12. ResultSet rs = null;
  13. try {
  14. Class.forName("oracle.jdbc.driver.OracleDriver");
  15. con = DriverManager.getConnection("jdbc:oracle:thin:testuser/testpass@//Elitecom1:1521/XE");
  16. stmt = con.createStatement();
  17. rs = stmt.executeQuery("SELECT * FROM person");
  18. while(rs.next()) {
  19. System.out.print(rs.getInt(1) + "t");
  20. System.out.println(rs.getString(2));
  21. }
  22. } catch (ClassNotFoundException e) {
  23. e.printStackTrace();
  24. } catch (SQLException e) {
  25. e.printStackTrace();
  26. } finally {
  27. try {
  28. rs.close();
  29. stmt.close();
  30. con.close();
  31. } catch (SQLException e) {
  32. e.printStackTrace();
  33. }
  34. }
  35. }
  36.  
  37. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
  38. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
  39. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
  40. at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
  41. at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:448)
  42. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
  43. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
  44. at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:383)
  45. at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:776)
  46. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:432)
  47. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
  48. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
  49. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  50. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
  51. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  52. at java.sql.DriverManager.getConnection(DriverManager.java:270)
  53. at BegliConnect.main(BegliConnect.java:18)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement