dbentertainment.jsp

来自「一个手机动态网页源程序」· JSP 代码 · 共 56 行

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