131
技術社區[雲棲]
SSH分頁
PageModel
package com.xy.util;
import java.util.List;
public class PageModel
{
private List datas; // 數據集合
private int total; // 數據總數
private int totalPage; // 數據可分的頁數
public PageModel()
{
super();
}
public PageModel(List datas, int total, int totalPage)
{
super();
this.datas = datas;
this.total = total;
this.totalPage = totalPage;
}
public List getDatas()
{
return datas;
}
public int getTotal()
{
return total;
}
public int getTotalPage()
{
return totalPage;
}
public void setDatas(List datas)
{
this.datas = datas;
}
public void setTotal(int total)
{
this.total = total;
}
public void setTotalPage(int totalPage)
{
this.totalPage = totalPage;
}
}
IStudentDao
package com.xy.dao;
import com.xy.pojo.Student;
import com.xy.util.PageModel;
public interface IStudentDao
{
// 分頁
public PageModel GetAllStudent(int start, int pagesize);
}
StuentDaoImpl
package com.xy.dao.impl;
import java.util.List;
import com.xy.dao.IStudentDao;
import com.xy.pojo.Student;
import com.xy.util.PageModel;
public class StuentDaoImpl extends BaseDaoHibernateImpl implements IStudentDao
{
public PageModel GetAllStudent(int start, int pagesize)
{
String sqlCount = "select count(*) from Student";
int count = ((Long) this.getSession().createQuery(sqlCount).uniqueResult()).intValue();
List lstStu = this.getSession().
createQuery("from Student s join fetch s.classes").setFirstResult(start).setMaxResults
(pagesize).list();
int totalPage = 0;
if (count % pagesize == 0)
{
totalPage = (count / pagesize);
}
else
{
totalPage = (count / pagesize) + 1;
}
// 得到結果集
PageModel pm = new PageModel();
pm.setTotal(count);
pm.setDatas(lstStu);
pm.setTotalPage(totalPage);
return pm;
}
}
ToMainAction
package com.xy.action;
import com.opensymphony.xwork2.ActionSupport;
import com.xy.dao.IStudentDao;
import com.xy.util.PageModel;
public class ToMainAction extends ActionSupport
{
private int pageIntNum; // 用來計算的頁碼
private String pageNum; // 傳來的字符串參數
private IStudentDao sdao;
private PageModel stuList;
private int totalPage;
public String execute()
{
if (null != pageNum && !"".equals(pageNum))
{
pageIntNum = Integer.valueOf(pageNum);
int start = (pageIntNum - 1) * 2;
stuList = sdao.GetAllStudent(start, 2);
}
else
{
pageIntNum = 1;
stuList = sdao.GetAllStudent(0, 2);
}
return SUCCESS;
}
public int getPageIntNum()
{
return pageIntNum;
}
public String getPageNum()
{
return pageNum;
}
public IStudentDao getSdao()
{
return sdao;
}
public PageModel getStuList()
{
return stuList;
}
public int getTotalPage()
{
return totalPage;
}
public void setPageIntNum(int pageIntNum)
{
this.pageIntNum = pageIntNum;
}
public void setPageNum(String pageNum)
{
this.pageNum = pageNum;
}
public void setSdao(IStudentDao sdao)
{
this.sdao = sdao;
}
public void setStuList(PageModel stuList)
{
this.stuList = stuList;
}
public void setTotalPage(int totalPage)
{
this.totalPage = totalPage;
}
}
Main.jsp
<s:iterator value="stuList.datas" var="stu" status="index">
<tr
onmouseout="this.style.backgroundColor='#ffffff';this.style.cursor='default'"
ondblclick="modify(<s:property value="#stu.stuId"/>)">
<td>
<s:checkbox name="stuids" fieldValue="%{#stu.stuId}" />
</td>
<td>
<s:property value="#stu.stuId" />
</td>
<td>
<s:property value="#stu.stuName" />
</td>
<td>
<s:if test="#stu.stuSex==1">男</s:if>
<s:else>女</s:else>
</td>
<td>
<s:property value="#stu.stuAge" />
</td>
<td>
<s:date name="#stu.stuBirth" format="yyyy年MM月dd日" />
</td>
<td>
<s:property value="#stu.classes.className" />
</td>
<td>
<s:if test="#stu.stuStatus==1">在職</s:if>
<s:else>離職</s:else>
</td>
<td>
<a href='stu_todel?id=<s:property value="#stu.stuId" />'>刪除</a>
</td>
</tr>
</s:iterator>
</table>
</s:form>
<s:if test="data.totalPage>1">
<s:if test="stuList.totalPage==pageIntNum">
<a href="ToMainAction?pageNum=1">首頁</a>
<a href="ToMainAction?pageNum=<s:property value="pageIntNum-1"/>">上一頁</a>
</s:if>
<s:elseif test="pageIntNum==1">
<a href="ToMainAction?pageNum=<s:property value="pageIntNum+1"/>">下一頁</a>
<a href="ToMainAction?pageNum=<s:property value="data.totalPage"/>">末頁</a>
</s:elseif>
<s:else>
<a href="ToMainAction?pageNum=1">首頁</a>
<a href="ToMainAction?pageNum=<s:property value="pageIntNum-1"/>">上一頁</a>
<a href="ToMainAction?pageNum=<s:property value="pageIntNum+1"/>">下一頁</a>
<a href="ToMainAction?pageNum=<s:property value="data.totalPage"/>">末頁</a>
</s:else>
當前第<s:property value="pageIntNum" />頁
共<s:property value="data.totalPage" />頁
</s:if>
SSH的配置與一般項目無區別。
最後更新：2017-04-02 06:52:19