Mybatis中查询、删除、创建表

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>