| @@ -78,12 +78,15 @@ |
| |
| for (Input ip : components) { |
| |
| - query = "SELECT wqm_ilp FROM wqm_soil_pest_interaction_leaching WHERE wqm_plp='" + ip.ai_plp + "'AND wqm_slp='" + ip.aoa_pslp + "';"; |
| + query = "SELECT wqm_ilp FROM wqm_soil_pest_interaction_leaching WHERE wqm_plp='" + ip.ai_plp + "' AND wqm_slp='" + ip.aoa_pslp + "';"; |
| resultSet = statement.executeQuery(query); |
| String op_pest_ilp = "err"; |
| while (resultSet.next()) { |
| op_pest_ilp = resultSet.getString("wqm_ilp"); |
| } |
| + System.out.println("ip.ai_plp = " + ip.ai_plp); |
| + System.out.println("ip.aoa_pslp = " + ip.aoa_pslp); |
| + System.out.println("op_pest_ilp = " + op_pest_ilp); |
| if (ip.aoa_rain_prob.equals("LOW")) { |
| switch (op_pest_ilp) { |
| case "HIGH": |
| @@ -98,12 +101,15 @@ |
| } |
| } |
| |
| - query = "SELECT wqm_isrp FROM wqm_soil_pest_interaction_solution_runoff WHERE wqm_psrp='" + ip.ai_psrp + "'AND wqm_ssrp ='" + ip.aoa_ssrp + "';"; |
| + query = "SELECT wqm_isrp FROM wqm_soil_pest_interaction_solution_runoff WHERE wqm_psrp='" + ip.ai_psrp + "' AND wqm_ssrp ='" + ip.aoa_ssrp + "';"; |
| resultSet = statement.executeQuery(query); |
| String op_pest_isrp = "err"; |
| while (resultSet.next()) { |
| op_pest_isrp = resultSet.getString("wqm_isrp"); |
| } |
| + System.out.println("ip.ai_psrp = " + ip.ai_psrp); |
| + System.out.println("ip.aoa_ssrp = " + ip.aoa_ssrp); |
| + System.out.println("op_pest_isrp = " + op_pest_isrp); |
| if (ip.aoa_rain_prob.equals("LOW")) { |
| switch (op_pest_isrp) { |
| case "HIGH": |
| @@ -112,18 +118,18 @@ |
| case "INTERMEDIATE": |
| op_pest_isrp = "LOW"; |
| break; |
| - case "LOW": |
| - op_pest_isrp = "VERY LOW"; |
| - break; |
| } |
| } |
| |
| - query = "SELECT wqm_iarp FROM wqm_soil_pest_interaction_adsorbed_runoff WHERE wqm_parp='" + ip.ai_parp + "'AND wqm_sarp='" + ip.aoa_sarp + "';"; |
| + query = "SELECT wqm_iarp FROM wqm_soil_pest_interaction_adsorbed_runoff WHERE wqm_parp='" + ip.ai_parp + "' AND wqm_sarp='" + ip.aoa_sarp + "';"; |
| resultSet = statement.executeQuery(query); |
| String op_pest_iarp = "err"; |
| while (resultSet.next()) { |
| op_pest_iarp = resultSet.getString("wqm_iarp"); |
| } |
| + System.out.println("ip.ai_parp = " + ip.ai_parp); |
| + System.out.println("ip.aoa_sarp = " + ip.aoa_sarp); |
| + System.out.println("op_pest_iarp = " + op_pest_iarp); |
| if (ip.aoa_rain_prob.equals("LOW")) { |
| switch (op_pest_iarp) { |
| case "HIGH": |
| @@ -132,9 +138,6 @@ |
| case "INTERMEDIATE": |
| op_pest_iarp = "LOW"; |
| break; |
| - case "LOW": |
| - op_pest_iarp = "VERY LOW"; |
| - break; |
| } |
| } |
| |