import java.sql.Connection;
import java.sql.DriverManager;
public class DBUntil {
public static void main(String[] args) {
DBUntil dbUntil=new DBUntil("root","数据库密码","sys");//sys是表名
}
private String account;
private String password;
private String sys;
public DBUntil(String account, String password, String sys) {
this.account = account;
this.password = password;
this.sys = sys;
init();
}
public static Connection con=null;
public static void closeConnection(Connection con) {
try {
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void init(){
try{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载成功");
}catch (Exception e){
System.out.println("加载驱动失败");
}
try{
String uri="jdbc:mysql://localhost:3306/sys?useUnicode=true&characterEncoding=utf-8";
con= DriverManager.getConnection(uri,account,password);
System.out.println("连接数据库成功");
}catch (Exception e){
System.out.println("连接数据库失败");
}
}
}
判断是否连接成功