荔园在线
荔园之美,在春之萌芽,在夏之绽放,在秋之收获,在冬之沉淀
[回到开始]
[上一篇][下一篇]
发信人: 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软件 网络书店