1.Maven依赖引入
导入所需要的maven依赖
<!--MyBatisPlus依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--数据连接池druid-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.20</version>
</dependency>
2.配置数据库信息
配置在application.properties文件当中
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/privateweb?useSSL=false&useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
spring.mvc.pathmatch.matching-strategy=ant_path_matcher
3.创建Mapper包,且在运行类当中加入@MapperScan注解和Mapper包的路径
4.定义Mapper接口
@Mapper
public interface UserMapper {
@Select("select * from student")
public List<User> getStudent();
}
5.在controller类中使用自动注解注入mapper且使用
@Autowired
private UserMapper userMapper;
@GetMapping("/user")
public String user(){
List<User> list = userMapper.getStudent();
System.out.println(list);
return "hello world";
}