teamdaoimpl.java

学生成绩管理系统

package com.qrsx.course.daoImpl;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;

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

import com.qrsx.course.dao.TeamDAO;
import com.qrsx.course.model.Team;
import com.qrsx.course.util.PageModel;



/**
 * 
 * @author Administrator
 *
 */
public class TeamDAOImpl extends HibernateDaoSupport implements TeamDAO {

	/**
	 * 添加班级
	 * @param 
	 */
	public void addTeam(Team team) throws Exception{
		
		this.getHibernateTemplate().save(team);

	}

	/**
	 * 修改班级
	 * @param 
	 */
	public void modifyTeam(Team team) throws Exception {

		this.getHibernateTemplate().update(team);
		
	}

	/**
	 * 删除班级
	 * @param 
	 */
	public void deleteTeam(String[] teamIdList) throws Exception {
		
		for (int i=0; i<teamIdList.length; i++) {
			Team team = (Team)this.getHibernateTemplate().load(Team.class, teamIdList[i]);
			this.getHibernateTemplate().delete(team);
		}		
	}

	/**
	 * 查询全部班级
	 */
	@SuppressWarnings("unchecked")
	public List<Team> findAllTeams() {

		List<Team> teamList = new ArrayList<Team>();
	
		Session session = this.getSession();
		Query query = session.createQuery("from Team t");
		teamList = query.list();
	
		return teamList;

	}
	
	
	/**
	 * 根据Id查询班级
	 * @param 
	 */
	public Team findTeamById(String id) {

		Team team = (Team)this.getHibernateTemplate().load(Team.class, id);
		
		return team;
	}

	/**
	 * 根据条件查询班级信息
	 */
	@SuppressWarnings("unchecked")
	public PageModel listTeam(int pageNo, Team team) {
		
		PageModel pageModel = null;
		List teamList = new ArrayList();
		
		Example exampleTeam = Example.create(team)
									 .enableLike(MatchMode.ANYWHERE)
									 .ignoreCase();

		
		teamList = this.getSession().createCriteria(Team.class)
									.add(exampleTeam)
									.setFirstResult((pageNo - 1) * PageModel.pageSize)
									.setMaxResults(PageModel.pageSize)
									.list();
		
		pageModel = new PageModel();
		pageModel.setPageNo(pageNo);
		pageModel.setList(teamList);
		pageModel.setTotalRecords(getTotalRecords(team));
		
		return pageModel;

	}

	/**
	 * 查询记录数
	 * @param 
	 * @return
	 */
	@SuppressWarnings("unchecked")
	private int getTotalRecords(Team team) {
		List teamList = new ArrayList();
		
		Example exampleTeam = Example.create(team)
		 							 .enableLike(MatchMode.ANYWHERE)
		 							 .ignoreCase();

		
		teamList = this.getSession().createCriteria(Team.class)
											   .add(exampleTeam)
											   .list();
		return teamList.size();
	}

}