Data Access - Spring Enterprise Recipes: A Problem Solution Approach - page 116

package com.apress.springenterpriserecipes.vehicle;
...
import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
public class JdbcVehicleDao extends SimpleJdbcDaoSupport implements
VehicleDao {
public void insert(Vehicle vehicle) {
String sql = "INSERT INTO VEHICLE (VEHICLE_NO, COLOR, WHEEL, SEAT) "
+ "VALUES (?, ?, ?, ?)";
getSimpleJdbcTemplate().update(sql, vehicle.getVehicleNo(),
vehicle.getColor(), vehicle.getWheel(), vehicle.getSeat());
}
...
}
SimpleJdbcTemplate offers a convenient batch update method for you to specify a SQL statement
and a batch of parameters in the form of List<Object[]> so that you don't need to implement the
BatchPreparedStatementSetter interface. Note that SimpleJdbcTemplate requires either a DataSource
or a JdbcTemplate .
package com.apress.springenterpriserecipes.vehicle;
...
import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
public class JdbcVehicleDao extends SimpleJdbcDaoSupport implements VehicleDao {
...
public void insertBatch(List<Vehicle> vehicles) {
String sql = "INSERT INTO VEHICLE (VEHICLE_NO, COLOR, WHEEL, SEAT) "
+ "VALUES (?, ?, ?, ?)";
List<Object[]> parameters = new ArrayList<Object[]>();
for (Vehicle vehicle : vehicles) {
parameters.add(new Object[] { vehicle.getVehicleNo(),
vehicle.getColor(), vehicle.getWheel(), vehicle.getSeat() });
}
getSimpleJdbcTemplate().batchUpdate(sql, parameters);
}
}
Using a Simple JDBC Template to Query a Database
When implementing the RowMapper<T> interface, the return type of the mapRow() method is
java.lang.Object . ParameterizedRowMapper<T> is a subinterface that takes a type parameter
as the return type of the mapRow() method.