public static void main(String[] args) {
try {
// Create the table
DbDAO.createTable();
// Save 1000 names with nonprepared statements
double nonPreparedSave;
StopWatch sw = new StopWatch();
for (int i = 0; i < 1000; i++) saveNameNonPrepared("person" + i);
nonPreparedSave = sw.elapsedTime();
// Reset the table
dropTable();
DbDAO.createTable();
// Save 1000 names with prepared statements
double preparedSave;
ArrayList<String> names = new ArrayList<String>();
for (int i = 0; i < 1000; i++) names.add("person" + i);
sw = new StopWatch();
saveNamePrepared(names);
preparedSave = sw.elapsedTime();
// Print af test af 1000 saves
System.out.println(
"1000 names saved! \nNonprepared: " + nonPreparedSave + "\nPrepared: " + preparedSave);
// Load 1000 names nonprepared ( We use that the table consists of the 1000 names from the
// arraylist names)
double nonPreparedLoad;
sw = new StopWatch();
for (String s : names) loadNameNonPrepared(s);
nonPreparedLoad = sw.elapsedTime();
// Load 1000 names prepared ( We use the arraylist names again )
double preparedLoad;
sw = new StopWatch();
loadNamesPrepared(names);
preparedLoad = sw.elapsedTime();
// Print af test af 1000 saves
System.out.println(
"1000 names loaded! \nNonprepared: " + nonPreparedLoad + "\nPrepared: " + preparedLoad);
// Reset table again
dropTable();
} catch (SQLException e) {
e.printStackTrace();
}
}
