hibrenate 中多对多的查询方法

来源:互联网 发布:模拟小提琴演奏软件 编辑:程序博客网 时间:2024/05/14 18:47

public Forward login(HttpServletRequest request, HttpServletResponse response) throws IOException{
  int pageNo=Integer.parseInt(request.getParameter("page"))-1;
  int pageSize=Integer.parseInt(request.getParameter("rows"));
  String username=request.getParameter("username");
  String password=request.getParameter("password");
  String bookname=request.getParameter("bookname");
  //BookInfo b1=new BookInfo();
  UserImpl u=new UserImpl();
  //b1=u.getBook(bookname);
        Page<User> page=u.getUser(pageNo, pageSize, username, password);
     List<User> list=page.getResults();
     //多对多的查询的方法使用
     List<Map<String, Object>> maps = new ArrayList<Map<String, Object>>();
     if(list!=null)
     {
          
        maps = new ArrayList<Map<String, Object>>(
    list.size());
      StringBuilder roles = new StringBuilder();
      StringBuilder role = new StringBuilder();
      for (int i = 0; i < list.size(); i++) {
       Map<String, Object> map = new LinkedHashMap<String, Object>();
       User u1 = list.get(i);
       map.put("id", u1.getUserid());
       map.put("username", u1.getUsername());
       Set<BookInfo> s=u1.getUser_book();
       Iterator<BookInfo> it = s.iterator(); 
       while (it.hasNext()) { 
           BookInfo bi = it.next();
        roles.append(bi.getBookname()+" ");
        role.append(bi.getBookpublisher()+" ");
       } 

       // 输出该对象所有的信息
       /*Iterator<BookInfo> it = u1.getUser_book().iterator();
       while(it.hasNext()){ 
        
        BookInfo bi = it.next();
        roles.append(bi.getBookname()+" ");
        role.append(bi.getBookinfoid()+" ");
       }*/
       
       map.put("bookname", roles.toString());
       map.put("publisher", role.toString());
       roles.replace(0, roles.length(), "");//清空上次的数据
       role.replace(0, role.length(), "");
       map.put("address",u1.getAddress());
       map.put("password",u1.getPassword());
       map.put("disabled", (u1.getUserstate()).equals("0")  ? "启用" : "禁用");// 0启用,1禁用
       maps.add(map);
       
     }  
     }
      WebUtils.writeJsonPage(response,page.getCount(), maps);
   return null;
 }

 

 

 

多对多保存的时候用到的情况

 

String [] bookid=request.getParameterValues("bookid");
  Set<BookInfo> bo=new HashSet<BookInfo>();
  if(bookid!=null)
  {
   for(int i=0;i<bookid.length;i++)
   {
    
    BookInfo b1=HibernateUtil.getObject(BookInfo.class,Integer.parseInt( bookid[i]));
    bo.add(b1);
   }
  }
  u.setUser_book(bo);

0 0