一、mysql驱动下载:
地址:https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-8.0.29.zip
二、项目引用
1 创建项目,模块
2 把 mysql-connector-java-8.0.29.jar 复制到项目中
3 引入的mysql包添加项目引用
三、示例代码
import com.mysql.jdbc.Driver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JDBCDemo {
public static void main(String[] args) throws Exception {
//1 注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//2 获取连接
String url = "jdbc:mysql://10.1.1.1:3306/db_test";
String username = "qingyuning";
String password = "qy@ing~2022";
Connection conn = DriverManager.getConnection(url, username, password);
//3 sql 语句
String sql = "update account set age=18 where id=1";
//4 获取执行sql的对象
Statement stmt = conn.createStatement();
//5 执行sql
int count = stmt.executeUpdate(sql);
//6 打印处理结果
System.out.println(count);
//7 释放资源
stmt.close();
conn.close();
}
}