直接上代码把,利用面向对象的思想,应该不难理解。
/**
* 批量记录错误语言检查错误信息
*
* @param languageToolResultBean
*/
public void batchLgToolResultTOErrorBatch(List<LanguageToolResultBean> languageToolResultBean, String assignment_history_id) {
Map<String, Object> mapParam = new HashMap<String, Object>();
mapParam.put("assignment_history_id", assignment_history_id);
mapParam.put("languageToolResultBean", languageToolResultBean);
List<Map<String, String>> listMap = (List<Map<String, String>>) this.getSqlMapClientTemplate().queryForList("writingEssay.queryEssayClassIdByAssId", Integer.valueOf(assignment_history_id));
if (listMap != null && listMap.size() > 0) {
mapParam.put("essay_id", listMap.get(0).get("essay_id"));
mapParam.put("classes_id", listMap.get(0).get("classes_id"));
}
this.getSqlMapClientTemplate().insert("writingEssay.batchLgToolResultTOErrorBatch", mapParam);
}
SQL 配置文件的写法:
<!-- 批量记录错误语言检查错误信息 -->
<insert id="batchLgToolResultTOErrorBatch" parameterClass="java.util.HashMap">
<![CDATA[
INSERT INTO t_assignment_error(
error_id,
user_id,
essay_id,
classes_id,
rule_id,
assignment_history_id,
error_catlog,
error_content_pre,
error_content,
error_content_suf,
error_msg,
error_content_length,
error_local_index)
VALUES
]]>
<iterate property="languageToolResultBean" conjunction=",">
<![CDATA[
(null,
#languageToolResultBean[].user_id#,
#essay_id#,
#classes_id#,
#languageToolResultBean[].rule_id#,
#assignment_history_id#,
#languageToolResultBean[].error_catlog#,
#languageToolResultBean[].error_content_pre#,
#languageToolResultBean[].error_content#,
#languageToolResultBean[].error_content_suf#,
#languageToolResultBean[].error_msg#,
#languageToolResultBean[].error_content_length#,
#languageToolResultBean[].error_local_index#)
]]>
</iterate>
</insert>