public List getList(int pageSize, int pageNow) {


    //獲取分頁數(shù)據(jù)
    List list = * ;
     //我用的sqlserver
    String sql = "select top 10 * from test
where username like '%badpeas%' and id not in 
(select top 0 id from test order by id)
order by id";
    return list;
}

public int getCount() {
    //我用的sqlserver
     String sql = "select count(*) from region where username like '%badpeas%'";
    //得到總數(shù)據(jù)條數(shù)
    int count = *;
    return count;
}
================================
Test類(封裝數(shù)據(jù))
public class Test(){
    private int id;
    private String username;
    private password;
    //省略seter, geter方法.
}

================================
show.jsp
 

    
        
        
        
    
 
    
        
        
        
    

NO
姓名
密碼
.
 
 

 
 
 
 
 
 
上一頁 
上一頁
下一頁 
下一頁
   [page: /]
 

================================
ShowAction.java
private int pageNow = 1 ; //初始化為1,默認(rèn)從第一頁開始顯示 
private int pageSize = 5 ; //每頁顯示5條記錄 
private int count; //總頁數(shù)
private List testList;
//省略seter, geter
public String execute() throws Exception {
count = (dao.getCount()-1)/pageSize+1; //得到總頁數(shù)
testList = dao.getList(pageSize, pageNow); //得到list
if (testList == null)
testList = new ArrayList();
return SUCCESS;
}