@Test public void findMemberPageList() throws Exception { List<MemberView> lsit = userGroupDao.findMemberPageList(paging); System.out.println("findMemberPageList :-------> " + lsit); Assert.assertTrue(lsit.size() > 0); }
public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException { String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," + "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " + "FROM user_group t1 " + "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging); return this.queryBySql(sql, MemberView.class); }
UserGroupDao extends BaseDao { public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException { String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," + "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " + "FROM user_group t1 " + "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging); return this.queryBySql(sql, MemberView.class); } }
UserGroupDao extends BaseDao { public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException { String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," + "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " + "FROM user_group t1 " + "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging); return this.queryBySql(sql, MemberView.class); }  }
UserGroupDao extends BaseDao { public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException { String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," + "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " + "FROM user_group t1 " + "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging); return this.queryBySql(sql, MemberView.class); }  Long insertUserGroup(UserGroup userGroup); Long insertUserGroup(Long user_id, Long group_id, Integer role, Integer opt_user); int deleteUserFromGroup(Long user_id, Long group_id); int updateUserPersimion(UserGroup userGroup); int updateUserPersimion(Long userId, Long groupId, Integer role, Integer opt_user); List<MemberView> getUserListByLikeUserName(String userName); List<UserGroup> getUserGroupByUserId(Long userId); List<UserGroup> getUserGroupByGroupId(Long groupId); List<UserGroup> getUserGroupByGroupIdAndUserId(Long groupId, Long userId); Long getMemberTotalCount(Paging<UserGroup> paging); List<MemberView> findMemberPageList(Paging<UserGroup> paging); }
UserGroupDao extends BaseDao { public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException { String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," + "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " + "FROM user_group t1 " + "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging); return this.queryBySql(sql, MemberView.class); }  Long insertUserGroup(UserGroup userGroup); Long insertUserGroup(Long user_id, Long group_id, Integer role, Integer opt_user); int deleteUserFromGroup(Long user_id, Long group_id); int updateUserPersimion(UserGroup userGroup); int updateUserPersimion(Long userId, Long groupId, Integer role, Integer opt_user); List<MemberView> getUserListByLikeUserName(String userName); List<UserGroup> getUserGroupByUserId(Long userId); List<UserGroup> getUserGroupByGroupId(Long groupId); List<UserGroup> getUserGroupByGroupIdAndUserId(Long groupId, Long userId); Long getMemberTotalCount(Paging<UserGroup> paging); List<MemberView> findMemberPageList(Paging<UserGroup> paging);  }