@@ -75,10 +75,9 @@ |
int pdrift_practice_score=0; |
String query; |
query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Leaching'" ; |
- if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ |
- System.out.println("String is not null"); |
- query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
- System.out.println(ip.plan_pract_variant); |
+ if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ |
+ query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
+ //System.out.println(ip.plan_pract_variant); |
//System.out.println(ip.AoAId); |
ResultSet results = statement.executeQuery(query); |
|
@@ -89,8 +88,8 @@ |
} |
query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Solution Runoff'" ; |
if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ |
- query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
- System.out.println(query); |
+ query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
+ //System.out.println(query); |
results = statement.executeQuery(query); |
|
while (results.next()) |
@@ -100,8 +99,8 @@ |
} |
query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Adsorbed Runoff'" ; |
if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ |
- query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
- System.out.println(query); |
+ query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
+ //System.out.println(query); |
results = statement.executeQuery(query); |
|
while (results.next()) |
@@ -111,8 +110,8 @@ |
} |
query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Drift'" ; |
if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ |
- query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
- System.out.println(query); |
+ query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");} |
+ //System.out.println(query); |
results = statement.executeQuery(query); |
|
while (results.next()) |