失眠网 > 图书管理系统——图书的查询功能/图书的添加功能

图书管理系统——图书的查询功能/图书的添加功能

时间：2024-03-30 10:38:10

1图书的查询功能

1.1点击图书馆里进行页面的跳转

Controller.java

/**图书首页*/@GetMapping("/bookIndex")public String bookIndex(){return "book/bookIndex";}

1.2设置静态页面

bookIndex.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ taglib prefix="form" uri="/tags/form" %><%@ taglib prefix="c" uri="/jstl/core" %><%String path=request.getContextPath();String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE html><html><head><meta charset="utf-8"><title>图书管理</title><meta name="renderer" content="webkit"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"><link rel="stylesheet" href="<%=basePath%>lib/layui-v2.5.5/css/layui.css" media="all"><link rel="stylesheet" href="<%=basePath%>css/public.css" media="all"></head><body><div class="layuimini-container"><div class="layuimini-main"><div class="layuimini-main"><div class="demoTable"><div class="layui-form-item layui-form ">书名<div class="layui-inline"><input class="layui-input" name="name" id="name" autocomplete="off"></div>图书编号<div class="layui-inline"><input class="layui-input" name="isbn" id="isbn" autocomplete="off"></div>图书分类<div class="layui-inline"><select name="typeId" id="typeId" lay-verify="required"><option value="">请选择</option></select></div><button class="layui-btn" data-type="reload">高级查询</button><%--<button class="layui-btn" lay-submit data-type="reload" lay-filter="queryBook">高级查询</button>--%></div></div></div><script type="text/html" id="toolbarDemo"><div class="layui-btn-container"><button class="layui-btn layui-btn-normal layui-btn-sm data-add-btn" lay-event="add"> 添加 </button><button class="layui-btn layui-btn-sm layui-btn-danger data-delete-btn" lay-event="delete"> 删除 </button></div></script><table class="layui-hide" id="currentTableId" lay-filter="currentTableFilter"></table><script type="text/html" id="currentTableBar"><a class="layui-btn layui-btn-normal layui-btn-xs data-count-edit" lay-event="edit">编辑</a><a class="layui-btn layui-btn-xs layui-btn-danger data-count-delete" lay-event="delete">删除</a></script></div></div><script src="<%=basePath%>lib/layui-v2.5.5/layui.js" charset="utf-8"></script><script>layui.use(['form', 'table'], function () {var $ = layui.jquery,form = layui.form,table = layui.table;table.render({elem: '#currentTableId',url: '<%=basePath%>bookAll',//查询图书数据toolbar: '#toolbarDemo',defaultToolbar: ['filter', 'exports', 'print', {title: '提示',layEvent: 'LAYTABLE_TIPS',icon: 'layui-icon-tips'}],cols: [[{type: "checkbox", width: 50},{field: 'id', width: 110, title: 'ID', sort: true},{field: 'isbn', width: 100, title: '图书编号'},//获取对象中的属性对象{templet:'<div>{{d.classInfo.name}}</div>', width: 110, title: '图书类型'},{field: 'name', width: 150, title: '图书名称'},{field: 'author', width: 110, title: '作者'},{field: 'price', width: 110, title: '价格'},{field: 'language', width: 110, title: '语言'},{title: '操作', minWidth: 150, toolbar: '#currentTableBar', align: "center"}]],limits: [10, 15, 20, 25, 50, 100],limit: 15,page: true,skin: 'line',id:'testReload'});//动态获取图书类型的数据$.get("findAllList",{},function (data) {var list=data;var select=document.getElementById("typeId");if(list!=null|| list.size()>0){for(var c in list){var option=document.createElement("option");option.setAttribute("value",list[c].id);option.innerText=list[c].name;select.appendChild(option);}}form.render('select');},"json")var $ = layui.$, active = {reload: function(){var name = $('#name').val();var isbn= $('#isbn').val();var typeId= $('#typeId').val();//执行重载table.reload('testReload', {page: {curr: 1 //重新从第 1 页开始},where: {name:name,isbn:isbn,typeId:typeId}}, 'data');}};$('.demoTable .layui-btn').on('click', function(){var type = $(this).data('type');active[type] ? active[type].call(this) : '';});/*** tool操作栏监听事件*/table.on('tool(currentTableFilter)', function (obj) {var data=obj.data;if (obj.event === 'edit') {// 监听添加操作var index = layer.open({title: '修改图书类型',type: 2,shade: 0.2,maxmin:true,shadeClose: true,area: ['100%', '100%'],content: '<%=basePath%>queryBookInfoById?id='+data.id,});$(window).on("resize", function () {layer.full(index);});} else if (obj.event === 'delete') {// 监听删除操作layer.confirm('真的删除行么', function (index) {//调用删除功能deleteInfoByIds(data.id,index);layer.close(index);});}});//监听表格复选框选择table.on('checkbox(currentTableFilter)', function (obj) {console.log(obj)});/*** 获取选中记录的id信息*/function getCheackId(data){var arr=new Array();for(var i=0;i<data.length;i++){arr.push(data[i].id);}//拼接idreturn arr.join(",");};/*** 提交删除功能*/function deleteInfoByIds(ids ,index){//向后台发送请求$.ajax({url: "deleteBookByIds",type: "POST",data: {ids: ids},success: function (result) {if (result.code == 0) {//如果成功layer.msg('删除成功', {icon: 6,time: 500}, function () {parent.window.location.reload();var iframeIndex = parent.layer.getFrameIndex(window.name);parent.layer.close(iframeIndex);});} else {layer.msg("删除失败");}}})};/*** toolbar监听事件*/table.on('toolbar(currentTableFilter)', function (obj) {if (obj.event === 'add') {// 监听添加操作var index = layer.open({title: '添加图书',type: 2,shade: 0.2,maxmin:true,shadeClose: true,area: ['100%', '100%'],content: '<%=basePath%>addBook',});$(window).on("resize", function () {layer.full(index);});} else if (obj.event === 'delete') {/*1、提示内容，必须删除大于0条2、获取要删除记录的id信息3、提交删除功能 ajax*///获取选中的记录信息var checkStatus=table.checkStatus(obj.config.id);var data=checkStatus.data;if(data.length==0){//如果没有选中信息layer.msg("请选择要删除的记录信息");}else{//获取记录信息的id集合var ids=getCheackId(data);layer.confirm('真的删除行么', function (index) {//调用删除功能deleteInfoByIds(ids,index);layer.close(index);});}}});});</script></body></html>

1.3Controller层实现分页查询

Controller.java

/*** 获取图书信息*/@ResponseBody@RequestMapping("/bookAll")public R bookAll(BookInfo info, @RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "15") Integer limit){PageInfo<BookInfo> pageInfo=bookInfoService.queryBookInfoAll(info,page,limit);return R.ok("成功",pageInfo.getTotal(),pageInfo.getList());}

2图书高级查询

2.1

bookIndex.jsp

2.2 获取图书的分类

bookIndex.jsp

//动态获取图书类型的数据$.get("findAllList",{},function (data) {var list=data;var select=document.getElementById("typeId");if(list!=null|| list.size()>0){for(var c in list){var option=document.createElement("option");option.setAttribute("value",list[c].id);option.innerText=list[c].name;select.appendChild(option);}}form.render('select');},"json")

2.3在Controller中编写findAllList

TypeController.java

/***获取图书类型列表*/@ResponseBody@RequestMapping("/findAllList")public List<ClassInfo> findAll(){PageInfo<ClassInfo> pageInfo= classService.queryClassInfoAll(null,1,100);List<ClassInfo> lists=pageInfo.getList();return lists;}

2.4获取输入值渲染table

bookIndex.jsp

var $ = layui.$, active = {reload: function(){var name = $('#name').val();var isbn= $('#isbn').val();var typeId= $('#typeId').val();//执行重载table.reload('testReload', {page: {curr: 1 //重新从第 1 页开始},where: {name:name,isbn:isbn,typeId:typeId}}, 'data');}};$('.demoTable .layui-btn').on('click', function(){var type = $(this).data('type');active[type] ? active[type].call(this) : '';});

3图书的添加功能

3.1监听事件

bookIndex.jsp

/*** toolbar监听事件*/table.on('toolbar(currentTableFilter)', function (obj) {if (obj.event === 'add') {// 监听添加操作var index = layer.open({title: '添加图书',type: 2,shade: 0.2,maxmin:true,shadeClose: true,area: ['100%', '100%'],content: '<%=basePath%>addBook',});$(window).on("resize", function () {layer.full(index);});}

3.2在Contrller编写addBook

BookController.java

/*** 添加页面*/@GetMapping("/addBook")public String addBook(){return "book/addBook";}

3.3创建添加图书的静态界面

bookIndex.jsp界面所有

3.4页面添加工作的实现

/*** 实现添加功能*/@ResponseBody@RequestMapping("/addBookSubmit")public R addBookSubmit(@RequestBody BookInfo bookInfo ){bookInfoService.addBookSubmit(bookInfo);return R.ok();}

如果觉得《图书管理系统——图书的查询功能/图书的添加功能》对你有帮助，请点赞、收藏，并留下你的观点哦！

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。