错误写法:Hql +=" AND noVippolicy.zuidijine > "+ minMoney+" OR "+ minMoney+" < noVippolicy.zugaojine " ;
正确写法 Hql +=" AND ( noVippolicy.zuidijine < "+ maxMoney+" OR noVippolicy.zugaojine < "+maxMoney+" )" ;
错误效果:查询到多个重复的数据,一定要用括号括起来,不然就当是两个条件,会重复查询
正确写法 Hql +=" AND ( noVippolicy.zuidijine < "+ maxMoney+" OR noVippolicy.zugaojine < "+maxMoney+" )" ;
错误效果:查询到多个重复的数据,一定要用括号括起来,不然就当是两个条件,会重复查询