如何抽取JDBC工具类：JDBCUtils

目的：简化书写（代码书写量大）
分析：
1.注册驱动也抽取
2.抽取一个方法获取连接对象

需求：不想传递参数（麻烦），还得保证工具类的通用性
解决：配置文件

3.抽取一个方法释放资源

在IEDA中的分布如下：JDBCUtils即为抽取出来的工具类

jdbc.properties文件内容如下：

代码实现：JDBCUtils

package util;

import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

//jdbc工具类
public class JDBCUtils {
    private static String url;
    private static String user;
    private static String password;
    private static String driver;

    //文件的读取，只需要读取一次即可拿到这些值。可使用静态代码块
    //静态代码块随着类的加载而加载，只执行一次
    static{
        try {
            //读取资源文件，获取值
            //1.创建Properties集合
            Properties pro = new Properties();

            //获取src路径下的文件的方式--->ClassLoader 类加载器
            ClassLoader classLoader = JDBCUtils.class.getClassLoader();
            URL res = classLoader.getResource("jdbc.properties");
            String path = res.getPath();
            System.out.println(path);

            //2.加载文件
            pro.load(new FileReader(path));
            //3.获取属性，赋值
            url = pro.getProperty("url");
            user = pro.getProperty("user");
            password = pro.getProperty("password");
            driver = pro.getProperty("driver");

            //4.注册驱动
            Class.forName(driver);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

//return连接对象
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,user,password);
    }

	//释放资源
    public static void close(Statement stmt,Connection coon){
        if(stmt != null){
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

        if(coon != null){
            try {
                coon.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

    public static void close(Statement stmt, Connection coon, ResultSet rs){
        if(stmt != null){
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

        if(coon != null){
            try {
                coon.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

        if(rs != null){
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
}

测试类：jdbcDemo3

package jdbc;

import domain.Boys;
import util.JDBCUtils;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class jdbcDemo3 {
    public static void main(String[] args) {
        List<Boys> list = new jdbcDemo2().findAll();
        System.out.println(list);
    }

    public List<Boys> findAll(){
        //查询所有boys对象
        List<Boys> list = null;
        ResultSet rs = null;
        Connection conn = null;
        Statement stmt = null;
        try {
            /*
            //1.注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取连接
            conn = DriverManager.getConnection("jdbc:mysql:///girls", "root", "7295wangmeng");
            */
            conn = JDBCUtils.getConnection();
            //3.定义sql
            String sql = "select * from boys";
            //4.获得执行sql的对象
            stmt = conn.createStatement();
            //5.执行sql
            rs = stmt.executeQuery(sql);
            //6.遍历结果集，封装对象，装载集合
            Boys boys = null;
            list = new ArrayList<Boys>();
            while (rs.next()){
                //获取对象
                int id = rs.getInt("id");
                String boyName = rs.getString("boyName");
                int userCP = rs.getInt("userCP");

                //创建boys对象，并赋值
                boys = new Boys();
                boys.setId(id);
                boys.setBoyName(boyName);
                boys.setUeseCP(userCP);
                //装载集合
                list.add(boys);
            }

        } /*catch (ClassNotFoundException e) {
            e.printStackTrace();
        } */catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {/*
            if (stmt != null){
                try {
                    stmt.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }

            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }

            if(rs != null){
                try {
                    rs.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }*/
            JDBCUtils.close(stmt,conn,rs);
        }
        return list;
    }
}