studentserviceimple.java

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

package com.xm.xjgl.xslr.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.xslr.condition.StudentCondition;
import com.xm.xjgl.xslr.domain.StudentEntity;

public class StudentServiceImple extends AbstractService implements
		StudentService {
	
	private StudentCondition condition ;

	public StudentCondition getCondition() {
		return condition;
	}
	public void setCondition(StudentCondition condition) {
		this.condition = condition;
	}

	public int checkRepeat(Object obj) throws Exception {
		return 0;
	}
	/** 构建hquery*/
	public void creatHquery() throws Exception {
		super.hquery = new HQuery();
		hquery.setQueryString(condition.getHqlString());
		//实例化参数
		Paras paras1=new Paras();
		paras1.setPName("%"+condition.getST_NAME()+"%");
		paras1.setTypeNo(Types.VARCHAR);
		Paras paras2=new Paras();
		paras2.setPName("%"+condition.getST_XH()+"%");
		paras2.setTypeNo(Types.VARCHAR);
	
		Paras paras4=new Paras();
		paras4.setPName("%"+condition.getCSRQ()+"%");
		paras4.setTypeNo(Types.VARCHAR);
		Paras paras5=new Paras();
		paras5.setPName("%"+condition.getRXRQ()+"%");
		paras5.setTypeNo(Types.VARCHAR);
		Paras paras6=new Paras();
		paras6.setPName("%"+condition.getSFZH()+"%");
		paras6.setTypeNo(Types.VARCHAR);
		Paras paras7=new Paras();
		paras7.setPName("%"+condition.getXB()+"%");
		paras7.setTypeNo(Types.VARCHAR);
		Paras paras8=new Paras();
		paras8.setPName("%"+condition.getMZ()+"%");
		paras8.setTypeNo(Types.VARCHAR);
		Paras paras9=new Paras();
		paras9.setPName("%"+condition.getSZXB()+"%");
		paras9.setTypeNo(Types.VARCHAR);
		
		Paras paras12=new Paras();
		paras12.setPName("%"+condition.getPYFS()+"%");
		paras12.setTypeNo(Types.VARCHAR);
		Paras paras13=new Paras();
		paras13.setPName("%"+condition.getEMAIL()+"%");
		paras13.setTypeNo(Types.VARCHAR);
		Paras paras14=new Paras();
		paras14.setPName("%"+condition.getPHONE()+"%");
		paras14.setTypeNo(Types.VARCHAR);
		Paras paras15=new Paras();
		paras15.setPName("%"+condition.getZZMM()+"%");
		paras15.setTypeNo(Types.VARCHAR);
		Paras paras16=new Paras();
		paras16.setPName("%"+condition.getXZ()+"%");
		paras16.setTypeNo(Types.VARCHAR);
		Paras paras17=new Paras();
		paras17.setPName("%"+condition.getZT()+"%");
		paras17.setTypeNo(Types.VARCHAR);
		ParasList paraslist=new ParasList();
		paraslist.add(paras1);
		paraslist.add(paras2);
		paraslist.add(paras4);
		paraslist.add(paras5);
		paraslist.add(paras6);
		paraslist.add(paras7);
		paraslist.add(paras8);
		paraslist.add(paras9);
		paraslist.add(paras12);
		paraslist.add(paras13);
		paraslist.add(paras14);
		paraslist.add(paras15);
		paraslist.add(paras16);
		paraslist.add(paras17);
		hquery.setParaslist(paraslist);
		this.setPageInfo();
	}

	public void delete(String id) throws Exception {

	}
	/**查询详细信息*/
	public Object queryById(String id) throws Exception {
		return dbDao.queryObjectById(StudentEntity.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 {
		dbDao.updateObject(obj);
	}

	/**设置页面信息*/
	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.XJ_ID asc" );
	}
	
	/**批量删除记录*/
	public String delete(List list) {
		try {
			if(list==null||list.size()==0)	return "false";			
			dbDao.deleteObjects(StudentEntity.class,list);
			return "true";
		} catch (Exception e) {
			e.printStackTrace();
			return "error";		
		}
	}
	
	/**添加学籍信息*/
	public void add(Object obj)
	{
		try {
			dbDao.addObject(obj);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}