Spring JDBC是Spring框架对JDBC的简单封装,其中提供了JDBCTemplate对象简化JDBC开发
new BeanPropertyRowMapper<类型>(类型.class)
这种实现类,该类可以实现数据到JavaBean的自动封装/**
* JDBCTemplate入门
*/
public class Demo1 {
public static void main(String[] args) throws Exception {
//创建JDBCTemplate对象
JdbcTemplate jdbcTemplate=new JdbcTemplate(DruidUtils.getDataSource());
//调用方法
String sql="update stuMess set score=100 where id=?";
int result=jdbcTemplate.update(sql,3);
System.out.println(result);
}
}
public class Demo2 {
private JdbcTemplate jdbcTemplate=new JdbcTemplate(DruidUtils.getDataSource());
@Test
public void test1(){
String sql="select * from FINALEXAM_PERSON where ELEC >?";
List<Person> personList=jdbcTemplate.query(sql,new BeanPropertyRowMapper<Person>(Person.class),3000);
for(Person p: personList){
System.out.println(p);
}
}
}
/* 运行结果:
Person{up='A路人', fan=2634110, all_like=4060804, all_play=130307845, elec=3717, submissions=246}
Person{up='hanser', fan=1940049, all_like=5015728, all_play=93791313, elec=14054, submissions=263}
Person{up='信誓蛋蛋', fan=4822994, all_like=12635046, all_play=285482138, elec=22156, submissions=181}
Person{up='ilem', fan=1379899, all_like=2696860, all_play=83757635, elec=5289, submissions=117}
......
*/