使用JdbcTemplate操作数据，jdbctemplate数据,使用Spring整合

使用JdbcTemplate操作数据，jdbctemplate数据,使用Spring整合

使用Spring整合

 @Resource JdbcTemplate tm; /**  *  * @Title: save  * @Description: 批量保存，批量删除与此方法类似  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void save() {  final List<Student> list = new ArrayList<Student>();  Student s = new Student();  s.setName("小明1212123");  Student s2 = new Student();  s2.setName("小明123fdfd");  Student s3 = new Student();  s3.setName("小明123adsaa");  list.add(s);  list.add(s2);  list.add(s3);  String sql = "insert into student(name) values (?)";  tm.batchUpdate(sql, new BatchPreparedStatementSetter() {   @Override   public void setValues(PreparedStatement ps, int i) throws SQLException {    ps.setString(1, list.get(i).getName());   }   @Override   public int getBatchSize() {    return list.size();   }  }); } /**  *  * @Title: find  * @Description: 查询结果返回实体list 第一种方式  * @author  * @param  * @return void 返回类型  * @throws  */ @SuppressWarnings("unchecked") @Test public void find() {  String sql = "select * from student where name=?";  List<Student> list = tm.query(sql, new String[] { "小明" }, new BeanPropertyRowMapper(Student.class));  for (int i = 0; i < list.size(); i++) {   System.out.println(list.get(i).getName());  } } /**  *  * @Title: findEntityList  * @Description: 查询结果返回实体list 第二种方式，此处的实体类Student需要实现RowMapper接口  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void findEntityList() {  test_trans  String sql = "select id,name from student";  List<Student> list = tm.query(sql, new Student());  for (int i = 0; i < list.size(); i++) {   Student s = list.get(i);   System.out.println(s.getId() + ">>>>>>>" + s.getName());  } } /**  *  * @Title: findEntityListWhere  * @Description: 通过条件查询数据  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void findEntityListWhere() {  String sql = "select id,name from student where id=?";  List<Student> list = tm.query(sql, new Object[] { 1 }, new Student());  for (int i = 0; i < list.size(); i++) {   Student s = list.get(i);   System.out.println(s.getId() + ">>>>>>>" + s.getName());  } } /**  *  * @Title: findEntity  * @Description: 查询结果返回单个实体  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void findEntity() {  String sql = "select id,name from student where id=1";  Student s = tm.queryForObject(sql, new Student());  System.out.println(s.getId() + ">>>>>>>" + s.getName()); } /**  *  * @Title: findMap  * @Description: 查询结果返回map  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void findMap() {  String sql = "select * from student";  List<Map<String, Object>> list = tm.queryForList(sql);  for (int i = 0; i < list.size(); i++) {   Map<String, Object> map = list.get(i);   System.out.println(map.get("id") + ">>>>>>" + map.get("name"));  } } /**  *  * @Title: count  * @Description: 统计数量  * @author  * @param  * @return void 返回类型  * @throws  */ @Test public void count() {  String sql = "select count(*) as 'count' from student";  Map<String, Object> map = tm.queryForMap(sql);  System.out.println("共找到>>>>>>>>>>:" + map.get("count") + "条数据"); }

实体Student类

import java.sql.ResultSet;import java.sql.SQLException;import javax.persistence.Transient;import org.springframework.jdbc.core.RowMapper;public class Student implements RowMapper<Student> { private Integer id; private String name; private String nothing; public Integer getId() {  return this.id; } public void setId(Integer id) {  this.id = id; } public String getName() {  return this.name; } public void setName(String name) {  this.name = name; } @Transient public String getNothing() {  return this.nothing; } public void setNothing(String nothing) {  this.nothing = nothing; } @Override public Student mapRow(ResultSet rs, int num) throws SQLException {  // TODO Auto-generated method stub  Student s = new Student();  try {   s.setId(rs.getInt("id"));   s.setName(rs.getString("name"));   s.setNothing(rs.getString("nothing"));  } catch (Exception e) {   // TODO: handle exception  }  return s; }}