announce.jsp

来自「网上购物系统」· JSP 代码 · 共 40 行

<%@ page contentType="text/html; charset=gb2312"%>
<table width="220" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="41" colspan="3" valign="bottom" background="images/left-1-1.gif"><div align="center" class="glow_white">站 内 公 告</div></td>
  </tr>
  <tr>
    <td width="5" bgcolor="#E7E7E7"></td>
    <td width="210">
	<!--公告栏目 开始-->
	<%
//公告栏目配置
Statement stmt_Announce=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_Announce = "Select * from tAnnounce  order by fDateAndTime Desc";
ResultSet Rs_Announce = stmt_Announce.executeQuery(sql_Announce);
while(Rs_Announce.next())
{
	String AnnounceTitle=Rs_Announce.getString("fTitle");
	%>
		&nbsp;&nbsp;·<a href="AnnounceContent.jsp?ID=<%=Rs_Announce.getInt("fID")%>" target="_blank" title="公告标题：<%=AnnounceTitle%>
	发布时间：<%=Rs_Announce.getString("fDateAndTime")%>" >
	<%
	if (AnnounceTitle.length()>15)
		{	AnnounceTitle=AnnounceTitle.substring(0,15)+"...";
		}
	%>
	<%=AnnounceTitle%></a><br />
<%
}
Rs_Announce.close(); //关闭记录集对象
stmt_Announce.close(); //关闭语句对象
%>	
	<!--公告栏目 结束-->
		</td>
    <td width="5" bgcolor="#E7E7E7"></td>
  </tr>
  <tr>
    <td colspan="3"><img src="images/left-1-2.gif" width="220" height="10" /></td>
  </tr>
</table>