Node.js 的 MySQL 操作

function Mysql() {
    var mysql = require('mysql');
    var connection = mysql.createConnection({
        // These are attributes
        host: 'localhost',
        user: 'root',
        password: '123456',
        database: 'tofeed'
    })
    // Method connect() to connect mysql
    connection.connect();

    // Create Table
    this.createTable = function (sql) {
        connection.query(sql, function (err, result) {
            if (err) {
                console.log('[CREATE ERROR] - ', err.message)
            } else {
                console.log('-------CREATE-------')
                console.log(result)
                console.log('--------------------\n\n')
            }
        })

        // Method end() to end connection
        connection.end();
    }

    // Select from database tofeed
    this.select = function (sql) {
        connection.query(sql, function (err, result) {
            if (err) {
                console.log('[SELECT ERROR] - ', err.message)
            } else {
                console.log('-------SELECT-------')
                console.log(result)
                console.log('--------------------\n\n')
            }
        })

        // Method end() to end connection
        connection.end();
    }

    // Insert into database tofeed
    this.insert = function (addSql, addSqlParams) {
        connection.query(addSql, addSqlParams, function (err, result) {
            if (err) {
                console.log('[INSERT ERROR] - ', err.message)
            } else {
                console.log('-------INSERT-------')
                console.log('INSERT ID', result)
                console.log('--------------------\n\n')
            }
        })

        // Method end() to end connection
        connection.end();
    }

    // Delete from database tofeed
    this.delete = function (delSql) {
        connection.query(delSql, function (err, result) {
            if (err) {
                console.log('[DELETE ERROR] - ', err.message)
            } else {
                console.log('-------DELETE-------')
                console.log('DELETE affectedRows: ', result.affectedRows)
                console.log('--------------------\n\n')
            }
        })

        // Method end() to end connection
        connection.end();
    }

    // Modify from database tofeed
    this.modify = function (modSql, modSqlParams) {
        connection.query(modSql, modSqlParams, function (err, result) {
            if (err) {
                console.log('[UPDATE ERROR] - ', err.message)
            } else {
                console.log('-------UPDATE-------')
                console.log('UPDATE affectedRows: ', result.affectedRows)
                console.log('--------------------\n\n')
            }
        })

        // Method end() to end connection
        connection.end();
    }
}

module.exports = Mysql;