删除列
Mapper
void deleteTableColumn(@Param("tableName") String tableName, @Param("column") String column);
Mapper.xml
<update id="deleteTableColumn">
ALTER TABLE ${tableName}
DROP COLUMN "${column}"
</update>
添加列
Mapper
void appendTableColumn(@Param("tableName") String tableName, @Param("column") Map<String, String> column);
Mapper.xml
<update id="appendTableColumn" parameterType="java.util.Map">
ALTER TABLE ${tableName}
ADD (
"${column.code}"
<choose>
<when test="column.type=='STRING'">
VARCHAR2(${column.length} BYTE) NULL
</when>
<when test="column.type=='NUMBER'">
NUMBER(${column.length},${column.precision}) NULL
</when>
<otherwise>
TIMESTAMP(${column.length}) NULL
</otherwise>
</choose>
)
</update>