classserviceimple.java

本源码为教学管理信息系统

package com.xm.xjgl.classmanage.service;

import java.sql.Types;
import java.util.List;

import com.wygl.page.HQuery;
import com.wygl.page.Paras;
import com.wygl.page.ParasList;
import com.wygl.service.AbstractService;
import com.xm.xjgl.classmanage.condition.ClassCondition;
import com.xm.xjgl.classmanage.domain.ClassEntity;

public class ClassServiceImple extends AbstractService implements ClassService {

	private ClassCondition condition ;
	
	public ClassCondition getCondition() {
		return condition;
	}

	public void setCondition(ClassCondition condition) {
		this.condition = condition;
	}
	
	public int checkRepeat(Object obj) throws Exception {
		return 0;
	}

	public void creatHquery() throws Exception {
		super.hquery = new HQuery();
		hquery.setQueryString(condition.getHqlString());
		//实例化参数
		Paras paras1=new Paras();
		paras1.setPName("%"+condition.getCLASS_BH()+"%");
		paras1.setTypeNo(Types.VARCHAR);
		Paras paras2=new Paras();
		paras2.setPName("%"+condition.getSSZY()+"%");
		paras2.setTypeNo(Types.VARCHAR);
		Paras paras3=new Paras();
		paras3.setPName("%"+condition.getSSXB()+"%");
		paras3.setTypeNo(Types.VARCHAR);
		ParasList paraslist=new ParasList();
		paraslist.add(paras1);
		paraslist.add(paras2);
		paraslist.add(paras3);
		hquery.setParaslist(paraslist);
		this.setPageInfo();
	}

	public void delete(String id) throws Exception {

	}
	/**根据ID查实体*/
	public Object queryById(String id) throws Exception {
		return dbDao.queryObjectById(ClassEntity.class, id);
	}

	/**查询信息*/
	public List queryList() throws Exception {
		return dbDao.queryObjectsToPages(hquery);
	}
	
	public String save(Object obj) throws Exception {
		return null;
	}
	
	/**保存修改后的班级信息*/
	public void saveObject(Object obj) throws Exception {
		super.dbDao.updateObject(obj);
	}
	/**添加班级信息*/
	public void add(Object obj){
		try {
			super.dbDao.addObject(obj);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	/**批量删除记录*/
	public String delete(List list)
	{
		try {
			if(list==null||list.size()==0)	return "false";			
			dbDao.deleteObjects(ClassEntity.class,list);
			return "true";
		} catch (Exception e) {
			e.printStackTrace();
			return "error";		
		}
	}
	
	/**设置页面信息*/
	public void setPageInfo() throws Exception {
		//查询记录总数
		int pagecount = 0;
		pagecount = dbDao.count(hquery);
		condition.setRowCounts(pagecount);
		condition.setCrossPages(Math.round(Math.ceil(pagecount*1.0/condition.getRowsPerpage())));  
		if(condition.getPageNo() > condition.getCrossPages()){
		    condition.setPageNo(condition.getCrossPages());
		}
		//设置当前行
		long currentRow = (condition.getPageNo() - 1)*condition.getRowsPerpage();
		if(currentRow < 0){
			currentRow = 0;
			condition.setPageNo(1);
		}
		condition.setCurrentRow(currentRow + 1);	
		//调用查寻方法得到第一页结果
		hquery.setPageStartNo(condition.getPageNo());
		hquery.setOrderby(" order by st.CLASS_ID asc" );	
	}

	public List queryByHql() {
		String hql = "from ClassEntity";
		try {
			return dbDao.queryObjects(hql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}



}