listpy.jsp

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

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