Guest User

Untitled

a guest
Dec 22nd, 2018
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. package check;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.SQLException;
  6.  
  7. public class Main {
  8. public static void main(String[] args) {
  9. try {
  10. Class.forName("com.mysql.jdbc.Driver");
  11. } catch (ClassNotFoundException e) {
  12. e.printStackTrace();
  13. }
  14. Connection conn = null;
  15. try {
  16. conn = DriverManager.getConnection("jdbc:mysql://mysql.zzz.com.ua:3306/angruh","testdb", "Test1111");
  17. } catch (SQLException e) {
  18. e.printStackTrace();
  19. }
  20. try {
  21. conn.close();
  22. } catch (SQLException e) {
  23. e.printStackTrace();
  24. }
  25. }
  26.  
  27. }
  28.  
  29. import java.sql.Connection;
  30. import java.sql.DriverManager;
  31.  
  32. public class Program{
  33.  
  34. public static void main(String[] args) {
  35. try{
  36. String url = "jdbc:mysql://localhost/store?serverTimezone=Europe/Moscow&useSSL=false";
  37. String username = "root";
  38. String password = "password";
  39. Class.forName("com.mysql.cj.jdbc.Driver").getDeclaredConstructor().newInstance();
  40. try (Connection conn = DriverManager.getConnection(url, username, password)){
  41.  
  42. System.out.println("Connection to Store DB succesfull!");
  43. }
  44. }
  45. catch(Exception ex){
  46. System.out.println("Connection failed...");
  47.  
  48. System.out.println(ex);
  49. }
  50. }
  51. }
Add Comment
Please, Sign In to add comment