IntelliJ IDEA Java SE连接数据库 MySQL

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);
	}