Question

iBatis中怎样按条件选择不同的表来执行查询

Answer 1

在配置文件里面就可以修改

<select id="getXXXX" resultClass="xxxxxVO" parameterClass="xxxVO">
select * from
<isEqual property="xxxVO.falg" compareValue="A">
tableA
</isEqual>
<isEqual property="xxxVO.falg" compareValue="B">
tableB
</isEqual>
<isEqual property="xxxVO.falg" compareValue="C">
tableC
</isEqual>

</select>

或者

<select id="getXXXX" resultClass="xxxxxVO" parameterClass="xxxVO">
<isEqual property="xxxVO.falg" compareValue="A">
select * from tableA
</isEqual>
<isEqual property="xxxVO.falg" compareValue="B">
select * from tableB
</isEqual>
<isEqual property="xxxVO.falg" compareValue="C">
select * from tableC
</isEqual>

</select>

返回字段可以用别名统一就可以了