浅谈Struts2分页的实现与代码实例

public List getList(int pageSize, int pageNow) {


    //获取分页数据
    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%'";
    //得到总数据条数
    int count = *;
    return count;
}
================================
Test类(封装数据)
public class Test(){
    private int id;
    private String username;
    private password;
    //省略seter, geter方法.
}

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

    
        
        
        
    
 
    
        
        
        
    

NO
姓名
密码
.
 
 

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

================================
ShowAction.java
private int pageNow = 1 ; //初始化为1,默认从第一页开始显示 
private int pageSize = 5 ; //每页显示5条记录 
private int count; //总页数
private List testList;
//省略seter, geter
public String execute() throws Exception {
count = (dao.getCount()-1)/pageSize+1; //得到总页数
testList = dao.getList(pageSize, pageNow); //得到list
if (testList == null)
testList = new ArrayList();
return SUCCESS;
}