@Test public void deleteUserFromGroup() throws Exception { int count = userGroupDao.deleteUserFromGroup(1L, 1L); System.out.println("deleteUserFromGroup :-------> " + count); Assert.assertTrue(count > 0); }
public int deleteUserFromGroup(Long user_id, Long group_id) throws SQLException { String sql = "DELETE FROM user_group WHERE user_id=? AND group_id=?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, user_id), Parameter.integerOf(StringUtils.EMPTY, group_id)); }
UserGroupDao extends BaseDao { public int deleteUserFromGroup(Long user_id, Long group_id) throws SQLException { String sql = "DELETE FROM user_group WHERE user_id=? AND group_id=?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, user_id), Parameter.integerOf(StringUtils.EMPTY, group_id)); } }
UserGroupDao extends BaseDao { public int deleteUserFromGroup(Long user_id, Long group_id) throws SQLException { String sql = "DELETE FROM user_group WHERE user_id=? AND group_id=?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, user_id), Parameter.integerOf(StringUtils.EMPTY, group_id)); }  }
UserGroupDao extends BaseDao { public int deleteUserFromGroup(Long user_id, Long group_id) throws SQLException { String sql = "DELETE FROM user_group WHERE user_id=? AND group_id=?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, user_id), Parameter.integerOf(StringUtils.EMPTY, group_id)); }  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 int deleteUserFromGroup(Long user_id, Long group_id) throws SQLException { String sql = "DELETE FROM user_group WHERE user_id=? AND group_id=?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, user_id), Parameter.integerOf(StringUtils.EMPTY, group_id)); }  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);  }