usermgmtdaohibernatetemplateimpl.java

电信用户自服务系统

package tarena.netctoss.dao.impl;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import tarena.netctoss.dao.IUserMgmtDAO;
import tarena.netctoss.model.User;
import tarena.netctoss.model.UserService;
import tarena.netctoss.util.PageBean;

public class UserMgmtDAOHibernateTemplateImpl extends
		BaseDAOHibernateTemplateImpl implements IUserMgmtDAO {

	public Integer[] countUserNumbers() {
		// TODO Auto-generated method stub
		return null;
	}

	public Collection pagination(int pageNumber, int pageLength) {
		// TODO Auto-generated method stub
		System.out.println("paginationDAO start");
		ArrayList c1 = new ArrayList();
		Collection<User> c = new ArrayList();
		c = this.selectAll(User.class);
		/*
		 * 伪实现
		for(int i=0;i<17;i++){
			User u = new User();
			u.setName("hongye - " + i);
			c.add(u);
		}
		 */
		
		PageBean pb = new PageBean();
		pb.setCurrentPage(pageNumber);
		pb.setPageRows(pageLength);
		pb.setTotalRows(c.size());
		int n = pb.getTotalRows() / pb.getPageRows();
		int m = pb.getTotalRows() % pb.getPageRows();
		if(m != 0){
			n += 1;
		}
		pb.setTotalPages(n);
		int count = 0;
		int num = 1;
		for(User u : c){
			if(pb.getCurrentPage() == 1 && num <= pb.getPageRows()){
				System.out.println("加" + num + "次***************");
				c1.add(u);
				num++;
			}else if(count > ((pb.getCurrentPage() - 1) * pb.getPageRows()) && num <= pb.getPageRows()){
				System.out.println("加" + num + "次+++++++++++++++");
				c1.add(u);
				num++;
			}
			System.out.println("执行了" + count + "次");
			System.out.println("每次的值是:" + u.getName());
			count++;
		}
		
		
		return c1;
	}

	public UserService selectServiceByLabLoginNameAndLabIp(String labLoginName,
			String labIp) {
		// TODO Auto-generated method stub
		String hql = "select u from UserService u where u.labLoginName=:labLoginName and u.labIp=:labIp";
		String[] strp = new String[]{"labLoginName", "labIp"};
		Object[] strv = new Object[]{labLoginName, labIp};
		List list = getHibernateTemplate().findByNamedParam(hql, strp, strv);
		if(list.size() == 0){
			return null;
		}
		return (UserService)list.get(0);
	}

	public Collection selectServicesByUserId(Integer uid) {
		// TODO Auto-generated method stub
		String hql = "select u from UserService u where u.id=:uid";
		List list = getHibernateTemplate().findByNamedParam(hql, "uid", uid);
		if(list.size() == 0){
			return null;
		}
		return list;
	}

	public User selectUserByLoginName(String loginName) {
		// TODO Auto-generated method stub
		String hql = "select u from User u where u.loginName=:loginName";
		List list = getHibernateTemplate().findByNamedParam(hql, "loginName", loginName);
		if(list.size() == 0){
			System.out.println("list is null");
			return null;
		}
		return (User)list.get(0);
	}

	public void updateUserServiceStatus(UserService service) {
		// TODO Auto-generated method stub
		this.update(service);
	}

	public void updateUserStatus(User user) {
		// TODO Auto-generated method stub
		this.update(user);
	}

}