jsp统计网站访问量

<%@ page import="java.util.concurrent.atomic.AtomicInteger" %>
<%
    // 获取或创建Session
    HttpSession session = request.getSession(true);
    
    // 使用AtomicInteger确保线程安全
    AtomicInteger visitCount = (AtomicInteger) session.getAttribute("visitCount");
    if (visitCount == null) {
        visitCount = new AtomicInteger(0);
        session.setAttribute("visitCount", visitCount);
    }
    
    // 增加访问次数
    int count = visitCount.incrementAndGet();
%>
<p>您已经访问了本页面 <%= count %> 次。</p>

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/website";
    String username = "root";
    String password = "password";
    
    try (Connection conn = DriverManager.getConnection(url, username, password)) {
        String sql = "INSERT INTO visit_log (ip, visit_time) VALUES (?, NOW()) ON DUPLICATE KEY UPDATE visit_count = visit_count + 1";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, request.getRemoteAddr());
        pstmt.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>
<p>网站访问量已更新。</p>