dismztj.jsp

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

<% String toptitle="查看统计"; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>
 <%String tjid=request.getParameter("id"); 
String sql="select tjtitle,tjbody,tjtime  From scott.mztj where tjid='"+tjid+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
 if(!rs.next()){ 
	 out.print("<script>alert('对不起,您所要查看的对象未找到');history.back();</script>");
	 }else{%>
  <%
  out.print("<TABLE width=766 height=100% border=0 align=center cellPadding=0 cellSpacing=1><TBODY><TR><TD width=766 height=404 vAlign=top bgColor=#f5f6fb class=wz7> <TABLE width=100% border=0 align=center cellPadding=0 cellSpacing=1><TBODY><TR><TD height=30 vAlign=top> <p>&nbsp;</p><DIV align='center'><strong>"+rs.getString("tjtitle")+"</strong></DIV><br> <hr align=center width=100% size=1 noshade></TD></TR></TBODY></TABLE><br> &nbsp;&nbsp;&nbsp;"+rs.getString("tjbody")+"</TD></TR><TR><TD bgColor=#f5f6fb class=wz7 height=20 vAlign=top><div align=right>统计日期:"+rs.getString("tjtime")+"-----<a href='javascript:window.close()'>【关闭窗口】</a></div></TD></TR></TBODY></TABLE>");
	 }%>
<%@ include file="foot.jsp"%>