dbcoolcars.jsp

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

<?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">
      <% 
         String sql="select * From " + DBLink;
         useStarNews.getConnection();
         useStarNews.getPreparedStatement(sql);
         useStarNews.executeQuery();
         while(useStarNews.resultSet.next())
           { int ID=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=" + ID + "&DBLink=" + DBLink + "\">" + Title + "</a>");
             out.print("</p>");
            
            } 
           useStarNews.closeResultSet();
           useStarNews.closePreStatement();
           useStarNews.closeConnection();
        %>
        </jsp:useBean>
</wml>