JDBC工具类抽取

JDBC工具类抽取

配置文件；src下建立文件 a.properties

    url =jdbc:mysql://127.0.0.1:3306/students
    user =root
    password =root
    driver =com.mysql.jdbc.Driver

JDBCUtils类

package day03;
//导包
import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

public class JDBCUtils {
private static String url;
private static String user;
private static String password;
private static String driver;

    /**
     * 文件的读取，只需要读取一次，即可拿到这些值
     */
    static {

        try {
            //创建properties集合
            Properties pro = new Properties();
            //获取src路径--》类加载器
            ClassLoader classLoader = JDBCUtils.class.getClassLoader();
            URL resource = classLoader.getResource("a.properties");
            String path = resource.getPath();
            System.out.println(path);

            pro.load(new FileReader(path));
            //获取数据值，赋值
            url = pro.getProperty("url");
            user = pro.getProperty("user");
            password = pro.getProperty("password");
            driver = pro.getProperty("driver");
            //注册驱动
            Class.forName(driver);


        } catch (IOException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    /**
     * JDBC工具类
     *
     * @return 连接对象
     */
    public static Connection getConnection() throws Exception {
        return DriverManager.getConnection(url, user, password);
    }

    /**
     * @param stmt
     * @param conn
     */
    public static void close(ResultSet rs, Statement stmt, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }

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

}

测试类

package day02;

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

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

    public List<Code06> findAll() {
        Connection conn = null;
        Statement stat = null;
        ResultSet rs = null;
        ArrayList<Code06> list = null;
        Code06 co = null;
        //导jar包
        try {
            list = new ArrayList<>();
            //注册驱动
            conn = JDBCUtils.getConnection();
            //获取sql连接对象
            stat = conn.createStatement();
            //定义sql
            String sql = "select * from student";
            //执行sql
            rs = stat.executeQuery(sql);
            while (rs.next()) {
                int sid = rs.getInt("sid");
                String sname = rs.getString("sname");
                String ssex = rs.getString("ssex");
                Date sbirthday = rs.getDate("sbirthday");
                int clid = rs.getInt("clid");
                co = new Code06();
                co.setSid(sid);
                co.setSname(sname);
                co.setSsex(ssex);
                co.setSbirthday(sbirthday);
                co.setClid(clid);
                //将资源添加到集合里面
                list.add(co);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {

            JDBCUtils.close(rs, stat, conn);
        }


        return list;

    }

}
                                                                        三