mybatis判断int是否为空的时候,需要注意的3点

public class ExcelPutVo {

  private Integer startTime; // 开始时间

  private Integer endTime; // 截止时间

  private int sentId; // 下达者id

  private String onlyUuid; // 唯一标识

  public int getSentId() {

  return sentId;

  }

  public void setSentId( int sentId) {

  this .sentId = sentId;

  }

  public String getOnlyUuid() {

  return onlyUuid;

  }

  public void setOnlyUuid(String onlyUuid) {

  this .onlyUuid = onlyUuid;

  }

  public Integer getStartTime() {

  return startTime;

  }

  public void setStartTime(Integer startTime) {

  this .startTime = startTime;

  }

  public Integer getEndTime() {

  return endTime;

  }

  public void setEndTime(Integer endTime) {

  this .endTime = endTime;

  }

<!-- 导出excel的数据查询 -->

  < select id = "selectByExcelPutVo" resultMap = "BaseResultMap"

  parameterType = "com.zeng.zhdj.wy.entity.vo.ExcelPutVo" >

  select *

  from count_use

  < where >

  1=1

  < if test = "sentId != null" >

  and sent_id=#{sentId,jdbcType=INTEGER}

  </ if >

  < if test = "endTime != null" >

  and count_end_month &lt;=#{endTime,jdbcType=INTEGER}

  </ if >

  < if test = "startTime!= null" >

  and count_start_month &gt;=#{startTime,jdbcType=INTEGER}

  </ if >

  < if test = "onlyUuid != null" >

  and only_type=#{onlyUuid,jdbcType=VARCHAR}

  </ if >

  </ where >

  </ select >