1.在项目中输入 npm install mysql --save && npm inatall sequlize --save
2.新建db.js
var Sequelize = require('sequelize') const sequelize = new Sequelize('hhdj', 'root', 'root', { host: 'localhost', dialect: 'mysql', pool: { max: 5, min: 0, idle: 10000 }, }); module.exports = sequelize
3. 新建user.js
var Sequelize = require('sequelize') var db = require('./db.js') var User = db.define('tb_user', { id:{ type: Sequelize.INTEGER(11), allowNull: false, primaryKey: true, autoIncrement: true }, username: { type: Sequelize.STRING(50), allowNUll: false }, password: { type: Sequelize.STRING(50), allowNull: false }, id_card: { type: Sequelize.STRING(50), allowNull: false }, disabled: { type: Sequelize.INTEGER(11), allowNull: false } }, { freezeTableName: true, timestamps: false }) module.exports = User
4.新建demo.js
var user = require('./user.js') // 查询 user.findOne({ where:{id: 1} }).then(function (res) { console.log(JSON.stringify(res)) }) .catch(function (ex) { console.log(ex) }) // 添加 user.create({ username: '杜强', password: '123456', id_card: '54dsf54sdf4', disabled: '111111' }) // 更改 var param = {'password': 'wuXiaoYa'} user.update(param,{ where: {id: 100} }) // 删除 user.destroy({where: {id: '34'}})