js使用mysql数据库

1、安装mysql

npm install --save mysql

2、配置

config.js

const mysql = require('mysql')
const client = mysql.createConnection({
    host: 'localhost',
    user: 'badianboke',
    password: 'badianboke',
    database: 'badianboke'
})

module.exports = function sqlFn(sql, arr, callback){
    client.query(sql, arr, (error, result) => {
        if (error){
            console.log(error);
            return;
        }
        callback(result)
    })
}

3、引入配置使用

const sqlFn = require('./config')

const sql = 'insert into user values (null,?,?,?)'

let username = 'badian'
let email = 'badian@666.com'
let password = 'badian'

const arr = [username, email, password]

sqlFn(sql, arr, result => {
    console.log('cc',result);
})