mybatis mapper建表

package com.wanda.desk.dao.mmapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

/**
 * @Classname KesuIdsMapper
 * @Description TODO
 * @Date 2021/6/16 19:05
 * @Created by songlk
 */
@Mapper
public interface KesuIdsMapper {
        @Update({"create table ${tableName}( " +
                "`id` int(11) NOT NULL AUTO_INCREMENT," +
                " `keId` int(11) NOT NULL  COMMENT '客诉'," +
                "`createUser` varchar(63) DEFAULT NULL COMMENT '创建人'," +
                "`updateUser` varchar(63) DEFAULT NULL COMMENT '更新人'," +
                "`owner`  varchar(63) DEFAULT NULL COMMENT '所有人'," +
                "`createTime` datetime DEFAULT NULL COMMENT '创建时间'," +
                "`updateTime` datetime DEFAULT NULL COMMENT '更新时间'," +
                " PRIMARY KEY (`id`),"+
                "UNIQUE KEY `keId` (`keId`)"+
                ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='客诉管理员ids';"})
        public void createTbKesuIds(@Param("tableName") String tableName);

        @Update({"drop table if exists ${tableName}"})
        public void dropExistTable(@Param("tableName") String tableName);


}

@SpringBootApplication(scanBasePackages = {"com.wanda.desk"})
@EnableScheduling
@MapperScan("com.wanda.desk.dao")
public class DeskApplication {
    public static void main(String[] args) {
        SpringApplication.run(DeskApplication.class, args);
    }

}