【狂神springboot笔记】SpringBoot整合Mybatis
2022/4/19 23:14:05
本文主要是介绍【狂神springboot笔记】SpringBoot整合Mybatis,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
1、添加依赖包和配置数据源
在官网找到对应的依赖
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.2.2</version> </dependency>
数据源不变
application.yml
spring: datasource: username: root password: 12345 url: jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai driver-class-name: com.mysql.cj.jdbc.Driver #这个是指定对应的扫描包和配置文件,相当于不用写mybatis的配置文件了 mybatis: type-aliases-package: com.wcy.pojo mapper-locations: classpath:mybatis/mapper/*.xml
2、创建pojo和mapper
Books类
import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @AllArgsConstructor @NoArgsConstructor public class Books { private int bookID; private String bookName; private int bookCounts; private String detail; }
BookMapper类
import com.wcy.pojo.Books; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; import java.util.List; //这个注解表示这是mybatis的一个mapper类 @Mapper @Repository public interface BookMapper { List<Books> queryAllBooks(); }
BookMapper.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.wcy.mapper.BookMapper"> <select id="queryAllBooks" resultType="Books"> select * from ssmbuild.books </select> </mapper>
3、编写控制器
BookController类
@RestController public class BookController { @Autowired private BookMapper bookMapper; @GetMapping("/queryAllBooks") public List<Books> queryAllBooks() { List<Books> bookList = bookMapper.queryAllBooks(); for (Books book : bookList) { System.out.println(book); } return bookList; } }
测试结果:
这篇关于【狂神springboot笔记】SpringBoot整合Mybatis的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-15鸿蒙生态设备数量超8亿台
- 2024-05-13TiDB + ES:转转业财系统亿级数据存储优化实践
- 2024-05-09“2024鸿蒙零基础快速实战-仿抖音App开发(ArkTS版)”实战课程已上线
- 2024-05-09聊聊如何通过arthas-tunnel-server来远程管理所有需要arthas监控的应用
- 2024-05-09log4j2这么配就对了
- 2024-05-09nginx修改Content-Type
- 2024-05-09Redis多数据源,看这篇就够了
- 2024-05-09Google Chrome驱动程序 124.0.6367.62(正式版本)去哪下载?
- 2024-05-09有没有大佬知道这种数据应该怎么抓取呀?
- 2024-05-09这种运行结果里的10.100000001,怎么能最快改成10.1?