<select id="selHisSettlement" resultType="org.his.beans.HisSettlement">
select * from HisSettlement
<where>
<if test="StartDate!=null and StartDate!=''">
AND POSJYSJ >= #{StartDate}
</if>
<if test="EndDate!=null and EndDate!=''">
AND POSJYSJ <= #{EndDate}
</if>
</where>
</select>
public String selHis(@Param("StartDate")String StartDate,@Param("EndDate")String EndDate) {
try {
List<HisSettlement> settlement = service.selHisSettlement(StartDate, EndDate);