JDBC tool class encapsulation

jdbc Encapsulation of tool class ：

package com.hyc.study02.utils;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

public class JDBCUtils {
    
    private static String driver = null;
    private static String url = null;
    private static String username = null;
    private static String psw = null;

    static {
    
        try {
    
            InputStream inputStream = JDBCUtils.class.getClassLoader().getResourceAsStream("db.properties");
            Properties properties = new Properties();
            properties.load(inputStream);

            driver = properties.getProperty("driver");
            //2、 Get user information 、url
            url = properties.getProperty("url");
            username = properties.getProperty("username");
            psw = properties.getProperty("psw");
            // The driver only loads once 
            //1、 The load driver 
            Class.forName(driver);
        } catch (Exception e) {
    
            e.printStackTrace();
        }
    }

    // Get the connection 
    public static Connection getConnection() throws SQLException {
    
        return DriverManager.getConnection(url, username, psw);
    }

    // Release the connection 
    public static void release(Connection connection, Statement statement, ResultSet resultSet) {
    
        if (resultSet != null) {
    
            try {
    
                resultSet.close();
            } catch (SQLException throwables) {
    
                throwables.printStackTrace();
            }
        }
        if (statement != null) {
    
            try {
    
                statement.close();
            } catch (SQLException throwables) {
    
                throwables.printStackTrace();
            }
        }
        if (connection != null) {
    
            try {
    
                connection.close();
            } catch (SQLException throwables) {
    
                throwables.printStackTrace();
            }
        }
    }
}

Insert data test ：

package com.hyc.study02;
import com.hyc.study02.utils.JDBCUtils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestInsert {
    
    public static void main(String[] args) {
    
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        try {
    
            //3、 Get database connection 
            connection = JDBCUtils.getConnection();

            //4、 Create execution sql The object of 
            statement = connection.createStatement();

            //5、 perform sql sentence 
            //6、 Return execution result set 
            String sql = "INSERT INTO `users`(`id`,`NAME`,`PASSWORD`,`email`,`birthday`) " +
                    "VALUES (4,'hyc','123456','[email protected]','2022-04-18')";
            int num = statement.executeUpdate(sql);
            if (num > 0) {
    
                System.out.println(" Insert data succeeded ！");
            }
        } catch (SQLException throwables) {
    
            throwables.printStackTrace();
        } finally {
    
            //7、 Release the connection 
            JDBCUtils.release(connection, statement, resultSet);
        }
    }
}

Delete data test ：

package com.hyc.study02;
import com.hyc.study02.utils.JDBCUtils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestDelete {
    
    public static void main(String[] args) {
    
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        try {
    
            //3、 Get database connection 
            connection = JDBCUtils.getConnection();

            //4、 Create execution sql The object of 
            statement = connection.createStatement();

            //5、 perform sql sentence 
            //6、 Return execution result set 
            String sql = "DELETE FROM `users` WHERE id=4";
            int num = statement.executeUpdate(sql);
            if (num > 0) {
    
                System.out.println(" Delete data succeeded ！");
            }
        } catch (SQLException throwables) {
    
            throwables.printStackTrace();
        } finally {
    
            //7、 Release the connection 
            JDBCUtils.release(connection, statement, resultSet);
        }
    }
}

Modify data test :

package com.hyc.study02;
import com.hyc.study02.utils.JDBCUtils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestUpdate {
    
    public static void main(String[] args) {
    
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        try {
    
            //3、 Get database connection 
            connection = JDBCUtils.getConnection();

            //4、 Create execution sql The object of 
            statement = connection.createStatement();

            //5、 perform sql sentence 
            //6、 Return execution result set 
            String sql = "UPDATE `users` SET `NAME`='zxzb',`email`='[email protected]' WHERE `id`=1";
            int num = statement.executeUpdate(sql);
            if (num > 0) {
    
                System.out.println(" Update data successful ");
            }
        } catch (SQLException throwables) {
    
            throwables.printStackTrace();
        } finally {
    
            //7、 Release the connection 
            JDBCUtils.release(connection, statement, resultSet);
        }
    }
}

Query data test ：

package com.hyc.study02;
import com.hyc.study02.utils.JDBCUtils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestSelect {
    
    public static void main(String[] args) {
    
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        try {
    
            //3、 Get database connection 
            connection = JDBCUtils.getConnection();

            //4、 Create execution sql The object of 
            statement = connection.createStatement();

            //5、 perform sql sentence 
            //6、 Return execution result set 
            String sql = "SELECT * FROM `users` WHERE id=1";
            resultSet = statement.executeQuery(sql);
            while (resultSet.next()) {
    
                System.out.println(resultSet.getInt("id"));
                System.out.println(resultSet.getString("NAME"));
                System.out.println(resultSet.getString("PASSWORD"));
                System.out.println(resultSet.getString("email"));
                System.out.println(resultSet.getDate("birthday"));
            }
        } catch (SQLException throwables) {
    
            throwables.printStackTrace();
        } finally {
    
            //7、 Release the connection 
            JDBCUtils.release(connection, statement, resultSet);
        }
    }
}