案例代碼：https://gitee.com/flymini/codes01/tree/master/springboot_/com-learn-boot09 **** **1. 引入spring-boot-starter-jdbc依賴** ```xml <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.13</version> </dependency> </dependencies> ``` **2. 數據庫配置** *`resources/application.yml`* ```xml spring: datasource: username: root password: uhg</flEt3dff url: jdbc:mysql://localhost:3306/learndb?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai driver-class-name: com.mysql.cj.jdbc.Driver ``` **3. 調用`JdbcTemplate`類的API來操作數據庫** ```java @RestController @RequestMapping("/student") public class StudentController { @Autowired private JdbcTemplate jdbcTemplate; @RequestMapping("/find") public void findById() { String sql = "select id,name,age,gender from student where id=?"; Map<String, Object> student = jdbcTemplate.queryForMap(sql, new Object[]{1}); System.out.println(student); //{id=1, name=張三, age=25, gender=男生} } } ```