Spring Boot 之持久层

Spring Boot 整合 JdbcTemplate

JdbcTemplate 是 Spring 自带的 JDBC 模版组件，底层实现了对 JDBC 的封装，用法与 MyBatis 类似，开发者需要自定义 SQL 语句，JdbcTemplate 帮助开发者完成数据库连接，SQL 执行，以及结果集的解析。
JdbcTemplate 不足之处是灵活性不如 MyBatis，因为 MyBatis 的 SQL 定义在 XML 中，更有利用维护和扩展，但是 JdbcTemplate 是以硬编码的方式将 SQL 直接写在 Java 代码中，不利用扩展和维护。

1、pom.xml配置相关依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.smartaotao</groupId>
    <artifactId>springbootmybatis</artifactId>
    <version>1.0-SNAPSHOT</version>

    <!-- Spring Boot整合jdbcTemplate -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.5.RELEASE</version>
    </parent>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

</project>

2、创建实体类对象

import lombok.Data;
/**
	添加lombok插件
*/
@Data
public class Student {
    private Long id;
    private String name;
}

3、repository接口和实现类

接口

public interface StudentRepository {
    public Student findById(Long id);
}

实现类

@Repository
public class StudentRepositoryImpl implements StudentRepository {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public Student findById(Long id) {
        return jdbcTemplate.queryForObject("select * from student where id = ?",new Object[] {id},new BeanPropertyRowMapper<Student>(Student.class));
    }
}

4、创建Handler

@RestController
public class StudentHandler {

    @Autowired
    private StudentRepository studentRepository;

    @GetMapping("/findById/{id}")
    public Student findById(@PathVariable("id") Long id){
        return studentRepository.findById(id);
    }
}

5、配置数据库连接信息

application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mybatis
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

6、启动类

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class,args);
    }
}