springboot 整合jdbcTemplate

导入依赖：

       <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.21</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

自定义实体类User：

package com.example.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/**
 * (User)实体类
 *
 * @author makejava
 * @since 2020-07-08 12:36:36
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User implements Serializable {
    private static final long serialVersionUID = -77292410218923755L;
    
    private Integer id;
    
    private String name;
    
    private String tel;


}

控制层：JDBCTemplateContorller

package com.example.controller;

import com.example.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * @author 19417
 */
@RestController
@RequestMapping("/jdbc")
public class JDBCTemplateContorller {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    @GetMapping("/getAll")
    public List<User> getAllUser(){
        String sql="select * from user ";
        return  jdbcTemplate.query(sql,new Object[]{}, new BeanPropertyRowMapper<>(User.class));
    }
    @GetMapping("/getuser/{id}")
    public User getUser(@PathVariable Integer id) {
        // 根据主键ID查询
        String sql = "select * from user where id = ?";
        return jdbcTemplate.queryForObject(sql, new Object[]{id}, new BeanPropertyRowMapper<>(User.class));
    }

    @DeleteMapping("/delet/{id}")
    public int delUser(@PathVariable Integer id) {
        // 根据主键ID删除用户信息
        String sql = "DELETE FROM user WHERE id = ?";
        return jdbcTemplate.update(sql, id);
    }


    @PostMapping("/add")
    public int addUser(@RequestParam("name") String name,@RequestParam("tel") String tel) {
        // 添加用户
        String sql = "insert into user(name, tel) values(?, ?)";
        return jdbcTemplate.update(sql, name, tel);
    }


    @PutMapping("/update/{id}")
    public int updateUser(@PathVariable Integer id,@RequestParam("name") String name,@RequestParam("tel") String tel ) {
        // 根据主键ID修改用户信息
        String sql = "UPDATE user SET name = ? ,tel = ? WHERE id = ?";
        return jdbcTemplate.update(sql, name, tel, id);
    }
}

测试：