小型网上书城完整版毕设源码+sql文件

package org.hyz.bookstore.controller; import java.io.File; import java.io.IOException; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.hyz.bookstore.entity.Book; import org.hyz.bookstore.entity.BookQueryCondition; import org.hyz.bookstore.entity.PageQueryBean; import org.hyz.bookstore.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.servlet.ModelAndView; import com.alibaba.fastjson.JSON; /** * 图书Controller * @author hyz * */ @Controller public class BookController { @Autowired private BookService bookService; /** * 显示添加图书页面 * @return */ @RequestMapping("/addbook") public ModelAndView showAddBook(){ ModelAndView mv = new ModelAndView("addbook"); return mv; } /** * 添加图书 * @return */ @RequestMapping("/add") public String addBook(Book book){ bookService.createBook(book); return "redirect:booklist"; } /** * 修改图书信息 * @param book * @return */ @RequestMapping("/modify") public String modifyBook(Book book){ bookService.modifyBook(book); return "redirect:booklist"; } /** * 根据id删除图书 * @param id * @return */ @RequestMapping("/delete/{id}") public String deleteBook(@PathVariable("id") Integer id){ bookService.deleteBookById(id); return "redirect:/booklist"; } /** * 根据id查找图书(显示修改图书页面) * @param id * @param model * @return */ @RequestMapping("/findbook/{id}") public String findBook(@PathVariable("id") Integer id,Model model){ Book book = bookService.findBookById(id); model.addAttribute("book",book); return "modifybook"; } /** * 分页按条件查询图书信息 * @return */ @RequestMapping("/listbook") @ResponseBody public PageQueryBean listBook(BookQueryCondition condition,Model model){ PageQueryBean bookList = bookService.listBook(condition); return bookList; } /** * 显示图书列表页面 * @return */ @RequestMapping("/booklist") public ModelAndView showBookList(){ ModelAndView mv = new ModelAndView("booklist"); return mv; } /** * 上传封面 * @param file * @param request * @return */ @RequestMapping(value = "/upload",produces = "text/json;charset=UTF-8") @ResponseBody public String uploadHead(@RequestParam("pictureImage") MultipartFile file,HttpServletRequest request){ String path = request.getSession().getServletContext().getRealPath("/static/image"); String filename = file.getOriginalFilename(); File dir = new File(path,filename); if(!dir.exists()){ dir.mkdirs(); } try { file.transferTo(dir); } catch (IOException e) { e.printStackTrace(); return "upload_fail"; } return JSON.toJSONString("/static/image/"+filename); } /** * 显示首页 * @param condition * @param model * @return */ @RequestMapping("/index") public String showIndex(){ return "index"; } }