Displaying differences for changeset
 
display as  

src/java/m/wqm/pesthazrating/V1_0.java

@@ -43,8 +43,6 @@
     private String aoa_phr_adrun_stvfish;
     
     private String error_msg;
-    private Connection conn;
-    private Statement statement;
     
     
     @Override
@@ -60,8 +58,6 @@
             
             this.components=new ArrayList<>(); 
             this.result1=new ArrayList<>();  
-            this.conn = null;
-            this.statement = null;
             
             try{
                 JSONArray groups = getJSONArrayParam("pestcomponents");
@@ -91,9 +87,8 @@
         {
             String eat_rating_human=null;
             if ( this.error_msg.isEmpty() ){            
-                try{
-                    conn = wqm.utils.WQMTools.getConnection("wqm", LOG );
-                    statement = conn.createStatement();                    
+                try(Connection conn = wqm.utils.WQMTools.getConnection("wqm", LOG);
+                    Statement statement = conn.createStatement();){
                     
                     for(V1_0.Input ip:components){                    
                         if(ip.ai_eathuman<1){