package project_try2;
import java.sql.*;
public class DBCONNECT {
    private static DBCONNECT instance = new DBCONNECT() ;
    public static final String url="jdbc:mysql://localhost/car_ser" ;
    public static final String USER_NAME="root" ;
    public static final String PASSWORD="" ;
    public static final String DRIVER_CLASS="com.mysql.jdbc.Driver";

     private  DBCONNECT()
     {
         try{
             Class.forName(DRIVER_CLASS) ;
         }catch(ClassNotFoundException e)
         {
             e.printStackTrace() ;

         }
     }
     private  Connection Createconnection()
     {
         Connection connection = null ;

         try {
             connection = DriverManager.getConnection(url, USER_NAME, PASSWORD);

         }catch(SQLException e){
            System.out.println("connection faild ") ;
         }
          return connection;
    }
    public static Connection getConnection(){
        return instance.Createconnection();
    }
}