Spring Boot JdbcTemplate

在pom.xml中添加JdbcTemplate的依赖

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

编写CatDao.java，声明为：@Repository，引入JdbcTemplate

那么只需要在需要使用的类中加入：

@Resource
private JdbcTemplate jdbcTemplate;

package com.example.demo.dao;

import javax.annotation.Resource;

import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import com.example.demo.bean.Cat;

/**
 * 使用@@Repository注解，标注是一个持久化的操作对象
 * @author Lidy
 */
@Repository
public class CatDao {

    @Resource
    private JdbcTemplate jdbcTemplate;
    
    public Cat selectByCatName(String catName){
        /**
         * 1.定义一个sql语句
         * 2.定义一个RowMapper
         * 3.执行查询方法
         */
        String sql = "select * from cat where cat_name=?";
        RowMapper<Cat> rowMapper = new BeanPropertyRowMapper<>(Cat.class);
        Cat cat = jdbcTemplate.queryForObject(sql, new Object[]{catName}, rowMapper);
        return cat;
    }
    
}