新闻模块

<%@ 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()%>" class="more"><img src="/images/ico_more.png" alt="more" /></a>
</h2>
<ul class="news_list">
<%
int sjCount = 0;
while(rs.next()){
sjCount++;
int id = rs.getInt("ID");
String title = rs.getString("Title");
String jqTitle = title;
if(title.length() > 18)
jqTitle = jqTitle.substring(0, 18) + "...";
Date pubTime = rs.getDate("PubTime");
String str_pubTime = formate.format(pubTime);
StringBuffer sbUrl = new StringBuffer();
sbUrl
.append("/jsp/search/searchItem.jsp?table=OA_tBlog&column=ID&mode=newsBoardRecord&order=PubTime%20desc&id=107&key=")
.append(id);
%>
<li>
<a href="<%=sbUrl.toString()%>" title="<%=title%>"><%=jqTitle%></a>
</li>
<% }
for(int i = 0; i < pageCount - sjCount; i++){
%>
<li> </li>
<%
}
%>
</ul>