简单粗暴直接放代码
注解方式 修改
@Update(" <script> " +
" update wx_clue_user_assign set employee_id = #{employeeId},employee_name = #{employeeName},department_id = #{departmentId},account_user_id = #{employeeId},assign_status = 1,assign_time=now() ,updator=#{updator}"+
" where corp_id=#{corpId} and id in\n" +
" <foreach collection=\"list\" item=\"item\" index=\"index\" separator=\",\" open=\"(\" close=\")\">\n" +
" #{item}\n" +
" </foreach>" +
"</script>")
注解方式 插入
@Insert(" <script> " +
"INSERT INTO wx_clue_behavior_rule (\n" +
"\tis_effective,\n" +
"\tunit_score,\n" +
"\tmax_score,\n" +
"\tmax_times,\n" +
"\tbehavior_id,\n" +
"\tcompany_id,\n" +
"\tupdator,\n" +
"\tcreator\n" +
") VALUES \n" +
" <foreach collection=\"list\" item=\"item\" index=\"index\" separator=\",\">\n" +
" (#{item.isEffective},#{item.unitScore},#{item.maxScore},#{item.maxTimes},#{item.behaviorId},#{companyId},#{creator},#{creator} )\n" +
" </foreach>" +
"</script>")