dbmystory.jsp

一个手机动态网页源程序

<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN""http://www.wapforum.org/DTD/wml_1.1.xml">
<%@ page language="java"  contentType="text/html;charset=gb2312"%>
<wml>
<%@ include file="TotalRecord.jsp"%>
<jsp:useBean id="ShowMyStory" scope="page" class="MrrTools.DBConnect"> 
   
        <% 
         out.print("<p align=\"center\"> 主题总数:" + total + "<br/>");
         out.print("\"管理员提示：发言请勿涉及不健康内容。\"</p><br/>");
         useMyStory.closeResultSet();
         useMyStory.closePreStatement();
         useMyStory.closeConnection();
         int sub=total-(flag - 1) * 5;
         if(sub>0)
         { 
         
         ShowMyStory.getConnection();
         ShowMyStory.getPreparedStatement(sql);
         ShowMyStory.executeQuery();
         int go=(flag - 1) * 5;
         while(go>0)
         {
         ShowMyStory.resultSet.next();
         go--;} 
                   
           int Show=1;
           while(ShowMyStory.resultSet.next() && Show<=5)
           {
              int ID=ShowMyStory.resultSet.getInt(1);
              String DBTitle=ShowMyStory.resultSet.getString(2).trim();
              String Content=ShowMyStory.resultSet.getString(3).trim();
              Date Date=ShowMyStory.resultSet.getDate(4);            
              int Respond=ShowMyStory.resultSet.getInt(5);
              int Click=ShowMyStory.resultSet.getInt(6);
              out.print("<p align=\"center\">");
              out.print("<a href=\"Forum-1.jsp?DBLink=" + DBLink + "&Title=" + DBTitle + "&Content=" + Content +
              "\">" + ID + "." + DBTitle + Date + "(回复:" + Respond + "人气:" + Click + ")</a>");
              out.print("</p>");
              Show++;                       
           }
            ShowMyStory.closeResultSet();
            ShowMyStory.closePreStatement();
            ShowMyStory.closeConnection();
            out.print("<p align=\"center\"><a href=\"MyStory.jsp?flag=" + flag + "&Title=" + Title + 
            "&DBLink=" +DBLink +"\">下一页</a><br/><br/></p>");
            }
         else
         {   flag=0;
             out.print("<p align=\"center\">浏览结束</p>");
         }
      %>
      </jsp:useBean>
 </wml>