jsp定时查询数据库

import java.util.Timer;
import java.util.TimerTask;

public class ScheduledTask {
    public static void main(String[] args) {
        Timer timer = new Timer();
        TimerTask task = new TimerTask() {
            @Override
            public void run() {
                // 执行数据库查询操作
                System.out.println("定时任务执行");
            }
        };
        // 每隔5秒执行一次任务
        timer.schedule(task, 0, 5000);
    }
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DatabaseQuery {
    public static void main(String[] args) {
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "user", "password");
            Statement stmt = conn.createStatement();
            String sql = "SELECT * FROM mytable WHERE condition = 'value'";
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                // 处理查询结果
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}