mapper文件写法
<select id="selectTable" parameterType="map" resultType="Integer">
select count(*)
from information_schema.TABLES
where LCASE(table_name)=#{dimCode}
</select>
<update id="dropTable">
DROP TABLE IF EXISTS ${dimCode}
</update>
<update id="createTable" parameterType="map">
CREATE TABLE ${dimCode} (
enum_key varchar(30) not null comment '枚举项的键',
enum_value varchar(60) not null comment '枚举项的值',
PRIMARY KEY (enum_key))
</update>
<insert id="insertTable" parameterType="map">
insert into ${dimCode}
(enum_key,enum_value)
values
(#{enumKey},
#{enumValue})
</insert>