java 区域表三级检索 if 判断

最新推荐文章于 2023-02-12 14:09:09 发布

OnePiece_Sky

最新推荐文章于 2023-02-12 14:09:09 发布

阅读量1.3k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/liujava621/article/details/32700957

版权

java 专栏收录该内容

47 篇文章 1 订阅

订阅专栏

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

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;
			}
		}