Lesson 8
Connect DB (Mysql)
public static Connection con(){
try{
Connection c;
Class.forName("com.mysql.jdbc.Driver");
c = DriverManager.getConnection("jdbc:mysql://localhost/apartment", "root", "xay123");
//JOptionPane.showMessageDialog(null, "Can");
return c;
}
catch(Exception e){
JOptionPane.showMessageDialog(null, "Can not");
return null;}
}
Connect DB (sqlite)
public static Connection A(){
try{
Class.forName("org.sqlite.JDBC");
//Connection c = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\saiyajack\\Desktop\\Java_Project\\SPM\\Project.sqlite");
Connection c = DriverManager.getConnection("jdbc:sqlite:Payment.sqlite");
JOptionPane.showMessageDialog(null, "Connect");
return c;
}
catch(Exception e){
JOptionPane.showMessageDialog(null, "Not Connect");
return null;
}
}
Connect sqlite 2
public static Connection A(){
try{
Class.forName("org.sqlite.JDBC");
//Connection c = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\saiyajack\\Desktop\\Java_Project\\SPM\\Project.sqlite");
Connection c = DriverManager.getConnection("jdbc:sqlite:Payment.sqlite");
JOptionPane.showMessageDialog(null, "Connect");
return c;
}
catch(Exception e){
JOptionPane.showMessageDialog(null, "Not Connect");
return null;
}
}
Mysql Driver
Derby Connect
public static Connection con(){
try{
Connection c;
//Class.forName("com.mysql.jdbc.Driver");
c = DriverManager.getConnection("jdbc:derby://localhost:1527/Bill", "xay", "xay");
JOptionPane.showMessageDialog(null, "Can");
return c;
}
catch(Exception e){
JOptionPane.showMessageDialog(null, "Can not");
return null;}
}