新建springboot项目
勾选lombok
pom添加依赖(mysql连接,mybatis-plus依赖)
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.25</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.2</version> </dependency>
application.yml配置(连接mysql8数据库)
server: port: 8080 spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/mp?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=UTC username: root password: 123456
在com.mp.pojo下创建User实体类
@Data @AllArgsConstructor @NoArgsConstructor public class User { private Long id; private String name; private Integer age; private String email; }
在com.mp.mapper下创建UserMapper
@Repository public interface UserMapper extends BaseMapper<User> { }
修改启动类Application
@SpringBootApplication @MapperScan("com.mptest.mapper") public class MpTestApplication { public static void main(String[] args) { SpringApplication.run(MpTestApplication.class, args); } }
测试类中测试
@SpringBootTest class MpTestApplicationTests { @Autowired private UserMapper userMapper; @Test void test() { List<User> users = userMapper.selectList(null); users.forEach(System.out::println); } }
输出结果
已经可以进行简单的crud操作
配置日志
在application.yml中添加配置
#配置日志 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
结果输出形式