pagedivbean.java

struts标签库,中英文版,数据添删改查,验证等功能,自己写的.

package com.jackie.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class PageDivBean {

	ResultSet rs = null;
	Connection con = null;
	Statement stmt = null;
	int pageRecord = 10;
	int reqPage = 1;
	int totalPages = 1;
	private String tabName;

	public ResultSet getRs() {
		int requestRecord = (reqPage - 1) * pageRecord;
		String mysql = "select * from " + tabName + " limit " + requestRecord
				+ "," + pageRecord;
		int pageNum=reqPage*pageRecord;
		String sql1 = "select threadid from (select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads) as T sswhere T.Pos > 100000 and T.Pos < 100030";
		String sql2005 = "select * from (select *, ROW_NUMBER() OVER (order by userid) as Pos from users) as T where T.Pos > "+requestRecord+" and T.Pos <="+pageNum;
		System.out.println("pageDivbean sql=" + sql2005);
		try {
			rs = stmt.executeQuery(sql2005);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}

	public void setRs(ResultSet rs) {
		this.rs = rs;
	}

	public Connection getCon() {
		return con;
	}

	public void setCon(Connection con) {
		this.con = con;
		try {
			stmt = con.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Statement getStmt() {
		return stmt;
	}

	public void setStmt(Statement stmt) {
		this.stmt = stmt;
	}

	public int getPageRecord() {
		return pageRecord;
	}

	public void setPageRecord(int pageRecord) {
		this.pageRecord = pageRecord;
	}

	public int getReqPage() {
		return reqPage;
	}

	public void setReqPage(int reqPage) {
		this.reqPage = reqPage;
	}

	public int getTotalPages() {
		int totalRecords = getTotalRecords();
		if (totalRecords % pageRecord == 0) {
			totalPages = totalRecords / pageRecord;
		} else {
			totalPages = totalRecords / pageRecord + 1;
		}
		return totalPages;
	}

	private int getTotalRecords() {
		// TODO Auto-generated method stub
		int totalRecords = 0;
		String sql = "select count(*) from " + tabName;
		try {
			ResultSet rs = stmt.executeQuery(sql);
			rs.next();
			totalRecords = rs.getInt(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return totalRecords;
	}

	public void setTotalPages(int totalPages) {
		this.totalPages = totalPages;
	}

	public String getTabName() {
		return tabName;
	}

	public void setTabName(String tabName) {
		this.tabName = tabName;
	}
}