Java连接MySQL数据库（jdbc连接数据库）

​一、实现代码​

package com.xtd.utils.sql;

import java.sql.*;

public class DBUtil {

    // 定义连接常量
    private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
//    private static final String URL = "jdbc:mysql://192.168.0.1:3306/sea?useSSL=true&useUnicode=true&characterEncoding=UTF-8";
    private static final String URL = "jdbc:mysql://192.168.0.1:3306/sea?characterEncoding=utf8&autoReconnect=true&serverTimezone=UTC";
    private static final String USER = "root";
    private static final String PASSWORD = "root";

    public static Connection conn = getConnection();
    // 测试
    public static void main(String[] args) throws SQLException {
        if( null != conn) System.out.println(conn);
        conn = null;
        conn = DBUtil.conn;
        System.out.println(conn);
    }

    // jdbc连接MySQL
    private static Connection getConnection() {
        if(null != conn) return conn;
        try {
            Class.forName(DRIVER);
            conn = DriverManager.getConnection(URL, USER, PASSWORD);
            if(null != conn) System.out.println("MySQL数据库连接成功！");
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        return conn;
    }

}

​二、前置条件​

​1、MySQL连接jar包​

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <!-- <version>5.1.47</version> -->
        <version>8.0.18</version>
  </dependency>

​2、MySQL数据库配置​

（1）账户密码 （2）数据库名

​三、运行结果​