listarti.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 34 行

<% String toptitle="查看信息"; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>
 <%String id=request.getParameter("id"); 
String sql="Select title, body,times From scott.allarti where id='"+id+"'"; 
ResultSet rst=stmt.executeQuery(sql); 
 if(rst.next()){  %>
<TABLE width="766" height="100%" border=0 align="center" cellPadding=0 cellSpacing=1>
  <TBODY>
    <TR> 
      <TD bgColor=#f5f6fb class=wz7 height=404 vAlign=top> 
        <TABLE width="766" border=0 align="center" cellPadding=0 cellSpacing=1>
          <TBODY>
            <TR> 
			
		
              <TD height=53 vAlign=top> <br>
                <DIV align=center> 
                  <font size="4"><%=rst.getString("title")%></font>
                </DIV></TD>
            </TR>
          </TBODY>
        </TABLE>
       &nbsp;&nbsp;&nbsp;<%=rst.getString("body")%></TD>
    </TR>
    <TR>
      <TD bgColor=#f5f6fb  height=20 vAlign=top><div align="right"><a href="javascript:window.close()">【关闭窗口】</a></div></TD>
    </TR>
  </TBODY>
</TABLE>
<% }else{
out.print("<script>alert('操作出错\n请返回重试');history.back();</script>");}
 %>
<%@ include file="foot.jsp"%>