?? pag.java
字號:
package com.zh.util;
import java.sql.*;
import com.zh.conpool.Condata;
public class page{
int showpage;
int pagecount=0;
int rowcount=0;
int pagesize;
String topage;
String httpfile;
String sql;
String str_where="";
ResultSet rs=null;
ResultSet rs1=null;
String countsql;
String pagesql;
Condata con=new Condata();
public void setpagesize(int n){
this.pagesize=n;
}
public ResultSet setQuerysql(String str_table,String str_where,String httpfile,String pages)throws SQLException{
nowpage=pages;
ResultSet rst=null;
httpfile=httpfile;
str_where=str_where;
countsql="select count(*) from "+str_table+" "+str_where;
pagesql="select * from"+str_table+" "str_where" order by id DESC;
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
try{
rst=query(countsql,pagesql);
}catch(Exception er){
er.getMessage();
}
return rst;
}
public ResultSet query(String countsql,String pagesql)throws SQLException{
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
if(topage==null){
showpage=1;
}else{
showpage=Integer.parseInt(topage);
}
if(showpage<1){
showpage=1;
}
rs=con.executeQuery(countsql);
if(rs.next()){
rowcount=rs.getInt(1);
}
pagecount=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1));
if(showpage>pagecount){
showpage=pagecount;
}
rs.close();
rs1=con.executeQuery(pagesql);
return rs1;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -