?? page.java
字號(hào):
import java.sql.ResultSet;
import java.sql.SQLException;
//分頁
public class Page {
private String view ;
public String getView() {
return view;
}
public void setView(ResultSet rs,String style,int go,int pagesize) throws SQLException {
if(style.equals("table")){
this.view = "<table border='2' width='350' align='center'>";
int i = 0;
if(go != 1)
rs.absolute(go-1);
else{
rs.first();
rs.previous();
}
int colsize = rs.getMetaData().getColumnCount();
while (rs.next()) {
if(++i <= pagesize){
this.view= this.view +"<tr>";
for(int k = 0;k<colsize;k++){
this.view= this.view +"<td>"+rs.getString(k+1) + "</td>";
}
this.view= this.view +"</tr>";
}else{
break;
}
}
//最后一頁
if((go+pagesize) > this.getRow(rs)){
this.view = this.view +"<tr><td><a href ='PageServlet?goto="+(go-pagesize)+"'>上一頁</a></td><td>末 頁</td></tr>";
}//第一頁
else if(go == 1){
this.view = this.view +"<tr><td>首 頁</td><td><a href ='PageServlet?goto="+(go+pagesize)+"'>下一頁</a></td></tr>";
} else{
this.view = this.view +"<tr><td><a href ='PageServlet?goto="+(go-pagesize)+"'>上一頁</a></td><td><a href ='PageServlet?goto="+(go+pagesize)+"'>下一頁</a></td></tr>";
}
this.view= this.view +"</table>";
}else{
this.view = "沒有該樣式";
}
}
public int getRow(ResultSet rs) throws SQLException {
ResultSet rsr = rs;
rsr.last();
return rsr.getRow();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -