JAVA分页类

最新推荐文章于 2022-02-18 11:27:39 发布

nuanchun666

最新推荐文章于 2022-02-18 11:27:39 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

文章标签： java vector string import constructor sql

本文链接：https://blog.youkuaiyun.com/nuanchun666/article/details/1320734

package com.itfuture.admin;

import java.sql.ResultSet;
import java.util.Vector;
import com.itfuture.admin.*;

public class SplitPage {

public SplitPage() {
  super();
  // TODO Auto-generated constructor stub
}
   public static Vector getOnePage(String cols,String tables,String order,
     String cond,String reqpage)//reqpage是想要得到的页数
   {
      int page_record=res.page_record;
      int curpage=1;    //当前页初始化为1
      int allnumber=0; //总记录数
      int allpage=0;    //总页数

      String sql="select count(*) from "+tables+" where 1=1 "+cond;
      openDAO dao=new openDAO();
      allnumber=dao.getCount(sql); //得到总记录数

      allpage=(allnumber+page_record-1)/page_record; //得到总页数

      if(reqpage!=null)
      {
        int wantpage=Integer.parseInt(reqpage);
        if(wantpage>allpage&&allpage>0)
        {
          curpage=allpage;
        }else if(wantpage<1)
                {
                curpage=1;
                }else{
                      curpage=wantpage;
                     }
      }
   sql="select top "+page_record+" "+cols+" from "+tables+" where 1=1 "+cond+" and "+order+" not in(select top "+(curpage-1)*page_record+" "+order+" from "+tables+" where 1=1 "+cond+" order by "+order+")order by "+order+"";
   ResultSet rs=dao.doQuery(sql);
   Vector vector=new Vector();
   vector.add(0,allnumber+"");
   vector.add(1,allpage+"");
   vector.add(2,curpage+"");
   vector.add(3,page_record+"");
   vector.add(4,rs);
   return vector;
   }
}