springboot mybatis下临时表的创建和删除,可用于查重去重

    /**
* 创建临时表
*/
@Update({"drop temporary table if exists ${tableName};", "create temporary table ${tableName} select doctor_id from crm_speaker where 1=2 "})
void createTemoraryTable(@Param("tableName") String tableName); /**
* 保存数据到临时表里面以便校验数据重复
*/
@Insert("<script>" +
"insert into ${tableName} (doctor_id) values\n" +
" <foreach collection=\"list\" item=\"doct\" index=\"index\" separator=\",\">\n" +
" (" +
" #{doct.doctorId,jdbcType=VARCHAR}\n" +
" )\n" +
" </foreach>\n" +
"</script>")
void insertBatchCheckDatas(@Param("list") List<SpeakerDO> dOs, @Param("tableName") String tableName); /**
* 删除临时表
*/
@Update({"drop temporary table if exists ${tableName}"})
void dropTemporaryTable(@Param("tableName") String tableName);
上一篇:js怎么动态加载js文件(JavaScript性能优化篇)


下一篇:git 的详解