listnews.jsp

JSP+ORACLE网站开发实例（下）.rar

<% String toptitle="新闻浏览..."; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>

  <%String id=request.getParameter("id"); 
String sql="Select nstitle,nsbody,writers,times From scott.news 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="100%" border=0 align="center" cellPadding=0 cellSpacing=1>
            <TBODY>
            <TR> 
              <TD height=30 vAlign=top> <p>&nbsp;</p>
                <DIV align="center"><strong> <%=rst.getString("nstitle")%></strong> </DIV><br>
                  <hr align="center" width="100%" size="1" noshade></TD>
            </TR>
            <TR> 
              <TD vAlign=top> <div align="right">--<%=rst.getString("writers")%>报导</div></TD>
            </TR>
          </TBODY>
        </TABLE><br>
         &nbsp;&nbsp;&nbsp;
		 <%=rst.getString("nsbody")%></TD>
    </TR>
    <TR> 
      <TD bgColor=#f5f6fb class=wz7 height=20 vAlign=top><div align="right">发表日期:<%=rst.getString("times")%>-----<a href="javascript:window.close()">【关闭窗口】</a></div></TD>
    </TR>
  </TBODY>
</TABLE>
<% } else{
out.print("<script>alert('对不起,您所要查看的对象并不存在\n请不要随意的地地址栏输入数字');history.back();</script>");

		 }
%>

<%@ include file="foot.jsp"%>