SpringBoot使用JdbcTemplate

<!-- springboot 整合 jdbcTemplate jar包 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

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

 

使用： 

直接注入JdbcTemplate 就可以使用

    @Autowired
	private JdbcTemplate jdbcTemplate ;

	@RequestMapping("/addUser2")
	public String addUser2(String name ,String address){
		log.info("name:"+name + "  -- "+ "address:"+address);
		String sql = "insert into user (name,address) values (?,?) " ;
		int update = jdbcTemplate.update(sql ,name,address);
		log.info("update:"+update);
		return "success" ;
	}