Spring Boot (六) JdbcTemplate

来源：互联网发布：淘宝卖家如何办理发票编辑：程序博客网时间：2024/06/09 14:42

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.那么只需要在需要使用的类中加入：

@Resourceprivate 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;@Repositorypublic class PlayerDao {@Resourceprivate 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：

@Resourceprivate PlayerDao playerDao;

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

阅读全文

0 0