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);
}
}
vehicle.rar （39个子文件） 
vehicle 
.project 561B src test java org ourpioneer vehicle DBTest.java 2KB main resources org ourpioneer vehicle db vehicle.log 342B vehicle.properties 437B vehicle.script 1KB spring applicationContext.xml 1KB sql-error-codes.xml 938B java org ourpioneer vehicle Demo.java 1KB exception VehicleDuplicateKeyException.java 371B VehicleDuplicateKeyTranslator.java 859B dao VehicleDAOImpl.java 3KB VehicleDAO.java 547B util DatabaseConnection.java 873B HsqldbConnection.java 933B HsqlServer.java 1KB jt VehicleRowMapper.java 647B InsertVehicleStatementCreator.java 997B bean Vehicle.java 2KB target classes org ourpioneer vehicle db vehicle.log 342B vehicle.properties 437B vehicle.script 1KB exception VehicleDuplicateKeyException.class 648B VehicleDuplicateKeyTranslator.class 1KB Demo.class 1KB dao VehicleDAO.class 590B VehicleDAOImpl.class 4KB util DatabaseConnection.class 896B HsqlServer.class 2KB HsqldbConnection.class 1KB jt VehicleRowMapper.class 1KB InsertVehicleStatementCreator.class 1KB bean Vehicle.class 2KB spring applicationContext.xml 1KB sql-error-codes.xml 938B test-classes org ourpioneer vehicle DBTest.class 2KB .settings org.maven.ide.eclipse.prefs 249B org.eclipse.jdt.core.prefs 274B pom.xml 1KB .classpath 569B资源评论
