MVC编写的新闻页面

package cn.news.impl;import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;import org.junit.Test;import cn.news.dao.BaseDao;
import cn.news.dao.NewsDetailDao;
import cn.news.entity.NewsDetail;public class NewsDetailDaoImpl extends BaseDao implements NewsDetailDao{ @Test
public void test() throws Exception
{
List<NewsDetail> list=getAllNews();
for (NewsDetail item : list) {
System.out.println(item.getNewsContent());
} } @Override
public List<NewsDetail> getAllNews() throws Exception {
List<NewsDetail> list=new ArrayList<NewsDetail>(); String sql="select * from newsDetails"; ResultSet rs=executeQuery(sql); if(rs!=null)
{
while(rs.next())
{
NewsDetail news=new NewsDetail(); news.setNewsId(rs.getInt("newsId"));
news.setNewsTitle(rs.getString("newsTitle"));
news.setNewsContent(rs.getString("newsContent"));
news.setNewsCreateDate(rs.getDate("newsCreateDate"));
news.setNewsAuthor(rs.getString("newsAuthor"));
news.setNewsCategoryId(rs.getInt("newsCategoryId")); list.add(news);
}
}
return list;
}}

package cn.news.servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import cn.news.entity.NewsDetail;
import cn.news.impl.NewsDetailDaoImpl;public class NewsServlet extends HttpServlet { /** */
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { doPost(request,response); } /** */
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { //实例化dao
NewsDetailDaoImpl dao=new NewsDetailDaoImpl(); try {
List<NewsDetail> list=dao.getAllNews(); request.setAttribute("list", list);
} catch (Exception e) {
e.printStackTrace();
} request.getRequestDispatcher("/index.jsp").forward(request, response);
}}

<ul class="classlist"> <%
List<NewsDetail>list=(List<NewsDetail>)request.getAttribute("list"); for(NewsDetail item:list)
{ %>
<li><a href='newspages/news_read.jsp'><%=item.getNewsTitle() %></a><span><%=item.getNewsCreateDate() %></span></li> <%
} %> <p align="right"> 当前页数:[1/2]&nbsp; <a href="#">下一页</a> <a href="#">末页</a> </p>
</ul>