springboot2.0系列三（整合JdbcTemplate）

springboot整合JdbcTemplate

pom文件引入

<parent>             <groupId>org.springframework.boot</groupId>             <artifactId>spring-boot-starter-parent</artifactId>             <version>2.0.0.RELEASE</version>       </parent>       <dependencies>             <!-- jdbcTemplate 依赖 -->             <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter-jdbc</artifactId>             </dependency>             <!-- mysql 依赖 -->             <dependency>                   <groupId>mysql</groupId>                   <artifactId>mysql-connector-java</artifactId>             </dependency>             <!-- 测试 -->             <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter-test</artifactId>                   <scope>test</scope>             </dependency>             <!-- springboot-web组件 -->             <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter-web</artifactId>             </dependency>       </dependencies>

application.properties新增配置

spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driver

 

UserService类

package com.example.demo.service; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Service; @Service public class UserService{  @Autowired  private JdbcTemplate jdbcTemplate;  public void createUser(String name, Integer age) { jdbcTemplate.update("insert into users values(null,?,?);", name, age);  } }

 UserControlle类

package com.example.demo.controller; import com.example.demo.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @RestController public class UserController {     @Autowired     UserService userService;     @RequestMapping("/insertUser")     public void index(String name,Integer age) {        userService.createUser(name,age);     } }

 

 App类

@SpringBootApplication public class App {         public static void main(String[] args) {             SpringApplication.run(App.class, args);       }   }

 启动项目

效果

调用接口 http://localhost:8080/insertUser?name=zhangsan&age=22  

数据库新增一条数据