Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. String current_test = "base_test";
  2. String getFinalAVG = "SELECT AVG(cycle_average) FROM complete_cycle_times";
  3. ResultSet final1 = stmt.executeQuery(getFinalAVG);
  4. final1.next();
  5. double final_avg = final1.getDouble(1);
  6.  
  7. String getFinalWorst = "SELECT MAX(time) FROM complete_cycle_times";
  8. ResultSet final2 = stmt.executeQuery(getFinalWorst);
  9. final2.next();
  10. double final_worst = final2.getDouble(1);
  11.  
  12. String getFinalBest = "SELECT MIN(time) FROM complete_cycle_times";
  13. ResultSet final3 = stmt.executeQuery(getFinalBest);
  14. final3.next();
  15. double final_best = final3.getDouble(1);
  16.  
  17. String getFinalMedian = "SELECT time FROM complete_cycle_times ORDER BY time ASC";
  18. ResultSet final4 = stmt.executeQuery(getFinalMedian);
  19. final4.absolute(size/2);
  20. double final_median = final4.getDouble(1);
  21.  
  22. String insertFinal = "INSERT INTO final_test_times_rd (test_name, average_time, worst_case, best_case, median_time)"
  23. + " VALUES (" + current_test + ", " + final_avg + ", " + final_worst + ", " + final_best + ", " + final_median + ")";
  24. stmt.executeUpdate(insertFinal);
  25.  
  26. con.commit();
  27.  
  28. resetTable(con, "complete_cycle_times");
  29. return true;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement