springboot加入jdbcTemplate

oppoppoppo

于 2017-02-23 16:30:31 发布

阅读量1k

点赞数

分类专栏： springboot

本文链接：https://blog.youkuaiyun.com/oppoppoppo/article/details/56674580

版权

springboot 专栏收录该内容

3 篇文章

订阅专栏

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


如果在JPA已经加入的话，则可以不用引入以上的配置。
<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

@Repository
public class JdbcTemplateUserRepository {
	
	@Resource
	private JdbcTemplate jdbcTemplate;
	
	public User getUserByName(User user){
		String sql = "select * from user where name =?";
		RowMapper<User> rowMapper = new BeanPropertyRowMapper<User>(User.class);
		return jdbcTemplate.queryForObject(sql, rowMapper, user.getName());
	}
}