mybatis查询参数为0且类型不是string的小问题

来源:互联网 发布:广州网络推广公司排名 编辑:程序博客网 时间:2024/05/10 23:32

jsp代码

<select class="form-control" id="status" name="status">    <option value="" selected="selected">单据状态</option>    <option value="0">已保存</option>    <option value="1">已经生成</option>    <option value="2">审核中</option>    <option value="3">已审核</option>    <option value="4">审核不通过</option>    <option value="5">作废</option></select>

java代码,status为Byte

public class AchievementComfirnWebDTO extends WebDTO {    private static final long serialVersionUID = 1L;    private Long detailId;    private Long id;    private String customerName;    private String customerPhone;    private Long orderId;    private Integer cityId;    private String companyName;    private String developerName;    private Integer houseId;    private String subscribeTimeStart;    private String subscribeTimeEnd;    private BigDecimal shouleMemberMoneyAll;    private BigDecimal shouleDeveloperMoneyAll;    private Byte status;

mybatis xml 代码

  1. 出错的
<if test="null != status">    AND A.STATUS = #{status}</if>
  1. 正确的
<if test="null != status and (status==0 ? '0' : status)">    AND A.STATUS = #{status}</if>用1查询不出结果,用2可以正常查询,假如status为string类型则无此问题。
0 0
原创粉丝点击