JDBC工具类

配置文件：

url=jdbc:mysql://localhost:3306/emp
user=root
password=123456

工具类：

public class JDBCTools {
    private static String url;
    private static String user;
    private static String password;
    private static Connection conn;
    static{
        Properties properties = new Properties();
        try {
            properties.load(JDBCTools.class.getClassLoader().getResourceAsStream("jdbc.properties"));
            url = properties.get("url").toString();
            user = properties.get("user").toString();
            password = properties.get("password").toString();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        if(conn == null) {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url, user, password);
        }
        return conn;
    }

    public static void free() throws SQLException {
        if(conn != null){
            conn.close();
        }
    }

    public static void update(String sql,Object... args){
        PreparedStatement pst = null;
        try {
            Connection connection = getConnection();
            pst = connection.prepareStatement(sql);
            if(args!=null&&args.length>0){
                for(int i = 0;i < args.length;i++){
                    pst.setObject(i+1,args[i]);
                }
            }
            pst.executeUpdate();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                if(pst!=null) {
                    pst.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

测试类：

public class Test {
    public static void main(String[] args) throws SQLException {
        String sql = "update employee set name = ? where id = ?";
        //执行sql
        JDBCTools.update(sql,"周扒",5);
        //关闭连接
        JDBCTools.free();
    }
}