Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String current_test = "base_test";
- String getFinalAVG = "SELECT AVG(cycle_average) FROM complete_cycle_times";
- ResultSet final1 = stmt.executeQuery(getFinalAVG);
- final1.next();
- double final_avg = final1.getDouble(1);
- String getFinalWorst = "SELECT MAX(time) FROM complete_cycle_times";
- ResultSet final2 = stmt.executeQuery(getFinalWorst);
- final2.next();
- double final_worst = final2.getDouble(1);
- String getFinalBest = "SELECT MIN(time) FROM complete_cycle_times";
- ResultSet final3 = stmt.executeQuery(getFinalBest);
- final3.next();
- double final_best = final3.getDouble(1);
- String getFinalMedian = "SELECT time FROM complete_cycle_times ORDER BY time ASC";
- ResultSet final4 = stmt.executeQuery(getFinalMedian);
- final4.absolute(size/2);
- double final_median = final4.getDouble(1);
- String insertFinal = "INSERT INTO final_test_times_rd (test_name, average_time, worst_case, best_case, median_time)"
- + " VALUES (" + current_test + ", " + final_avg + ", " + final_worst + ", " + final_best + ", " + final_median + ")";
- stmt.executeUpdate(insertFinal);
- con.commit();
- resetTable(con, "complete_cycle_times");
- return true;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement