安装sequelize
npm install sequelize
//引入框架
var Sequelize = require('sequelize');
//初始化链接(支持连接池)
var sequelize = new Sequelize('test', 'root', '***', {
host: '127.0.0.1',
dialect: 'mysql',
pool: {
max: 5,
min: 0,
idle: 10000
},
// SQLite only
storage: 'path/to/database.sqlite'
});
//定义数据模型
const User = sequelize.define('my_users', {
userId: {
field: 'userId',
type: Sequelize.INTEGER,
allowNull: true,
primaryKey: true
},
userName: {
field: 'userName',
type: Sequelize.STRING,
allowNull: false,
},
}, {
tableName: 'my_users',
timestamps: false,
freezeTableName: true
});
// 查询数据
User.findAll({
attributes: ['userId', 'userName'],
where:{'userId':10001}
}).then(function(user){
if (user.length > 0) {
console.log(user[0].userId);
console.log(user[0].userName);
}
});
User.create({
userId: 10008,
userName: '小明'
}).then(function (created){
// 创建结果
//console.log(created);
}).catch(function(err){
// 出错了
//console.log(err);
});
User.update({userName:'liu'}, {where:{userId:10007}}).then(function (result){
// 修改结果
console.log(result);
}).catch(function(err){
// 出错了
console.log(err);
});
User.destroy({where:{userId:10006}}).then(function (result){
// 操作结果
console.log(result);
}).catch(function(err){
// 出错了
console.log(err);
});