/*
* 业务模块
* */
const path = require('path');
const fs = require('fs');
const db =require('./dbutils.js');
//渲染主页
exports.showIndex = (req,resp)=>{
let sql = 'select * from book';
db.base(sql,null,(result)=>{
resp.render('index.art',{list:result})
});
}
//跳转到添加图书页面
exports.toAddBook = (req,resp)=>{
resp.render('addbook.art',{})
}
exports.addBook = (req,resp)=>{
//获取表单数据
let books = req.body;
let obj = {};
for(let key in books){
obj[key] = books[key];
}
let sql = 'insert into book set ?';
db.base(sql,obj,(result) =>{
if (result.affectedRows == 1){
resp.redirect('/')
}
})
}
//跳转到编辑图书页面
exports.toEditBook = function (req,resp) {
//获取参数
let id = req.query.id;
let sql = 'select * from book where id = ?';
let data = [id];
db.base(sql,data,(result)=>{
resp.render('edbook.art',{result})
})
};
//修改图书
exports.editBook = function (req,resp) {
let book = req.body;
let sql = 'UPDATE `mybook`.`book` SET `name`=?, `author`=?, `category`=?, `description`=? WHERE (`id`=?);';
let data = [book.name,book.author,book.category,book.description,book.id];
db.base(sql,data,(result) =>{
if(result.affectedRows == 1){
resp.redirect('/')
}
})
};
//删除指定图书
exports.deleteBook = function (req,resp) {
let id = req.query.id;
let sql = 'delete from book where id = ?';
let data = [id];
db.base(sql,data,(result) =>{
if(result.affectedRows == 1){
resp.redirect('/')
}
})
}