filessearchrep.java

为公司做的质量考核接口源码,用spring,hibernate,XML实现,对XML接口编程很有帮助

package business.files;

import java.util.List;

import common.DisposeBase;
import common.QueryInfo;

import dao.FixFileFilesDAO;

public class FilesSearchRep extends DisposeBase{

	private FixFileFilesDAO dao;
	private QueryInfo info;
	
	public boolean dispose(){
		String TableName="TbFixFileFiles"; 
		String SelectFields=" id,fileName,corpNum,corpName,controlMan,controlDate,isSubmit,remark  ";
		String WhereSQL=null;
		String OrderByFields="id";
		boolean OrderByAsc=false;
		int PageSize=this.getHead().getParamInteger("PageSize").intValue();
		int PageIndex=this.getHead().getParamInteger("PageIndex").intValue();
		String fileId=this.getHead().getParamString("fileId");
		StringBuilder sb=new StringBuilder();
		sb.append("1=1");
		if (!fileId.equals("")) {
			sb.append(" and fileId like '%").append(fileId).append("%'");
		}
		WhereSQL=sb.toString();
		info.setTableName(TableName);
		info.setSelectFields(SelectFields);
		info.setOrderByAsc(OrderByAsc);
		info.setOrderByFields(OrderByFields);
		info.setPageIndex(PageIndex);
		info.setPageSize(PageSize);
		info.setWhereSQL(WhereSQL);
		List ret=null;
		try {
			ret=dao.findByPage();
			return retResult(ret);
		}catch(Exception e) {
			return retResult(e.getMessage());
		}
	}

	public FixFileFilesDAO getDao() {
		return dao;
	}

	public void setDao(FixFileFilesDAO dao) {
		this.dao = dao;
	}

	public QueryInfo getInfo() {
		return info;
	}

	public void setInfo(QueryInfo info) {
		this.info = info;
	}
}