JDBC应用

public class JDBCTest1 {
    public static void main(String[] args) throws IOException {
        InputStream is =JDBCTest1.class.getClassLoader().getResourceAsStream("jdbc.properties");
        //InputStream si = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
        // 返回委托的系统类加载器, 返回读取指定资源的输入流。
        Properties pro = new Properties();
        pro.load(is);
        String driver = pro.getProperty("driver");
        String url = pro.getProperty("url");
        String user = pro.getProperty("user");
        String password = pro.getProperty("password");
        //注册驱动
        Connection con = null;
        Statement sta = null;
        ResultSet rs = null;
        try {
            Class.forName(driver);
            //2.进行连接
            con = DriverManager.getConnection(url, user, password);
            //3.创建数据库操作对象
            sta = con.createStatement();
            //4.进行sql操作
            String sql = "select id,name,email from customers";
            rs = sta.executeQuery(sql);
            //5.处理查询结果集
            while(rs.next()){
                String id = rs.getString("id");
                String name = rs.getString("name");
                String email = rs.getString("email");
                System.out.println(id +","+ name +","+ email);
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
        //释放资源
            if(con != null){
                try {
                    sta.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(sta != null){
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(rs != null){
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }



    }
}