FE1

最新推荐文章于 2023-02-28 15:31:26 发布

dalong3333

最新推荐文章于 2023-02-28 15:31:26 发布

阅读量90

点赞数

分类专栏： SQL Java 文章标签： java sql

本文链接：https://blog.csdn.net/dalong3333/article/details/84744926

版权

Java 同时被 2 个专栏收录

32 篇文章 0 订阅

订阅专栏

SQL

12 篇文章 0 订阅

订阅专栏

/**
 * 添加预案关联
 * @author ecy
 */	
	@Override
	public void addPlanGroupMap(Connection conn,PlanInfo planInfo) throws Exception {
		PreparedStatement pst = null;

		String addPlanGroupMapByPersonSQL = "insert into SNOW_PLAN_PERSON_MAP (GROUP_ID,PERSON_ID) VALUES(?,?)";
		pst = DBCommon.getPsm(conn, addPlanGroupMapByPersonSQL);
		if(planInfo.getPlanGroupList()!=null && planInfo.getPlanGroupList().size()>0){
			for(int i=0;i<planInfo.getPlanGroupList().size();i++){
				pst.setString(1, planInfo.getPlanGroupList().get(i).getGroupID());
				if(planInfo.getPlanGroupList().get(i).getPersonList()!=null && planInfo.getPlanGroupList().get(i).getPersonList().size()>0){
					for(int j=0;j<planInfo.getPlanGroupList().get(i).getPersonList().size();j++){
						pst.setString(2, planInfo.getPlanGroupList().get(i).getPersonList().get(j).getPersonID());
						pst.addBatch();
					}
				}
			}
			pst.executeBatch();
		}

		String addPlanGroupMapByCarSQL = "insert into SNOW_PLAN_CAR_MAP (GROUP_ID,CAR_ID) VALUES (?,?)";
		pst = DBCommon.getPsm(conn, addPlanGroupMapByCarSQL);
		if(planInfo.getPlanGroupList()!=null && planInfo.getPlanGroupList().size()>0){
			for(int i=0;i<planInfo.getPlanGroupList().size();i++){
				pst.setString(1, planInfo.getPlanGroupList().get(i).getGroupID());
				if(planInfo.getPlanGroupList().get(i).getCarList()!=null && planInfo.getPlanGroupList().get(i).getCarList().size()>0){
					for(int j=0;j<planInfo.getPlanGroupList().get(i).getCarList().size();j++){
						pst.setString(2, planInfo.getPlanGroupList().get(i).getCarList().get(j).getCarID());
						pst.addBatch();
					}
				}
			}
			pst.executeBatch();
		}

		String addPlanGroupMapByCommandCarSQL = "insert into SNOW_PLAN_COMMAND_CAR_MAP (GROUP_ID,COMMAND_CAR_ID) VALUES (?,?)";
		pst = DBCommon.getPsm(conn, addPlanGroupMapByCommandCarSQL);
		if(planInfo.getPlanGroupList()!=null && planInfo.getPlanGroupList().size()>0){
			for(int i=0;i<planInfo.getPlanGroupList().size();i++){
				pst.setString(1, planInfo.getPlanGroupList().get(i).getGroupID());
				if(planInfo.getPlanGroupList().get(i).getCommandCarList()!=null && planInfo.getPlanGroupList().get(i).getCommandCarList().size()>0){
					for(int j=0;j<planInfo.getPlanGroupList().get(i).getCommandCarList().size();j++){
						pst.setString(2, planInfo.getPlanGroupList().get(i).getCommandCarList().get(j).getCommandCarID());
						pst.addBatch();
					}
				}
			}
			pst.executeBatch();
		}

		String addPlanGroupMapByStockSQL = "insert into SNOW_PLAN_STOCK_MAP (GROUP_ID,STOCKID) VALUES (?,?)";
		pst = DBCommon.getPsm(conn, addPlanGroupMapByStockSQL);
		if(planInfo.getPlanGroupList()!=null && planInfo.getPlanGroupList().size()>0){
			for(int i=0;i<planInfo.getPlanGroupList().size();i++){
				pst.setString(1, planInfo.getPlanGroupList().get(i).getGroupID());
				if(planInfo.getPlanGroupList().get(i).getStockList()!=null && planInfo.getPlanGroupList().get(i).getStockList().size()>0){
					for(int j=0;j<planInfo.getPlanGroupList().get(i).getStockList().size();j++){
						pst.setString(2, planInfo.getPlanGroupList().get(i).getStockList().get(j).getStockID());
						pst.addBatch();
					}
				}
			}
			pst.executeBatch();
		}

		String addPlanGroupMapByAreaSQL = "insert into SNOW_PLAN_GROUP_AREA (ROAD_CODE,ROAD_NAME,direction,STAKE_START,STAKE_END,REMARKS,group_id,group_area_id) VALUES (?,?,?,?,?,?,?,?)";
		pst = DBCommon.getPsm(conn, addPlanGroupMapByAreaSQL);
		if(planInfo.getPlanGroupList()!=null && planInfo.getPlanGroupList().size()>0){
			for(int i=0;i<planInfo.getPlanGroupList().size();i++){
				if(planInfo.getPlanGroupList().get(i).getGroupAreaList()!=null && planInfo.getPlanGroupList().get(i).getGroupAreaList().size()>0){
					for(int j=0;j<planInfo.getPlanGroupList().get(i).getGroupAreaList().size();j++){
						String id = IDGenerator.generateUID();
						pst.setString(1, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getRoadCode());
						pst.setString(2, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getRoadName());
						pst.setString(3, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getDirection());
						pst.setString(4, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getStartStake());
						pst.setString(5, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getEndStake());
						pst.setString(6, planInfo.getPlanGroupList().get(i).getGroupAreaList().get(j).getRemarks());
						pst.setString(7, planInfo.getPlanGroupList().get(i).getGroupID());
						pst.setString(8, id);
						pst.addBatch();
					}
				}
			}
			pst.executeBatch();
		}

		if(pst!=null){
			pst.close();
		}

	}