SpringBoot持久层技术(jdbcTemplate+mybatis+springdataJPA)

整合jdbcTemplate

jdbctemplate是Spring提供的JDBC框架，利用AOP技术来解决直接使用jdbc带来的大量代码的繁杂问题

SpringBoot对JdbcTemplate的使用提供了一套自动化配置类：JdbcTemplateAutoConfiguration类,所以想要使用只需要提供JdbcTemplate的依赖和dataSource依赖即可

案例

1.pom.xml配置

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.1</version>
        </dependency>
        <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-jdbc</artifactId>
        </dependency>
    </dependencies>

2.配置数据库连接信息applicaion.properties

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql:///chapter05?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

3.创建JavaBean

public class Book {
   
    private int id;
    private String name;
    private Double price;
	//省略getter setter
}

4.创建持久层接口dao

jdbcTemplate 对于增删改都使用update方法

@Repository
public class BookDao {
   
//加入jdbc依赖后就可以直接注入使用
    @Autowired
    JdbcTemplate jdbcTemplate;

    public int addBook(Book book){
   
        return jdbcTemplate.update("insert into book(name,price) values(?,?)",book.getName(),book.getPrice());
    }
    public int updateBook(Book book){
   
        return  jdbcTemplate.