新聞發布系統架構 - WJ-163－IT工程師數位筆記本

文章出處

實現效果圖:

分層架構圖：

關鍵代碼：控制臺輸出新聞內容

實現類：

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;
    }

}

頁面顯示新聞標題以及時間：

新增NewsServlet類繼承HttpServlet。關鍵代碼：

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);
    }

}

index.jsp

   
      <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>

web.xml