经过比较个人感觉sequelize 比其他orm好用些,用了半天时间终于搞定了,直接上代码
1、利用sequelize model生成table
applicationMysql.js文件------------
var Sequelize = require('sequelize');
var sequelize = new Sequelize('db', 'root', 'root', {
host: 'localhost',
dialect: 'mysql',
pool: {
max: 5,
min: 0,
idle: 10000
},
Sequelize :Sequelize
});
function ApplicationMysql(){
return sequelize;
}
module.exports = new ApplicationMysql();
user.js文件-----------------
var app = require('../server/applicationMysql.js');
User =