jsp与mysql系统时间比较

<%@ page import="java.util.Date" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.sql.*" %>

<%
    // 获取当前服务器时间
    Date now = new Date();
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    String serverTime = sdf.format(now);

    // 获取数据库时间
    String dbTime = "";
    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT NOW()");
        if (rs.next()) {
            dbTime = rs.getString(1);
        }
        rs.close();
        stmt.close();
        conn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }

    // 比较时间
    boolean isWithinTimeRange = false;
    if (!serverTime.isEmpty() && !dbTime.isEmpty()) {
        Date serverDateTime = sdf.parse(serverTime);
        Date dbDateTime = sdf.parse(dbTime);
        // 假设活动开始时间为2023-10-01 10:00:00，结束时间为2023-10-01 12:00:00
        Date startTime = sdf.parse("2023-10-01 10:00:00");
        Date endTime = sdf.parse("2023-10-01 12:00:00");
        isWithinTimeRange = serverDateTime.after(startTime) && serverDateTime.before(endTime);
    }

    if (isWithinTimeRange) {
        out.println("活动正在进行中！");
    } else {
        out.println("活动已结束或尚未开始。");
    }
%>