首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java相关 >

hql用到or时的有关问题

2012-05-01 
hql用到or时的问题String hql0 select m from Materials m,Bill b1,Bill b2 where b1.billtype ENTE

hql用到or时的问题
String hql0 = "select m from Materials m,Bill b1,Bill b2 where b1.billtype = 'ENTER' and b2.billtype = 'EXIT' and m in elements(b1.materials) or m in elements(b2.materials) ";
本hql语句在b2不为null时能得到正确的结果,但是当b2为null时得到的结果页为nul,我要得到的结果是在b2为null时得到正确的结果

[解决办法]
String hql0 = "";
if(b2 != null){
hql0 = "select m from Materials m,Bill b1,Bill b2 where b1.billtype = 'ENTER' and b2.billtype = 'EXIT' and m in elements(b1.materials) or m in elements(b2.materials) ";

}else{
hql0 = "select m from Materials m,Bill b1,Bill b2 where b1.billtype = 'ENTER' and b2.billtype = 'EXIT' and m in elements(b1.materials) 
}

热点排行