SpringBoot九：整合JdbcTemplate

pom文件引入以下依赖

<dependencies>
	<!-- Spring Boot web依赖 -->
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
	</dependency>
	<!-- 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>
</dependencies>

application.properties配置

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

Controller

@RestController
public class JdbcTemplateController {
	@Autowired
	private JdbcTemplateService jdbcTemplateService;

	// http://localhost:8080/createUser?name=zhangsan&age=18
	@RequestMapping("/createUser")
	public String createUser(String name, Integer age) {
		jdbcTemplateService.createUser(name, age);
		return "success";
	}

}

service

@Service
public class JdbcTemplateServiceImpl implements JdbcTemplateService {
	@Autowired
	private JdbcTemplate jdbcTemplate;

	@Override
	public void createUser(String name, Integer age) {
		jdbcTemplate.update("insert into users values(null,?,?);", name, age);
	}

}

http://localhost:8080/createUser?name=zhangsan&age=18

代码托管：springboot_jdbctemplate