jsp新闻发布系统教程

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/newsdb";
    String username = "root";
    String password = "password";
    Connection conn = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
    } catch (Exception e) {
        e.printStackTrace();
    }
%>

<%@ include file="DBConnection.jsp" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
    <title>新闻列表</title>
</head>
<body>
    <h1>新闻列表</h1>
    <ul>
        <%
            String sql = "SELECT * FROM news";
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
        %>
            <li><a href="NewsDetail.jsp?id=<%= rs.getInt("id") %>"><%= rs.getString("title") %></a></li>
        <%
            }
            rs.close();
            stmt.close();
        %>
    </ul>
</body>
</html>

<%@ include file="DBConnection.jsp" %>
<%@ page import="java.sql.*" %>
<html>
<head>
    <title>新闻详情</title>
</head>
<body>
    <h1>新闻详情</h1>
    <%
        int id = Integer.parseInt(request.getParameter("id"));
        String sql = "SELECT * FROM news WHERE id = " + id;
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        if (rs.next()) {
    %>
            <h2><%= rs.getString("title") %></h2>
            <p><%= rs.getString("content") %></p>
    <%
        }
        rs.close();
        stmt.close();
    %>
</body>
</html>

String sql = "SELECT * FROM news WHERE id = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
ResultSet rs = pstmt.executeQuery();