js+查询某一时间段数据库

function fetchData(startDate, endDate) {
    fetch(`/api/data?start=${startDate}&end=${endDate}`)
        .then(response => response.json())
        .then(data => console.log(data))
        .catch(error => console.error('Error:', error));
}

// 使用示例
fetchData('2023-01-01', '2023-01-31');

const express = require('express');
const MongoClient = require('mongodb').MongoClient;
const app = express();

let db;

MongoClient.connect('mongodb://localhost:27017/mydatabase', (err, client) => {
    if (err) return console.log(err);
    db = client.db('mydatabase');
});

app.get('/api/data', (req, res) => {
    const { start, end } = req.query;
    db.collection('mycollection').find({
        date: { $gte: new Date(start), $lte: new Date(end) }
    }).toArray((err, result) => {
        if (err) return res.status(500).send(err);
        res.send(result);
    });
});

app.listen(3000, () => console.log('Server running on port 3000'));