Spring数据库访问之异常处理

package org.ourpioneer.vehicle.dao; import java.util.ArrayList; import java.util.List; import org.ourpioneer.vehicle.bean.Vehicle; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource; import org.springframework.jdbc.core.namedparam.SqlParameterSource; import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport; /** * VehicleDAO实现类 * * @author Nanlei * */ public class VehicleDAOImpl extends SimpleJdbcDaoSupport implements VehicleDAO { public void delete(Vehicle vehicle) { String sql = "delete from vehicle where ID=?"; getSimpleJdbcTemplate().update(sql, vehicle.getId()); } public Vehicle findById(int id) { String sql = "select * from vehicle where ISD=?"; return getSimpleJdbcTemplate().queryForObject(sql, BeanPropertyRowMapper.newInstance(Vehicle.class), id); } // public void insert(final Vehicle vehicle) { // String sql = "insert into vehicle(ID,PLATE,CHASSIS,COLOR,WHEEL,SEAT) values(:id,:plate,:chassis,:color,:wheel,:seat)"; // SqlParameterSource parameterSource = new BeanPropertySqlParameterSource( // vehicle); // getSimpleJdbcTemplate().update(sql, parameterSource); // } public void insert(final Vehicle vehicle) { String sql = "insert into vehicle(ID,PLATE,CHASSIS,COLOR,WHEEL,SEAT) values(?,?,?,?,?,?)"; getJdbcTemplate().update(sql, vehicle.getId(),vehicle.getPlate(),vehicle.getChassis(),vehicle.getColor(),vehicle.getWheel(),vehicle.getSeat()); } public void update(Vehicle vehicle) { String sql = "update vehicle set PLATE=?,CHASSIS=?,COLOR=?,WHEEL=?,SEAT=? where ID=?"; getJdbcTemplate().update(sql, vehicle.getPlate(), vehicle.getChassis(), vehicle.getColor(), vehicle.getWheel(), vehicle.getSeat(), vehicle.getId()); } public void insertBatch(final List<Vehicle> vehicles) { String sql = "insert into vehicle(PLATE,CHASSIS,COLOR,WHEEL,SEAT) values(:plate,:chassis,:color,:wheel,:seat)"; List<SqlParameterSource> parameters = new ArrayList<SqlParameterSource>(); for (Vehicle vehicle : vehicles) { parameters.add(new BeanPropertySqlParameterSource(vehicle)); } getSimpleJdbcTemplate().batchUpdate(sql, parameters.toArray(new SqlParameterSource[0])); } public List<Vehicle> findAll() { String sql = "select * from vehicle"; return getSimpleJdbcTemplate().query(sql, BeanPropertyRowMapper.newInstance(Vehicle.class)); } public int countVehicle() { String sql = "select count(*) from vehicle"; return getJdbcTemplate().queryForInt(sql); } public String getChassis(int id) { String sql = "select COLOR from vehicle where ID=?"; return getSimpleJdbcTemplate().queryForObject(sql, String.class, id); } }