java连接mysql

连接本地

方式一：

url: jdbc:mysql://localhost:3306/sportplay?useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
username: root
password: 123456

方式二：

jdbc:mysql://localhost:3306/数据库名?配置

package com.cw.demo01;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class MysqlConn {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
       //添加依赖
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/db_test";
        String user="root";
        String password="root";
        //测试连接
        Connection connection = DriverManager.getConnection(url, user, password);
        //连接增删改查jdbc
        Statement statement = connection.createStatement();
        String sql="update tb_books set name='456' where id='2'";
        //执行增删改查
        int i = statement.executeUpdate(sql);
        System.out.println(i);
        //关闭连接
        if(statement!=null){
            statement.close();
        }
        if(connection!=null){
            connection.close();
        }
    }
}