Spring boot jdbcTemplate

Spring boot jdbcTemplate

上一节 Spring boot lombok

Spring boot lombok

源码

springboot学习指南

---

jdbcTemplate

简介
spring 提供了好的的template类 简化和封装了一些便利的操作，例如 jdbcTemplte, redisTemplate，kafkaTemplate, rabbitTemplate 等等；
现在使用 jdbcTemplate 进行对数据库的操作。虽然没有mybatis 和jpa，hibernate等orm框架更先进，
不过在小型项目中偶尔还是可以使用的。

1. 引入依赖

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--创建web项目-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

2. 配置文件中配置数据源信息

server:
  port: 8989
spring:
  application:
    name: test-jdbcTemplate
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mytest?useSSL=false&charsetEncoding=utf8
    driver-class-name: com.mysql.jdbc.Driver
logging:
  level:
    org.springframework.jdbc.core: debug

3. 创建数据库表结构
创建user表

drop table t_user;
commit;
create table t_user
(
    u_id        varchar(64)                         not null
        primary key,
    u_name      varchar(32)                         not null,
    password    varchar(32)                         not null,
    money       int(10)                             null,
    create_time timestamp default CURRENT_TIMESTAMP not null
);
commit ;

创建表实体类

@ToString
public class UserEntity {
   

    private String uId;

    private String uName;

    private String password;

    private Long money;

    private Date createTime;

    public String getuId() {
   
        return uId;
    }

    public void setuId(String uId) {
   
        this.uId = uId;
    }

    public String getuName() {
   
        return uName;
    }

    public void setuName(String uName) {
   
        this.uName = uName;
    }

    public String getPassword() {
   
        return password;
    }

    public void setPassword(String password) {
   
        this.password = password;
    }

    public Long getMoney(