#### 模糊查詢 ``` LIKE CONCAT('%', #{keyword}, '%') LIKE '%${keyword}%' ``` #### select ``` // sql語句 // 如果返回int、String、hashmap等，需要將resultMap改成：resultType="int"等 ``` #### 批量插入 ``` int count = 0; int batchCount = 50; List<EvaluationResultScore> evaluationResultScoreList = new ArrayList<EvaluationResultScore>(); for (int i=0; i<length; i++) { EvaluationResultScore evaluationResultScore = new EvaluationResultScore(); evaluationResultScore.setResultId(resultId); evaluationResultScore.setItemId(itemId); evaluationResultScore.setOptionName(optionName); evaluationResultScore.setOptionScore(optionScore); evaluationResultScore.setRealScore(realScore); evaluationResultScoreList.add(evaluationResultScore); count++; if ((count%batchCount)==0) { iEvaluationResultScoreDAO.insertBatch(evaluationResultScoreList); evaluationResultScoreList.clear(); } } if (evaluationResultScoreList!=null && evaluationResultScoreList.size()>0) { iEvaluationResultScoreDAO.insertBatch(evaluationResultScoreList); evaluationResultScoreList.clear(); } ``` #### sql文寫法 ``` <insert id="insertBatch"> INSERT INTO evaluation_result_score (result_id, item_id, option_name, option_score, real_score) VALUES <foreach collection="list" item="item" index="index" separator=","> (#{item.resultId}, #{item.itemId}, #{item.optionName}, #{item.optionScore}, #{item.realScore}) </foreach> </insert> ```