Advertisement
Guest User

Untitled

a guest
Nov 19th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. protected void loginToDatabase() {
  2. Properties properties = new Properties();
  3. String url = "jdbc:postgresql://gegevensbanken.khleuven.be:51516/2TX32?sslfactory=org.postgresql.ssl.NonValidatingFactory";
  4. properties.setProperty("user", "r0372415");
  5. properties.setProperty("password", "TRUMPTRUMPTRUMPTRUMPTRUMPTRUMP");
  6. properties.setProperty("ssl", "true");
  7. properties.setProperty("sslfactory", "org.postgresql.ssl.NonValidatingFactory");
  8.  
  9. try {
  10. Class.forName("org.postgresql.Driver");
  11. } catch (ClassNotFoundException e) {
  12. e.printStackTrace();
  13. return;
  14. }
  15. try {
  16. connection = DriverManager.getConnection(url, properties);
  17. } catch (SQLException e) {
  18. System.out.println("Connection failed");
  19. e.printStackTrace();
  20. return;
  21. }
  22. }
  23.  
  24. protected void closeConnection() {
  25. try {
  26. connection.close();
  27. statement.clearBatch();
  28. } catch (SQLException e) {
  29. e.printStackTrace();
  30. }
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement