核心提示:源代码如下:/*** 实现分页* @param start* @param end* @return*/ public ArrayListMessageDto showPage(int start,...
源代码如下:/**
* 实现分页
* @param start
* @param end
* @return
*/
public ArrayList<MessageDto> showPage(int start, int total) {
ArrayList<MessageDto> mds = new ArrayList<MessageDto>();
String sql = "select * from message order by msg_id desc limit ?,?";
try {
psm = conn.prepareStatement(sql);
psm.setInt(1, start);
psm.setInt(2, total);
rs = psm.executeQuery();
while(rs.next()) {
mds.add(new MessageDto(rs.getString("title"),rs.getString("content")));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
this.close(rs, psm);
}
return mds;
}
/**
* 得到记录条数
* @return
*/
public int getRows() {
String sql = "select count(*) from message";
int rows = 0;
try {
psm = conn.prepareStatement(sql);
rs = psm.executeQuery();
while(rs.next()){
rows = rs.getInt(1);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
this.close(rs, psm);
}
return rows;
}
<!-- 显示评论列表 -->
<div class="box" style="width:800px; height: 500px">
<%
int rows = new UpLoadMessageDao().getRows();
if(rows > 0){ %>
<s:forEach items="<%= new UpLoadMessageDao().showPage(startRow,rowCount)%>" var="msg">
<div class="msg" style="border: 1px solid pink;height: auto;width: 798px;">
<table>
<tbody>
<tr><td>标题:</td><td>${ msg.title }</td></tr>
<tr><td>内容:</td><td></td></tr>
<tr><td></td>
<td align="left" style="width: 700px;height: 30px;font-style: normal;">
<textarea style="width: 700px;height: 100px;" istyle="none" readonly="readonly">${ msg.content }</textarea></td>
</tr>
</tbody>
</table>
</div>
</s:forEach>
<%} else {%>
<div class="empty" style="border: 1px solid pink;width:798px;height: 100px;font-size: 50px;padding: 100px 0px;">
抱歉,当前没有相关评论!
</div>
<%}%&, gt;
</div>
<!-- 显示评论列表 结束-->
<!-- 分页 -->
<div class="showPage" style="width: 800px;height: 50px;">
<table>
<tbody align="right">
<tr>
<%
if(pageNow > 1) {
%>
<td><a href="<%=path %>/index.jsp?pageNow=<%=pageNow - 1 %>">上一页</a></td><td> </td>
<%} %>
<%
int pages = rows / rowCount;
if(rows % rowCount != 0) {
pages++;
}
for(int i = 1; i <= pages; i++) {
if(pageNow == i) {
%>
<td><a href="<%=path %>/index.jsp?pageNow=<%=i %>"><span style="color: green;font-size: 35"><%=i %></span></a></td><td> </td>
<%} else { %>
<td><a href="<%=path %>/index.jsp?pageNow=<%=i %>"><%=i %></a></td><td> </td>
<%} %>
<% }%>
<%
if(pageNow < pages) {
%>
<td><a href="<%=path %>/index.jsp?pageNow=<%=pageNow + 1 %>">下一页</a></td><td> </td>
<%} %>
</tr>
</tbody>
</table>
</div>
<!-- 分页结束 -->
<!-- 留言区 -->
<form action="<%=path %>/uploadMsg" method="post" style="height: 250px;width:auto;" >
<fieldset style="height:100%; padding: 30px 100px;">
<legend>发言区</legend>
<table>
<tbody>
<tr><td align="left">标题:</td><td><input type="text" name="title" size="30"></td></tr>
</tbody>
</table>
<table>
<tbody>
<tr><td align="left">内容:</td><td><textarea rows="5" cols="40" name="content"></textarea></td></tr>
<tr><td></td><td align="right" height="30"><input type="submit" value=" 发 表 留 言 "/></td></tr>
</tbody>
</table>
</fieldset>