Spring Boot整合JDBC

pom.xml添加相关依赖

<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.11</version>
</dependency>

Application.yml

server:
  port: 9090

spring:
  thymeleaf:
    prefix: classpath:/templates/
    suffix: .html
    mode: HTML5
    encoding: UTF-8
  datasource:
    url: jdbc:mysql://localhost:3306/jdbcstudy?serverTimezone=UTC&useLegacyDatetimeCode=false&useUnicode=true&characterEncoding=UTF-8​
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

实体类User

package com.makerjack.entity;

import lombok.Data;

import javax.validation.constraints.Min;
import javax.validation.constraints.NotEmpty;
import javax.validation.constraints.NotNull;

@Data
public class User {

    @NotNull(message = "id不能为空")
    private int id;
    @NotEmpty(message = "姓名不能为空")
    private String name;
    @Min(message = "金额必须大于1000", value = 1000)
    private int money;
}

接口UserRepository

package com.makerjack.repository;

import com.makerjack.entity.User;

import java.util.List;

public interface UserRepository {
    public List<User> findAll();
    public User findById(int id);
    public void save(User user);
    public void update(User user);
    public void deleteById(int id);
}

UserRepositoryImpl

package com.makerjack.repository.impl;

import com.makerjack.entity.User;
import com.makerjack.repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class UserRepositoryImpl implements UserRepository {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public List<User> findAll() {
        return jdbcTemplate.query("select * from account",new BeanPropertyRowMapper<>(User.class));
    }

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

    @Override
    public void save(User user) {
        jdbcTemplate.update("insert into account(name ,money) value (?,?)",user.getName(),user.getId());
    }

    @Override
    public void update(User user) {
        jdbcTemplate.update("update account set name = ?,money = ? where id =?",user.getName(),user.getMoney(),user.getId());
    }

    @Override
    public void deleteById(int id) {
        jdbcTemplate.update("delete from account where id = ?",id);
    }
}

Handler

package com.makerjack.controller;

import com.makerjack.entity.User;
import com.makerjack.repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/user")
public class UserHandler {

    @Autowired
    private UserRepository userRepository;

    @GetMapping("/findAll")
    public List<User> findAll(){
        return userRepository.findAll();
    }

    @GetMapping("/findById/{id}")
    public User findById(@PathVariable("id") int id){
        return userRepository.findById(id);
    }

    @PostMapping("/save")
    public void save(@RequestBody User user){
        userRepository.save(user);
    }

    @PutMapping("/update")
    public void update(User user){
        userRepository.update(user);
    }

    @DeleteMapping("/deleteById/{id}")
    public void deleteByIde(@PathVariable("id") int id){
        userRepository.deleteById(id);
    }
}