SpringBoot整合mybatis进行数据库操作
1.环境的搭建
pom.xml
<!--核心模块,包括自动配置支持、日志和YAML -->
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<!-- 测试模块,包括JUnit、Hamcrest、Mockito -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- 控制层的支持 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!--mysql的支持 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
2.在application.xml添加数据库连接配置
spring.datasource.url=jdbc:mysql://localhost:3306/light
spring.datasource.username=root
spring.datasource.password=j
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
3.mapper层 使用mybatis generator工具自动添加mapper
![](/Users/jj/Desktop/屏幕快照 2017-08-16 下午4.17.44.png)
4.不添加service层,直接在web层验证结果
@RestController
@RequestMapping(value="/light")
public class LightController {
@Autowired
private LightMapper lightMapper;
@ResponseBody
@RequestMapping(value="/getlight/ {id}" ,method=RequestMethod.GET)
public Light getLight(@PathVariable int id) {
Light selectByPrimaryKey = lightMapper.selectByPrimaryKey(id);
return selectByPrimaryKey;
}
}