Inteher类型为null时,自动拆箱[ 还是调用Integer.intValue() ]会报空指针异常.并不会向我们想象中的那样帮我们转成默认值
if ( Integer.valueOf(0).equals( dto.getFeeStatus() ) ) {
sql.append(" AND TO_DAYS(start_time) = TO_DAYS(now()) ");
}else if ( Integer.valueOf(1).equals( dto.getFeeStatus() ) ) {
sql.append(" AND TO_DAYS(start_time) = TO_DAYS(now())+1 ");
}else if ( Integer.valueOf(2).equals( dto.getFeeStatus() ) ) {
sql.append(" AND YEARWEEK(date_format(start_time,'%Y-%m-%d')) = YEARWEEK(now()) ");
}else {
sql.append(" AND date_format(start_time,'%Y-%m')=date_format(now(),'%Y-%m') ");
}