JdbcTemplate jdbcTemplate = new JdbcTemplate(getDataSource());

KeyHolder keyHolder = new GeneratedKeyHolder();

final String query = queryStringBuilder.toString();

jdbcTemplate.update(

new PreparedStatementCreator() {

@Override

public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {

PreparedStatement ps =

connection.prepareStatement(query, new String[] {"customer_id"});

return ps;

}

},

keyHolder);

List<?> keys = keyHolder.getKeyList();

for (Object key : keys) {

@SuppressWarnings("unchecked")

Map<Object, Object> keyMap = (Map<Object, Object>)key;

Entry<Object, Object> entry = keyMap.entrySet().iterator().next();

Long id = (Long) entry.getValue();

results.add(id.intValue());

}