daosupport.java

企业门户网站企业商务网是企业信息化管理进程中的一个重要的标志

package com.dao;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.JdbcTemplate;

import com.action.ManagerAction;
import com.dao.PageBean;

public class DaoSupport {
	protected static final Log log = LogFactory.getLog(ManagerAction.class
			.getName());

	private JdbcTemplate jtl = null;

	public JdbcTemplate getJtl() {
		return jtl;
	}

	public void setJtl(JdbcTemplate jtl) {
		this.jtl = jtl;
	}

	public List getObjectList(String sqlSelect) {
		List list = jtl.queryForList(sqlSelect);
		System.out.println("list:" + list);
		return list;
	}

	public void executeSql(String insertSql) {
		jtl.execute(insertSql);
	}

	// 取得总行数
	public int totalPage(String selectSql) {
		int s = jtl.queryForInt(selectSql);
		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); // 初始化一个PageBean对象,存储分页数据
		try {
			Vector vec = new Vector();
			log.info("执行SQL语句SELECT TOP 查询出前几条语句!");
			List list = jtl.queryForList(sql1 + pageBean.rowsPerPage + sql2
					+ tablename + sql3 + (curPage - 1) * pageBean.rowsPerPage
					+ sql4 + Constants.Products + sql5);
			System.out.println(list.size());
			System.out.println(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 > (curPage - 1) * Constants.PAGE_LENGTH - 1) {
					log.info("到此!");
					// String[] productForm = (String[]) it.next();
					// System.out.println(productForm);
					vec.add(it.next());
				}
				i++;
			}
			pageBean.setMaxRowCount(maxRowCount);
			System.out.println("记录总条数 " + pageBean.getMaxRowCount());
			pageBean.setRowsPerPage(Constants.PAGE_LENGTH);
			System.out.println("每页的条数 " + pageBean.getRowsPerPage());
			pageBean.countMaxPage();
			pageBean.curPage = curPage;
			System.out.println("当前页  " + pageBean.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); // 初始化一个PageBean对象,存储分页数据

		try {
			Vector vec = new Vector();
			log.info("执行SQL语句SELECT TOP 查询出前几条语句!");
			List list = jtl.queryForList(sql);
			System.out.println(sql);
			int i = 0;
			Iterator it = list.iterator();
			while (it.hasNext()) {
				if (i > (curPage - 1) * Constants.PAGE_LENGTH - 1) {
					log.info("到此!");
					// String[] productForm = (String[]) it.next();
					// System.out.println(productForm);
					vec.add(it.next());
				}
				i++;
			}
			pageBean.setMaxRowCount(maxRowCount);
			System.out.println("记录总条数 " + pageBean.getMaxRowCount());
			pageBean.setRowsPerPage(Constants.PAGE_LENGTH);
			System.out.println("每页的条数 " + pageBean.getRowsPerPage());
			pageBean.countMaxPage();
			pageBean.curPage = curPage;
			System.out.println("当前页  " + pageBean.curPage);
			pageBean.setData(vec);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return pageBean;
	}

}