memberservice.java

论坛软件系统亦称电子公告板(BBS)系统

			sql.append(and);
			and = " and ";
			sql.append(" extcredits2 < " + lower_extcredits2);
		}
		if (!higher_extcredits2.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits2 > " + higher_extcredits2);
		}
		if (!higher_extcredits3.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits3 > " + higher_extcredits3);
		}
		if (!higher_extcredits4.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits4 > " + higher_extcredits4);
		}
		if (!higher_extcredits5.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits5 > " + higher_extcredits5);
		}
		if (!higher_extcredits6.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits6 > " + higher_extcredits6);
		}
		if (!higher_extcredits7.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits7 > " + higher_extcredits7);
		}
		if (!higher_extcredits8.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits8 > " + higher_extcredits8);
		}
		if (!lower_extcredits3.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits3 < " + lower_extcredits3);
		}
		if (!lower_extcredits4.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits4 < " + lower_extcredits4);
		}
		if (!lower_extcredits5.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits5 < " + lower_extcredits5);
		}
		if (!lower_extcredits6.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits6 < " + lower_extcredits6);
		}
		if (!lower_extcredits7.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits7 < " + lower_extcredits7);
		}
		if (!lower_extcredits8.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" extcredits8 < " + lower_extcredits8);
		}
		if (!lower_posts.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" posts < " + lower_posts);
		}
		if (!higher_posts.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" posts > " + higher_posts);
		}
		if (!regip.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" regip like '" + regip + "%' ");
		}
		if (!lastip.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" lastip like '" + lastip + "%' ");
		}
		if (!regdatebefore.equals("")) {
			regdatebefore = (Common.dataToInteger(regdatebefore, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" regdate < " + regdatebefore);
		}
		if (!regdateafter.equals("")) {
			regdateafter = (Common.dataToInteger(regdateafter, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" regdate > " + regdateafter);
		}
		if (!lastvisitbefore.equals("")) {
			lastvisitbefore = (Common.dataToInteger(lastvisitbefore, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" lastvisit < " + lastvisitbefore);
		}
		if (!lastvisitafter.equals("")) {
			lastvisitafter =(Common.dataToInteger(lastvisitafter, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" lastvisit > " + lastvisitafter);
		}
		if (!lastpostbefore.equals("")) {
			lastpostbefore = (Common.dataToInteger(lastpostbefore, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" lastpost < " + lastpostbefore);
		}
		if (!lastpostafter.equals("")) {
			lastpostafter = (Common.dataToInteger(lastpostafter, "yyyy-MM-dd")-timeoffset)+"";
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" lastpost > " + lastpostafter);
		}
		if (!birthyear.equals("")||!birthmonth.equals("")||!birthday.equals("")) {
			sql.append(where);
			where = " ";
			sql.append(and);
			and = " and ";
			sql.append(" bday like '" + (!birthyear.equals("")?birthyear:"%") + "-"+(!birthmonth.equals("")?birthmonth:"%")+"-"+(!birthday.equals("")?birthday:"%")+" '");
		}
		return sql.toString();
	}
	public boolean insertRanks(Ranks rank) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertRanks(rank);
	}

	public boolean modifyRanks(Ranks rank) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).modifyRanks(rank);
	}
	public boolean deleteRanks(Ranks rank) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteRanks(rank);
	}
	public Ranks findRanksById(short rankId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findRanksById(rankId);
	}
	public List<Ranks> findAllRanks() {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findAllRanks();
	}
	public boolean insertAccess(Access access) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertAccess(access);
	}
	public boolean modifyAccess(Access access) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).modifyAccess(access);
	}
	public boolean deleteAccess(Access access) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteAccess(access);
	}
	public List<Access> findAccessByUserId(int userId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findAccessByUserId(userId);
	}
	public boolean insertMemberfields(Memberfields memberfields) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertMemberfields(memberfields);
	}
	public boolean modifyMemberfields(Memberfields memberfields) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).modifyMemberfields(memberfields);
	}
	public boolean deleteMemberfields(Memberfields memberfields) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteMemberfields(memberfields);
	}
	public Memberfields findMemberfieldsById(int memberFieldsId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMemberfieldsById(memberFieldsId);
	}
	public boolean insertOnlineTime(Onlinetime onlinetime) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertOnlineTime(onlinetime);
	}
	public boolean modifyOnlineTime(Onlinetime onlinetime) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).modifyOnlineTime(onlinetime);
	}
	public boolean deleteOnlineTime(Onlinetime onlinetime) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteOnlineTime(onlinetime);
	}
	public Onlinetime findOnlineTimeById(int onlinetimeId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findOnlinetimeById(onlinetimeId);
	}
	public List<Styles> findAllStyles() {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findAllStyles();
	}
	public boolean insertPms(Pms pms) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertPms(pms);
	}
	public Members findMemberById(int memberId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMemberById(memberId);
	}
	public List<Forums> findForumsByType() {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findForumsByType();
	}
	public Access findAccessByFid(short fid, int uid) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findAccessByFid(fid, uid);
	}
	public boolean deleteSpacecaches(int uid) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteSpacecaches(uid);
	}
	public List<Medals> findMedalsByAvailable(byte available) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMedalsByAvailable(available);
	}
	public List<Usergroups> findUsergroupByExt() {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findUsergroupByExt();
	}
	public boolean deleteValidating(Validating validate) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).deleteValidating(validate);
	}
	public List<Members> findMembersByGroupid(Short groupid) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMembersByGroupid(groupid);
	}
	public List findMembersByInId(int lowerId, int upperId) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMembersByInId(lowerId, upperId);
	}
	public boolean insertMemberByJDBC(Members member) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).insertMemberByJDBC(member);
	}
	public List<Members> getMemberListWithMemberIdList(List<Integer> memberIdList){
		return ((MembersDao) BeanFactory.getBean("memberDao")).getMemberListWithMemberIdList(memberIdList);
	}
	public List<Profilefields> findprofilefieldByAvaliable(byte avaliable){
		return ((MembersDao) BeanFactory.getBean("memberDao")).findprofilefieldByAvaliable(avaliable);
	}
	public List<Members> findByProperty(String propertyName, Object value) {
		return ((MembersDao) BeanFactory.getBean("memberDao")).findByProperty(propertyName, value);
	}
	public List<Members> findMembersByHql(String hql,int startrow,int maxrows){
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMembersByHql(hql, startrow, maxrows);
	}
	public int findMemberCountByHql(String hql){
		return ((MembersDao) BeanFactory.getBean("memberDao")).findMemberCountByHql(hql);
	}
	public List<Members> getAllMembers(){
		return ((MembersDao) BeanFactory.getBean("memberDao")).getAllMembers();
	}
	public void updateMembers(List<Members> membersList){
		((MembersDao) BeanFactory.getBean("memberDao")).updateMembers(membersList);
	}
	
	public void updateMembers(String hql){
		((MembersDao) BeanFactory.getBean("memberDao")).updateMembers(hql);
	}
}