ParameterizedRowMapper<Person> rm=ParameterizedBeanPropertyRowMapper.newInstance(Person.class);
Map m=new HashMap<String, Integer>();
m.put("pid", 1);
m.put("A", 2);
m.put("B", 10);
SqlParameterSource sqlparamsourc=new MapSqlParameterSource(m);
SqlParameterSource sqlParameterSource=new BeanPropertySqlParameterSource(new Person (10L,"神之梦"));
List<Person> list=jdbc.query(sql, rm, m);
System.out.println(list.size());
List<Person> list1=jdbc.query(sql11, rm, 5);
List<Person> list2=jdbc.query(sql111, rm, 5,10);
int num=jdbc.queryForInt(sqls, m);
System.out.println(">5 de you "+num);
List<Person> list3=jdbc.query(sql, rm, sqlParameterSource);
SqlParameterSource[] sqlsrc= SqlParameterSourceUtils.createBatch(list1.toArray());
System.out.println("list3 size ="+list3.size());
jdbc.batchUpdate(sqlinsert, sqlsrc);
Map m=new HashMap<String, Integer>();
m.put("pid", 1);
m.put("A", 2);
m.put("B", 10);
SqlParameterSource sqlparamsourc=new MapSqlParameterSource(m);
SqlParameterSource sqlParameterSource=new BeanPropertySqlParameterSource(new Person (10L,"神之梦"));
List<Person> list=jdbc.query(sql, rm, m);
System.out.println(list.size());
List<Person> list1=jdbc.query(sql11, rm, 5);
List<Person> list2=jdbc.query(sql111, rm, 5,10);
int num=jdbc.queryForInt(sqls, m);
System.out.println(">5 de you "+num);
List<Person> list3=jdbc.query(sql, rm, sqlParameterSource);
SqlParameterSource[] sqlsrc= SqlParameterSourceUtils.createBatch(list1.toArray());
System.out.println("list3 size ="+list3.size());
jdbc.batchUpdate(sqlinsert, sqlsrc);