for循环里面进行数据库查询的处理

public class {
	public static void main(String[] args) {

		List<ProductPop> list = productDao.getProudctList(map);//获取产品列表

			if (list.size() > 0) {//如果列表为空

				Map<String, Object> map2 = new HashMap<String, Object>();

				List<String> proList =new ArrayList<String>();

				for (int i = 0; i < list.size(); i++) {

					ProductPop productPop = list.get(i);
					proList.add(productPop.getProduct_id());//把id放在新的list里面

					if (searcher!=null) {
						map2.put("status", searcher.getStatus());
					}
				}

				map2.put("products_id",proList);//把装id的list放在map里面

				List<GoodsPop> goodsPop = productDao.queryGoodsList(map2);//获取购物清单内容，map遍历放在方法里处理

				for (int i = 0; i < list.size(); i++) {

					ProductPop productPop = list.get(i);

					List<GoodsPop> goodsPopList=new ArrayList<GoodsPop>();

					for (GoodsPop goodsPop2 : goodsPop) {//list的超级循环

						if (productPop.getProduct_id().equals(goodsPop2.getProducts_id())) {
							//如果产品id和购物清单的id相同

							goodsPopList.add(goodsPop2);//新的购物清单生成
						}
					}
					productPop.setGoodsList(goodsPopList);//放入新的购物清单
				}
			}

			return list;
		}

	}