SpringBoot整合mybatis进行快速开发

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


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;
    }
}

5.验证结果

只需要添加jar包加上数据库的配置就可以直接进行mybatis的使用了，太哇塞了！！