daosupport.java

用SPRING做的一个企业信息系统网站

package com.enterpriseweb.bean;

import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import org.springframework.jdbc.core.JdbcTemplate;

import com.enterpriseweb.util.Constants;

public class DaoSupport {
	
	private JdbcTemplate jtl;

	public JdbcTemplate getJtl() {
		return jtl;
	}

	public void setJtl(JdbcTemplate jtl) {
		this.jtl = jtl;
	}
	public List getObjectList(String sql){
		List list = this.jtl.queryForList(sql);
		if(list == null || list.isEmpty()){
			return null;
		}
		return list;
	}
	public void saveObject(String sql){
		this.jtl.execute(sql);
	}
	public void updateObject(String sql){
		this.jtl.update(sql);
	}
	public void deleteObject(String sql){
		this.jtl.execute(sql);
	}
	public int getTotalPage(String sql){
		int s = this.jtl.queryForInt(sql);
		return s;
	}
	public PageBean getPageBean(String sql1, String sql2, String sql3,
			String sql4, String sql5, String tablename, int curPage,
			int maxRowCount){
		PageBean pageBean = new PageBean(Constants.PAGE_LENGTH);
		try{
			Vector vec = new Vector();
			List list = this.jtl.queryForList(sql1 + pageBean.rowsPerPage + sql2
					+ tablename + sql3 + (curPage - 1) * pageBean.rowsPerPage
					+ sql4 + Constants.Products + sql5);
			int i = 0;
			Iterator it = list.iterator();
			while(it.hasNext()){
				if(i>(pageBean.curPage-1)*Constants.PAGE_LENGTH-1){
					vec.add(it.next());
				}
				i++;
			}
			pageBean.setMaxRowCount(maxRowCount);
			pageBean.setRowsPerPage(Constants.PAGE_LENGTH);
			pageBean.countTotalPage();
			pageBean.curPage = curPage;
			pageBean.setData(vec);
		}catch(Exception e){
			e.printStackTrace();
		}
		return pageBean;
	}
	//控制动态分页
	public PageBean getPageBean1(String sql, int curPage, int maxRowCount){
		
		PageBean pageBean = new PageBean(Constants.PAGE_LENGTH);
		try{
			Vector vec = new Vector();
			List list = this.jtl.queryForList(sql);
			int  i = 0;
			Iterator it = list.iterator();
			while(it.hasNext()){
				if(i>(pageBean.maxRowCount+Constants.PAGE_LENGTH-1)/Constants.PAGE_LENGTH){
					vec.add(it.next());
				}
				i++;
			}
			pageBean.setMaxRowCount(maxRowCount);
			pageBean.setRowsPerPage(Constants.PAGE_LENGTH);
			pageBean.countTotalPage();
			pageBean.curPage = curPage;
			pageBean.setData(vec);
			
		}catch(Exception e){
			e.printStackTrace();
		}
		return pageBean;
	}
}