worknet.jsp

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

<% String toptitle="网上办事..."; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>

 <%String id=request.getParameter("id"); 
 	        String    nettitle="";
			String    netbody="";
			String    filename="";
			String    workfile="";	
String sql="Select nettitle,netbody,filename,workfile From scott.worknet where id='"+id+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
 if(!rs.next()){ 
	  out.print("<script>alert('对不起,您所要查询的对象不存在');history.back();</script>");
 }else{
	nettitle=rs.getString("nettitle");
	netbody=rs.getString("netbody");
	filename=rs.getString("filename");
    workfile=rs.getString("workfile");	  
	  %>
<table width="766" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr align="center" bgcolor="#F6F6F6"> 
    <td height="27" colspan="3"  background="images/zxzctp2.gif"><%=nettitle%></td>
  </tr>
  <tr> 
    <td height="20" background="images/dhbg2.gif" bgcolor="#F6F6F6"> 
      <div align="center"><strong>相关信息</strong></div></td>
    <td colspan="2">*--插图</td>
  </tr>
  <tr> 
    <td width="16%" rowspan="2" valign="center" bgcolor="#F6F6F6"> <br>
        <%	
			    sql="select  id,nettitle from scott.worknet where id<>'"+id+"' order by nettime desc";
	ResultSet rst=stmt.executeQuery(sql); 
                                    	 int ii=1;
                                      while(ii<11&&rst.next()) {  
	   %>
        <a href="worknet.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("nettitle")%></a><br>
        <%ii++;}	   %>
      </div></td>
    <td width="1%" rowspan="2" valign="top"><img src="images/dhtp2.gif" width="2" height="101%"></td>
    <td width="83%" height="80%" valign="top"><div align="center"><%if(workfile!=null){%><img height="100"  src="upload/<%=workfile%>" width="100" /><%}%></div>&nbsp;&nbsp;<%=netbody%></td>
  </tr>
  <tr>
    <td height="20%"> 
      <%
	
 out.print("</td></tr><tr align='right' bgcolor=#F6F6F6><td height='20' colspan='3'> <a href='javascript:window.close()'>【关闭窗口】</a></td></tr></table>");
 } %>
<%@ include file="foot.jsp"%>