我正在尝试使用已导入Vscode的位桶代码,并使服务器使用MSSQL数据库在端口3000上进行侦听。之后,我必须实现端点。我只是想知道我安装了所有软件包,还依赖于为什么我仍然会遇到相同的错误。我在这里安装了npm expree并全部安装在同一环境中。请帮我解决一下这个。
npm install express npm install express-session npm安装mssql
“严格使用”;
const express = require('express');
const bodyParser = require('body-parser');
const Database = require('./lib/Database');
const setup = async () => {
const database = new Database();
const db = await database.init()
.catch((error) => {
console.error(error);
process.exit(1);
});
const app = express();
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended: false}));
app.get('/devices',(req,res,next) => {
return db.all('SELECT * FROM devices;')
.then((devices) => res.json(devices))
.catch(next);
});
app.get('/devices/:deviceId',next) => {
return db.get('SELECT * FROM devices WHERE id = ?;',req.params.deviceId)
.then((devices) => res.json(devices))
.catch(next);
});
app.post('/devices',next) => {
const newDevice = [req.body.siteId,req.body.name,req.body.active];
return db.run('INSERT INTO devices (siteId,name,active) VALUES (?,?,?)',newDevice)
.then((insertResult) => db.get('SELECT * FROM devices WHERE id = ?',insertResult.stmt.lastID))
.then((insertedDevice) => res.json(insertedDevice))
.catch(next);
});
app
.listen(3000,'0.0.0.0',() => {
console.info('server listening on port: 3000');
})
.on('request',(req) => {
console.info(req.method,req.baseUrl + req.url);
})
.on('error',(err) => {
console.error(err);
});
};
setup();
我想使端口使用节点侦听,并实现CRUD操作的功能。
发生以下错误
[错误:ENOENT:没有这样的文件或目录,scandir'c:\ Users \ me \ Downloads \ nodeAPI \ migrations'] errno:-4058, 代码:“ ENOENT”, syscall:“ scandir”, 路径:'c:\ Users \ me \ Downloads \ nodeAPI \ migrations'}