node mysql

菜鸟

安装

cnpm install mysql

在express中使用

const mysql = require('mysql');


class UserDao {

    constructor(){
         this.connection = mysql.createConnection({
            host: UserDao.host,
            user: UserDao.user,
            password: UserDao.password,
            database: UserDao.database
        });
        this.connection.connect();
    }
    query(sql){
        this.connection
      let result = this.connection.query(sql, function (error, results, fields) {
            console.log('The solution is: ', results[0].solution);
        });

        return result;
    }


}

UserDao.host = 'localhost';
UserDao.user = 'root';
UserDao.password = 'root';
UserDao.database= 'database';

module.exports = UserDao;

连接池连接

class MysqlModel
{
    constructor(){
        this.pool = mysql.createPool({
            connectionLimit : 3,
            host: '127.0.0.1',
            user: '111111',
            password: '111111',
            database: 'database'
        });
        Q.promisifyAll(this.pool);
    }
    query(sql, values) {
        // 返回一个 Promise
    return new Promise((resolve, reject) => {
        this.pool.getConnection(function (err, connection) {
            if (err) {
                reject(err)
            } else {
                connection.query(sql, values, (err, rows) => {

                    if (err) {
                        reject(err)
                    } else {
                        resolve(rows)
                    }
                    // 结束会话
                    connection.release() // connection.release() //当连接完成后，调用connection.release()方法使连接返回到连接池，以便其他人可以再次使用。
                })
            }
        })
    })

   }
}