newsshow.asp

一个互联网络公司网站源码

<!--#include file="../inc/conn.asp" -->
<%
	response.Charset="gb2312"
	response.ContentType="text/html"
	newsType=request.QueryString("newsType")
	if request.QueryString("ID")<>"" and isnumeric(request.QueryString("ID")) then 
	sql="select * from article where id='"&request.QueryString("ID")&"' and articleType='"&newsType&"'"
	else
	sql="select top 1 * from article where articleType='"&newsType&"' order by id desc"
	end if
	set rs=server.CreateObject("adodb.recordset")
	rs.open sql,conn,1,1
	if not rs.eof then
%>
<table width=95% border=0 cellspacing=0 cellpadding=0>
  <tr>
    <td height=3 bgcolor=#DBDBDB>
</td>
  </tr>
  <tr>
    <td height=28 align=center bgcolor=#FAFAFA><span class=pt14><strong><%=rs("title")%></strong></span></td>
  </tr>
  <tr>
    <td height=24 align=center bgcolor=#FAFAFA>发布日期：<%=rs("insertTime")%></td>
  </tr>
  <tr>
    <td height=1 bgcolor=#DBDBDB></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<table width=95% border=0 cellpadding=6 cellspacing=0 bgcolor=#FFFFFF class=gao>
  <tr>
    <td bgcolor=#FFFFFF><%if rs("articlepic")<>"" then%> <img src= <%=rs("articlepic")%>  align= left  border= 0  /><%end if%>
<%=rs("content")%></td>
  </tr>
</table>
<%
end if
rs.close
conn.close
%>