org.springframework.jdbc.core.simple.SimpleJdbcInsert#executeAndReturnKey ( )源码实例Demo

/**
 * Alternative to RideRepositoryImpl#createRide(com.pluralsight.model.Ride)
 */
public Ride createRideSimpleJDBC(Ride ride) {
	final SimpleJdbcInsert insert = new SimpleJdbcInsert(jdbcTemplate);

	insert.setGeneratedKeyName("id");

	final Map<String, Object> data = new HashMap<>();
	data.put("name", ride.getName());
	data.put("duration", ride.getDuration());

	final List<String> columns = new ArrayList<>();
	columns.add("name");
	columns.add("duration");

	insert.setTableName("ride");
	insert.setColumnNames(columns);

	final Number id = insert.executeAndReturnKey(data);
	return getRide(id);
}
 

private static void insertConstructor(JdbcTemplate jdbc) {
    separator("insertConstructor");
    SimpleJdbcInsert insertActor = new SimpleJdbcInsert(jdbc).withSchemaName("region").withTableName("jc_region").usingGeneratedKeyColumns("region_id");

    Map<String, Object> parameters = new HashMap<String, Object>();
    parameters.put("region_name", "new region name");
    Number number = insertActor.executeAndReturnKey(parameters);
    log.debug("Inserted region id: {}", number.longValue());
}