急！！急！！急！！跪求JSP高手帮忙把调用一张图片的代码加个循环改成调用全部！最好带分页功能

<%
//dynmaic pic
String picpath=null;
String zhusi=null;
Statement pstmt=conn.createStatement();
ResultSet rst=null;
int leng=1;
int pic_id=-1;
sql="SELECt id,title,images FROM (select id,title,images from article WHERe menuid = '49' AND images LIKE '%;'  ORDER BY id DESC) where rownum<2";
rst=stmt.executeQuery(sql);
while(rst.next())
  {
  pic_id=rst.getInt("id");
  zhusi=str.getStr(rst.getString("title"));
  picpath=rst.getString("images");
  picpath=picpath.substring(0,(picpath.length()-1));
  if(zhusi!=null)leng=zhusi.length();
        }

rst.close();pstmt.close();
  %>
                      <td colspan="2"><div align="center"> <a href="../content.jsp?id=<%=pic_id%>" target="_blank"><IMG src="<%=picpath%>" width=185 height=150 border="0"></a></div></td>
                    </tr>
                    <tr>
                      <td height="35" colspan="2">

                        <div align="center">
      <a href="../content.jsp?id=<%=pic_id%>" target="_blank">
                                      <%if(leng<16){%>
                                      <%=zhusi%>
                                      <%}else{%>
                                      <%=zhusi.substring(0,15)%>...
                                      <%}%>
                          </a></div></td>
                   </tr>

                                 
           </table>
                        </div></td>
-----------------------------------------------------------------------------------------------------------
跪求高手帮忙修改一下，上述代码只能调用一张图片，是数据库最顶端的那张！跪求属于menuid = '49' 的所有照片的调用方法，最好能加上分页，一行显示5张，一页3行，希望高手们们帮忙！！！急！！急！！急！！  

 <%@ page contentType="texthtml; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><%@ page import ="java.util.*" %><% java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); java.util.Date currentTime = new java.util.Date();//得到当前系统时间 String str_date1 = formatter.format(currentTime); //将日期时间格式化 String str_date2 = currentTime.toString(); //将Date型日期时间转换成字符串形式 String sss=(str_date1.substring(0,4));String year=str_date1.substring(0,4);//截取年String month=str_date1.substring(5,7);//截取月int yy=Integer.parseInt(year);//将年定义为数字int mm=Integer.parseInt(month);//将月定义为数字out.print(yy+1);//将年加一年%> 当前时间：<%= str_date1 %>