笔记Day04：JDBC实现MySQL数据库查询（结合配置文件，不使用连接池和DBUtils的情况下）

测试类：

package com.itheima.test2抽取工具类;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class utilsTest {
    public static void main(String[] args) {

        Connection con = null;
        Statement stat = null;
        ResultSet rs = null;
        //导入注册驱动
        //获取连接对象
        con = utils.getConnection();
        try {
            //获取可执行SQL语句的对象
            stat = con.createStatement();
            //写入SQL语句
            String sql = "SELECT * FROM user;";
            //执行SQL语句
            rs = stat.executeQuery(sql);
            //操作结果集，赋值给相应的变量，并输出
            while (rs.next()) {
                int uid = rs.getInt("uid");
                String uname = rs.getString("uname");
                String password = rs.getString("password");
                System.out.println(uid + "..." + uname + "..." + password);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //释放资源
            utils.release(con, stat, rs);
        }
    }
}

---

工具类：

package com.itheima.test2抽取工具类;

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

public class utils {
    //此处首先声明jdbc的四大参数（参数和方法都是静态的，便于调用）
    private static String driverClass;
    private static String url;
    private static String user;
    private static String password;
    //构造方法私有化
    private utils() {
    }

    //读取配置文件
    public static void read() {
        Properties pro = new Properties();
        try {
            pro.load(new FileReader("Day04\\config.properties"));//注：该处需要new FileReader
            driverClass = pro.getProperty("driverClass");
            url = pro.getProperty("url");//注:不细心容易错写为uid
            user = pro.getProperty("user");
            password = pro.getProperty("password");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    static {
        try {
            utils.read();
            //注册驱动
            Class.forName(driverClass);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection() {
        try {
            return DriverManager.getConnection(url,user,password);//注：三个参数
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public static void release(Connection con, Statement stat, ResultSet rs) {
        try {
            if (con != null) {
                con.close();
                con = null;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //  7.释放资源
            try {
                if (stat != null) {
                    stat.close();
                    stat = null;
                }
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (rs != null) {
                        rs.close();
                        rs = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        }
    }

    public static void release(Connection con, Statement stat) {
        try {
            if (con != null) {
                con.close();
                con = null;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //  7.释放资源
            try {
                if (stat != null) {
                    stat.close();
                    stat = null;
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

---

配置文件：

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql:///web3
username=root
password=123