emergencypage.java~3~

野生动物系统的JAVA源码, 野生动物系统的JAVA源码

package scout.operation.emergency;

import scout.database.util.*;
import scout.util.*;
import java.sql.*;
import java.util.*;

/**
 * <p>Title: 国家陆生野生动物疫源疫病监测信息系统</p>
 *
 * <p>Description:分页 </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Leizhao
 * @version 1.0
 */

public class EmergencyPage extends Pagination{
    public EmergencyPage() {
        this.rowsPerPage = 10;
        try {
            this.setPageBean("emergency");
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    /**
     * 得到要显示在本页的数据
     * 输入参数：String page 第几页的内容，String tableName,操作的表名
     * 返回类型：Pagination,可通过此对象的data属性访问结果。
     **/
    public EmergencyPage getResult(String page) throws Exception {
        try {
            EmergencyPage p = new EmergencyPage();
            Vector v = new Vector();
            int pageNum = Integer.parseInt(page); //第几页的数据。
            Statement s = con.createStatement();

            //联合查询
            String sql =
                    "select * from emergency "
                    + " LIMIT " + ((pageNum - 1) * this.rowsPerPage) +
                    "," + p.rowsPerPage;
            ResultSet rs = s.executeQuery(sql);
            v = this.getRecord(rs);
            rs.close();
            s.close();

            p.setCurPage(pageNum);
            p.data = v;
            return p;
        } catch (Exception ex) {
            ex.printStackTrace();
            throw ex;
        }
    }


    /**
     * 根据不同的表结构获得不同的结果
     * 输入参数：String page 第几页的内容，String tableName,操作的表名
     * 返回类型：Pagination,可通过此对象的data属性访问结果。
     **/

    protected Vector getRecord(ResultSet rs) throws Exception {
        Vector v = new Vector();
        while (rs.next()) {
            Object[] obj = new Object[7];
            obj[0] = rs.getString("number");
            obj[1] = rs.getString("scoutDate");
            obj[2] = rs.getString("scoutSite");
            obj[3] = rs.getString("scoutMan");
            obj[4] = rs.getString("scoutTime");
            obj[5] = rs.getString("scoutAddr");
            obj[6] = rs.getInt("ID");
            v.add(obj);
        }
        return v;
    }

    /**
     * 调试代码*/
    public static void main(String[] args) {

        EmergencyPage p = new EmergencyPage();
        Vector v = null;
        try {
            v = p.getResult("1").data;

            System.out.println("可用行" + p.getAvailableCount());
            System.out.println("最大页" + p.maxPage);
            System.out.println("最大行" + p.maxRowCount);
            System.out.println("每页显示行" + p.rowsPerPage);

        } catch (Exception ex) {
            ex.printStackTrace();
        }
        java.util.Enumeration e = v.elements();
        while (e.hasMoreElements()) {
            Object[] obj = (Object[]) e.nextElement();
            for (int i = 0; i < obj.length; i++) {
                System.out.printf(obj[i].toString() + "\t");
            }
            System.out.println();
        }
    }
}