integraldao.java

一个oa系统

package com.oa.companyculture.db;

import java.util.List;

import org.hibernate.HibernateException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.oa.db.User;

public class IntegralDao extends HibernateDaoSupport {
	
	/**
	 * 查询所以用户的信息
	 * @return
	 */
	public List findAll(){
		List list = null;
		try {  
			list = (List)this.getHibernateTemplate().find("from Integral order by integrals desc");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	/**
	 * 根据用户名查询用户的积分信息
	 * 
	 * @param userName
	 * @return
	 */
	public List findByUserName(String userName) {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Integral where username=?", userName);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 用户每次发帖后,增加一次回帖数及积分,并及时更新称号
	 * 
	 * @param userName
	 */
	public void addIssueNumsAndIntegrals(String userName) {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Integral where username=?", userName);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (list != null && list.size() != 0) {
			Integral integral = (Integral) list.get(0);
			int issuenums = integral.getIssuenums();
			int integrals = integral.getIntegrals();
			integrals = integrals + 5;
			issuenums++;
			if (integrals < 20) {
				integral.setLeve("注册看看");
			} else if (integrals >= 20 && integrals < 50) {
				integral.setLeve("偶尔光临");
			} else if (integrals >= 50 && integrals < 100) {
				integral.setLeve("常驻人口");
			} else if (integrals >= 100 && integrals < 200) {
				integral.setLeve("以坛为家");
			} else if (integrals >= 200 && integrals < 400) {
				integral.setLeve("伴坛终老");
			} else if (integrals >= 400 && integrals < 600) {
				integral.setLeve("缘定三生");
			} else if (integrals >= 600 && integrals < 1000) {
				integral.setLeve("七世轮回");
			} else if (integrals > 1000) {
				integral.setLeve("十世金身");
			}
			integral.setIssuenums(issuenums);
			integral.setIntegrals(integrals);
			this.getHibernateTemplate().update(integral);
		}
	}

	/**
	 * 用户每次回帖后,增加一次回帖数及积分,并及时更新称号
	 * 
	 * @param userName
	 */
	public void addRevertNumsAndIntegrals(String userName) {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Integral where username=?", userName);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	  if (list != null && list.size() != 0) {
			Integral integral = (Integral) list.get(0);
			int revertnums = integral.getRevertnums();
			int integrals = integral.getIntegrals();
			integrals = integrals + 1;
			revertnums++;
			if (integrals < 20) {
				integral.setLeve("注册看看");
			} else if (integrals >= 20 && integrals < 50) {
				integral.setLeve("偶尔光临");
			} else if (integrals >= 50 && integrals < 100) {
				integral.setLeve("常驻人口");
			} else if (integrals >= 100 && integrals < 200) {
				integral.setLeve("以坛为家");
			} else if (integrals >= 200 && integrals < 400) {
				integral.setLeve("伴坛终老");
			} else if (integrals >= 400 && integrals < 600) {
				integral.setLeve("缘定三生");
			} else if (integrals >= 600 && integrals < 1000) {
				integral.setLeve("七世轮回");
			} else if (integrals > 1000) {
				integral.setLeve("十世金身");
			}
			integral.setRevertnums(revertnums);
			integral.setIntegrals(integrals);
			this.getHibernateTemplate().update(integral);
		}
	}
	
	public void Save(Integral vo) {// 保存积分信息
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}