querydao.java

JAVA实现的中小型企业CRM客户关系管理系统

package com.crm.query;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import com.crm.common.Page;
import com.crm.dao.CommonDAO;
import com.crm.message.po.Message;


public class QueryDAO extends CommonDAO implements IQueryDAO{

	public List getList(Map params,String sqlname, HttpServletRequest request) {
		Page page = new Page();
		//获取当前页
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject(sqlname+"count",params);
		page.setRscount(count.intValue());
		//计算总页数
		int pagecout = page.getPageCount();
		
		
		
		int pagesize = page.getPagesize();
		
		//生成显示tool 
		String pagetool = page.pagetool(request.getRequestURI()+page.getParams(request));
		request.setAttribute("pagetool",pagetool);

		List list =  this.getSqlMapClientTemplate().queryForList(sqlname,params,(currentPage-1)*pagesize,pagesize);
		return list;
	}

	
}