【无标题】

node编写一个简单接收数据并写入sql

//1.固定的，引进express框架
const express = require('express')
const app = express()
 
 
//2.设置跨域访问
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();
});
 
//3.端口号
const port = 3000
//3.1 监听端口
app.listen(port, () => {
    console.log(`Example app listening at http://localhost:${port}`)
})
 
 
//4.连接数据库
var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '123456',
    database: 'sys'
});
 
//5.建立连接数据库
connection.connect();
 
//6.根据id查询数据库里面的数据
app.get("/list/:id",(req,res)=>{
    
        let searchSql = 'SELECT * from `user_test` WHERE `id` = ? '
        let searchParams = [req.params.id]
        connection.query(searchSql,searchParams,(err,result) =>{
            res.send(result)
            // connection.release()
        
    });
});
 
//6.1根据参数添加数据到数据库
app.get('/insert',(req,res)=>{
        console.log(req.query)
        var addSql = 'INSERT INTO `user`(`id`,`username`,`password`) VALUES(?,?,?)';
        var addSqlParams = [req.query.id,req.query.username,req.query.password];
        //增
        connection.query(addSql, addSqlParams, function (err, result) {
            if (err) {
                console.log('[INSERT ERROR] - ', err.message);
                return;
            }
            console.log(result)
            res.send("添加数据成功！！");//添加成功后，输出这条数据在页面！
            //释放连接
            // connection.release();
        
    });
});