老师,请问我这个报错如何处理啊,
mysql js部分
const mysql = require("mysql");
const clinet = mysql.createConnection({
host:"localhost",
user:"root",
password:"",
database:"itbaizhan_ego"
})
function sqlFn(sql,arr,callback){
clinet.query(sql,arr,(error,result) =>{
if(error){
console.log(error);
return;
}
callback(result)
})
}
module.exports = sqlFn
index主入口文件部分
const express =require('express');
const app =express();
const router =require('./router');
const bodyParser =require("body-parser");
app.use(bodyParser.urlencoded({
extended:true
}))
app.use("/api",router);
app.listen(3000,()=>{
console.log("服务器运行在3000端口");
})
router 配置部分
const express =require('express');
const router =express.Router;
const sqlFn =require('./mysqlC');
router.post("/login",(req,res)=>{
//接受username以及password参数
const username=req.body.username;
const password=req.body.password;
//查询的sql语句
const sql = "select * from user where username=? and password=?"
const arr =[username,password];
sqlFn(sql,arr,result=>{
if(result.length >0){
res.send({
status:200,
result
})
}else(
res.send({
status:400,
msg:'用户名密码错误'
})
)
})
})
module.exports =router;
报错部分
