package com.dingdong.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DbConn {
protected Connection dbConn = null;
private String driverName="com.mysql.cj.jdbc.Driver";
private String dbURL="jdbc:mysql://127.0.0.1:3307/phonestore?serverTimezone=UTC";
private String userName="root";
private String userPwd="root";
public void dbConn(){
try{
Class.forName(driverName);
dbConn=DriverManager.getConnection(dbURL, userName,userPwd);
System.out.println("Connection successful");
}catch (Exception e) {
System.out.println(e.getMessage());
}
}
public void closeConn() throws SQLException{
// statement.close();
// dbConn.close();
}
private Connection getConnection(){
try{
Class.forName(driverName);
dbConn=DriverManager.getConnection(dbURL, userName,userPwd);
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return dbConn;
}
public static void main(String[] args){
DbConn d=new DbConn();
System.out.println(d.getConnection());
}
}
出现以下即为连接成功。