IntelliJ IDEA Java SE连接数据库 MySQL
添加jdbc jar包
MySQL连接 MyDBConnection 类
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class MyDBConnection{
private String DBDriver;
private String DBURL;
private String DBUser;
private String DBPass;
private Connection conn=null;
private Statement stmt=null;
public MyDBConnection(String driver,String dburl,String user,String pass){
DBDriver=driver;
DBURL=dburl;
DBUser=user;
DBPass=pass;
try{
Class.forName(DBDriver);
}catch(Exception e){
e.printStackTrace();
}
try{
conn=DriverManager.getConnection(DBURL,DBUser,DBPass);
stmt=conn.createStatement();
}catch(Exception e){
e.printStackTrace();
}
}
public Connection getMyConnection(){
return conn;
}
public Statement getMyStatement(){
return stmt;
}
public void closeMyConnection(){
try{
stmt.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
public String toString(){
return "DBDriver"+DBDriver+"DBURL"+DBURL+"DBUser"+DBUser+"DBPass"+DBPass;
}
调用 MyDBConnection 类
public static void main(String[] args) {
//1.注册驱动
String DBDriver="com.mysql.jdbc.Driver";
//2.连接路径
String DBURL="jdbc:mysql://localhost:3306/choosecourse";
//3.账户
String DBUser="root";
//3.密码
String DBPass="111";
//4.创建连接
new MyDBConnection(DBDriver,DBURL,DBUser,DBPass);
}