本文共 1312 字，大约阅读时间需要 4 分钟。

对应的User类和Role类

public class User implements Serializable {
       private Integer id;    private String username;    private Date birthday;    private String sex;    private String address;        private List
   
     roles;    }
   

public class Role implements Serializable {
       private Integer roleId;    private String roleName;    private String roleDesc;    private List
   
     users;    }
   

Dao

public interface IUserDao {
       /**     * 查询所有用户     * @return     */   public List
   
     findAll();}
   

public interface IRoleDao {
       List
   
     findAll();}
   

IUserDao.xml

   
         
          
          
          
          
        
            
             
             
             
             
             
                 
                  
                  
              
         
        
        
           SELECT u.*,r.ID as rid ,r.ROLE_NAME,r.ROLE_DESC from `user` u       LEFT  OUTER JOIN user_role ur on u.id=ur.UID        LEFT OUTER JOIN  role r on r.ID=ur.RID    
   

测试类

/**     *测试findAll()方法     */    @Test    public void findAllTest(){
           List
   
     userList = userDao.findAll();        for (User user:userList             ) {
               System.out.println(user.toString());            System.out.println(user.getRoles());        }    }
   

从Role查询User就不演示了，原理是一样的

转载地址：http://vciwi.baihongyu.com/