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