jsp新闻发布系统代码

JSP（JavaServer Pages）是一种用于创建动态Web页面的技术，它允许开发者将Java代码嵌入到HTML页面中，从而实现动态内容的生成和交互。下面是一个简单的JSP新闻发布系统的代码示例，包括新闻列表展示和新闻详情查看的功能。

1. 新闻列表展示页面（newsList.jsp）

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>新闻列表</title>
</head>
<body>
<h1>新闻列表</h1>
<table border="1">
    <tr>
        <th>标题</th>
        <th>发布时间</th>
    </tr>
    <c:forEach items="${newsList}" var="news">
        <tr>
            <td><a href="newsDetail.jsp?id=${news.id}">${news.title}</a></td>
            <td>${news.publishTime}</td>
        </tr>
    </c:forEach>
</table>
</body>
</html>

2. 新闻详情页面（newsDetail.jsp）

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>${news.title}</title>
</head>
<body>
<h1>${news.title}</h1>
<p>${news.content}</p>
<p>发布时间：${news.publishTime}</p>
</body>
</html>

3. 新闻数据模型（News.java）

public class News {
    private int id;
    private String title;
    private String content;
    private Date publishTime;

    // Getters and Setters
}

4. 新闻数据访问对象（NewsDAO.java）

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class NewsDAO {
    private Connection getConnection() throws SQLException {
        // 这里应该使用连接池获取数据库连接
        return DriverManager.getConnection("jdbc:mysql://localhost:3306/newsdb", "username", "password");
    }

    public List<News> getAllNews() {
        List<News> newsList = new ArrayList<>();
        try (Connection conn = getConnection();
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM news")) {
            while (rs.next()) {
                News news = new News();
                news.setId(rs.getInt("id"));
                news.setTitle(rs.getString("title"));
                news.setContent(rs.getString("content"));
                news.setPublishTime(rs.getDate("publish_time"));
                newsList.add(news);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return newsList;
    }

    public News getNewsById(int id) {
        News news = null;
        try (Connection conn = getConnection();
             PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM news WHERE id = ?")) {
            pstmt.setInt(1, id);
            ResultSet rs = pstmt.executeQuery();
            if (rs.next()) {
                news = new News();
                news.setId(rs.getInt("id"));
                news.setTitle(rs.getString("title"));
                news.setContent(rs.getString("content"));
                news.setPublishTime(rs.getDate("publish_time"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return news;
    }
}

5. Servlet处理请求（NewsServlet.java）

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@WebServlet("/news")
public class NewsServlet extends HttpServlet {
    private NewsDAO newsDAO = new NewsDAO();

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String action = request.getParameter("action");
        if ("list".equals(action)) {
            List<News> newsList = newsDAO.getAllNews();
            request.setAttribute("newsList", newsList);
            request.getRequestDispatcher("newsList.jsp").forward(request, response);
        } else if ("detail".equals(action)) {
            int id = Integer.parseInt(request.getParameter("id"));
            News news = newsDAO.getNewsById(id);
            request.setAttribute("news", news);
            request.getRequestDispatcher("newsDetail.jsp").forward(request, response);
        }
    }
}