jsp新闻编辑模块源码

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>编辑新闻</title>
</head>
<body>
    <h1>编辑新闻</h1>
    <form action="update_news.jsp" method="post">
        <input type="hidden" name="newsId" value="${news.id}">
        标题: <input type="text" name="title" value="${news.title}"><br>
        内容: <textarea name="content" rows="10" cols="50">${news.content}</textarea><br>
        <input type="submit" value="保存">
    </form>
</body>
</html>

<%@ page import="java.sql.*" %>
<%
    String newsId = request.getParameter("newsId");
    String title = request.getParameter("title");
    String content = request.getParameter("content");

    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/newsdb", "username", "password");
        String sql = "UPDATE news SET title=?, content=? WHERE id=?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, title);
        pstmt.setString(2, content);
        pstmt.setInt(3, Integer.parseInt(newsId));
        pstmt.executeUpdate();
        response.sendRedirect("news_list.jsp");
    } catch (Exception e) {
        e.printStackTrace();
        out.println("更新新闻失败：" + e.getMessage());
    } finally {
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
    }
%>