Spring之SimpleJdbcTemplate的使用

package org.monday.springjdbc; import java.util.ArrayList; import java.util.List; import org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper; import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport; public class UserDaoImpl extends SimpleJdbcDaoSupport implements UserDao { @Override public void insert(User user) { String sql = "insert into user(id,name)values(?,?)"; getSimpleJdbcTemplate().update(sql, user.getId(), user.getName()); } @Override public void update(User user) { String sql = "update user set name=? where id=?"; getSimpleJdbcTemplate().update(sql, user.getName(), user.getId()); } @Override public void delete(User user) { String sql = "delete from user where id=?"; getSimpleJdbcTemplate().update(sql, user.getId()); } @Override public void delete(int id) { String sql = "delete from user where id=?"; getSimpleJdbcTemplate().update(sql, id); } @Override public User findById(int id) { String sql = "select * from user where id=?"; return getSimpleJdbcTemplate().queryForObject(sql, ParameterizedBeanPropertyRowMapper.newInstance(User.class), id); // 下面的方法只能返回一列,所以行不通 // return getSimpleJdbcTemplate().queryForObject(sql, User.class, id); } @Override public int findByName(String name){ String sql = "select id from user where name=?"; return getSimpleJdbcTemplate().queryForObject(sql, Integer.class, name); // Integer.class 改成int.class 不行 // 貌似只能用包装类 } @Override public List<User> findAll() { String sql = "select * from user"; return getSimpleJdbcTemplate().query(sql, ParameterizedBeanPropertyRowMapper.newInstance(User.class)); } @Override public int count() { String sql = "select count(*) from user"; return getSimpleJdbcTemplate().queryForInt(sql); } @Override public void batchInsert(List<User> users) { String sql = "insert into user(id,name)values(?,?)"; List<Object[]> parameters = new ArrayList<Object[]>(); for (User u : users) { parameters.add(new Object[] { u.getId(), u.getName() }); } getSimpleJdbcTemplate().batchUpdate(sql, parameters); } }