# 初步搭建數據庫的模型 基礎包 > mysql2 > sequelize 前言： 在連接數據庫的時候發現sequelize可以搭建數據庫的model。特別寫下一遍記錄文，不過也踩了不少的坑 目錄結構： ~~~ app | |---orm | | | |---data //數據庫操作邏輯 | | |---index.js | |---db //數據庫連接初始化 | | |---index.js | |---model //表的模型 | | |---users // users表 | | | |---index.js | ~~~ model下的user代碼： ~~~ let client = require('./../../db/index'); let Sequelize = require('sequelize') let sequelize = client.client let userModel = sequelize.define('users',{ 'USER_ID': { type: Sequelize.INTEGER, allowNull: false, primaryKey: true }, 'USER_NAME': { type: Sequelize.STRING }, 'USER_IPHONE': { type: Sequelize.STRING }, 'USER_MONEY': { type: Sequelize.INTEGER }, 'USER_PASSWORD': { type: Sequelize.STRING } },{ createdAt: false, updatedAt: false }); module.exports.userModel = userModel ~~~ data下面的index代碼： ~~~ const Sequelize = require('sequelize'); const db = require('./../db/index'); const userModel = require('./../model/user/index'); exports.findAll = function *(query) { let sql = 'select * from users where user_id = :id'; return yield db.client.query(sql, { replacements: { id: query.id }, type: Sequelize.QueryTypes.SELECT }) } exports.findOne = function *(query) { let data = yield userModel.userModel.findById(query.id); console.log(data.dataValues); return data.dataValues // console.log(query) } ~~~ router里調用業務層邏輯代碼： ~~~ /** * Created by Administrator on 2017/8/5. */ const db = require('./../orm/data'); let getArticle = exports.getArticle = function *() { this.body = 'hell word getarticle' } let findAll = exports.findAll = function *() { let query = { id: 1 } let data = yield db.findAll(query); this.body = data } let findOne = exports.findOne = function *() { let query = { id: 1 } let data = yield db.findOne(query); this.body = data } exports.register = function (router) { router.get('/api/getArticle', getArticle) router.get('/api/findAll', findAll) router.get('/api/findOne', findOne) }; ~~~ 坑點： * 可能是自己部不怎么熟悉export的語法問題，export導出后是個對象所以要點client，才能拿到數據庫的實例 * 表名會默認添加s，所以填寫表名和，新建表的時候需要注意。當然也可以自己編寫configuration來指定表名tableName，具體可以參考下面這條連接。[表名修改](https://itbilu.com/nodejs/npm/V1PExztfb.html#definition-configuration) * 還是需要自己引入sequelize來確認類型。目前我也不知道是為啥。