jsp页面统计点击次数

CREATE TABLE page_hits (
    id INT AUTO_INCREMENT PRIMARY KEY,
    page_name VARCHAR(255) NOT NULL,
    hits INT DEFAULT 0
);

<%@ page import="java.sql.*" %>
<%
    String pageName = "example.jsp"; // 当前页面名称
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdb", "username", "password");

        // 检查是否存在该页面的记录
        pstmt = conn.prepareStatement("SELECT hits FROM page_hits WHERE page_name = ?");
        pstmt.setString(1, pageName);
        rs = pstmt.executeQuery();

        int hits = 0;
        if (rs.next()) {
            hits = rs.getInt("hits");
        }

        // 更新点击次数
        hits++;
        pstmt = conn.prepareStatement("UPDATE page_hits SET hits = ? WHERE page_name = ?");
        pstmt.setInt(1, hits);
        pstmt.setString(2, pageName);
        pstmt.executeUpdate();

        out.println("Page hits: " + hits);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try { if (rs != null) rs.close(); } catch (Exception e) {}
        try { if (pstmt != null) pstmt.close(); } catch (Exception e) {}
        try { if (conn != null) conn.close(); } catch (Exception e) {}
    }
%>