🎇个人主页:Ice_Sugar_7
🎇所属专栏:JavaEE
🎇欢迎点赞收藏加关注哦!
图书管理系统 v1.0
- 🍉登录
- 🍉图书操作
- 🍌图书类
- 🍌页面信息
- 🍌操作
- 🍉前端页面
- 🍌展示图书
- 🍌添加图书
- 🍌更新图书
🍉登录
首先需要准备个登录页面,前端代码如下:
<!DOCTYPE html>
<html lang="en"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>Document</title><link rel="stylesheet" href="css/bootstrap.min.css"><link rel="stylesheet" href="css/login.css"><script type="text/javascript" src="js/jquery.min.js"></script>
</head><body>
<div class="container-login"><div class="container-pic"><img src="pic/computer.png" width="350px"></div><div class="login-dialog"><h3>登陆</h3><div class="row"><span>用户名</span><input type="text" name="userName" id="username" class="form-control"></div><div class="row"><span>密码</span><input type="password" name="password" id="password" class="form-control"></div><div class="row"><button type="button" class="btn btn-info btn-lg" onclick="javascript language-javascript">login()">登录</button></div></div>
</div>
<script src="js/jquery.min.js"></script>
<script>javascript">function login() {$.ajax({url: "/UserController/login",type: "post",data: {username: $("#username").val(),password: $("#password").val()},success: function (result) {if (result == "") {//密码正确location.href = "book_list.html";} else {alert(result);}}});}
</script>
</body></html>
页面如下:
登录的逻辑为:前端输入用户名和密码,传给后端,后端根据用户名,到数据库查找用户信息(是否有这名用户),然后将输入的 password 和数据库中的用户密码进行匹配,看是否正确
后端准备个用户信息的类:
java">@Data
public class UserInfo {private Integer id;private String userName;private String password;private Integer deleteFlag;private Date createTime;private Date updateTime;
}
接下来是验证登录信息,根据 Spring MVC 的框架完成代码:
java">@RestController
@RequestMapping("/UserController")
public class UserController {@Autowiredprivate UserService userService;@RequestMapping("/login")public String login(String username, String password, HttpSession session) {//用户名或密码为空if(!StringUtils.hasLength(username) || !StringUtils.hasLength(password))return "用户名和密码不能为空";//先从数据库中找找有没有这个用户名UserInfo userInfo = userService.queryByName(username);if(userInfo == null) return "用户不存在";if(!userInfo.getPassword().equals(password)) return "密码错误"; //账号和密码不一致session.setAttribute(Constants.USER_SESSION_KEY,userInfo); //成功登录后保存用户信息return "";}
}
java">public class Constants {public static final String USER_SESSION_KEY = "user_session_key";
}
java">public class UserService {@Autowiredprivate UserInfoMapper userInfoMapper;public UserInfo queryByName(String userName) {return userInfoMapper.queryByName(userName);}
}
java">@Mapper
public interface UserInfoMapper {@Select("select id,user_name,password,delete_flag,create_time,update_time" +" from user_info where user_name = #{userName} and delete_flag = 0")public UserInfo queryByName(String userName);}
🍉图书操作
🍌图书类
先准备个图书的类:
java">@Data
public class BookInfo {private Integer id; //图书编号private String bookName; //书名private String author; //作者private Integer count; //数量private BigDecimal price; //定价private String publish; //出版社private Integer status; //状态 1表示可以借阅;2表示不可借阅private String statusCN; //到时页面呈现书的借阅状态要用中文private Date createTime; //创建时间private Date updateTime; //更新时间
}
使用枚举表示图书状态:
java">public enum BookStatus {DELETE(0,"删除"), //采用逻辑删除NORMAL(1,"可借阅"),FORBIDDEN(2,"不可借阅"),;BookStatus(Integer code, String desc) {this.code = code;this.desc = desc;}private Integer code;private String desc;/*** 根据 code 返回描述信息* @return*/public static BookStatus getDescByCode(Integer code) {switch (code) {case 0: return DELETE;case 1: return NORMAL;case 2: return FORBIDDEN;}return FORBIDDEN;}public Integer getCode() {return code;}public void setCode(Integer code) {this.code = code;}public String getDesc() {return desc;}public void setDesc(String desc) {this.desc = desc;}
}
🍌页面信息
需要实现翻页功能,每页展示若干本图书(这里默认每页 10 本书)
用一个 PageRequest 的类表示页面信息:当前页数和当前页第一本书的下标;PageResult 记录总的信息:页面数、每一页的信息等
java">@Data
@NoArgsConstructor
@AllArgsConstructor
public class PageRequest {private Integer offset; //当前页起始位置的元素下标private Integer pageNum = 1; //当前页数 默认在第一页private Integer pageSize = 10; //每页展示的记录数 默认为 10 条public Integer getOffset() {return (pageNum - 1) * pageSize;}
}
java">@Data
@NoArgsConstructor
@AllArgsConstructor
public class PageResult<T> {private List<T> records;private Integer count;private PageRequest pageRequest;
}
🍌操作
这个系统我们需要实现这几个功能:添加图书、删除单本图书、批量删除图书、修改图书信息
Controller 类:
java">@Slf4j
@RestController
@RequestMapping("BookController")
public class BookController {@Autowiredprivate BookService bookService;@RequestMapping("addBook")public String addBook(BookInfo bookInfo) {//打日志log.info("添加图书,bookInfo:{}",bookInfo);//检验参数是否为空if(!StringUtils.hasLength(bookInfo.getBookName())|| !StringUtils.hasLength(bookInfo.getAuthor())|| bookInfo.getCount() == null|| bookInfo.getPrice() == null|| !StringUtils.hasLength(bookInfo.getPublish())|| bookInfo.getStatus() == null) {return "添加的图书信息不能为空";}//添加图书try {Integer res = bookService.insertBook(bookInfo);if(res > 0) return "";} catch (Exception e) {log.error("添加图书异常,e:",e);}return "添加失败";}@RequestMapping("getBookListByPage")public PageResult<BookInfo> getBookListByPage(PageRequest pageRequest, HttpSession httpSession) {//return bookService.queryBookByPage(pageRequest.getPageSize(),pageRequest.getOffset());log.info("查询图书列表,请求参数pageRequest:{}",pageRequest);PageResult<BookInfo> bookList = bookService.queryBookByPage(pageRequest);return bookList;}@RequestMapping("queryBookById")public BookInfo queryBookById(Integer bookId) {if(bookId == null || bookId <= 0) return new BookInfo();BookInfo bookInfo = bookService.queryBookById(bookId);return bookInfo;}@RequestMapping("updateBook")public String updateBook(BookInfo bookInfo) {log.info("修改图书,bookInfo:{}",bookInfo);try {Integer res = bookService.updateBook(bookInfo);if(res > 0) return "";} catch (Exception e) {log.error("修改图书异常,e:",e);}return "修改失败";}@RequestMapping("batchDeleteBookByIds")public boolean batchDeleteBookByIds(@RequestParam List<Integer> ids) {log.info("批量删除图书,books:{}",ids);try{bookService.batchDeleteBookByIds(ids);} catch (Exception e) {log.error("删除异常,e:",e);return false;}return true;}
}
Service 类:
java">@Service
public class BookService {@Autowiredprivate BookInfoMapper bookInfoMapper;public Integer insertBook(BookInfo bookInfo) {return bookInfoMapper.insertBook(bookInfo);}public PageResult<BookInfo> queryBookByPage(PageRequest pageRequest) {//获取总记录数Integer count = bookInfoMapper.count();//获取当前页的记录List<BookInfo> bookInfos = bookInfoMapper.queryBookByPage(pageRequest.getPageSize(),pageRequest.getOffset());//处理状态 将状态码转为状态——可借阅/不可借阅for(BookInfo bookInfo : bookInfos) {bookInfo.setStatusCN(BookStatus.getDescByCode(bookInfo.getStatus()).getDesc());}return new PageResult<>(bookInfos,count,pageRequest);}public BookInfo queryBookById(Integer bookId) {return bookInfoMapper.queryBookById(bookId);}public Integer updateBook(BookInfo bookInfo) {return bookInfoMapper.updateBook(bookInfo);}public void batchDeleteBookByIds(List<Integer> ids) {bookInfoMapper.batchDeleteBookByIds(ids);}}
Mapper 接口
java">@Mapper
public interface BookInfoMapper {@Select("select * from book_info where status != 0 order by id limit #{limit},#{offset}")public List<BookInfo> queryBookByPage(Integer offset,Integer limit); //offset 当前页第一本书的下标 limit 一页最多展示多少本书@Select("select count(1) from book_info where status != 0")public Integer count();@Insert("insert into book_info(book_name,author,count,price,publish,status) values " +"(#{bookName},#{author},#{count},#{price},#{publish},#{status})")public Integer insertBook(BookInfo bookInfo);@Select("select id,book_name,author,count,price,publish,status,create_time,update_time " +"from book_info where id = #{bookId} and status != 0")public BookInfo queryBookById(Integer bookId);public Integer updateBook(BookInfo bookInfo);public void batchDeleteBookByIds(List<Integer> ids);
}
更新图书和批量删除采用 xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yj.librarymanagement.mapper.BookInfoMapper"><update id="updateBook">update book_info<set><if test="bookName != null">book_name = #{bookName},</if><if test="author != null">author = #{author},</if><if test="count != null">count = #{count},</if><if test="price != null">price = #{price},</if><if test="publish != null">publish = #{publish},</if><if test="status != null">status = #{status}</if></set>where id = #{id}</update><update id="batchDeleteBookByIds">update book_info set status = 0where id in<foreach collection="ids" open="(" close=")" item="id" separator=",">#{id}</foreach></update>
</mapper>
🍉前端页面
🍌展示图书
java"><!DOCTYPE html>
<html lang="en"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>图书列表展示</title><link rel="stylesheet" href="css/bootstrap.min.css"><link rel="stylesheet" href="css/list.css"><script type="text/javascript" src="js/jquery.min.js"></script><script type="text/javascript" src="js/bootstrap.min.js"></script><script src="js/jq-paginator.js"></script></head><body>
<div class="bookContainer"><h2>图书列表展示</h2><div class="navbar-justify-between"><div><button class="btn btn-outline-info" type="button" onclick="location.href='book_add.html'">添加图书</button><button class="btn btn-outline-info" type="button" onclick="batchDelete()">批量删除</button></div></div><table><thead><tr><td>选择</td><td class="width100">图书ID</td><td>书名</td><td>作者</td><td>数量</td><td>定价</td><td>出版社</td><td>状态</td><td class="width200">操作</td></tr></thead><tbody></tbody></table><div class="demo"><ul id="pageContainer" class="pagination justify-content-center"></ul></div><script>getBookListByPage();function getBookListByPage() {$.ajax({url:"BookController/getBookListByPage" + location.search,type:"get",success: function (result) {console.log(result.records);if(result.records == null) { //判断相等是== 不是=alert("没有图书");return;}var finnalHtml = "";for (var book of result.records) {finnalHtml += '<tr>';finnalHtml += '<td><input type="checkbox" name="selectBook" value="' + book.id + '" id="selectBook" class="book-select"></td>';finnalHtml += '<td>' + book.id + '</td>';finnalHtml += '<td>' + book.bookName + '</td>';finnalHtml += '<td>' + book.author + '</td>';finnalHtml += '<td>' + book.count + '</td>';finnalHtml += '<td>' + book.price + '</td>';finnalHtml += '<td>' + book.publish + '</td>';finnalHtml += '<td>' + book.statusCN + '</td>';finnalHtml += '<td>';finnalHtml += '<div class="op">';finnalHtml += '<a href="book_update.html?bookId=' + book.id + '">修改</a>';finnalHtml += '<a href="javascript:void(0)" onclick="deleteBook(' + book.id + ')">删除</a>';finnalHtml += '</div></td></tr>';}$("tbody").html(finnalHtml);//翻页信息$("#pageContainer").jqPaginator({totalCounts: result.count, //总记录数pageSize: 10, //每页的个数visiblePages: 5, //可视页数currentPage: result.pageRequest.pageNum, //当前页码first: '<li class="page-item"><a class="page-link">首页</a></li>',prev: '<li class="page-item"><a class="page-link" href="javascript:void(0);">上一页<\/a><\/li>',next: '<li class="page-item"><a class="page-link" href="javascript:void(0);">下一页<\/a><\/li>',last: '<li class="page-item"><a class="page-link" href="javascript:void(0);">最后一页<\/a><\/li>',page: '<li class="page-item"><a class="page-link" href="javascript:void(0);">{{page}}<\/a><\/li>',//页面初始化和页码点击时都会执行onPageChange: function (page, type) {console.log("第"+page+"页, 类型:"+type);if(type == "change") {location.href = "book_list.html?pageNum="+page;}}});}});}function deleteBook(id) {var isDelete = confirm("确认删除?");if (isDelete) {//删除图书(逻辑删除)$.ajax({url: "/BookController/updateBook",type: "post",data: {id: id,status: 0},success: function () {//刷新页面location.href = "book_list.html"}});}}function batchDelete() {var isDelete = confirm("确认批量删除?");if (isDelete) {//获取复选框的idvar ids = [];$("input:checkbox[name='selectBook']:checked").each(function () {ids.push($(this).val());});console.log(ids);//批量删除$.ajax({url: "/BookController/batchDeleteBookByIds?ids=" + ids,type: "post",success: function (result) {if (result) {alert("批量删除成功");location.href = "book_list.html"}}});}}</script>
</div>
</body>
</html>
🍌添加图书
java"><!DOCTYPE html>
<html lang="en"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>图书列表展示</title><link rel="stylesheet" href="css/bootstrap.min.css"><link rel="stylesheet" href="css/list.css"><script type="text/javascript" src="js/jquery.min.js"></script><script type="text/javascript" src="js/bootstrap.min.js"></script><script src="js/jq-paginator.js"></script></head><body>
<div class="bookContainer"><h2>图书列表展示</h2><div class="navbar-justify-between"><div><button class="btn btn-outline-info" type="button" onclick="location.href='book_add.html'">添加图书</button><button class="btn btn-outline-info" type="button" onclick="batchDelete()">批量删除</button></div></div><table><thead><tr><td>选择</td><td class="width100">图书ID</td><td>书名</td><td>作者</td><td>数量</td><td>定价</td><td>出版社</td><td>状态</td><td class="width200">操作</td></tr></thead><tbody></tbody></table><div class="demo"><ul id="pageContainer" class="pagination justify-content-center"></ul></div><script>getBookListByPage();function getBookListByPage() {$.ajax({url:"BookController/getBookListByPage" + location.search,type:"get",success: function (result) {console.log(result.records);if(result.records == null) { //判断相等是== 不是=alert("没有图书");return;}var finnalHtml = "";for (var book of result.records) {finnalHtml += '<tr>';finnalHtml += '<td><input type="checkbox" name="selectBook" value="' + book.id + '" id="selectBook" class="book-select"></td>';finnalHtml += '<td>' + book.id + '</td>';finnalHtml += '<td>' + book.bookName + '</td>';finnalHtml += '<td>' + book.author + '</td>';finnalHtml += '<td>' + book.count + '</td>';finnalHtml += '<td>' + book.price + '</td>';finnalHtml += '<td>' + book.publish + '</td>';finnalHtml += '<td>' + book.statusCN + '</td>';finnalHtml += '<td>';finnalHtml += '<div class="op">';finnalHtml += '<a href="book_update.html?bookId=' + book.id + '">修改</a>';finnalHtml += '<a href="javascript:void(0)" onclick="deleteBook(' + book.id + ')">删除</a>';finnalHtml += '</div></td></tr>';}$("tbody").html(finnalHtml);//翻页信息$("#pageContainer").jqPaginator({totalCounts: result.count, //总记录数pageSize: 10, //每页的个数visiblePages: 5, //可视页数currentPage: result.pageRequest.pageNum, //当前页码first: '<li class="page-item"><a class="page-link">首页</a></li>',prev: '<li class="page-item"><a class="page-link" href="javascript:void(0);">上一页<\/a><\/li>',next: '<li class="page-item"><a class="page-link" href="javascript:void(0);">下一页<\/a><\/li>',last: '<li class="page-item"><a class="page-link" href="javascript:void(0);">最后一页<\/a><\/li>',page: '<li class="page-item"><a class="page-link" href="javascript:void(0);">{{page}}<\/a><\/li>',//页面初始化和页码点击时都会执行onPageChange: function (page, type) {console.log("第"+page+"页, 类型:"+type);if(type == "change") {location.href = "book_list.html?pageNum="+page;}}});}});}function deleteBook(id) {var isDelete = confirm("确认删除?");if (isDelete) {//删除图书(逻辑删除)$.ajax({url: "/BookController/updateBook",type: "post",data: {id: id,status: 0},success: function () {//刷新页面location.href = "book_list.html"}});}}function batchDelete() {var isDelete = confirm("确认批量删除?");if (isDelete) {//获取复选框的idvar ids = [];$("input:checkbox[name='selectBook']:checked").each(function () {ids.push($(this).val());});console.log(ids);//批量删除$.ajax({url: "/BookController/batchDeleteBookByIds?ids=" + ids,type: "post",success: function (result) {if (result) {alert("批量删除成功");location.href = "book_list.html"}}});}}</script>
</div>
</body></html>
🍌更新图书
java"><!DOCTYPE html>
<html lang="en"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>修改图书</title><link rel="stylesheet" href="css/bootstrap.min.css"><link rel="stylesheet" href="css/add.css">
</head><body><div class="container"><div class="form-inline"><h2 style="text-align: left; margin-left: 10px;"><svg xmlns="http://www.w3.org/2000/svg" width="40"fill="#17a2b8" class="bi bi-book-half" viewBox="0 0 16 16"><pathd="M8.5 2.687c.654-.689 1.782-.886 3.112-.752 1.234.124 2.503.523 3.388.893v9.923c-.918-.35-2.107-.692-3.287-.81-1.094-.111-2.278-.039-3.213.492V2.687zM8 1.783C7.015.936 5.587.81 4.287.94c-1.514.153-3.042.672-3.994 1.105A.5.5 0 0 0 0 2.5v11a.5.5 0 0 0 .707.455c.882-.4 2.303-.881 3.68-1.02 1.409-.142 2.59.087 3.223.877a.5.5 0 0 0 .78 0c.633-.79 1.814-1.019 3.222-.877 1.378.139 2.8.62 3.681 1.02A.5.5 0 0 0 16 13.5v-11a.5.5 0 0 0-.293-.455c-.952-.433-2.48-.952-3.994-1.105C10.413.809 8.985.936 8 1.783z" /></svg><span>修改图书</span></h2></div><form id="updateBook"><input type="hidden" class="form-control" id="bookId" name="id"><div class="form-group"><label for="bookName">图书名称:</label><input type="text" class="form-control" id="bookName" name="bookName"/></div><div class="form-group"><label for="bookAuthor">图书作者</label><input type="text" class="form-control" id="bookAuthor" name="author"/></div><div class="form-group"><label for="bookStock">图书库存</label><input type="text" class="form-control" id="bookStock" name="count"/></div><div class="form-group"><label for="bookPrice">图书定价:</label><input type="number" class="form-control" id="bookPrice" name="price"></div><div class="form-group"><label for="bookPublisher">出版社</label><input type="text" id="bookPublisher" class="form-control" name="publish"/></div><div class="form-group"><label for="bookStatus">图书状态</label><select class="custom-select" id="bookStatus" name="status"><option value="1" selected>可借阅</option><option value="2">不可借阅</option></select></div><div class="form-group" style="text-align: right"><button type="button" class="btn btn-info btn-lg" onclick="update()">确定</button><button type="button" class="btn btn-secondary btn-lg" onclick="javascript:history.back()">返回</button></div></form></div><script type="text/javascript" src="js/jquery.min.js"></script><script>$.ajax({url: "/BookController/queryBookById" + location.search,type: "get",success: function (book) {if(book != null) {$("#bookId").val(book.id);$("#bookName").val(book.bookName);$("#bookAuthor").val(book.author);$("#bookStock").val(book.count);$("#bookPrice").val(book.price);$("#bookPublisher").val(book.publish);$("#bookStatus").val(book.status);}}})function update() {$.ajax({url:"/BookController/updateBook",type:"post",data:$("#updateBook").serialize(),success: function (result) {if(result == "") {//更新成功,跳转到展示页面location.href = "book_list.html";} else {alert("修改失败:"+result);}},error: function (error) {console.log(error);}});}</script>
</body>
</html>