Mr_ZhangAdd的博客

很多时候表与表之间是有关系的，比如一对一 一对多等等，也有的没有建立起 关系只是存了主键id 。此时多表查询可以使用left join代码如下： QUser qUser = QUser.user; QStudent qStudent = QStudent.student; String userName = "张三"; String bloodType = "AB"; Predicate predicate = qU

@Override public List<ProjectStatusDTO> getProjectStatus(Long departId) { QProject qProject = QProject.project; Predicate predicate = qProject.isNotNull().or(qProject.isNul...

/** * 查询项点的违占比 * * @param param * @return * @throws Exception */ @Override public BaseRecordDTO findRiskWeiZhanBi(SearchParam param) throws Exception { ...

首先感谢https://blog.youkuaiyun.com/qq_38230774/article/details/88870649和https://blog.youkuaiyun.com/qq_38230774/article/details/88870649和https://bbs.youkuaiyun.com/topics/392207536的资料先说需求 查询每个月的数据量是多少详细点： ...

predicate = StringUtils.isEmpty(param.getParam().get("start")) ? predicate : ExpressionUtils.and(predicate, qMonthcheckplan.start.goe(DateUtils.str2day(param.getParam().get("start").toString(...