jdbctemplate mysql 分页查询 返回list对象_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";

Listlist=jdbcTemplate.query(sql, new MyRowMapper());

System.out.println(list);

}

}

class MyRowMapper implements RowMapper{

@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]]