旅游网站jsp源码

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>旅游产品列表</title>
</head>
<body>
<h1>热门旅游产品</h1>
<table border="1">
    <tr>
        <th>产品名称</th>
        <th>价格</th>
        <th>描述</th>
    </tr>
    <%
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/travel_db", "username", "password");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM products");
            while (rs.next()) {
    %>
    <tr>
        <td><%= rs.getString("name") %></td>
        <td><%= rs.getDouble("price") %></td>
        <td><%= rs.getString("description") %></td>
    </tr>
    <%
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
        }
    %>
</table>
</body>
</html>