下载express-generator
npm install express-generator -g
生成项目
express -e ProjectName
或者使用node自带的npx生成项目
npx express
安装依赖
cnpm install
运行
npm run start
热更新------>下载nodemon
cnpm install --save-dev nodemon
修改package.json
"scripts": {
"start": "node ./bin/www",
"devstart": "nodemon ./bin/www"
}
执行
npm run devstart
目录结构
bin: www 创建服务器,并监听服务器
node_modules:依赖项
public : 静态资源目录
routes: 路由文件
view: 模板文件
app.js 入口文件
然后可以直接在routes下的index.js写业务内容
例如:
// 导出所有学生的成绩
router.post('/exportGrade', async function(req, res, next) {
// SELECT * FROM (SELECT stu.* FROM stu WHERE sno IN (SELECT sno FROM xk_info WHERE tcid ='43'))AS s,results as r WHERE s.sno=r.sno ORDER BY zcj asc
let sql = `SELECT * FROM (SELECT stu.* FROM stu WHERE sno IN (SELECT sno FROM xk_info WHERE tcid ='${req.body.tcid}'))AS s,results as r WHERE s.sno=r.sno ORDER BY zcj asc`
pool.getConnection(function(err, connection) {
if (err) throw err;
connection.query(sql, function(error, results, fields) {
connection.release();
res.send(results)
if (error) throw error;
});
});
});