SpringBoot之六：JDBCTemplate

蔚落 2022-05-28 05:46 194阅读 0赞

本文的基本配置和[SpringBooot之四：JPA][SpringBooot_JPA]配置一致。

\#\#一、开发步骤解析

\#\#\#1、pom.xml配置JPA：提供了JDBCTemplate的支持

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

\#\#\#2、编写Dao层

/**
     * 使用@Repository注解，标注这是一个持久化操作对象
     * 
     * @author yang
     */
    @Repository
    public class CatDao {
    
    	@Resource
    	private JdbcTemplate jdbcTemplate;
    	
    	/**
    	 * 1、定义一个Sql语句
    	 * 2、定义一个RowMapper
    	 * 3、执行查询方法
    	 * @return
    	 */
    	public Cat selectByCatName(String name) {
    		String sql="select * from cat where name=?";
    		RowMapper<Cat> rowMapper=new BeanPropertyRowMapper<>(Cat.class);
    		Cat cat=jdbcTemplate.queryForObject(sql, rowMapper, name);
    		return cat;
    	}
    	
    }

\#\#\#3、编写Service层

@Service
    public class CatServiceJDBCTemplate {
    
    	@Resource
    	private CatDao catDao;
    	
    	
    	public Cat selectByCatName(String name) {
    		return catDao.selectByCatName(name);
    	}
    	
    	
    }

\#\#\#4、Controller层测试

@RequestMapping("/selectByCatName")
    public Cat selectByCatName(String name){
    	return template.selectByCatName(name);
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ld2JpZV85MDc0ODY4NTI_size_16_color_FFFFFF_t_70_pic_center][]

[SpringBooot_JPA]: https://blog.csdn.net/newbie_907486852/article/details/79751985
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ld2JpZV85MDc0ODY4NTI_size_16_color_FFFFFF_t_70_pic_center]: /images/20220528/18f60cc4ef724a0da8ebbd2903d786b9.png