Oracle多表连接实现单个表内元素查询所有内容

根据分类一查询商品

select * from dangdang_product t1 left join dangdang_category2 t2 on t1.dd_category2_id=t2.dd_category2_id
left join dangdang_category1 t3 on t2.dd_category1_id=t3.dd_category1_id where t3.dd_category1_id=1

根据分类二查询商品

select * from dangdang_product t1 
       left join dangdang_category2 t2 on t1.dd_category2_id =t2.dd_category2_id
        where t2.dd_category2_id =101

后台实现代码
由于分类一为一位数，分类二为三位数添加if判断

if (id>100) {
			List<product> list2 = productDao.selectBycategory2id(id);
			request.setAttribute("productList", list2);
		}else {
			List<product> list2 = productDao.selectBycategory1id(id);
			request.setAttribute("productList", list2);
		}