第三名模块mysql

mysql

	
let express=require("express")()
// console.log(express)
let port=8080;
// Node解决跨域问题
express.all("/*", function(req, res, next) {
    // 跨域处理
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Headers", "X-Requested-With");
    res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");
    res.header("X-Powered-By", ' 3.2.1');
    res.header("Content-Type", "application/json;charset=utf-8");
    next(); // 执行下一个路由
})

let mysql=require("mysql")
let sql=mysql.createConnection({
    host:"localhost",
    user:"root",
    password:"123456",
    database:"student"
})
sql.connect();
//从数据库中获取数据
express.get("/logon",(request,response)=>{
    let username = request.query.username;
	let password = request.query.password;
    sql.query(`SELECT * FROM user WHERE username="${username}"AND password="${password}"`,(error,data)=>{
        if(error){
            console.log(error)
            response.send("error")
        }else{
            if(!data.length){
                response.send("error")
            }
            else{
                response.send("success")
            }
        }
    })
})
//像数据库中写入数据
express.get("/addUser",(request,response)=>{
    let username = request.query.username;
	let password = request.query.password;
    sql.query(`INSERT INTO user(username,password) values("${username}","${password}")`,(error)=>{
        if(error){
            console.log(error)
            response.send("error")
        }else{
            response.send("success")
        }
    })
})

express.listen(port)
console.log("server is running at " + port)