jdbcTemplate 实现查询返回list

package spring_jdbctemplate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class JdbcTemplateDemo2 {
	@Test
	public void delete(){
		DriverManagerDataSource dataSource=new DriverManagerDataSource();
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		dataSource.setUrl("jdbc:mysql://xxxx:3306/test");
		dataSource.setUsername("hpn");
		dataSource.setPassword("hpn2017");
		//常见JdbcTemplate对象，设置数据源
		JdbcTemplate jdbcTemplate=new JdbcTemplate(dataSource);
		//设置sql语句
		String sql="select * from test2";
		List<User> list=jdbcTemplate.query(sql, new MyRowMapper());
		System.out.println(list);
	}
}

class MyRowMapper implements RowMapper<User>{

	@Override
	public User mapRow(ResultSet rs, int num) throws SQLException {
		//从结果集里把数据得到
		String username=rs.getString("username");
		String password=rs.getString("password");
		//把数据封装到对象里
		User user=new User();
		user.setUsername(username);
		user.setPassword(password);
		return user;
	}
	
}

返回结果：[User [username:yangyang,password:123], User [username:haha,password:456], User [username:hehe,password:567]]