Advertisement
Fahim_7861

JavaDbConnection

Nov 29th, 2018
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1.  
  2. import java.sql.*;
  3. import javax.swing.*;
  4.  
  5. public class JavaDbConnection {
  6.  
  7.  
  8. private static Connection connection = null;
  9.  
  10. public static Connection dbConnect() {
  11. try {
  12. // Class.forName("org.sqlite.JDBC");
  13. Class.forName("com.mysql.jdbc.Driver");
  14.  
  15. System.out.println("Connected");
  16.  
  17. // connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/school_management_project?zeroDateTimeBehavior=convertToNull","root","");
  18.  
  19. connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/maa_coaching_center?zeroDateTimeBehavior=convertToNull","root","");
  20.  
  21. //JOptionPane.showMessageDialog(null,"Connected");
  22.  
  23. // connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/maa_coaching_center?zeroDateTimeBehavior=convertToNull");
  24. //Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/hospital_management","root","");
  25. //JOptionPane.showMessageDialog(null, "Connection established!");
  26. return connection;
  27. } catch (Exception e) {
  28. JOptionPane.showMessageDialog(null, "Not Connected");
  29. return null;
  30. }
  31. }
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement