「MyBatis」图书管理系统 v1.0

2024-09-01 19:52
文章标签 管理系统 图书 mybatis v1.0

本文主要是介绍「MyBatis」图书管理系统 v1.0，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

🎇个人主页：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="login()">登录</button></div></div>
</div>
<script src="js/jquery.min.js"></script>
<script>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 和数据库中的用户密码进行匹配，看是否正确
后端准备个用户信息的类：

@Data
public class UserInfo {private Integer id;private String userName;private String password;private Integer deleteFlag;private Date createTime;private Date updateTime;
}

接下来是验证登录信息，根据 Spring MVC 的框架完成代码：

@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 "";}
}

public class Constants {public static final String USER_SESSION_KEY = "user_session_key";
}

public class UserService {@Autowiredprivate UserInfoMapper userInfoMapper;public UserInfo queryByName(String userName) {return userInfoMapper.queryByName(userName);}
}

@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);}

🍉图书操作

🍌图书类

先准备个图书的类：

@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; //更新时间
}

使用枚举表示图书状态：

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 记录总的信息：页面数、每一页的信息等

@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;}
}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class PageResult<T> {private List<T> records;private Integer count;private PageRequest pageRequest;
}

🍌操作

这个系统我们需要实现这几个功能：添加图书、删除单本图书、批量删除图书、修改图书信息

Controller 类：

@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 类：

@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 接口

@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>

🍉前端页面

🍌展示图书

<!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>

🍌添加图书

<!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>

🍌更新图书

<!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>

这篇关于「MyBatis」图书管理系统 v1.0的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/1127893。

相关文章

Spring Boot项目中结合MyBatis实现MySQL的自动主从切换功能

Spring Boot项目中结合MyBatis实现MySQL的自动主从切换功能

《SpringBoot项目中结合MyBatis实现MySQL的自动主从切换功能》：本文主要介绍SpringBoot项目中结合MyBatis实现MySQL的自动主从切换功能,本文分步骤给大家介绍的... 目录原理解析1. mysql主从复制（Master-Slave Replication）2. 读写分离3.
阅读更多...
Mybatis 传参与排序模糊查询功能实现

Mybatis 传参与排序模糊查询功能实现

《Mybatis传参与排序模糊查询功能实现》：本文主要介绍Mybatis传参与排序模糊查询功能实现,本文通过实例代码给大家介绍的非常详细,感兴趣的朋友跟随小编一起看看吧... 目录一、#{ }和${ }传参的区别二、排序三、like查询四、数据库连接池五、mysql 开发企业规范一、#{ }和${ }传参的
阅读更多...
基于SpringBoot+Mybatis实现Mysql分表

基于SpringBoot+Mybatis实现Mysql分表

《基于SpringBoot+Mybatis实现Mysql分表》这篇文章主要为大家详细介绍了基于SpringBoot+Mybatis实现Mysql分表的相关知识,文中的示例代码讲解详细,感兴趣的小伙伴可... 目录基本思路定义注解创建ThreadLocal创建拦截器业务处理基本思路1.根据创建时间字段按年进
阅读更多...
将Mybatis升级为Mybatis-Plus的详细过程

将Mybatis升级为Mybatis-Plus的详细过程

《将Mybatis升级为Mybatis-Plus的详细过程》本文详细介绍了在若依管理系统（v3.8.8）中将MyBatis升级为MyBatis-Plus的过程,旨在提升开发效率,通过本文,开发者可实现... 目录说明流程增加依赖修改配置文件注释掉MyBATisConfig里面的Bean代码生成使用IDEA生
阅读更多...
Spring Boot + MyBatis Plus 高效开发实战从入门到进阶优化(推荐)

Spring Boot + MyBatis Plus 高效开发实战从入门到进阶优化(推荐)

《SpringBoot+MyBatisPlus高效开发实战从入门到进阶优化(推荐)》本文将详细介绍SpringBoot+MyBatisPlus的完整开发流程,并深入剖析分页查询、批量操作、动... 目录Spring Boot + MyBATis Plus 高效开发实战：从入门到进阶优化1. MyBatis
阅读更多...
MyBatis 动态 SQL 优化之标签的实战与技巧(常见用法)

MyBatis 动态 SQL 优化之标签的实战与技巧(常见用法)

《MyBatis动态SQL优化之标签的实战与技巧(常见用法)》本文通过详细的示例和实际应用场景,介绍了如何有效利用这些标签来优化MyBatis配置,提升开发效率,确保SQL的高效执行和安全性,感... 目录动态SQL详解一、动态SQL的核心概念1.1 什么是动态SQL？1.2 动态SQL的优点1.3 动态S
阅读更多...
Spring Boot结成MyBatis-Plus最全配置指南

Spring Boot结成MyBatis-Plus最全配置指南

《SpringBoot结成MyBatis-Plus最全配置指南》本文主要介绍了SpringBoot结成MyBatis-Plus最全配置指南,包括依赖引入、配置数据源、Mapper扫描、基本CRUD操... 目录前言详细操作一.创建项目并引入相关依赖二.配置数据源信息三.编写相关代码查zsRArly询数据库数
阅读更多...
Spring Boot 整合 MyBatis 连接数据库及常见问题

Spring Boot 整合 MyBatis 连接数据库及常见问题

《SpringBoot整合MyBatis连接数据库及常见问题》MyBatis是一个优秀的持久层框架,支持定制化SQL、存储过程以及高级映射,下面详细介绍如何在SpringBoot项目中整合My... 目录一、基本配置1. 添加依赖2. 配置数据库连接二、项目结构三、核心组件实现（示例）1. 实体类2. Ma
阅读更多...
Mybatis从3.4.0版本到3.5.7版本的迭代方法实现

Mybatis从3.4.0版本到3.5.7版本的迭代方法实现

《Mybatis从3.4.0版本到3.5.7版本的迭代方法实现》本文主要介绍了Mybatis从3.4.0版本到3.5.7版本的迭代方法实现,包括主要的功能增强、不兼容的更改和修复的错误,具有一定的参考... 目录一、3.4.01、主要的功能增强2、selectCursor example3、不兼容的更改二、
阅读更多...
mybatis-plus分页无效问题解决

mybatis-plus分页无效问题解决

《mybatis-plus分页无效问题解决》本文主要介绍了mybatis-plus分页无效问题解决,原因是配置分页插件的版本问题,旧版本和新版本的MyBatis-Plus需要不同的分页配置,感兴趣的可... 昨天在做一www.chinasem.cn个新项目使用myBATis-plus分页一直失败，后来经过多方
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2