[TOC] >[success] # 使用數據庫的service.js 編寫 ~~~ 1.先看 下面的express -- 配合數據庫章節在看這個案例 2.整個案例的db.js 使用的是下面章節分裝的數據庫api ~~~ >[danger] ##### 數據庫service.js ~~~ const path = require('path'); const fs = require('fs'); const db = require('./db.js'); // 渲染主頁面 exports.showIndex = (req,res) =>{ let sql = 'select * from book'; db.base(sql,null,(data)=>{ res.render('index',{list:data}) }); }; // 跳轉添加圖書頁面 exports.toaddBook = (req,res) =>{ res.render('addBook'); }; // 處理添加的post exports.addBook = (req,res) =>{ let info = req.body; let book = {}; for(let i in info){ book[i] = info[i]; } let sql = "insert into book set ?"; db.base(sql,book,(result)=>{ if(result.affectedRows == 1){ res.redirect('/'); } }) }; // 跳轉編輯圖書頁面 exports.toEditBook = (req,res) => { let id = req.query.id; let sql = 'select * from book where id=?'; let data = [id]; db.base(sql,data,(result)=>{ console.log(result,result[0]) res.render('editBook',result[0]); }); }; // 編輯圖書更新數據 exports.editBook = (req,res) => { let info = req.body; let sql = 'update book set name=?,author=?,category=?,description=? where id=?'; let data = [info.name,info.author,info.category,info.description,info.id]; db.base(sql,data,(result)=>{ if(result.affectedRows == 1){ res.redirect('/'); } }); }; // 刪除圖書信息 exports.deleteBook = (req,res) => { let id = req.query.id; let sql = 'delete from book where id=?'; let data = [id]; db.base(sql,data,(result)=>{ if(result.affectedRows == 1){ res.redirect('/'); } }); }; ~~~