Json嵌套Json取参数

最新推荐文章于 2023-07-26 19:07:01 发布

叶小锋

最新推荐文章于 2023-07-26 19:07:01 发布

阅读量818

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/yyfpeak/article/details/39577353

版权

java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

public List<User_Group> getlist(Connection con,User_Group user_Group,String searchInfo,PageBean pageBean) throws Exception{
       StringBuffer sb = new StringBuffer("select * from user_group");
       if(StringUtil.isNotEmpty(searchInfo)){
           sb.append(" where group_desc like '%"+searchInfo+"%'");
       }
       if(pageBean!=null){
           sb.append(" limit "+pageBean.getStart()+","+pageBean.getRows());
       }
       PreparedStatement pstmt =con.prepareStatement(sb.toString());
       ResultSet rs= pstmt.executeQuery();
       List<User_Group> resultUserGroupList = new ArrayList<User_Group>();
       while(rs.next())
       {
           User_Group uu = new User_Group();
           uu.setGroup_id(rs.getInt("group_id"));
           uu.setGroup_desc(rs.getString("group_desc"));
           uu.setTv_msg(rs.getString("tv_msg"));
           uu.setAd_pic1_json(rs.getString("ad_pic1_json"));
           uu.setAd_pic2_url(rs.getString("ad_pic2_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic3_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic4_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic5_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic6_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic7_url"));
           uu.setAd_pic2_url(rs.getString("ad_pic8_url"));
           uu.setAd_mov_url(rs.getString("ad_mov_url"));
           uu.setAd_mov2_url(rs.getString("ad_mov2_url"));
           resultUserGroupList.add(uu);
       }
       for(int i = 0; i < resultUserGroupList.size(); i++){
           if(resultUserGroupList.get(i).getAd_pic1_json()!=null&&!"".equals(resultUserGroupList.get(i).getAd_pic1_json())){
           JSONObject a = JSONObject.fromObject(resultUserGroupList.get(i).getAd_pic1_json());
           resultUserGroupList.get(i).setAd_pic1_json(a.getString("url"));
       }
       }
       return resultUserGroupList;
   }