荔园在线

荔园之美,在春之萌芽,在夏之绽放,在秋之收获,在冬之沉淀

[回到开始] [上一篇][下一篇]


发信人: guangzhougd (考北大上清华读港大回深大), 信区: Java
标  题: 高效的分页系统(中)
发信站: 荔园晨风BBS站 (Thu Nov 16 23:18:49 2006), 站内

/**
 * <br>满分教育有限公司.
 * <br>http://www.0755-100.com
 * @author Hyucai
 * 深圳大学
 * 日期:2006-9-20
 */
package com.0755.javaBean;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

/**
 * StudentPageDetail.java
 * com.0755.javaBean
 */
public class StaffPageDetails extends Pagination {

    String Mysql=    "select  "
                    +"Staff_ID, "
                    +"Staff_Surname, "
                    +"Staff_Sex, "
                    +"Staff_Status, "
                    +"Staff_Degree, "
                    +"Staff_Major, "
                    +"Staff_School, "
                    +"Staff_LateLogonDate "
                    +"  from   StaffBaseInfo,StaffDetailInfo   "
                    +"where StaffBaseInfo.Staff_ID=StaffDetailInfo.Staff_SID  "
                    +"and StaffBaseInfo_Valid=1  "
                    +"  order   by Staff_LateLogonDate DESC ,Staff_RegDate DESC
 ";


    /**
     *
     */
    public StaffPageDetails(){

        this.setSql(Mysql);
    }


    /* (非 Javadoc)
     * @see com.0755.javaBean.Pagination#packResultSet(java.sql.ResultSet, int,
int)
     */
    protected Collection packResultSet(ResultSet rs, int beginRow, int EndRow)
            throws Exception {

        Collection StaffPageDetailColl = new ArrayList();
        int count=1;

        while(rs.next()){

            if(beginRow<=count&&count<=EndRow){

                StaffDetail ST=new StaffDetail();

                ST.setStaffDetail_ID(rs.getInt(1));
                ST.setStaffDetail_Surname(rs.getString(2));
                ST.setStaffDetail_Sex(rs.getInt(3));
                ST.setStaffDetail_Status(rs.getInt(4));
                ST.setStaffDetail_Degree(rs.getInt(5));
                ST.setStaffDetail_Major(rs.getString(6));
                ST.setStaffDetail_School(rs.getString(7));
                ST.setStaffDetail_LateLogonDate(rs.getString(8));

                StaffPageDetailColl.add(ST);
            }
            count++;
            if(count>EndRow) break;

        }

        return StaffPageDetailColl;
    }

    /**
     * @param args
     */
    public static void main(String[] args) {
    }
}

--



※ 修改:·guangzhougd 于 Nov 16 23:20:16 修改本文·[FROM: 192.168.124.24]
※ 来源:·荔园晨风BBS站 http://bbs.szu.edu.cn·[FROM: 192.168.124.24]


[回到开始] [上一篇][下一篇]

荔园在线首页 友情链接:深圳大学 深大招生 荔园晨风BBS S-Term软件 网络书店