var mysql = require('mysql');

var connection = mysql.createConnection({

    host     : 'localhost',

    port     : '',

    database : 'users',

    multipleStatements: true,

    user     : 'root',

    password : '',

});

connection.connect(function(err) {

    if(err) console.log('与MySQL数据库建立连接失败。');

    else{

        console.log('与MySQL数据库建立连接成功。');

        connection.query('INSERT INTO users SET  ?',{username:'jack',firstname:'lu'},function(err,data){

             if(err){

                 console.log('插入数据失败')

             } else {

                 console.log('插入数据成功');

                 connection.query('SELECT *FROM ??',['users'],function(err,data) {

                       if(err) {

                           console.log('查询数据失败');

                       } else {

                           console.log(data)

                           connection.end() ;

                       }

                 })

             }

        })

    }

});