如何把jt.execute(sql1)执行的结果赋值给一个变量，然后存到session中

Question

 @RequestMapping(value="/vip",method = RequestMethod.GET) 
      public ModelAndView login1(final HttpSession httpSession) {
        String phone = (String) httpSession.getAttribute("phone");
        String viewname = "";
            viewname = "vip";
            String sql = "select * from user where phone ='"+phone+"' ";
            String sql1 = "select vip from user where phone ='"+phone+"'";
            System.out.println(sql);
            final User user = new User();
            jt.query(sql, new RowCallbackHandler(){
                public void processRow(ResultSet rs) throws SQLException {
                    if (rs.isFirst()) {
                        user.setName(rs.getString(1));
                        user.setPhone(rs.getString(2)); 
                        user.setPassword(rs.getString(3));
                        user.setSex(rs.getString(4));
                        user.setVip(rs.getString(5));
                    }

                }   
            });
            jt.execute(sql1);
            System.out.println(sql1);
            httpSession.setAttribute("phone", phone);
            ModelAndView mv = new ModelAndView(viewname);
            mv.addObject("user", user);
            return mv;
        }

Answer 1

Statement接口的execute用于返回多个结果集的情况，不推荐使用。一般用的是executeQuery、executeUpdate。
executeQuery返回一个ResultSet对象用于得到数据库结果;
executeUpdate返回int类型得到影响的行数。