| 发表于：2007-01-16 11:24:25 楼主 |
public pagebean listdata（string page,int perpage,string strpagewhere,string strwheretype,string strwhere,string strordername,int iorder,int sqltype)throws exception{
string strsql = " ";
if（strordername== " ")
strordername= "id ";
try{
pagebean pagebean=new pagebean（this,perpage,strpagewhere);
int pagenum=integer.parseint（page);
statement stm = conn.createstatement（);
if（sqltype == 1){
strsql = "select top "+pagenum*pagebean.rowsperpage+ " * from commenttoday ";}
else if（sqltype == 2){
strsql = "select * from commenttoday ";
}
if（strwheretype.equalsignorecase（ "search ")){
strsql=strsql+ " where title like '% "+strwhere+ "% ' "+
" or content like '% "+strwhere+ "% ' "+
" or pic like '% "+strwhere+ "% ' ";
}
else if（strwheretype.equalsignorecase（ "where ")){
strsql = strsql+ " "+strwhere;
}
switch（iorder){
case 1:strsql=strsql+ " order by "+strordername+ " asc ";break;
case 2:strsql=strsql+ " order by "+strordername+ " desc ";break;
}
if（sqltype == 2){
strsql = strsql+ " limit "+pagenum*pagebean.rowsperpage;
}
resultset rst = stm.ＥＸＥＣutequery（strsql);
int i = 0;
while（rst.next（)){
if （i > （pagenum - 1)*pagebean.rowsperpage - 1){
object[] obj = new object[5];
obj[0] = new integer（rst.getint（ "id "));
obj[1] = new integer（rst.getint（ "classid "));
obj[2] = rst.getstring（ "title ");
obj[3] = rst.getstring（ "content ");
obj[4] = rst.getstring（ "pic ");
list.add（obj);
}
i++;
}
rst.close（);
stm.close（);
pagebean.curpage = pagenum;
pagebean.data = list;
return pagebean;
}catch（exception e){
e.printstacktrace（);
throw e;
}
}
请问 if （i > （pagenum - 1)*pagebean.rowsperpage - 1){
起什么作用 |
|
|
|
|
