SpringBoot配置jdbcTemplate

package com.pp.config;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

@Configuration
public class SpringJdbcConfig {
	@Value(value="${spring.datasource.driver-class-name}")
	private String driverClassName;
	@Value(value="${spring.datasource.url}")
	private String url;
	@Value(value="${spring.datasource.username}")
	private String username;
	@Value(value="${spring.datasource.password}")
	private String password;
	
	@Bean
	public DriverManagerDataSource dataSource() {
		DriverManagerDataSource dataSource = new DriverManagerDataSource();
		dataSource.setDriverClassName(driverClassName);
		dataSource.setUrl(url);
		dataSource.setUsername(username);
		dataSource.setPassword(password);
		
		return dataSource;
	}
	
	@Bean
	public JdbcTemplate jdbcTemplate(DriverManagerDataSource dataSource) {
		JdbcTemplate jdbcTemplate = new JdbcTemplate();
		jdbcTemplate.setDataSource(dataSource);
		
		return jdbcTemplate;
	}
}

Controllerl

	@Autowired
	JdbcTemplate jdbcTemplate;

	@RequestMapping("/jdbc")
	@ResponseBody
	public List<Student> list() {
		String sql = "select * from student";
		return jdbcTemplate.query(sql, new RowMapper<Student>() {

			@Override
			public Student mapRow(ResultSet arg0, int arg1) throws SQLException {
				Student s = new Student();
				s.setId(arg0.getInt("id"));
				s.setName(arg0.getString("name"));
				s.setSex(arg0.getString("sex"));

				return s;
			}
		});
	}