- 下载jdbc jar包,中央仓库下载
https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.24
- 项目导入
右键jar包,然后add as library
![](https://img-blog.csdnimg.cn/img_convert/6ab8e3416e428eccfa15cc4ba19b8428.png)
![](https://img-blog.csdnimg.cn/img_convert/74c92ff39f50ade4eb38849800c30e54.png)
- 数据库操作
3.1连接数据库
package com.heima.jdbc;
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.jdbc.Driver");
// 2.获取连接
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "hexiong";
Connection conn = DriverManager.getConnection(url, username, password);
// 3.定义sql
String sql = "update account set money = 2000 where id = 1";
// 4.获取执行sql的对象
Statement stmt = conn.createStatement();