IDEA链接MySQL jar包

一、创建以一个空项目

package com.itheima.jdbc;

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

public class JDBCDemo {
    public static void main(String[] args) throws Exception {
        //注册驱动
        //Class.forName("com.mysql.cj.jdbc.Driver");
       
       //获取链接
        //String url="jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8";
        String url="jdbc:mysql:///test?serverTimezone=GMT%2B8";
        String username="root";
        String password="*****";
        Connection conn = DriverManager.getConnection(url,username,password);

        // 定义sql
        String sql="update user2 set password = 666 where id =1";

        Statement stmt = conn.createStatement();

        int count = stmt.executeUpdate(sql);

        System.out.println(count);

        stmt.close();
        conn.close();
    }
}

成功了