连接本地
方式一:
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();
}
}
}