node+express编写简单接口(个人笔记)

//导入模块
const express = require('express');
const mysql = require('mysql');
const bodyParser = require('body-parser')
const app = express();
//建立数据库连接
const sql= mysql.createPool({
	host: 'localhost',
	user: 'root',
	password: '123456',
	database: 'user',
	port: 3306
})
// 设置中间间去获取post请求参数
bodyParser.urlencoded({ extended:  false  })
app.use(bodyParser.json())

// 设置为可跨域
app.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();
});

// 前端请求地址为  http://localhost:8001/user/info
app.get('/user/info', (req, res) => {
	if (req.method == 'GET') {
		sql.query(`SELECT * FROM userInfo`, (qerr, vals, fields) => {
			res.send({
				data:vals
			})
		})
	} else {
		res.send('请求有误')
	}

})
app.post('/user/lologin', (req, res) => {
	if (req.method == 'POST') {
		if(req.body.username&&req.body.password){
			sql.query("SELECT * FROM userLogin where username="+"'"+req.body.username+"'"+"and password="+"'"+req.body.password+"'", (qerr, vals, fields) => {				if(vals && vals.length>0){
					res.status(200)
					res.send({
						code: 200,
						message: '登录成功'
					})
				}else{
					res.status(404)
					res.send({
						code: -1,
						message: '登录失败,请检查您的账号密码'
					})
				}
				
			})
		}else{
			res.status(404)
			res.send({
				code: -1,
				message: '登录失败,账号或者密码不能为空'
			})
		}
		
	} else {
		res.send({
				code: -1,
				message: '登录失败'
			})
	}

})

app.listen(80, () => {
	console.log('ok-启动成功');
})