dbstarnews.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>
 <jsp:useBean id="useStarNews" scope="page" class="MrrTools.DBConnect">
      <%
         int count=1;
         String sql="select * From " + DBLink;
         useStarNews.getConnection();
         useStarNews.getPreparedStatement(sql);
         useStarNews.executeQuery();
         if(ID.equals("1"))
         {
           while(useStarNews.resultSet.next()&& count<2)
           {count++;} 
           while(useStarNews.resultSet.next())
           { int ID2=useStarNews.resultSet.getInt(1);
             String Title=useStarNews.resultSet.getString(2);
             String Content=useStarNews.resultSet.getString(3);
             String Image=useStarNews.resultSet.getString(4);
             out.print("<p align=\"center\">");
             out.print("<img src=\"Image/" + Image + "\"/><br/>");
             out.print("<a href=\"ShowContent.jsp?ID=" + ID2 + "&DBLink=" + DBLink + "\">" + Title + "</a>");
             out.print("</p>");
           } 
           useStarNews.closeResultSet();
           useStarNews.closePreStatement();
           useStarNews.closeConnection();
         }
         else
         {
          while(useStarNews.resultSet.next())
           { int ID3=useStarNews.resultSet.getInt(1);
             String Title=useStarNews.resultSet.getString(2);
             String Content=useStarNews.resultSet.getString(3);
             String Image=useStarNews.resultSet.getString(4);
             out.print("<p align=\"center\">");
             out.print("<img src=\"Image/" + Image + "\"/><br/>");
             out.print("<a href=\"ShowContent.jsp?&ID=" + ID3 + "&DBLink=" + DBLink + "\">" + Title + "</a>");
             out.print("</p>");
           } 
           useStarNews.closeResultSet();
           useStarNews.closePreStatement();
           useStarNews.closeConnection();
         }
      %>
      </jsp:useBean>
</wml>