java 区域表三级检索 if 判断

最新推荐文章于 2025-01-16 10:06:45 发布

原创最新推荐文章于 2025-01-16 10:06:45 发布 · 1.4k 阅读

1 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

47 篇文章

订阅专栏

注：仅供参考，多多指点，若有更好的方法，提高效率的，请留下你的思路。。。。

if(area != 0){
			//判断有没有二级
			if(this.areaList(area).size() != 0){
				if(area1 != 0){
					//判断有没有三级
					if(this.areaList(area1).size() != 0){
						if(area2 != 0){
							hql += " and region ="+area2;
							hqlCount += " and region ="+area2;
						}else{
							hql += " and region in (select countryAreaId from Area where parentId ="+area1+")";
							hqlCount += " and region in (select country_area_id from area where parent_id ="+area1+")";
						}
					}else{
						hql += " and region ="+area1;
						hqlCount += " and region ="+area1;
					}
				}else{
					hql += " and region in (select countryAreaId from Area where parentId in (select countryAreaId from Area where parentId="+area+"))";
					hqlCount += " and region in (select country_area_id from area where parent_id in (select country_area_id from area where parent_id="+area+"))";
				}
			}else{
				hql += " and region ="+area;
				hqlCount += " and region ="+area;
			}
		}