原代碼：

QueryWrapper<entity> queryWrapper = QueryGenerator.initQueryWrapper(entity, null); listQueryWrapperFun(req,queryWrapper);private void listQueryWrapperFun(HttpServletRequest req,QueryWrapper<entity> initQueryWrapper){String time = req.getParameter("time");initQwrapper(initQueryWrapper,time) }

接下來(lái)使用listQueryWrapperFun()方法對(duì)前端接收的數(shù)據(jù)進(jìn)行拼接給到initQwrapper()方法進(jìn)行條件查詢(xún)組裝

private void initQwrapper(QueryWrapper<entity>) initQueryWrapper,String time){//判空if(StringUtils.isNotBlank(time)) {initQueryWrapper.eq("time", time);} }

數(shù)據(jù)庫(kù)執(zhí)行的sql為：

select * from 表名 where time = ? and time = ?

解決寫(xiě)法：直接實(shí)例化QueryWrapper

QueryWrapper<entity> queryWrapper = new QueryWrapper<>();

或者在實(shí)體類(lèi)中把time屬性設(shè)為null

entity.setTime(null); QueryWrapper<entity> queryWrapper = QueryGenerator.initQueryWrapper(entity, null); listQueryWrapperFun(req,queryWrapper);private void listQueryWrapperFun(HttpServletRequest req,QueryWrapper<entity> initQueryWrapper){String time = req.getParameter("time");initQwrapper(initQueryWrapper,time) }

總結(jié)

以上是生活随笔為你收集整理的jeecg框架MybatisPlus出现查询条件重复现象的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。