jsp手动分页
原创
©著作权归作者所有:来自51CTO博客作者大小姐的生产工厂的原创作品,请联系作者获取转载授权,否则将追究法律责任
注意:
sql语句要写对,jsp显示 List 时的 item的字段名要写对
这里 where uid 要放在前面才能成功执行,否则会报错
SELECT * FROM conn_logs WHERE uid = 0 ORDER BY gid DESC LIMIT 0,15
在写items的时候,如果controller里面已经写了,这里会有提示
成功效果:
分页:
1. 注意顺序
2. start = Integer.parseInt(request.getParameter("start")); // 这里是得到参数的值,不是getsession哦,之前就错在这里
@Controller
public class ConnLogsController {
@Autowired
HttpServletRequest request;
@RequestMapping("showConnLogs")
public ModelAndView showConnLogs() {
ModelAndView modelAndView = new ModelAndView();
RepoDao repoDao = new RepoDaoImp();
int start = 0;
int count = 10;
try {
start = Integer.parseInt(request.getParameter("start"));
} catch (Exception e) {
}
int next = start + count;
int userId = (int) request.getSession().getAttribute("userId");
List<ConnLogs> connLogs = repoDao.showPage(userId, start, count);
modelAndView.addObject("next", next);
modelAndView.addObject("connLogs", connLogs);
modelAndView.setViewName("/jsp/ConnLogs/ConnLogsViewer.jsp");
return modelAndView;
}
}
<table width="100%" border="1">
<tr>
<td>gid</td>
<td>warnningPtLink</td>
</tr>
<c:forEach var="C" items="${connLogs}">
<tr>
<td>${C.gid}</td>
<td>${C.warningPtLink}</td>
</tr>
</c:forEach>
<tr>
<td colspan="6" align="center">
<a href="/DETECT-X/showConnLogs.action?start=${next}">[下一页]</a>
</td>
</tr>
</table>