mybatis中执行DDL语句

在mapper.xml中一般都是对表数据进行DML(增删改查)操作，很少通过MyBatis对数据库进行DDL(create, alter, drop)操作，下面就mybatis的DDL给大家做个简单介绍。

方法一、在相关mapper.xml文件中DDL的配置代码

@Update("alter table ${tableName} rename ${newTableName}")
void alterTableName(String tableName,String newTableName);

@Update("truncate table ${tableName}")
void truncateTable(String tableName);

@Update("create table ${newTableName} as select * from ${tableName}")
void createNewTableAndInsertData(String tableName,String newTableName);

方法二、在相关mapper.xml文件中DDL的配置代码

<update id="alterTableName">
	alter table ${tableName} rename ${newTableName}
</update>

<update id="truncateTable">
	truncate table ${tableName}
</update>
    
 <update id="createNewTableAndInsertData">
 	create table ${newTableName} as select * from ${tableName}
</update>