public int[] create(List<Notice> notices) {
SqlParameterSource[] params = SqlParameterSourceUtils.createBatch(notices.toArray());
return jdbc.batchUpdate(
"insert into notices (name, email, text) values (:name, :email, :text)", params);
}
/**
* 批量操作
*
* @param sql
* @param obj
* @return
*/
public int[] batchOperate(String sql, List<?> obj) {
int[] a = null;
try {
a = simpleJdbcTemplate.batchUpdate(sql, SqlParameterSourceUtils.createBatch(obj.toArray()));
} catch (Exception e) {
log.info(e);
return null;
// throw new DaoException("数据库操作失败！",e);
}
return a;
}
/**
* Match input parameter values with the parameters declared to be used in the call.
*
* @param parameterSource the input values
* @return a Map containing the matched parameter names with the value taken from the input
*/
public Map<String, Object> matchInParameterValuesWithCallParameters(
SqlParameterSource parameterSource) {
// For parameter source lookups we need to provide case-insensitive lookup support
// since the database metadata is not necessarily providing case sensitive parameter names.
Map<String, String> caseInsensitiveParameterNames =
SqlParameterSourceUtils.extractCaseInsensitiveParameterNames(parameterSource);
Map<String, String> callParameterNames =
new HashMap<String, String>(this.callParameters.size());
Map<String, Object> matchedParameters = new HashMap<String, Object>(this.callParameters.size());
for (SqlParameter parameter : this.callParameters) {
if (parameter.isInputValueProvided()) {
String parameterName = parameter.getName();
String parameterNameToMatch = this.metaDataProvider.parameterNameToUse(parameterName);
if (parameterNameToMatch != null) {
callParameterNames.put(parameterNameToMatch.toLowerCase(), parameterName);
}
if (parameterName != null) {
if (parameterSource.hasValue(parameterName)) {
matchedParameters.put(
parameterName,
SqlParameterSourceUtils.getTypedValue(parameterSource, parameterName));
} else {
String lowerCaseName = parameterName.toLowerCase();
if (parameterSource.hasValue(lowerCaseName)) {
matchedParameters.put(
parameterName,
SqlParameterSourceUtils.getTypedValue(parameterSource, lowerCaseName));
} else {
String englishLowerCaseName = parameterName.toLowerCase(Locale.ENGLISH);
if (parameterSource.hasValue(englishLowerCaseName)) {
matchedParameters.put(
parameterName,
SqlParameterSourceUtils.getTypedValue(parameterSource, englishLowerCaseName));
} else {
String propertyName = JdbcUtils.convertUnderscoreNameToPropertyName(parameterName);
if (parameterSource.hasValue(propertyName)) {
matchedParameters.put(
parameterName,
SqlParameterSourceUtils.getTypedValue(parameterSource, propertyName));
} else {
if (caseInsensitiveParameterNames.containsKey(lowerCaseName)) {
String sourceName = caseInsensitiveParameterNames.get(lowerCaseName);
matchedParameters.put(
parameterName,
SqlParameterSourceUtils.getTypedValue(parameterSource, sourceName));
} else {
logger.warn(
"Unable to locate the corresponding parameter value for '"
+ parameterName
+ "' within the parameter values provided: "
+ caseInsensitiveParameterNames.values());
}
}
}
}
}
}
}
}
if (logger.isDebugEnabled()) {
logger.debug(
"Matching "
+ caseInsensitiveParameterNames.values()
+ " with "
+ callParameterNames.values());
logger.debug("Found match for " + matchedParameters.keySet());
}
return matchedParameters;
}
private int[] batchUpdateByPojo(String sqlStr, List<Object> pojoList) {
SqlParameterSource[] batch = SqlParameterSourceUtils.createBatch(pojoList.toArray());
int[] updateCounts = simpleJdbcTemplate.batchUpdate(sqlStr, batch);
if (null != this.additiveSql) simpleJdbcTemplate.update(this.additiveSql);
return updateCounts;
}
public int batchUpdate(
String sqlId, Map<String, Integer> sqlTypes, final List<Map<String, Object>> batchValues) {
long cur = System.currentTimeMillis();
try {
int[] batchCount = null;
String sql = sqlp.getValue(sqlId, sqlId);
ParsedSql parsedSql = NamedParameterUtils.parseSqlStatement(sql);
if (sqlTypes != null && !sqlTypes.isEmpty()) {
MapSqlParameterSource[] batch = new MapSqlParameterSource[batchValues.size()];
for (int i = 0; i < batchValues.size(); i++) {
Map<String, Object> valueMap = batchValues.get(i);
batch[i] = new MapSqlParameterSource();
for (Entry<String, Integer> entry : sqlTypes.entrySet()) {
if (!valueMap.containsKey(entry.getKey())) {
valueMap.put(entry.getKey(), null);
}
batch[i].addValue(entry.getKey(), valueMap.get(entry.getKey()), entry.getValue());
}
if (logger.isTraceEnabled()) {
logger.trace(
new StringBuffer("SqlId=")
.append(sqlp.containsKey(sqlId) ? sqlId : "")
.append("\n#")
.append((i + 1))
.append("\t")
.append(CapDbUtil.convertToSQLCommand(sql, valueMap))
.toString());
}
}
cur = System.currentTimeMillis();
batchCount =
NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(
parsedSql, batch, super.getJdbcOperations());
} else {
SqlParameterSource[] batch =
SqlParameterSourceUtils.createBatch(
batchValues.toArray(new HashMap[batchValues.size()]));
cur = System.currentTimeMillis();
batchCount =
NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(
parsedSql, batch, super.getJdbcOperations());
}
int rows = 0;
for (int i : batchCount) {
rows += i;
}
return rows;
} catch (Exception e) {
Throwable cause = (Throwable) e;
String msg = cause.getMessage();
while ((cause = cause.getCause()) != null) {
if (cause instanceof BatchUpdateException) {
cause = ((BatchUpdateException) cause).getNextException();
}
msg = cause.getMessage();
}
throw new CapDBException(msg, e, causeClass);
} finally {
logger.info("CapNamedJdbcTemplate spend {} ms", (System.currentTimeMillis() - cur));
}
} // ;