dbshowcon.jsp

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

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