基于jsp的网站流量统计

<!-- 示例：Google Analytics跟踪代码 -->
<script async src="https://www.googletagmanager.com/gtag/js?id=GA_MEASUREMENT_ID"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());
  gtag('config', 'GA_MEASUREMENT_ID');
</script>

// 示例：自定义统计脚本
<%@ page import="java.sql.*" %>
<%
    String ip = request.getRemoteAddr();
    String url = request.getRequestURI();
    String userAgent = request.getHeader("User-Agent");

    // 连接数据库并插入记录
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost/statistics", "username", "password");
        pstmt = conn.prepareStatement("INSERT INTO traffic (ip, url, user_agent, timestamp) VALUES (?, ?, ?, NOW())");
        pstmt.setString(1, ip);
        pstmt.setString(2, url);
        pstmt.setString(3, userAgent);
        pstmt.executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
    }
%>