java使用JDBC操作数据库（增删改查的方法）

import java.sql.*;
import java.util.Scanner;

public class Connect {
    static final String DB_URL="jdbc:mysql://localhost:3306/newdata?serverTimezone=UTC";
    static final String USER_NAME="root";
    static String USER_PASS="";
    static Connection conn=null;
    static {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    // connect database
    public static Connection Connect(){
        try {
           conn=DriverManager.getConnection(DB_URL,USER_NAME,USER_PASS);
        }catch (SQLException e){
            e.printStackTrace();
        }
        return conn;
    }
    // select from tables
    public static void select(){
        try{
            String sql="select id,name,age,salart from emp";
            PreparedStatement prst = conn.prepareStatement(sql);
            ResultSet rs = prst.executeQuery();
            while (rs.next()) {
                System.out.println(rs.getInt("id")+" "+rs.getString("name")+" "+
                        rs.getInt("age")+" "+rs.getDouble("salart"));
            }
            conn.close();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
    // insert data to table
    public static void insert(int num,String name,int age,Float saray){
        try{
            String sql= "insert into emp(id,name,age,salart)values(?,?,?,?)";
            PreparedStatement stmt = conn.prepareStatement(sql);
            stmt.setInt(1,num);
            stmt.setString(2,name);
            stmt.setInt(3,age);
            stmt.setFloat(4,saray);
            stmt.executeUpdate();
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
    // delete data from table
    public static void delete(int num){
        try{
            String sql="delete from emp where id=?";
//            Statement stmt=conn.createStatement();
            PreparedStatement stmt = conn.prepareStatement(sql);
            stmt.setObject(1,num);
            stmt.executeUpdate();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
    public static void updata(int num,String name){
        try {
            String sql= "update emp set name=? where id=?";
            PreparedStatement stmt = conn.prepareStatement(sql);
            stmt.setObject(1,name);
            stmt.setObject(2,num);
            stmt.executeUpdate();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
    public static void show(){
        Connect();
        System.out.println("==========欢迎使用员工管理系统（database版本）==========");
        System.out.println("==========1.查看员工==========");
        System.out.println("==========2.添加员工==========");
        System.out.println("==========3.删除员工==========");
        System.out.println("==========4.修改员工==========");
        System.out.println("==========5.退出系统==========");
        System.out.println("请选择功能：");
        Scanner scan=new Scanner(System.in);
        int num,age;
        String name;
        Float salary;
        int select=scan.nextInt();
        switch (select){
            case 1:
                select();
                break;
            case 2:
                System.out.println("请输入编号：");
                num=scan.nextInt();
                System.out.println("请输入姓名：");
                name=scan.next();
                System.out.println("请输入年龄：");
                age=scan.nextInt();
                System.out.println("请输入薪资：");
                salary=scan.nextFloat();
                insert(num,name,age,salary);
                break;
            case 3:
                System.out.println("请输入删除的编号：");
                num=scan.nextInt();
                delete(num);
                break;
            case 4:
                System.out.println("请输入修改的编号：");
                num=scan.nextInt();
                System.out.println("请输入新的姓名：");
                name=scan.next();
                updata(num,name);
                break;
            case 5:
                System.exit(0);
                break;
                default:
                    System.out.println("操作有误");
        }
    }
    public static void main(String[] args){
        while(true){
            show();
        }
    }
}