nodejs链接mysql

模块

mysql

安装

npm install mysql

使用

// An highlighted block
const mysql = require("mysql")

let sqlInfo = {
    host: 'xx.xxx.xxx.x',
    port: "3306",
    user: "test",
    password: "test",
    database: "test"
}

select_status = function (id, cb,info = sqlInfo) {
    let connection = mysql.createConnection({
        host: info.host,
        port: info.port,
        user: info.user,
        password: info.password,
        database: info.database
    })

    connection.connect();
    let sqlRequest = "SELECT * FROM `test`.`info` WHERE `id` = '"+id+"' ORDER BY `create_time` DESC";
    connection.query(sqlRequest, "",(error, results, fields)=>{
        if (results.length == 0){
            cb(null);
        }else{
            cb(results);
        }

    });
    connection.end();
}
exports.select_status = select_status;

这样在别的文件中就可以调用这个方法了
注意：connection.query 第三个参数是callback