- springboot集成mybatis-plus
搭建一个springboot项目
点击next
把java版本改成8,点击next
选择springboot版本2.4.2 点击next
选择项目地址点击finish
在pom文件里加入依赖
org.springframework.boot spring-boot-starter-web org.springframework.boot spring-boot-devtools runtime true org.projectlombok lombok true org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-jdbc mysql mysql-connector-java com.baomidou mybatis-plus-boot-starter 3.2.0 org.springframework.boot spring-boot-maven-plugin org.projectlombok lombok
创建application.yml文件添加数据源配置
spring:
datasource:
url: jdbc:mysql://localhost:3306/dbtest?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
username: root
password: root
测试数据源链接是否成功
编写实体类
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Long id;
private String name;
private Integer age;
private String email;
}
创建mapper文件继承BaseMapper
开始测试(记得在启动类上加@MapperScan(“mapper的全路径名”)) 不然会报错找不到映射文件
@SpringBootTest
class DemoApplicationTests {
@Autowired
private DataSource dataSource;
@Autowired
private UserMapper userMapper;
@Test
void contextLoads() throws SQLException {
System.out.println("获取的数据库连接为:"+dataSource.getConnection());
}
@Test
void insertTest(){
User user = new User();
user.setId(8L);
user.setAge(18);
user.setEmail("110@qq.com");
user.setName("冷暖");
userMapper.insert(user);
}
}
数据库插入成功



