文章目录
-
- 1.整合MyBatis
-
-
- 1.需求分析
- 2.数据库表设计
- 3.数据库环境配置
-
- 1.新建maven项目
- 2.pom.xml 引入依赖
- 3.application.yml 配置数据源
- 4.Application.java 编写启动类
- 5.测试
- 6.配置类切换druid数据源
- 7.测试数据源是否成功切换
- 4.Mybatis基础配置
-
- 1.编写映射表的bean
- 2.MonsterMapper.java 编写mapper接口
- 3.MonsterMapper.xml 编写mapper.xml实现mapper接口
- 4.application.yml 扫描mapper.xml配置文件的位置
- 5.测试
- 5.MyBatis高级配置
-
- 1.方式一:在application.yml中配置mybatis.config-location指定mybatis-config.xml配置文件的位置
- 2.方式二:直接在application.yml中配置
- 6.继续编写Service层和Controller层
-
- 1.MonsterService.java
- 2.MonsterServiceImpl.java
- 3.测试
- 4.MonsterController.java
- 5.测试
- 6.解决时间问题
- 7.完整文件目录
- 2.整合MyBatis-Plus
-
-
- 1.MyBatis-Plus基本介绍
- 2.数据库表设计
- 3.数据库环境配置
-
- 1.创建maven项目
- 2.pom.xml 导入依赖
- 3.application.yml 配置数据源
- 4.DruidDataSourceConfig.java 配置类切换druid数据源
- 5.编写启动类Application.java,测试运行
- 4.MyBatis-Plus基础配置
-
- 1.编写映射表的bean
- 2.MonsterMapper.java 编写Mapper接口
- 3.测试接口方法使用
- 5.MyBatis-Plus高级配置
-
- 6.继续编写Service层和Controller层
-
- 1.MonsterService.java
- 2.MonsterServiceImpl.java
- 3.测试
- 4.细节说明
- 5.MonsterController.java
- 7.细节说明
-
- 1.@MapperScan 扫描包下的所有Mapper
-
- 2.@TableName bean的类名与表名不一致时使用
- image-20240317200951971
- 3.MyBatis引入了哪些依赖
- 8.MyBatisX快速开发
-
- 1.安装插件
- 2.使用方式
-
- 1.挑一个带小鸟的方法
- 2.直接alt + Enter
- 3.生成sql语句
- 4.查看生成的方法
- 5.点击左边的小鸟就可以直接跳转到指定方法或者xml
- 9.完整文件目录
- 10.MyBatis-Plus小结
1.整合MyBatis
1.需求分析
2.数据库表设计
CREATE DATABASE `springboot_mybatis`;
use `springboot_mybatis`;
CREATE TABLE `monster` (
`id` INT NOT NULL AUTO_INCREMENT,
`age` INT NOT NULL,
`birthday` DATE DEFAULT NULL,
`email` VARCHAR(255) DEFAULT NULL,
`gender` char(1) DEFAULT NULL,
`name` VARCHAR(255) DEFAULT NULL,
`salary` DOUBLE NOT NULL,
PRIMARY KEY (`id`)
);
SELECT * FROM `monster`;
insert into monster values(null, 20, '2000-11-11', 'nmw@sohu.com', '男', '牛魔王', 5000.88);
insert into monster values(null, 10, '2011-11-11', 'bgj@sohu.com', '女', '白骨精', 2000.00);
3.数据库环境配置
1.新建maven项目
2.pom.xml 引入依赖
parent>
artifactId>spring-boot-starter-parentartifactId>
groupId>org.springframework.bootgroupId>
version>2.5.3version>
parent>
dependencies>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-starter-webartifactId>
dependency>
dependency>
groupId>org.projectlombokgroupId>
artifactId>lombokartifactId>
optional>trueoptional>
dependency>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-starter-testartifactId>
scope>testscope>
dependency>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-configuration-processorartifactId>
optional>trueoptional>
dependency>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-starter-data-jdbcartifactId>
dependency>
dependency>
groupId>mysqlgroupId>
artifactId>mysql-connector-javaartifactId>
scope>runtimescope>
dependency>
dependency>
groupId>com.alibabagroupId>
artifactId>druidartifactId>
version>1.1.17version>
dependency>
dependency>
groupId>org.mybatis.spring.bootgroupId>
artifactId>mybatis-spring-boot-starterartifactId>
version>2.2.2version>
dependency>
dependencies>
3.application.yml 配置数据源
- 数据库名
- 用户名
- 密码
- 驱动是mysql8的(因为上面使用了版本仲裁)
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://localhost:3306/springboot_mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
4.Application.java 编写启动类
package com.sun.springboot.mybatis;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
5.测试
package com.sun.springboot.mybatis;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.annotation.Resource;
@SpringBootTest
public class ApplicationTest {
@Resource
private JdbcTemplate jdbcTemplate;
@Test
public void t1() {
System.out.println(jdbcTemplate.getDataSource().getClass());
}
}
6.配置类切换druid数据源
package com.sun.springboot.mybatis.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
import java.sql.SQLException;
import java.util.Arrays;
@Configuration
public class DruidDataSourceConfig {
@ConfigurationProperties("spring.datasource")
@Bean
public DataSource dataSource() throws SQLException {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setFilters("stat, wall");
return druidDataSource;
}
@Bean
public ServletRegistrationBean statViewServlet() {
StatViewServlet statViewServlet = new StatViewServlet();
ServletRegistrationBeanStatViewServlet> registrationBean =
new ServletRegistrationBean>(statViewServlet, "/druid/*");
registrationBean.addInitParameter("loginUsername", "root");
registrationBean.addInitParameter("loginPassword", "root");
return registrationBean;
}
@Bean
public FilterRegistrationBean webStatFilter() {
WebStatFilter webStatFilter = new WebStatFilter();
FilterRegistrationBeanWebStatFilter> filterRegistrationBean =
new FilterRegistrationBean>(webStatFilter);
filterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
filterRegistrationBean.addInitParameter
("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
return filterRegistrationBean;
}
}
7.测试数据源是否成功切换
package com.sun.springboot.mybatis;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.annotation.Resource;
@SpringBootTest
public class ApplicationTest {
@Resource
private JdbcTemplate jdbcTemplate;
@Test
public void t1() {
System.out.println(jdbcTemplate.getDataSource().getClass());
}
}
4.Mybatis基础配置
1.编写映射表的bean
package com.sun.springboot.mybatis.bean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import java.util.Date;
@Data
public class Monster {
private Integer id;
private Integer age;
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
private Date birthday;
private String email;
private String name;
private String gender;
private Double salary;
}
2.MonsterMapper.java 编写mapper接口
package com.sun.springboot.mybatis.mapper;
import com.sun.springboot.mybatis.bean.Monster;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface MonsterMapper {
public Monster getMonsterById(Integer id);
}
3.MonsterMapper.xml 编写mapper.xml实现mapper接口
DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
mapper namespace="com.sun.springboot.mybatis.mapper.MonsterMapper">
select id="getMonsterById" resultType="com.sun.springboot.mybatis.bean.Monster" parameterType="Integer">
select * from monster where id = #{id}
select>
mapper>
4.application.yml 扫描mapper.xml配置文件的位置
mybatis:
mapper-locations: classpath:mapper/*.xml
5.测试
package com.sun.springboot.mybatis;
import com.sun.springboot.mybatis.bean.Monster;
import com.sun.springboot.mybatis.mapper.MonsterMapper;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.annotation.Resource;
@SpringBootTest
public class ApplicationTest {
@Resource
private JdbcTemplate jdbcTemplate;
@Resource
private MonsterMapper monsterMapper;
@Test
public void t1() {
System.out.println(jdbcTemplate.getDataSource().getClass());
}
@Test
public void t2() {
Monster monsterById = monsterMapper.getMonsterById(1);
System.out.println(monsterById);
}
}
5.MyBatis高级配置
1.方式一:在application.yml中配置mybatis.config-location指定mybatis-config.xml配置文件的位置
2.方式二:直接在application.yml中配置
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com/sun/springboot/mybatis/bean
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
6.继续编写Service层和Controller层
1.MonsterService.java
package com.sun.springboot.mybatis.service;
import com.sun.springboot.mybatis.bean.Monster;
public interface MonsterService {
public Monster getMonsterById(Integer id);
}
2.MonsterServiceImpl.java
package com.sun.springboot.mybatis.service.Impl;
import com.sun.springboot.mybatis.bean.Monster;
import com.sun.springboot.mybatis.mapper.MonsterMapper;
import com.sun.springboot.mybatis.service.MonsterService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Service
public class MonsterServiceImpl implements MonsterService {
@Resource
private MonsterMapper monsterMapper;
@Override
public Monster getMonsterById(Integer id) {
return monsterMapper.getMonsterById(id);
}
}
3.测试
package com.sun.springboot.mybatis;
import com.sun.springboot.mybatis.bean.Monster;
import com.sun.springboot.mybatis.mapper.MonsterMapper;
import com.sun.springboot.mybatis.service.MonsterService;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.annotation.Resource;
@SpringBootTest
public class ApplicationTest {
@Resource
private MonsterService monsterService;
@Test
public void getMonsterById() {
Monster monsterById = monsterService.getMonsterById(1);
System.out.println(monsterById);
}
}
4.MonsterController.java
package com.sun.springboot.mybatis.Controller;
import com.sun.springboot.mybatis.bean.Monster;
import com.sun.springboot.mybatis.service.MonsterService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.annotation.Resource;
@Controller
public class MonsterController {
@Resource
private MonsterService monsterService;
@GetMapping("/getMonster/{id}")
@ResponseBody
public Monster getMonsterById(@PathVariable("id") Integer id) {
Monster monsterById = monsterService.getMonsterById(id);
return monsterById;
}
}
5.测试
6.解决时间问题
7.完整文件目录
2.整合MyBatis-Plus
1.MyBatis-Plus基本介绍
2.数据库表设计
CREATE DATABASE `springboot_mybatisplus`;
USE `springboot_mybatisplus`;
CREATE TABLE `monster` (
`id` INT NOT NULL AUTO_INCREMENT,
`age` INT NOT NULL,
`birthday` DATE DEFAULT NULL,
`email` VARCHAR(255) DEFAULT NULL,
`gender` CHAR(1) DEFAULT NULL,
`name` VARCHAR(255) DEFAULT NULL,
`salary` DOUBLE NOT NULL,
PRIMARY KEY (`id`)
);
SELECT * FROM `monster`;
INSERT INTO monster VALUES(NULL, 20, '2000-11-11', 'xzj@sohu.com', '男', ' 蝎 子 精 ',
15000.88);
INSERT INTO monster VALUES(NULL, 10, '2011-11-11', 'ytj@sohu.com', '女', ' 玉 兔 精 ',
18000.88);
3.数据库环境配置
1.创建maven项目
2.pom.xml 导入依赖
parent>
artifactId>spring-boot-starter-parentartifactId>
groupId>org.springframework.bootgroupId>
version>2.5.3version>
parent>
dependencies>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-starter-webartifactId>
dependency>
dependency>
groupId>org.projectlombokgroupId>
artifactId>lombokartifactId>
optional>trueoptional>
dependency>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-starter-testartifactId>
scope>testscope>
dependency>
dependency>
groupId>org.springframework.bootgroupId>
artifactId>spring-boot-configuration-processorartifactId>
optional>trueoptional>
dependency>
dependency>
groupId>mysqlgroupId>
artifactId>mysql-connector-javaartifactId>
scope>runtimescope>
dependency>
dependency>
groupId>com.alibabagroupId>
artifactId>druidartifactId>
version>1.1.17version>
dependency>
dependency>
groupId>com.baomidougroupId>
artifactId>mybatis-plus-boot-starterartifactId>
version>3.4.3version>
dependency>
dependencies>
3.application.yml 配置数据源
server:
port: 8080
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/springboot_mybatisplus?useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
4.DruidDataSourceConfig.java 配置类切换druid数据源
package com.sun.springboot.mybatisplus.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
import java.sql.SQLException;
import java.util.Arrays;
@Configuration
public class DruidDataSourceConfig {
@ConfigurationProperties("spring.datasource")
@Bean
public DataSource dataSource() throws SQLException {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setFilters("stat, wall");
return druidDataSource;
}
@Bean
public ServletRegistrationBean statViewServlet() {
StatViewServlet statViewServlet = new StatViewServlet();
ServletRegistrationBeanStatViewServlet> registrationBean =
new ServletRegistrationBean>(statViewServlet, "/druid/*");
registrationBean.addInitParameter("loginUsername", "root");
registrationBean.addInitParameter("loginPassword", "root");
return registrationBean;
}
@Bean
public FilterRegistrationBean webStatFilter() {
WebStatFilter webStatFilter = new WebStatFilter();
FilterRegistrationBeanWebStatFilter> filterRegistrationBean =
new FilterRegistrationBean>(webStatFilter);
filterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
filterRegistrationBean.addInitParameter
("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
return filterRegistrationBean;
}
}
5.编写启动类Application.java,测试运行
package com.sun.springboot.mybatisplus;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
4.MyBatis-Plus基础配置
1.编写映射表的bean
package com.sun.springboot.mybatisplus.bean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import java.util.Date;
@Data
public class Monster {
private Integer id;
private Integer age;
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date birthday;
private String email;
private String name;
private String gender;
private Double salary;
}
2.MonsterMapper.java 编写Mapper接口
package com.sun.springboot.mybatisplus.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sun.springboot.mybatisplus.bean.Monster;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface MonsterMapper extends BaseMapperMonster> {
}
3.测试接口方法使用
package com.sun.springboot.mybatisplus;
import com.sun.springboot.mybatisplus.bean.Monster;
import com.sun.springboot.mybatisplus.mapper.MonsterMapper;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import javax.annotation.Resource;
@SpringBootTest
public class MonsterMapperTest {
@Resource
private MonsterMapper monsterMapper;
@Test
public void t1() {
Monster monster = monsterMapper.selectById(1);
System.out.println(monster);
}
}
5.MyBatis-Plus高级配置
application.yml 进行配置
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
6.继续编写Service层和Controller层
1.MonsterService.java
package com.sun.springboot.mybatisplus.service.Impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.sun.springboot.mybatisplus.bean.Monster;
import com.sun.springboot.mybatisplus.mapper.MonsterMapper;
import com.sun.springboot.mybatisplus.service.MonsterService;
import org.springframework.stereotype.Service;
@Service
public class MonsterServiceImpl extends ServiceImplMonsterMapper, Monster> implements MonsterService {
}
2.MonsterServiceImpl.java
package com.sun.springboot.mybatisplus.service.Impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.sun.springboot.mybatisplus.bean.Monster;
import com.sun.springboot.mybatisplus.mapper.MonsterMapper;
import com.sun.springboot.mybatisplus.service.MonsterService;
import org.springframework.stereotype.Service;
@Service
public class MonsterServiceImpl extends ServiceImplMonsterMapper, Monster> implements MonsterService {
}
3.测试
package com.sun.springboot.mybatisplus;
import com.sun.springboot.mybatisplus.bean.Monster;
import com.sun.springboot.mybatisplus.mapper.MonsterMapper;
import com.sun.springboot.mybatisplus.service.MonsterService;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import javax.annotation.Resource;
@SpringBootTest
public class MonsterServiceTest {
@Resource
private MonsterService monsterService;
@Test
public void t1() {
Monster byId = monsterService.getById(2);
System.out.println(byId);
}
}
4.细节说明
- 简单来说就是MonsterServiceImpl只需要实现MonsterService接口的方法
- 可以调用IService接口的方法,也可以调用MonsterService接口的方法
5.MonsterController.java
package com.sun.springboot.mybatisplus.controller;
import com.sun.springboot.mybatisplus.bean.Monster;
import com.sun.springboot.mybatisplus.service.MonsterService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.annotation.Resource;
@Controller
public class MonsterController {
@Resource
private MonsterService monsterService;
@GetMapping("/getMonster/{id}")
@ResponseBody
public Monster getMonsterById(@PathVariable("id") Integer id) {
Monster byId = monsterService.getById(id);
return byId;
}
}
7.细节说明
1.@MapperScan 扫描包下的所有Mapper
启动类配置注解
2.@TableName bean的类名与表名不一致时使用
3.MyBatis引入了哪些依赖
8.MyBatisX快速开发
1.安装插件
2.使用方式
1.挑一个带小鸟的方法
2.直接alt + Enter
3.生成sql语句
4.查看生成的方法
5.点击左边的小鸟就可以直接跳转到指定方法或者xml
9.完整文件目录
10.MyBatis-Plus小结