文章目录
整合MyBatis-Plus
中小型公司使用MyBatis-Plus
新建阿里云模块(模拟做法)
因为MyBatis-Plus是国人开发的,所以springboot官方并没有整合MyBatis-Plus的集成依赖
所以我们使用阿里云的模块
这先不管,直接next
新建普通模块(官方做法)
添加mybatis-plus依赖
Maven Repository: Search/Browse/Explore (mvnrepository.com)
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3</version>
</dependency>
编写yml
#配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mybatis
username: root
password: 12345
编写实体类
package com.taotao.domain;
/**
* create by 刘鸿涛
* 2022/5/1 21:12
*/
@SuppressWarnings({"all"})
public class user {
private int id;
private String username;
private int password;
private String gender;
private String addr;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public int getPassword() {
return password;
}
public void setPassword(int password) {
this.password = password;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getAddr() {
return addr;
}
public void setAddr(String addr) {
this.addr = addr;
}
@Override
public String toString() {
return "user{" +
"id=" + id +
", username='" + username + '\'' +
", password=" + password +
", gender='" + gender + '\'' +
", addr='" + addr + '\'' +
'}';
}
}
编写Dao层
mybatis-plus ,BaseMapper类有些简单的sql方法,所以继承类后可以直接调用方法使用即可
package com.taotao.Dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.taotao.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
/**
* create by 刘鸿涛
* 2022/5/2 10:45
*/
@Mapper
@SuppressWarnings({"all"})
public interface UserDao extends BaseMapper<User> {
}
编写测试
package com.taotao;
import com.taotao.Dao.UserDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
@SpringBootTest
class Springboot06MabatisPlusApplicationTests {
@Autowired
private UserDao userDao;
@Test
void contextLoads() {
System.out.println(userDao.selectById(1));
}
}
测试失败(mapper映射sql表名)
编写yml(方案一)
#配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mybatis
username: root
password: 12345
#设置Mp相关配置
mybatis -plus:
global-config:
db-config:
table-prefix: tb_
测试成功
实体类注解(方案二)
实体类加上@TableName(“表名”)注解
测试成功
测试查询所有
@Test
void testGetAll(){
System.out.println(userDao.selectList(null));
}