SpringBoot + Mybatis
前提:
- 搭建SpringBoot框架项目
如果没有搭建,可查看以下链接【 IDEA SpringBoot 从零搭建(有网络情况下)】
https://blog.csdn.net/weixin_42862834/article/details/105651992
1、pom文件引入相关依赖
可以直接去Maven Repository 查找需要的依赖包
官网地址: https://mvnrepository.com/
<!--mybatis - springboot 启动依赖-->
<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<!--mysql 驱动-->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.19</version>
</dependency>
<!--Spring Boot web 核心依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
2、项目包结构
创建包结构如下
3、设置配置文件
SpringBoot配置文件: application.properties
具体代码如下:
server.port=8989
server.servlet.context-path=/demo
# mysql 数据源配置
spring.datasource.url=jdbc:mysql://localhost:3306/demo_mysql?serverTimezone=Asia/Shanghai&useSSL=false&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# mybatis 配置
mybatis.mapper-locations=classpath*:/mapper/**.xml
mybatis.type-aliases-package=com.example.demo.model
4、 CRUD实现(附:部分参数含义及代码)
-
实体类(省略get/set 、有参无参构造… )
如果使用的是IDEA, 可以使用快捷键创建get/set 等(Alt + Insert)
-
dao层
-
mapper.xml文件
字段详解如下:
具体代码:<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.demo.dao.UserDao"> <!--User查询映射结果--> <resultMap id="UserResultMap" type="com.example.demo.model.User"> <result column="id" property="id" /> <result column="name" property="userName"/> <result column="password" property="password"/> <result column="age" property="age"/> </resultMap> <select id="selectAll" resultMap="UserResultMap"> SELECT * FROM tbl_user </select> <select id="selectByName" resultMap="UserResultMap"> SELECT * FROM tbl_user WHERE `name`= #{userName} </select> <insert id="insertUser" > INSERT INTO tbl_user VALUES(#{id}, #{userName}, #{password}, #{age}) </insert> <delete id="deleteUserById"> DELETE FROM tbl_user WHERE `id`= #{id} </delete> </mapper>
-
service层 (接口及实现类:)
-
controller层
5、启动类设置
- 如下:
6、运行测试
-
运行
DemoApplication.java
的 main 函数
如图,SpringBoot启动成功:
(SpringBoot修改启动logo方法:https://blog.csdn.net/weixin_42862834/article/details/105657927) -
简单的postman 测试
1、insertUser
2、seleteAllUser
3、deleteById
4、seleteAllUser
测试OK ~ ~ SpringBoot 整合 Mybatis 成功 ~ ~