这是mybatis配置文件
<sql id="UserSql">
<where>
<if test="orderSTATUS != null and orderSTATUS!= ''" >
and order_STATUS= #{orderSTATUS,jdbcType=VARCHAR}
</if>
</where>
</sql>
<select id="listorder" resultMap="orderResultMap" parameterType="com.luojian.bean.Order">
select * from gameorder <include refid="UserSql" />
</select>
实体类
private String orderSTATUS;
public String getOrderSTATUS() {
return orderSTATUS;
}
public void setOrderSTATUS(String orderSTATUS) {
this.orderSTATUS = orderSTATUS;
}