majorserviceimple.java

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

package com.xm.xjgl.majormanage.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.majormanage.condition.MajorCondition;
import com.xm.xjgl.majormanage.domain.MajorEntity;


public class MajorServiceImple extends AbstractService implements MajorService {
	
	private MajorCondition condition ;

	public MajorCondition getCondition() {
		return condition;
	}
	public void setCondition(MajorCondition condition) {
		this.condition = condition;
	}
	
	/** 构建hquery*/
	public void creatHquery() throws Exception {
		super.hquery = new HQuery();
		hquery.setQueryString(condition.getHqlString());
		//实例化参数
		Paras paras1=new Paras();
		paras1.setPName("%"+condition.getZYMC()+"%");
		paras1.setTypeNo(Types.VARCHAR);
		Paras paras2=new Paras();
		paras2.setPName("%"+condition.getSSXB()+"%");
		paras2.setTypeNo(Types.VARCHAR);
		ParasList paraslist=new ParasList();
		paraslist.add(paras1);
		paraslist.add(paras2);
		hquery.setParaslist(paraslist);
		this.setPageInfo();
	}
	
	/**设置页面信息*/
	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 maj.MAJOR_ID asc" );
	}
	
	/**查询信息*/
	public List queryList() throws Exception {
		return dbDao.queryObjectsToPages(hquery);
	}
	/**批量删除专业信息*/
	public String delete(List list) {
		try {
			if(list==null||list.size()==0)	return "false";			
			dbDao.deleteObjects(MajorEntity.class,list);
			return "true";
		} catch (Exception e) {
			e.printStackTrace();
			return "error";		
		}
	}
	
	public int checkRepeat(Object obj) throws Exception {
		return 0;
	}
	/**添加专业信息*/
	public void add(Object obj)
	{
		try {
			dbDao.addObject(obj);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void delete(String id) throws Exception {
		
	}
	/**根据条件查询专业*/
	public Object queryById(String id) throws Exception {
		return dbDao.queryObjectById(MajorEntity.class, id);
	}
	/**保存修改后的专业信息*/
	public void saveObject(Object obj) throws Exception {
		 dbDao.updateObject(obj);
	}
	public String save(Object obj) throws Exception {
		return null;
	}

	

}