mydictdao.java

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

package com.crm.mydict;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.crm.common.Page;
import com.crm.dao.CommonDAO;
import com.crm.mydict.po.MyDictInfo;

public class MyDictDAO extends CommonDAO implements IMyDictDAO{


	public List getMyDictList(MyDictInfo mydictinfo,HttpServletRequest request){
		Page page = new Page();
		
		
		//获取当前页 
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject("MyDict.selectmydictcount",mydictinfo);
		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("MyDict.selectmydictlist",mydictinfo,(currentPage-1)*pagesize,pagesize);
//	System.out.println("list.size="+list.size());
		return list;
		//
	}
	public boolean addMyDict(MyDictInfo mydictinfo){

		this.getSqlMapClientTemplate().insert("MyDict.insertmydict", mydictinfo);
		return true;
	}
	public boolean modifyMyDict(MyDictInfo mydictinfo){

		this.getSqlMapClientTemplate().update("MyDict.updatemydict", mydictinfo);
		return true;
	}	
	public List getMyDictTypeList(MyDictInfo mydictinfo){
		return this.getSqlMapClientTemplate().queryForList("MyDict.selectdicttype",mydictinfo);
	}
	public List getMyDictTypeList(String typeid){
		MyDictInfo mydictinfo = new MyDictInfo();
		mydictinfo.setTypeid(typeid);
		return this.getSqlMapClientTemplate().queryForList("MyDict.selectdicttype",mydictinfo);
	}
	public MyDictInfo getMyDictInfo(String sId){
		return (MyDictInfo)this.getSqlMapClientTemplate().queryForObject("MyDict.selectmydict", sId);
	}
	 
	 

}