示例:(竟然因为题目中有连着的中和共两个字判定为包含敏感词批量审核未通过!!!)
<select id="getHostByIp" resultMap="hostDomain" parameterType="string">
select
<include refid="Base_Column_List">
<property name="alias" value="h" />
</include>
,
c.CLUSTER_ID
from ms_host h
left join ms_host_cluster_rel c on
h.HOST_ID
= c.HOST_ID
where h.IP=#{ip}
order by
h.UPDATE_TIME
</select>
<sql id="Base_Column_List">
${alias}.HOST_ID,
${alias}.HOSTNAME,
${alias}.TYPE,
${alias}.IP,
${alias}.RMI_PORT,
${alias}.SOCKET_PORT,
${alias}.USERNAME,
${alias}.PASSWORD,
${alias}.WORKSPACE,
${alias}.REGISTRY_TIME,
${alias}.VERSION,
${alias}.AGENT_STATUS,
${alias}.RMI_STATUS,
${alias}.SOCKET_STATUS,
${alias}.UPDATE_TIME,
${alias}.ERROR_MSG
</sql>