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