JDBC code

package 读写锁;

import lombok.NoArgsConstructor;
import org.junit.Test;

import java.sql.*;

@NoArgsConstructor
public class JDBC {
    static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String DB_URL =  "jdbc:mysql://127.0.0.1:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&serverTimezone=UTC";
    // 数据库的用户名与密码，需要根据自己的设置
    static final String USER = "root";
    static final String PASS = "root";
    static {
        try {
            Class.forName(JDBC_DRIVER);
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }



    public void add(Person person) throws SQLException {
        Connection conn= DriverManager.getConnection(DB_URL,USER,PASS);
        String sql="INSERT INTO person (vip,name,number) VALUES (?,?,?)";
        PreparedStatement statement = conn.prepareStatement(sql);
        statement.setInt(1,person.getVip());
        statement.setString(2,person.getName());
        statement.setInt(3,person.getNumber());
        statement.executeUpdate();
        statement.close();
        conn.close();
    }

    public Person readPerson(int vip) throws SQLException {
        Connection conn= DriverManager.getConnection(DB_URL,USER,PASS);
        String sql="select * from person where vip=?";
        PreparedStatement preparedStatement = conn.prepareStatement(sql);
        preparedStatement.setInt(1,vip);
        ResultSet set = preparedStatement.executeQuery();
        String name=null;int number = 0;
        while(set.next()){
            name=set.getString("name");
            number=set.getInt("number");
        }
        return new Person(vip,name,number);
    }

    @Test
    public void test() throws SQLException {
        JDBC jdbc=new JDBC();
        //jdbc.add(new Person(0,"wuyuhao",123));
        System.out.println(jdbc.readPerson(0).toString());
    }
}