JDBCUtils工具类

今天把我平时写的JDBC连接数据库一些代码封装成一个工具类，方便我以后做项目时候，比较便捷。

public class JDBCUtils {


    private static String url;
    private static String name;
    private static String driver;
    private static String password;


    /**
     * 从db中获取数据库配置信息
     * 因为我们外面的类并不需要调用这个方法，所以我们把它写成静态代码块
     */
   static {
        try {
            ClassLoader classLoader = JDBCUtils.class.getClassLoader();
            InputStream resourceAsStream = classLoader.getResourceAsStream("db.properties");
            Properties properties = new Properties();
            properties.load(resourceAsStream);
            driver = properties.getProperty("driver");
            url = properties.getProperty("url");
            name = properties.getProperty("name");
            password = properties.getProperty("password");
        } catch (IOException e) {
            e.printStackTrace();
        }


    }
    /**
     * 注册驱动，获取连接
     * @return
     */
    public static Connection getConnection()  {
        Connection connection = null;
        try {
            Class.forName(driver);
            connection= DriverManager.getConnection(url, name, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }

    /**
     *  //做非空判断,释放创建的对象
     * @param connection
     * @param statement
     * @param resultSet
     * @throws SQLException
     */
    public static void release(Connection connection, PreparedStatement statement, ResultSet resultSet) throws SQLException {
        if(resultSet!=null){
            resultSet.close();
        }
        if(statement!=null){
            statement.close();

        }
        if(connection!=null){
            connection.close();
        }
    }
}