1.首先创建一个表,塞点数据
2.创建一个Bean去接受它
**public class User_name {
private String name;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "姓名是 "+name+" 密码是 "+password;
}
}
**
3.使用spring封装将表中数据打包成我想要的bean的集合
public class Damo7 {
public static void main(String[] args) {
//获取连接池的对象,付给JDBCTem对象
JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBC_util_2.getDataSource());
String sql="select * from user1";
//这个门道就多了,不过基本功能是将表中数据封装为bean的集合
List<User_name> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User_name>(User_name.class));
for(User_name user_name:query){
System.out.println(user_name);
}
}
}
4.结果令人满意
七月 13, 2020 5:10:01 下午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
姓名是 jiang 密码是 123
Process finished with exit code 0