# 連接mysql數據庫 基礎包 > mysql2 > sequelize > 關于sequelize的庫的介紹可以看看這篇博客 > https://itbilu.com/nodejs/npm/VkYIaRPz-.html > 需要注意的是 博客里的初始化例子里的數據庫驅動要用mysql2而不是mysql > 我這里一開始是用mysql報錯了，后來根據提示使用了mysql2就沒有報錯了 目錄結構 ~~~ orm | |---data // 數據庫的實際操作 | |---index.js | |---db // 初始化數據庫連接 | |---index.js ~~~ db里的index代碼如下 ~~~ let Sequelize = require('sequelize'); let client = new Sequelize('headcms', 'root', 'king123', { host: 'localhost', dialect: 'mysql', pool: { max: 5, min: 0, idle: 1000 } }); module.exports.client = client ~~~ data里的index代碼如下 ~~~ const Sequelize = require('sequelize'); const db = require('./../db/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 }) } ~~~ 調用代碼： ~~~ const db = require('./../orm/data'); let findAll = exports.findAll = function *() { let query = { id: 1 } let data = yield db.findAll(query); this.body = data } exports.register = function (router) { router.get('/api/findAll', findAll) }; ~~~ 說明： > @query 應該是從前端讀取的對象。一般都是狀態管理vuex的載荷