mybatis mysql in查询_MySQL使用 QueryWrapper查询条件in可以直接使用数字的

page = new Page<>(current, size);

QueryWrapperqw = new QueryWrapper<>();

if (beginDate != null && !beginDate.equals("") && endDate != null && !endDate.equals("")) {

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

try {

beginDate = beginDate.concat(BEGIN_TIME);

endDate = endDate.concat(END_TIME);

Date startTime = formatter.parse(beginDate);

Date endTime = formatter.parse(endDate);

qw.between("create_time", startTime, endTime);

} catch (ParseException e) {

e.printStackTrace();

}

}

if (status != null) {

qw.eq("status", status);

} else {

qw.in("status", 0,1,3,4);

}

if (eventCode != null) {

qw.eq("event_code", eventCode);

}

qw.orderByDesc("id");

return eventTagProcessMapper.selectPage(page, qw);