结果集Resultset的updateString()，updateInt()之类的用法

    public class test {
        public static void main(String[] args) throws SQLException {
            
                Connection conn = null ;
                PreparedStatement ps = null ;
                ResultSet  rs = null ;
                List<Student> list = new ArrayList<Student>();
                try {
                    conn = JdbcUtils.getConnection();
                    String sql = "select id,name,age from mydb.student;" ;
                    ps = conn.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,
                            ResultSet.CONCUR_UPDATABLE);    //如果这两个属性掉了就会报错
                            //sql后面的第一个属性设置只能向前滚动(这是默认值)，第二个属性设置为可修改类型的参数。
                    rs = ps.executeQuery();
                    while(rs.next()){
                        rs.updateString("name", "Lily");

                        rs.updateInt("age", 18);
                        rs.updateRow();     //最后执行修改
//                        Student student = new Student(rs.getInt("id"),rs.getString("name"),rs.getInt("age"));
//                        list.add(student);
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                    throw e;
                }finally{
                    JdbcUtils.closeResource(conn, ps, rs);
                }  
        }

    }