- 前言
- 操作步骤
- 扩展
- 1. 表名有前缀的情况
整合MyBatis-Plus的小案例
MyBatis-Plus官网:https://baomidou.com/
准备的表数据,附sql
CREATE TABLE `user` (
`id` int NOT NULL,
`name` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'wangsan');
INSERT INTO `user` VALUES ('2', 'lisi');
INSERT INTO `user` VALUES ('3', 'liuwu');
- 引入依赖
com.baomidou
mybatis-plus-boot-starter
3.4.3
mysql
mysql-connector-java
- 配置application.yml文件
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/mydb?characterEncoding=UTF-8&useSSL=false
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
- 编写pojo和mapper
public class User {
private Integer id;
private String name;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Mapper; @Mapper public interface UserMapper extends BaseMapper{ }
- 编写测试用例并执行测试
@SpringBootTest
public class SpringbootRestDemoTests {
@Autowired
private UserMapper userMapper;
@Test
public void hello(){
System.out.println(userMapper.selectById(1).getName());
}
}
加粗样式
数据库的表名叫 tb_user,而对应的对象叫做User,此时将会对应不上。
- 解决方法一:单独给User类添加注解@TableName(“tb_user”)
- 解决方法二: 配置统一的前缀(所有表都是tb_开头的情况下)
#配置统一前缀
mybatis-plus:
global-config:
db-config:
table-prefix: tb_



