springboot+mybatis动态创建数据表和删除数据库表

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.4</version>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.9</version>
</dependency>

 @RequestMapping("/createTable")  //动态创建表
    public void test2(){
        String tableName = "t2";      //mybatis中#() 占位符，对应的变量会自动加上引号   $()  拼接符，对应的变量不会自动加上引号
        String name = "name";     //表中字段名字
        testService.test12(tableName,name);//创建表
        return;
    }

    void test12(String tableName,String name);

    @Override
    public void test12(String tableName,String name) {
        testMapper.test2(tableName,name);
        return;
    }

    void test2(@Param("tableName") String tableName,@Param("name") String name);

<!--这个注意是用${} 因为$这个符号是拼接的意思，而#{}是占位符，会自动把变量的值两边加上引号-->
<update id="test2" parameterType="java.lang.String">
    CREATE TABLE ${tableName}(
        id int NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        ${name} varchar(10) NOT null
    )
</update>

    @RequestMapping("/deleteTable")  //动态删除表
    public void deletetable(){
        String tableName = "t2";
        testService.test3(tableName);
        return;
    }

    void test3(String tableName);

    @Override
    public void test3(String tableName) {
        testMapper.test3(tableName);
    }

    void test3(@Param("tableName") String tableName);

<update id="test3" parameterType="java.lang.String">
    DROP TABLE IF EXISTS ${tableName}
</update>