springboot 整合 jdbcTemplate

1 依赖

<dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-jdbc</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.0.29</version>
</dependency>

2 配置文件

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/blog?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456

3 调用

@Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public void fangfa1() {

        //用于执行 `INSERT`、`UPDATE`、`DELETE` 等DML语句
        String sql = "insert into admin (username,password) values(?,?)";
        jdbcTemplate.update(sql, "yonghu_1", "123456");

        //用于执行 `INSERT`、`UPDATE`、`DELETE` 等DML语句
        String sql = "update admin set username=?,password=? where id=39";
        jdbcTemplate.update(sql, "yonghu_0", 123456);

        //用于执行 `INSERT`、`UPDATE`、`DELETE` 等DML语句
        String sql = "delete from admin where id=?";
        jdbcTemplate.update(sql, 41);

        //执行查询语句，返回一个List集合，List中存放的是RowMapper指定类型的数据。
        String sql = "select * from admin where id<?";
        BeanPropertyRowMapper<Admin> rowMapper = new BeanPropertyRowMapper<>(Admin.class);
        List<Admin> query = jdbcTemplate.query(sql, rowMapper, 50);

        //创建表的SQL语句
        String sql = "CREATE TABLE product("
                + "pid INT PRIMARY KEY AUTO_INCREMENT,"
                + "pname VARCHAR(20),"
                + "price DOUBLE"
                + ");";
        jdbcTemplate.execute(sql);

        //执行查询语句，返回一个指定类型的数据
        String sql = "select count(*) from admin";
        Integer i = jdbcTemplate.queryForObject(sql, Integer.class);
        System.out.println(i);

        //执行查询语句，返回一个指定类型的数据
        String sql = "select username from admin where id=39";
        String s = jdbcTemplate.queryForObject(sql, String.class);
        System.out.println(s);

        //执行查询语句，将一条记录放到一个Map中
        String sql = "select * from admin where id=?";
        Map<String, Object> stringObjectMap = jdbcTemplate.queryForMap(sql, 40);
        System.out.println(stringObjectMap);

        //执行查询语句，返回一个List集合，List中存放的是Map类型的数据。
        String sql = "select * from admin where id<?";
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql, 42);
        System.out.println(maps);
    }