mybatis-plus 平常用到的语句记录

发布时间 2023-04-07 09:45:19作者: 全琪俊
//当前时间
Date date = DateUtil.date();
String dateStr = DateUtil.format(date, "yyyy-MM-dd");

sysLogLambdaQueryWrapperhydl.apply("DATE_FORMAT(create_time,'%Y-%m-%d') = '"+dateStr+"'");

sysUserLambdaQueryWrapper.apply("AND (YEAR(CURDATE())-YEAR(birth_day)+1) = " + sysUserVO.getUserAge() );

sysNoticeMsgQueryWrapperYes.lambda().and(wrapper -> wrapper.eq(SysNoticeMsg::getDataId, userId).or().eq(SysNoticeMsg::getCreateBy, userId));