一、MyBatis-Plus是什么?
1、官方简介:
MyBatis-Plus (简称 MP)是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。
2、框架结构:
二、MyBatis-Plus整合springboot
步骤一、新建一个springboot项目
步骤二、在maven的pom.xml文件中添加如下依赖:
<!--springboot的web依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--mysql数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--MyBatis-Plus的依赖,这里用的不是最新版本,可以使用下面的最新版本号替换-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3.1</version>
</dependency>
步骤三、准备数据库表及数据
CREATE TABLE `user` (
`id` int(11) NOT NULL DEFAULT 1 AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`age` int(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
插入几条数据做测试
INSERT INTO `user` VALUES (1, '张三', 22);
INSERT INTO `user` VALUES (2, '李四', 21);
INSERT INTO `user` VALUES (3, '王五', 23);
步骤四、在项目中新建一个实体类
public class User {
// 用于标注主键,主键字段名及主键的类型
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
private String name;
private Integer age;
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;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "{\"User\":{"
+ "\"id\":"
+ id
+ ",\"name\":\""
+ name + '\"'
+ ",\"age\":"
+ age
+ "}}";
}
}
步骤五、在项目中新建一个mapper接口
@Repository
public interface UserMapper extends BaseMapper<User> {
}
步骤六、在项目中新建一个service接口
public interface UserService extends IService<User> {
}
步骤七、在项目中新建一个service的实现类
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
@Autowired
private UserMapper userMapper;
/**
* 查询所有用户信息
* @return
*/
public List<User> getUserList() {
QueryWrapper<User> wrapper = new QueryWrapper<>();
return userMapper.selectList(wrapper);
}
}
步骤八、在项目中新建一个controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserServiceImpl userService;
@GetMapping("/getUserList")
public String getUserList() {
return userService.getUserList().toString();
}
}
最后,不要忘了在启动类上加上mapper的扫描注解
@SpringBootApplication
@MapperScan("${mapperPath}") // mapperPath是项目中mapper所在的包名完整路径
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
启动项目,完成~