jdbc 03 jdbcUtil 类

贾琏欲执事,,这五个步骤,每次CRUD都创建,这样不好,写一个类把获取连接对象,施放资源方法抽取出来,这样好一点

public class JdbcUtil1 {

    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql:///jdbc-test";
    private static final String NAME = "root";
    private static final String PASSWORD = "rootroot";

    private static Connection connection = null;

    static {
        try {
            Class.forName(DRIVER);
            connection = DriverManager.getConnection(URL, NAME, PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * 返回链接对象
     *
     * @return
     */
    public static Connection returnConnection() {
        return connection;
    }

    /**
     * 释放资源
     *
     * @param resultSet          resultSet
     * @param statement          statement
     * @param connection         connection
     */
    public static void close(ResultSet resultSet, Statement statement, Connection connection) {
        try {
            resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}