一、集成Mybatis
1、导入依赖:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
2、在入口类扫描mapper(dao):在入口类上使用**@MapperScan**注解,其值为mapper的包路径,如:@MapperScan(“com.itboot.mapper”)
3、配置文件application.properties 中的数据库配置:
#数据库连接信息
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/erp?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useAffectedRows=true
spring.datasource.username=root
spring.datasource.password=123456
#配置实体类所在包
mybatis.type-aliases-package = com.itboot.domain
4、各类的代码,这里仅测试,没有service:
入口类:
//SpringBootApplication 注解声明该类是一个SpringBoot项目的引导类(入口类)
@SpringBootApplication
@MapperScan("com.itboot.mapper")
public class MySpringBootApplication {
public static void main(String[] args) {
// run方法表示运行SpringBoot的入口类,其参数就是入口类的字节码对象
SpringApplication.run(MySpringBootApplication.class);
}
}
controller:
@Controller
public class MabatisController {
@Autowired
private IUserMapper userMapper;
@RequestMapping("/queryUserList")
@ResponseBody
public List<User> queryUserList() {
List<User> users = userMapper.queryUserList();
return users;
}
}
mapper:
public interface IUserMapper {
@Select("select * from user_inf")
List<User> queryUserList();
}