<deleteid="dropTableByTableName">
drop table ${tableName}
</delete><selectid="isTableExistInDB"resultType="java.lang.String">
SELECT
table_name
FROM
information_schema.COLUMNS
WHERE
table_schema = 'public'
AND TABLE_NAME = #{tableName}
LIMIT 1
</select>
isTableExistInDB sql 中 table_schema = ‘public’ 的 public 可根据实际情况作出改变