jdbc Resultset解析

「爱情、让人受尽委屈。」 2021-11-02 06:12 210阅读 0赞

**jdbc连接数据库代码 【复习一下执行流程】**

static final String url = "jdbc:mysql://localhost:3306/lib?useUnicode=true&characterEconding=UTF-8";
        static final String user = "root";//数据库的用户名
        static final String password = "root";//数据库的密码
        static Connection conn = null;
        static Statement st = null;
        static ResultSet rs = null;
    
    
             Class.forName("com.mysql.jdbc.Driver");
             conn = DriverManager.getConnection(url, user, password);
    
             String sql = "select * from manager where name = ? and password = ? ";
    
                st = conn.createStatement();
                st.setString(1, user.getName());
                st.setString(2, user.getPassword());
                rs = st.executeQuery();
    
    try {
                while (rs.next()) {
                        .....对结果集的操作......
    
                        // 关闭数据库连接
                       ps.close();
                       rs.close();
                       conn.close();
    
                }
            } catch (Exception e) {
                // TODO: handle exception
            }

### ** 1 创建statement的操作** ###

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 1][] ###

![20190810122421422.png][]

![20190810122353913.png][]

![20190810122408253.png][]

### **2 ResultSet 的方法** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 2][]

![20190810122145602.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2019081012294135.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 1]: /images/20211102/7388abed2ac34d3a8ff0c2400890c2a2.png
[20190810122421422.png]: /images/20211102/4df7df5ce7a341919d07707c3a73694a.png
[20190810122353913.png]: /images/20211102/242d59a57d2d41e080bcbf755e337a17.png
[20190810122408253.png]: /images/20211102/3622802646094907a1f821366c106752.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 2]: /images/20211102/3d48cf5198384168a5abc4f624efb076.png
[20190810122145602.png]: /images/20211102/9a68e681d8a34519845b45d83abad9de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwOTY5MTA4_size_16_color_FFFFFF_t_70 3]: /images/20211102/81dabb13e7104cff9a4dd26ebd5737dc.png