操作数据库的基本类（个人代码记录）

BaseDao.java
package com.xiao.dao;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

//操作数据库的公共类
public class BaseDao {
    
    private static String driver;
    private static String url;
    private static String username;
    private static String password;
    
    //静态代码块，类加载的时候就已经初始化了
        static {
        Properties properties = new Properties();
        //通过类加载器读取对应的资源
        InputStream is = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");

        try {
            properties.load(is);
        } catch (IOException e) {
            e.printStackTrace();
        }
        
        driver=properties.getProperty("driver");
        url=properties.getProperty("url");
        username=properties.getProperty("username");
        password=properties.getProperty("password");
    }
    
    //获取数据库的连接
    public static Connection getConnection(){
            Connection connection=null;
        try {
            Class.forName(driver);
            connection= DriverManager.getConnection(url,username,password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }
    
    //编写查询公共方法
    public static ResultSet execute(Connection connection,String sql,Object[] params,PreparedStatement preparedStatement,ResultSet resultSet) throws SQLException {
         //预编译了SQL，在后面可以直接执行
            preparedStatement = connection.prepareStatement(sql);

        for (int i = 0; i < params.length; i++) {
            //setObject，占位符从1开始，但是数组从0开始
            preparedStatement.setObject(i+1,params[i]);
        }
        resultSet = preparedStatement.executeQuery();
        return resultSet;
    }
        
        //编写增删改公共方法
    public static int update(Connection connection,String sql,Object[] params,PreparedStatement preparedStatement) throws SQLException {

        preparedStatement = connection.prepareStatement(sql);

        for (int i = 0; i < params.length; i++) {
            //setObject，占位符从1开始，但是数组从0开始
            preparedStatement.setObject(i+1,params[i]);
        }
        int updateRows = preparedStatement.executeUpdate();
        return updateRows;
    }
    
    //关闭连接，释放资源
    public static boolean closeResource(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet){
            boolean flag=true;
            
            if(resultSet!=null){
                try {
                    resultSet.close();
                    resultSet=null;
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                    flag=false;
                }
            }
            if(preparedStatement!=null){
                try {
                    preparedStatement.close();
                    preparedStatement=null;
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                    flag=false;
                }
            }
            if(connection!=null){
                try {
                    connection.close();
                    connection=null;
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                    flag=false;
                }
            }
            return flag;
    }
}

db.properties

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=utf-8
username=root
password=xiaocong