Spring Boot (六) JdbcTemplate

1.pom.xml文件中添加JdbcTemplate依赖

<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>

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

@Resource
private JdbcTemplate jdbcTemplate;

例如：依旧以Player的查询为例

PlayerDao

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.milan.domain.Player;

@Repository
public class PlayerDao {

	@Resource
	private JdbcTemplate jdbcTemplate;
	
	public Player getPlayerByName(String name){
		String sql = "select * from player where name = ?";
		RowMapper<Player> rowMapper = new BeanPropertyRowMapper<>(Player.class);
		Player player = jdbcTemplate.queryForObject(sql, new Object[]{name}, rowMapper);
		return player;
	}
	
}

PlayerService：

@Resource
private PlayerDao playerDao;

@Transactional
public Player getPlayerByName(String name){
	return playerDao.getPlayerByName(name);
}

PlayerController：

@RequestMapping("/getPlayerByName")
public Player getPlayerByName(String name){
	return playerService.getPlayerByName(name);
}

地址栏通过http://localhost:8080/player/getPlayerByName?name=kaka 即可得到查询结果