MyBatis使用Map批量插入数据的一个例子

直接上代码把，利用面向对象的思想，应该不难理解。

    /**
     * 批量记录错误语言检查错误信息
     * 
     * @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>