分页-上传图片-MD5加密-验证码-在线编辑器

public List findpage(int page) throws Exception { // TODO Auto-generated method stub List alllist=new ArrayList(); //记录行数 int num=0; if(page>1) { num=PAGE_NUM*(page-1); } try { String sql="select top "+PAGE_NUM+" *from FirstLevelTitle where id not in (select top " +num+" id from FirstLevelTitle order by id desc)order by id desc"; con=ConnectionManager.getCon(); ps=con.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()) { FirstLevelTitle f=new FirstLevelTitle(); f.setId(rs.getInt(1)); f.setTitleName(rs.getString(2)); f.setCreator(rs.getString(3)); f.setCreatorTime(rs.getString(4)); alllist.add(f); } } catch (RuntimeException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(ps); ConnectionManager.closeConnection(con); } return alllist; } ================================================================================================= <table border="1"> <tr> <td>新闻标题</td> <td>发布者</td> <td>发布时间</td> <td colspan="2">操作</td> </tr> <% int pageNum=1; int size=FirstLevelDaoImpl.PAGE_NUM; String pageParam=request.getParameter("page"); if(pageParam!=null) { pageNum=Integer.parseInt(pageParam); } FirstLevelDao fdao=new FirstLevelDaoImpl(); List listpage=fdao.findpage(pageNum); int beforePage=pageNum; int nextPage=pageNum; if(listpage.size()==size) { nextPage=pageNum+1; } if(pageNum>1) { beforePage=pageNum-1; } for(int i=0;i<listpage.size();i++) { FirstLevelTitle f=(FirstLevelTitle)listpage.get(i); %> <tr> <td><%=f.getTitleName() %></td> <td><%=f.getCreator() %></td> <td><%=f.getCreatorTime() %></td> <td><font size=3 color="red"><a href="update_firstlevel.jsp?fid=<%=f.getId() %>">修改</a></td> <td><font size=3 color="red"><a href="delete_firstlevel.jsp?fid=<%=f.getId() %>">删除</font></td> </tr> <% } %> <tr valign="bottom" align="right"> <td colspan="3" width="100%">&nbsp;&nbsp;&nbsp;&nbsp;<a href="selectFirstLevelTitle.jsp?page=<%=beforePage%>">上一页</a>| <a href="selectFirstLevelTitle.jsp?page=<%=nextPage%>">下一页</a></td> </tr> </table>