jsp新闻发布系统实例

import java.sql.*;

public class DBConnection {
    public static Connection getConnection() throws SQLException {
        String url = "jdbc:mysql://localhost:3306/newsdb";
        String user = "root";
        String password = "password";
        return DriverManager.getConnection(url, user, password);
    }
}

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
    <title>新闻列表</title>
</head>
<body>
    <h1>最新新闻</h1>
    <ul>
        <%
            try {
                Connection conn = DBConnection.getConnection();
                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery("SELECT * FROM news ORDER BY publish_date DESC");
                while (rs.next()) {
        %>
                    <li><a href="newsDetail.jsp?id=<%= rs.getInt("id") %>"><%= rs.getString("title") %></a></li>
        <%
                }
                rs.close();
                stmt.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        %>
    </ul>
</body>
</html>