u04c102bo.java

持久层hibernate技术使用的一个例子

package cn.hope.front.bo;

import java.util.List;

import org.apache.log4j.Logger;

import cn.hope.front.pojo.SJournal;

import cn.hope.front.pojo.U07CommonListVO;
import cn.hope.front.pojo.dao.SJournalDAO;


import cn.hope.front.util.U07Page;

public class U04C102BO {
	Logger log = Logger.getLogger(U04C101BO.class.getName());
	SJournalDAO sJournalDAO = new SJournalDAO();
	SJournal sJournal = new SJournal();
	public U07CommonListVO serach(String id,int start, boolean isEq)throws Exception {
		U07CommonListVO cl_vo = new U07CommonListVO();
		int range = 2;// 每页显示记录数
		int count = 0;// 总记录数
		List list = null;// 查询得到的结果集
		U07Page page = new U07Page();// 分页
		String fenyeStr = "";
		try {
			list = sJournalDAO.searchSJournal(id, start, range,isEq);//得到结果集
			
			while (list.size() > 0) {
				sJournal = (SJournal) list.get(0);
				int i =sJournal.getCDutyconC().getCdId().intValue();
				int ii =sJournal.getCDutyconG().getCdId().intValue();
				//到校情况
				if(i==1){
					sJournal.setComeCase("正常");
				}
				else if(i==2){
					sJournal.setComeCase("病假");
				}
				else if(i==3){
					sJournal.setComeCase("早退");
				}
				else if(i==4){
					sJournal.setComeCase("事假");
				}
				else if(i==5){
					sJournal.setComeCase("旷课");
				}
				else if(i==6){
					sJournal.setComeCase("迟到");
				}
				else{
					sJournal.setComeCase("其他");
				}
				//离校情况
				if(ii==1){
					sJournal.setGoCase("正常");
				}
				else if(ii==2){
					sJournal.setGoCase("病假");
				}
				else if(ii==3){
					sJournal.setGoCase("早退");
				}
				else if(ii==4){
					sJournal.setGoCase("事假");
				}
				else if(ii==5){
					sJournal.setGoCase("旷课");
				}
				else if(ii==6){
					sJournal.setGoCase("迟到");
				}
				else{
					sJournal.setGoCase("其他");
				}
			}
		
			count = sJournalDAO.getCount();
			cl_vo.setRs(list);
			cl_vo.setCount(count);
			cl_vo.setStart(start);
			cl_vo.setRange(range);
		
			fenyeStr = page.fenye(cl_vo);
			cl_vo.setFenye(fenyeStr);
			cl_vo.setCurrentPage(page.getCurrentPage());
			cl_vo.setTotalPage(page.getTotalPage());
			cl_vo.setStartSub(page.getStartSub());
			cl_vo.setOverSub(page.getOverSub());
		} catch (Exception e) {
			log.error(e);
			e.printStackTrace();
			throw new Exception(e);
		}
		return cl_vo;
	}
}