<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                [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('/'); } }); }; ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看