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;
	}

}