nodejs+mysql入门实例(链接到数据库)
2017-05-04 15:30 muamaker 阅读(417) 评论(0) 编辑 收藏 举报//连接数据库 var mysql = require('mysql'); var connection = mysql.createConnection({ host: '******', //数据库地址 user: '******', //数据库用户名 password: '*****', //数据库管理密码 database:'*******', //数据库名称 insecureAuth: true }); connection.connect(
connection.connect(function(err) {
if (err) {
console.error('error connecting: ' + err.stack);
return;
}
console.log('connected as id ' + connection.threadId);
});
); //查询 connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) { if (err) throw err; console.log('The solution is: ', rows[0].solution); }); //关闭连接 connection.end();
npm install mysql -save
mysql链接池的使用
var mysql = require('mysql'); var sqlConfig = require('../../lib/mysql'); var mySqlParams = { connectionLimit : sqlConfig.connectionLimit, //最大链接数 一般设置为 100 host: sqlConfig.host, //数据库地址 user: sqlConfig.user, //数据库用户名 password: sqlConfig.password, //数据库管理密码 database:sqlConfig.database, //数据库名称 insecureAuth: sqlConfig.insecureAuth }
var pool = mysql.createPool(mySqlParams); module.exports = function (operate,params = false) { var prom = new Promise(function (resolve, reject) { pool.query(operate, params ,function(err, rows, fields) { if (err) { reject(err); }else{ resolve(rows); } }); }).then(function(res){ console.log("数据库查询成功:" + operate + ";" +params); console.log(res); return Promise.resolve(res); }).catch(function(e){ console.log("数据库查询失败:" +e.message+ operate + ";" +params); console.log(e); return Promise.reject(e); }); return prom; }
sequelize 插件,方便操作mysql