自定义JdbcUtils

最新推荐文章于 2024-09-25 10:59:43 发布

SuperQiu~

最新推荐文章于 2024-09-25 10:59:43 发布

阅读量75

点赞数

分类专栏： JDBC 文章标签： java

本文链接：https://blog.csdn.net/weixin_44966780/article/details/120545269

版权

JDBC 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

自定义JdbcUtils

package jdbc;

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

/**
 * @author 小邱
 * @version 0.0.1
 * @description jdbcUtils实现获取连接关闭资源的功能
 * @since 2021/9/27 20:19
 */
public class JdbcUtils {

    //获取连接
    public static Connection getConnection() {
        Connection connection = null;
        try {
            //加载配置文件
            InputStream resource = JdbcPreparedStatementTest.class.getClassLoader().getResourceAsStream("jdbc.properties");
            Properties properties = new Properties();
            properties.load(resource);
            //获取配置文件属性
            String username = properties.getProperty("username");
            String password = properties.getProperty("password");
            String url = properties.getProperty("url");
            String driverClassName = properties.getProperty("driverClassName");
            //加载驱动
            Class.forName(driverClassName);
            //获取连接
            connection = DriverManager.getConnection(url, username, password);
        } catch (IOException | ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
            return connection;
    }

    //关闭资源
    public static void close(Connection connection, Statement statement) {
        try {
            if (connection != null) {
                connection.close();
            }
            if (statement != null) {
                statement.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }


    }
    //关闭资源
    public static void close(Connection connection, Statement statement, ResultSet resultSet) {
        try {
            if (connection != null) {
                connection.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (resultSet != null) {
                resultSet.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }


    }

}