<!--删除表单数据表的字段-->
<update id="dropColumn" parameterType="java.util.Map">
alter table ${tableName} drop column ${columnName}
</update>
<!--增加表单数据表的字段-->
<update id="addColumn" parameterType="java.util.Map">
alter table ${tableName} add column ${columnName} ${columnType}
</update>
为什么?<!--统计报表查询sql-->
<select id="selectReportStatData" parameterType="java.util.Map" resultType="java.util.Map" statementType="STATEMENT">
select ${selectColumns} from ${tableName}
<if test="where != null and where != ''"> ${where} </if>
group by ${groupBy}
<if test="orderBy != null and orderBy != ''">${orderBy} </if>
</select>
联系客服