JDBCK快速入门

直接就是一张截图简简单单

package cn.itcast.jdbc;

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

public class fff {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //获取连接对象
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/d?useSSL=false&serverTimezone=UTC","root","123456");
        //写入sql语句
        String sql = "update account set balance = 1000 where id=2";
        //获取执行sql的对象
        Statement stmt = con.createStatement();
        //然后就是使用对象里面的方法去执行sql语句
        int sql1 = stmt.executeUpdate(sql);
        System.out.println(sql1);
        stmt.close();
        con.close();
    }
}