Advertisement
Guest User

Untitled

a guest
Jan 29th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. public class Connessione {
  2.  
  3. // valori che possono variare in base al database
  4. public static final String NOME_DRIVER = "com.mysql.jdbc.Driver";
  5. public static final String NOME_DATABASE = "parchidivertimento";
  6. public static final String LINK_DATABASE = "jdbc:mysql://localhost/" + NOME_DATABASE
  7. + "?verifyServerCertificate=false&useSSL=true";
  8. public static final String USR_DATABASE = "root";
  9. public static final String PSW_DATABASE = "password";
  10.  
  11. /**
  12. * Genera una connessione col server dove risiede il database
  13. *
  14. * @return oggetto di tipo Connection collegato al database
  15. */
  16. public static Connection connect() {
  17. Connection con = null;
  18. try {
  19. Class.forName(NOME_DRIVER);
  20. con = DriverManager.getConnection(LINK_DATABASE, USR_DATABASE, PSW_DATABASE);
  21. return con;
  22. } catch (Exception ex) {
  23. System.err.println("Error: " + ex);
  24. return null;
  25. }
  26. }
  27.  
  28. /**
  29. * Chiude una connessione con il database
  30. *
  31. * @param con
  32. * connessione col database
  33. */
  34. public static void disconnect(Connection con) {
  35. if (con != null) {
  36. try {
  37. con.close();
  38. } // prova la chiusura
  39. catch (SQLException e) {
  40. } // viene ignorato
  41. }
  42. }
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement