Node.js 操作mysql数据库

var Q = require('q');
var mysql = require('mysql');
var connection = mysql.createConnection({
    host     : 'localhost',
    port     :  3306,
    user     : 'root',
    password : '123456',
    database : '',
    charset  : 'UTF8_GENERAL_CI',
    useConnectionPooling: true
});

strSQL_CreateDatabase = 'create database if not exists `Medical`;';

strSQL_CreateTable = 'create table if not exists `Medical`.`Main`(id int primary key auto_increment, `ImagePath` varchar(4096) not null, `UploadTime` datetime not null, `Result` varchar(200));';

strSQL_InsertTable = 'insert into `Medical`.`Main`(ImagePath, UploadTime, Result)values(?, ?, ?);';

strSQL_DeleteTable = 'delete from `Medical`.`Main` where date(UploadTime)=?;';

//------------------------------------------------------------------------------------------------------------------//
function ConnectMysql(){//连接mysql
    connection.connect(function(err){
        if(err){
            console.error(err.message);
        }
        else{
            console.log('connect success');
        }
    });
}

//------------------------------------------------------------------------------------------------------------------//
function DisConnect(){
    connection.end(function(error){
        if (error){
            console.error(error.message);
        }
    });
}

//------------------------------------------------------------------------------------------------------------------//
function CreateDatabase(){//如果数据库不存在则创建
    connection.query(strSQL_CreateDatabase, function(error, results){
        if (error){
            console.error(error.message) ;
        }
        else{
            console.log('create database success');
        } 
    });
}

//------------------------------------------------------------------------------------------------------------------//
function CreateTable(){//如果数据表不存在则创建
    connection.query(strSQL_CreateTable, function(error, results){
        if(error){
            console.error(error.message);
        }
        else{
            console.log('create table success');
        }
    });
}

//------------------------------------------------------------------------------------------------------------------//
function QueryData(){//查表。注意根据条件查询或者联表查询
    connection.query('select * from `Medical`.`Main`;', function(error, results, fields){
        if (error){
            console.error(error.message);
        }
        else{
            console.log('Search result is: ', results);
        }
    });
}

//------------------------------------------------------------------------------------------------------------------//
function InsertData(strParams){//插入数据
    connection.query(strSQL_InsertTable, strParams, function(error, results){
        if (error){
            console.error(error.message);
        }
        console.log('insert data ok: ', results.affectedRows);
    });
}

//------------------------------------------------------------------------------------------------------------------//
function DeleteData(strParams){//删除数据
    connection.query(strSQL_DeleteTable, strParams, function(error, results){
        if (error){
            console.error(error.message);
        }
        console.log('delete data ok: ', results.affectedRows);
    });
}

//------------------------------------------------------------------------------------------------------------------//
var step1 = Q().then(ConnectMysql).then(CreateDatabase).then(CreateTable);//同步操作

QueryData();//异步操作
InsertData(['123', '2018-01-24 09:34:54', 'OK']);//异步操作
DeleteData(['2018-01-24']);//异步操作
DisConnect();//异步操作