curd操作-編輯文章 · node.js開發web應用

# 在/application/controllers/article.js中新增代碼塊 ``` async mod(req, res) { if (req.isPost) { //提交后 var post = req.body; var itemid = parseInt(req.query.itemid); if (!itemid) { res.render('msg', { code: 0, msg: '數據不存在', url: '' }); return; } //標題判斷 var title = post.title.trim(); if (!title) { res.render('msg', { code: 0, msg: '標題不能為空', url: '' }); return; } //內容判斷 var content = post.content.trim(); if (!content) { res.render('msg', { code: 0, msg: '內容不能為空', url: '' }); return; } //執行更新操作 let r = await model.u("update article SET ? where itemid=?", post, [itemid]); if (r) { res.render('msg', { code: 1, msg: '操作成功', url: '/article/index' }); } else { res.render('msg', { code: 0, msg: '操作失敗', url: '' }); } return; } var itemid = parseInt(req.query.itemid); if (!itemid) { res.render('msg', { code: 0, msg: '數據不存在', url: '' }); return; } //從數據庫中讀取文章 let data = await model.find("SELECT * from article where itemid=?", [itemid]); //加載模板文件 res.render(req.TPL, { data: data }); } ``` # 新建對應模板文件/application/views/article/mod.html ``` <!doctype html> <html> <head> <meta charset="utf-8"> <title>編輯文章</title> </head> <body> <div style="text-align:center"> <h2>編輯文章 <span><a href="/article/index">返回</a></span></h2> <form action="/article/mod?itemid=<%=data.itemid%>" method="post"> <table width="100%" border="1"> <tbody> <tr> <td align="right">標題</td> <td align="left"><input type="text" name="title" id="" value="<%=data.title%>"></td> </tr> <tr> <td align="right">內容</td> <td align="left"><textarea name="content" id="" cols="30" rows="10"><%=data.content%></textarea> </td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="submit" value="提交"></td> </tr> </tbody> </table> </form> </div> </body> </html> ``` # 顯示結果 ![](https://img.kancloud.cn/bc/97/bc97b4e61daa774e30c5c0911c937408_897x350.png)