@Test public void getUserGroupByGroupId() throws Exception { List<UserGroup> lsit = userGroupDao.getUserGroupByGroupId(1L); System.out.println("getUserGroupByGroupId :-------> " + lsit); Assert.assertTrue(lsit.size() > 0); }
public List<UserGroup> getUserGroupByGroupId(Long groupId) throws SQLException { String sql = "SELECT id, user_id, group_id, role, opt_user FROM user_group WHERE group_id = ?"; return this.queryBySql(sql, UserGroup.class, Parameter.integerOf(StringUtils.EMPTY, groupId)); }
UserGroupDao extends BaseDao { public List<UserGroup> getUserGroupByGroupId(Long groupId) throws SQLException { String sql = "SELECT id, user_id, group_id, role, opt_user FROM user_group WHERE group_id = ?"; return this.queryBySql(sql, UserGroup.class, Parameter.integerOf(StringUtils.EMPTY, groupId)); } }
UserGroupDao extends BaseDao { public List<UserGroup> getUserGroupByGroupId(Long groupId) throws SQLException { String sql = "SELECT id, user_id, group_id, role, opt_user FROM user_group WHERE group_id = ?"; return this.queryBySql(sql, UserGroup.class, Parameter.integerOf(StringUtils.EMPTY, groupId)); }  }
UserGroupDao extends BaseDao { public List<UserGroup> getUserGroupByGroupId(Long groupId) throws SQLException { String sql = "SELECT id, user_id, group_id, role, opt_user FROM user_group WHERE group_id = ?"; return this.queryBySql(sql, UserGroup.class, Parameter.integerOf(StringUtils.EMPTY, groupId)); }  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<UserGroup> getUserGroupByGroupId(Long groupId) throws SQLException { String sql = "SELECT id, user_id, group_id, role, opt_user FROM user_group WHERE group_id = ?"; return this.queryBySql(sql, UserGroup.class, Parameter.integerOf(StringUtils.EMPTY, groupId)); }  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);  }