接上一个简陋的代码

整合版（增删改查）

import java.sql.*;
import java.lang.String;


public class demo_db {

    private static Connection conn; //声明 Connection 对象
    private static Statement st;//声明预处理 PreparedStatement 对象
    private static ResultSet rs;//声明结果 ResultSet 对象

    private static String url = "jdbc:mysql://localhost:3306/mysql?serverTimezone=UTC";
    private static String user = "root";
    private static String password = "123456";


    public Connection getconnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("数据库驱动成功！！");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try {
            conn = DriverManager.getConnection(url, user, password);
            System.out.println("数据库连接成功");
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return conn;
    }


    public static void sel() {

        try {
            String sql = "SELECT * FROM demo";  //mysql查询语句

            st = conn.createStatement();
            rs = st.executeQuery(sql);          //得到结果集

            while (rs.next()) { //如果当前语句不是最后一条，则进入循环
                //展示数据集
                System.out.println(rs.getInt(1) + " "
                        + rs.getInt(2));
            }
            rs.close();//释放资源
            st.close();
        } catch (SQLException e) {//捕获异常
            e.printStackTrace();
        }
    }

    public static void add() {

        try {
            String sql = "insert  into demo values(10,20)";
            st = conn.createStatement();
            //rs = st.executeUpdate(sql);
            st.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public static void update() {

        try {
            String sql = "update demo  set age=30 where name = 20";
            st = conn.createStatement();
            st.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void del() {

        try {
            String sql = "delete from demo where name = 20";
            st = conn.createStatement();
            st.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public static void main(String[] args) {

        demo_db db = new demo_db();
        conn = db.getconnection();
        //del();        //删除
        //sel();        //查询
        //add();        //添加
        //update();     //更新
    }

}