springboot和mybatisplus版本
时间: 2023-08-23 16:07:09 浏览: 88
Mybatis Plus与Spring Boot版本兼容性如下:
Mybatis Plus 3..7对应Spring Boot 2.1.x
Mybatis Plus 3.1.对应Spring Boot 2.2.x
Mybatis Plus 3.2.对应Spring Boot 2.3.x
Mybatis Plus 3.3.对应Spring Boot 2.4.x
建议使用最新版本的Mybatis Plus和Spring Boot以获得更好的性能和稳定性。
相关问题
springboot整合mybatisplus 2.3.3版本
SpringBoot 2.3.3版本中,可能会出现自动配置DataSource的问题,需要手动配置。同时,整合MybatisPlus需要引入相关依赖和配置文件。
1. 在pom.xml文件中引入MybatisPlus的依赖:
```xml
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
```
2. 在application.yml配置文件中添加数据库连接信息:
```yaml
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
```
3. 在启动类上添加注解@EnableTransactionManagement开启事务管理,并排除自动配置DataSource:
```java
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
@EnableTransactionManagement
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
```
4. 创建实体类和Mapper接口,并使用MybatisPlus提供的注解进行配置:
```java
@Data
public class User {
private Long id;
private String name;
private Integer age;
private String email;
}
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
```
5. 在Service层中注入Mapper,并使用MybatisPlus提供的方法进行数据库操作:
```java
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> list() {
return userMapper.selectList(null);
}
@Override
public User getById(Long id) {
return userMapper.selectById(id);
}
@Override
public void save(User user) {
userMapper.insert(user);
}
@Override
public void update(User user) {
userMapper.updateById(user);
}
@Override
public void delete(Long id) {
userMapper.deleteById(id);
}
}
```
springboot和mybatisplus详细整合
SpringBoot和MybatisPlus的整合可以让我们更加方便地进行数据库操作,以下是详细的整合步骤:
1.在pom.xml文件中添加MybatisPlus和Clickhouse的依赖:
```xml
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
<dependency>
<groupId>ru.yandex.clickhouse</groupId>
<artifactId>clickhouse-jdbc</artifactId>
<version>0.3.1</version>
</dependency>
```
2.在application.properties文件中添加Clickhouse的配置:
```properties
spring.datasource.driver-class-name=ru.yandex.clickhouse.ClickHouseDriver
spring.datasource.url=jdbc:clickhouse://localhost:8123/default
spring.datasource.username=default
spring.datasource.password=
```
3.创建实体类和Mapper接口,使用MybatisPlus的注解来简化代码:
```java
@Data
public class User {
@TableId(type = IdType.AUTO)
private Long id;
private String name;
private Integer age;
}
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
```
4.在Service中注入Mapper,并使用MybatisPlus提供的方法进行数据库操作:
```java
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> listUsers() {
return userMapper.selectList(null);
}
@Override
public User getUserById(Long id) {
return userMapper.selectById(id);
}
@Override
public void saveUser(User user) {
userMapper.insert(user);
}
@Override
public void updateUser(User user) {
userMapper.updateById(user);
}
@Override
public void deleteUser(Long id) {
userMapper.deleteById(id);
}
}
```
5.在Controller中注入Service,并编写接口方法:
```java
@RestController
@RequestMapping("/users")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("")
public List<User> listUsers() {
return userService.listUsers();
}
@GetMapping("/{id}")
public User getUserById(@PathVariable Long id) {
return userService.getUserById(id);
}
@PostMapping("")
public void saveUser(@RequestBody User user) {
userService.saveUser(user);
}
@PutMapping("")
public void updateUser(@RequestBody User user) {
userService.updateUser(user);
}
@DeleteMapping("/{id}")
public void deleteUser(@PathVariable Long id) {
userService.deleteUser(id);
}
}
```