5.12总结

package com.mf.jdbc;

import com.mysql.jdbc.Driver;

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

/**

• JDBC的快速入门
  */

public class JDBCDemo {
public static void main(String[] args) throws Exception {
//1.注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");

    //2.获取连接
    String url = "jdbc:mysql://localhost:3306/db1?useSSL=false&serverTimezone=UTC";
    String username = "root";
    String password = "123456";
    Connection conn = DriverManager.getConnection(url, username, password);

    //3.定义sql语句
    String sql = "update emp set salary = 2000 where id = 1";

    //4.获取执行sql的对象 Statement
    Statement stmt = conn.createStatement();

    //5.执行sql
    int count = stmt.executeUpdate(sql);

    //6.处理结果
    System.out.println(count);

    //7.释放资源
    stmt.close();
    conn.close();
}

}