dbbag.jsp

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

<?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="DBShowCon" scope="page" class="MrrTools.DBConnect">
<%        int i=1;
          String sql ="SELECT * FROM " + DBLink;
          DBShowCon.getConnection();
          DBShowCon.getPreparedStatement(sql);
          DBShowCon.executeQuery();
          DBShowCon.resultSet.next();
          String Content=DBShowCon.resultSet.getString(3);
          String Image=DBShowCon.resultSet.getString(4);
          while(i<=1)
          {
          out.print("<p align=\"center\">");
          out.print("<img src=\"Image/" + Image + "\" width=\"80\" length=\"80\"/><br/>");
          out.print(Content);
          out.print("</p><br/>");
          i++;
          }
          DBShowCon.closeConnection();
          DBShowCon.closePreStatement();
          DBShowCon.closeResultSet();
       
      %>
      </jsp:useBean>
 </wml>