查询部分代码
@RequestMapping("/select.do") public String selectBook(@RequestParam(value = "bookTypeid",required = false,defaultValue = "0")Integer id, @RequestParam(value = "bookName",required = false) String bookName, @RequestParam(value = "borrow",required = false ,defaultValue = "-1")Integer borrow, @RequestParam(value = "now",required = false,defaultValue = "1") Integer now, ModelMap map){ PageHelper.startPage(now,3); List<BookInfo> bookInfos= bookInfoService.selectAll(id,bookName,borrow); PageInfo<BookInfo> pageInfo=new PageInfo<BookInfo>(bookInfos); map.put("pageInfo",pageInfo); List<BookType> bookTypes = bookTypeService.selectAllBookType(); map.put("bookTypes",bookTypes); map.put("id",id); System.out.println(id); map.put("bookName",bookName); map.put("borrow",borrow); return "index"; } |
添加部分代码
@RequestMapping("/add.do") public void addBook(BookInfo bookInfo, HttpServletResponse response) throws IOException { System.out.println(bookInfo); int num= bookInfoService.insertSelective(bookInfo); response.setContentType("text/html; charset=UTF-8"); PrintWriter printWriter=response.getWriter(); if (num>0){ printWriter.write("<script>alert('新增成功');location.href='index.do'</script>"); }else { printWriter.write("<script>alert('新增失败');location.href='toadd.do'</script>"); } } |
删除部分代码
@RequestMapping("/delete") public String delete(@RequestParam(value = "id",required = false)Integer id){ int i = bookInfoService.deleteByPrimaryKey(id); return "forward:select.do"; } |
页面
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <html> <head> <title>图书管理</title> </head> <body> <div id="div" style="width: 800px;height: 600px;margin: 0px auto;border: 1px solid black"> <h1 style="text-align: center;">图书管理系统</h1> <div style="text-align: center;" > <form action="/select.do" method="post" id="query"> 图书分类<select name="bookTypeid"> <option value="0">全部</option> <c:forEach items="${bookTypes}" var="bookTypes"> <option value="${bookTypes.id}" <c:if test="${bookTypes.id==id}">selected="selected"</c:if>>${bookTypes.typeName}</option> </c:forEach> </select> 图书名称<input name="bookName" value="${bookName}"> 是否借阅 <select name="borrow"> <option value="-1">请选择</option> <option value="0" <c:if test="${borrow==0 }">selected="selected" </c:if>>未借阅</option> <option value="1" <c:if test="${borrow==1 }">selected="selected" </c:if>>已借阅</option> </select> <input type="hidden" name="now" id="pageno"> <input type="submit" value="查询"> </form> </div> <input type="button" value="批量删除" οnclick="deleteids();"> <a href="/toadd.do">添加书籍</a> <div style="margin: 0px auto; width: 630px;"> <form id="delete" action="/select.do" method="post"> <table border="1"> <tr> <td><input type="hidden" name="choose" value="7"> <input type="checkbox" name="ids" οnclick="showCheck(this.checked);"> </td> <td>图书编号</td> <td>图书分类</td> <td>图书名称</td> <td>作者</td> <td>出版社</td> <td>操作</td> <td>详情</td> <td>删除</td> <td>修改</td> </tr> <c:forEach items="${pageInfo.list}" var="book"> <tr> <td> <input type="checkbox" name="bookid" value="${book.bookId }"> </td> <td>${book.bookCode }</td> <td>${book.bookTypes.typeName}</td> <td>${book.bookName }</td> <td>${book.bookAuthor }</td> <td>${book.publishPress }</td> <td> <c:if test="${book.isBorrow ==0 }">未借阅</c:if> <c:if test="${book.isBorrow ==1 }">已借阅</c:if> </td> <td><a href="/delete?id=${book.bookId }">详情</a></td> <td><a href="delete?id=${book.bookId }">删除</a></td> <td><a href="bookservlet.do?id=${book.bookId }">修改</a></td> </tr> </c:forEach> <tr> <td colspan="9"> <a href="javascript:doPage(1);">首页</a> <a href="javascript:doPage(${pageInfo.pageNum-1});">上一页</a> <a href="javascript:doPage(${pageInfo.pageNum+1});">下一页</a> <a href="javascript:doPage(${pageInfo.pages});">末页</a> ${pageInfo.pageNum}/${pageInfo.pages}页</td> </tr> </table> </form> </div> </div> </body> <script type="text/javascript" src="resource/js/jquery_2.1.4_baidu_min.js"></script> <script type="text/javascript"> function doPage(pageno) { //.给表单的当前也那么赋值 $("#pageno").val(pageno); //提交查询的表单 $("#query").submit(); } function changecheckBox(check) { $("input[name='bookid']").attr("checked", check); } function deleteAll() { $("#delete").submit(); } </script> </html> |