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 即可得到查询结果