å¨é¡¹ç®ä¸ï¼å页æ¯ä¸ä¸ªé¡¹ç®ä¸å¿
ä¸å¯å°çï¼å®å¯ä»¥é²æ¢æ们ä»æ°æ®åºä¸è¿è¡å¤§éæ°æ®æ¥è¯¢æ¶é度åæ
¢ï¼æé«æ们çæ¥è¯¢æç
1ãå®ä¹å页模åï¼PageModel
package com.common.page;
import java.util.List;
/**
* å°è£
å页信æ¯
* @author Administrator
*
*/
public class PageModel<E> {
//ç»æé
private List<E> list;
//æ¥è¯¢è®°å½æ°
private int totalRecords;
//æ¯é¡µå¤å°æ¡æ°æ®
private int pageSize;
//第å 页
private int pageNo;
/**
* æ»é¡µæ°
* @return
*/
public int getTotalPages() {
return (totalRecords + pageSize - 1) / pageSize;
}
/**
* åå¾é¦é¡µ
* @return
*/
public int getTopPageNo() {
return 1;
}
/**
* ä¸ä¸é¡µ
* @return
*/
public int getPreviousPageNo() {
if (pageNo <= 1) {
return 1;
}
return pageNo - 1;
}
/**
* ä¸ä¸é¡µ
* @return
*/
public int getNextPageNo() {
if (pageNo >= getBottomPageNo()) {
return getBottomPageNo();
}
return pageNo + 1;
}
/**
* åå¾å°¾é¡µ
* @return
*/
public int getBottomPageNo() {
return getTotalPages();
}
public List<E> getList() {
return list;
}
public void setList(List<E> list) {
this.list = list;
}
public int getTotalRecords() {
return totalRecords;
}
public void setTotalRecords(int totalRecords) {
this.totalRecords = totalRecords;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getPageNo() {
return pageNo;
}
public void setPageNo(int pageNo) {
this.pageNo = pageNo;
}
}
2ãå页æµè¯ï¼å¨MySQLä¸å»ºç«admin表ï¼éé¢æå段idãnameãpassword
3ãç®åAdminçå®ä½beanç±»ï¼
package com.common.page;
public class Admin {
private int id;
private String name;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
4ãæµè¯è°ç¨ï¼ package com.common.page;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.common.db.DbUtil;
public class Client {
public static PageModel findAdmins(int pageNo,int pageSize){
Connection conn=DbUtil.getConnection();
String sql="select * from admin limit ?,?";
PageModel pageModel=null;
PreparedStatement pstm=null;
ResultSet rs=null;
Admin admin=null;
List<Admin> list=new ArrayList<Admin>();
try {
pstm=conn.prepareStatement(sql);
pstm.setInt(1, (pageNo-1)*pageSize);
pstm.setInt(2, pageNo*pageSize);
rs=pstm.executeQuery();;
while(rs.next()){
admin=new Admin();
admin.setId(rs.getInt("a_id"));
admin.setName(rs.getString("a_name"));
admin.setPassword(rs.getString("a_pwd"));
list.add(admin);
}
ResultSet rs2=pstm.executeQuery("select count(*) from admin");
int total=0;
if(rs2.next()){
total=rs2.getInt(1);
}
pageModel=new PageModel();
pageModel.setPageNo(pageNo);
pageModel.setPageSize(pageSize);
pageModel.setTotalRecords(total);
pageModel.setList(list);
} catch (SQLException e) {
e.printStackTrace();
}finally{
DbUtil.close(conn);
DbUtil.close(pstm);
DbUtil.close(rs);
}
return pageModel;
}
public static void main(String[] args) {
PageModel pageModel=Client.findAdmins(2,4);
List<Admin> list=pageModel.getList();
for(Admin a:list){
System.out.print("ID:"+a.getId()+",ç¨æ·å:"+a.getName()+",å¯ç :"+a.getPassword());
System.out.println();
}
System.out.print("å½å页:"+pageModel.getPageNo()+" ");
System.out.print("å
±"+pageModel.getTotalPages()+"页 ");
System.out.print("é¦é¡µ:"+pageModel.getTopPageNo()+" ");
System.out.print("ä¸ä¸é¡µ:"+pageModel.getPreviousPageNo()+" ");
System.out.print("ä¸ä¸é¡µ:"+pageModel.getNextPageNo()+" ");
System.out.print("尾页:"+pageModel.getBottomPageNo()+" ");
System.out.print("å
±"+pageModel.getTotalRecords()+"æ¡è®°å½");
System.out.println();
}
}
è¿æ ·å页ææå°±å®ç°äºï¼æ们è¦å®ç°å页ææï¼åªè¦ä¼ å
¥ç¸åºçåæ°åç¸åºçæ°æ®åºæ§è¡è¯å¥å³å¯å®ç°ï¼å¸æ大家è½çµæ´»è¿ç¨ã
温馨提示:答案为网友推荐,仅供参考