page.jsp

仿校内网站

                int pagesize = 5;//每页显示记录数
                int liststep = 10;//最多显示分页页数
                int pages = 1;//默认显示第一页
                if (request.getParameter("pages") != null) 
                {
                    pages = Integer.parseInt(request.getParameter("pages"));//分页页码变量
                }
                //out.print(year + " "+ sex + " " +  age_from + " " + age_to + " " + constellation + " " + marry + " " + blood + " " + education + " " + province + " " + city);
                SearchDB db = new SearchDB();
                ResultSet rs = null;
                try
                {
                    rs = db.search(year, sex, age_from, age_to, constellation, marry, blood, education, province, city);       
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
                //sql="select count(*) from table";//取出记录总数,把*换成记录名性能更加
                //ResultSet rs = (ResultSet)session.getAttribute("result");
                rs.last();
                int count = rs.getRow();//取出的记录总数
                //out.print("count : " + count + "<br>");
                if(count == 0)
                {
                    out.print("<table width=\"800\" border=\"0\">");
                    out.print("<tr>");
                    out.print("<td height=\"30\" bgcolor=\"ddddfd\" class=\"STYLE3\"><div align=\"center\">SORRY!没有找到你想找的朋友!</div></td>");
                    out.print("</tr>");
                    out.print("<tr>");
                    out.print("<td height=\"30\" bgcolor=\"ddddfd\" class=\"STYLE3\"><div align=\"center\"><a href=\"search.jsp\">返回</a></div></td>");
                    out.print("</tr>");
                    out.print("</table>");
                }
                else
                {
                    int pagescount = (int) Math.ceil((double) count / pagesize);//求总页数，ceil（num）取整不小于num
                    if (pagescount < pages) {
                        pages = pagescount;//如果分页变量大总页数，则将分页变量设计为总页数
                    }
                    if (pages < 1) {
                        pages = 1;//如果分页变量小于１,则将分页变量设为１
                    }
                    int listbegin = (pages - (int) Math.ceil((double) liststep / 2));//从第几页开始显示分页信息
                    if (listbegin < 1) {
                        listbegin = 1;
                    }
                    int listend = pages + liststep/2;//分页信息显示到第几页
                    if (listend > pagescount) {
                        listend = pagescount + 1;
                    }

                    //显示数据部分
                    int recordbegin = (pages - 1) * pagesize;//起始记录
                    int recordend = 0;
                    recordend = recordbegin + pagesize;
                    //最后一页记录显示处理
                    if (pages == pagescount) {
                        recordend = (int) (recordbegin + pagesize * (count % pagesize) * 0.1);
                    }
                    
                    if(pages == 1)
                    {
                        rs.beforeFirst();
                    }
                    else
                    {
                        rs.absolute((pages - 1) * pagesize);
                    }

                    //显示搜索结果
                    out.print("<table width=\"800\" border=\"0\" bgcolor=\"f0f0f0\">");
                    int counter = 0;
                    while(rs.next())
                    {
                        out.print("<tr>");
                        out.print("<td width=\"150\" height=\"150\" rowspan=\"3\"><a href=\"homepage.jsp?be_visited_id=" + rs.getString("users.user_id") + "\">");
                        out.print("<img src=\"" + rs.getString("photo_path") + "\"" + " width=\"130\" height=\"130\" border=\"0\" align=\"middle\"/></a></td>");
                        out.print("<td width=\"624\"><div align=\"left\"><a href=\"homepage.jsp?be_visited_id=" + rs.getString("users.user_id") + "\">" + rs.getString("user_name") + "</a></div></td>");                    
                        out.print("</tr>");
                        out.print("<tr>");
                        out.print("<td><div align=\"left\">");                    
                        if(rs.getInt("sex") == 1)
                        {
                            out.print("男");
                        }
                        else
                        {
                            out.print("女");
                        }
                        out.print("&nbsp");
                        if(String.valueOf(rs.getInt("bir_year")) != null)
                        {
                            out.print(year - rs.getInt("bir_year") + "岁");
                        }                    
                        out.print("&nbsp");
                        if(rs.getInt("marriage") == 1)
                        {
                            out.print("单身");
                        }
                        else if(rs.getInt("marriage") == 0)
                        {
                            out.print("已婚");
                        }                    
                        out.print("&nbsp");
                        if(rs.getString("province") != null)
                        {
                            out.print(rs.getString("province"));
                        }                    
                        out.print("&nbsp");
                        if(rs.getString("city") != null)
                        {
                            out.print(rs.getString("city"));
                        }
                        out.print("</div></td>");
                        out.print("</tr>");
                        out.print("<tr>");
                        if(rs.getString("self_description") != null)
                        {
                            out.print("<td height=\"80\"><div align=\"left\"><a href=\"homepage.jsp?be_visited_id=" + rs.getString("users.user_id") + "\"<p>" + rs.getString("self_description") + "</p><p>&nbsp;</p><p>&nbsp;</p></a></div></td>");
                        }
                        out.print("</tr>");
                        counter++;
                        if(counter >= pagesize)
                            break;
                    }
                    out.print("</table>");
                    db.closeConnection();
                    /*for (int i = recordbegin; i < recordend; i++)
                    {
                        response.getWriter().println("record " + i + "<br>");
                    }*/

                    out.print("<table width=\"800\" border=\"0\" bgcolor=\"f0f0f0\"><tr><td><div align=\"center\">");
                    //<显示上一页
                    /*if (pages > 1) 
                    {
                        out.print("<a href=?pages=" + (pages - 1) + ">上一页</a>");
                        out.print("&nbsp");
                    }//>显示上一页
                    //<显示分页码*/
                    for (int i = listbegin; i < listend; i++)
                    {
                        if (i != pages) 
                        {//如果i不等于当前页
                            out.print("<a href=page.jsp?pages=" + i + ">[" + i + "]</a>");
                            out.print("&nbsp");
                        } 
                        else 
                        {
                            out.print("[" + i + "]");
                            out.print("&nbsp");
                        }
                    }//显示分页码>
                    //<显示下一页
                    /*if (pages != pagescount) 
                    {
                        out.print("<a href=?pages=" + (pages + 1) + ">下一页</a>");
                        out.print("&nbsp");
                    }//>显示下一页*/
                    out.print("</div></td></tr></table>");
                    //>显示分页信息
                }
            %>
        </div>
    </body>
</html>