快讯模块

新闻模块
<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%>
<%@page import="com.apex.util.ApexRowSet"%>
<%@page import="com.apex.util.DAO"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>

<!-- 美院新闻 -->

<%
StringBuffer sbMoreUrl = new StringBuffer();
sbMoreUrl
.append("/templ.jsp?id=108");

SimpleDateFormat formate = new SimpleDateFormat("yyyy.MM.dd");
int pageCount = Integer.parseInt(request.getParameter("pageCount"));
String sql = "select ID,Title,PubTime from OA_tBlog where category=1 and SCOPE like '%3%' and FBXXFW like '%1%' order by ZD desc,PubTime desc";
ApexRowSet rs = DAO.getRowset(sql, 1, pageCount);
%>

<h2>
news 美院新闻<a href="<%=sbMoreUrl.toString()%>" alt="快讯模块" /></a>
</h2>
<ul title="<%=title%>"><%=jqTitle%></a>
</li>
<%}
for(int i = 0; i < pageCount - sjCount; i++){
%>
<li>&nbsp;</li>
<%
}
%>
</ul>