Java连接Mysql数据库【基础版】（JDBC）

首先做了一个及其简单的学生表

CREATE TABLE student (
id int(11) NOT NULL PRIMARY KEY ,
username  varchar(6) NOT NULL ,
money int(11) NULL 
)
;

INSERT INTO student VALUES (1 ,'张三', 1200)；
INSERT INTO student VALUES (2 ,'李四', 2000)；
INSERT INTO student VALUES (3 ,'刘二', 5200)；

加载驱动类地址：https://downloads.mysql.com/archives/c-j/

下载解压缩后将bin添加到lib文件夹，在Idea上右键添加为库

INSERT操作

package lky;

import java.sql.Connection;
import java.sql.DriverManager;   //JDBC驱动管家
import java.sql.SQLException;
import java.sql.Statement;

public class Day01 {
    public static void main(String[] args) throws ClassNotFoundException,SQLException{
        //加载驱动类
        Class.forName("com.mysql.cj.jdbc.Driver");
        //构建连接参数
        String url = "jdbc:mysql://localhost:3306/day01?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8";
        String username="root";
        String password="123";

        //获取连接对象
        Connection connection =  DriverManager.getConnection(url,username,password);

        //判断连接对象
        if (connection == null){
            System.out.println("连接失败");
        }else {
            System.out.println("连接成功");

        //获取执行者对象
            Statement statement = connection.createStatement();

            String sql = "INSERT INTO student VALUES(4 ,'王五', 3200) ";

            if(statement.executeUpdate(sql)>=1){
                System.out.println("插入成功");
            }else{
                System.out.println("插入失败");
            }
            connection.close();
        }
    }
}

DELETE

//            String sql = "INSERT INTO student VALUES(4 ,'王五', 3200) ";
            String sql = "DELETE FROM student WHERe id = 1";

 UPDATe

//            String sql = "INSERT INTO student VALUES(4 ,'王五', 3200) ";
//            String sql = "DELETE FROM student WHERe id = 1";
            String sql = "UPDATe student SET money = 4500 where id = 2";

 SELECT

String sql ="SELECT * FROM student";
            ResultSet resultSet = statement.executeQuery(sql);
            while (resultSet.next()){
                System.out.println(resultSet.getString("username"));
                System.out.println(resultSet.getString("money"));