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();
}
}
public static void dropTable() {
try {
DbDAO.dropTable();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void saveNamePrepared(ArrayList<String> names) {
try {
DbDAO.saveNamePrepared(names);
} catch (SQLException e) {
e.printStackTrace();
System.err.println("Failed to save names");
System.exit(1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.err.println("Failed to save names");
System.exit(1);
}
}
public static void saveNameNonPrepared(String name) {
try {
DbDAO.saveNameNonPrepared(name);
} catch (SQLException e) {
e.printStackTrace();
System.err.println("Failed to save name");
System.exit(1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.err.println("Failed to save name");
System.exit(1);
}
}
public static ArrayList<String> loadAllNamesNonPrepared() {
ArrayList<String> al = null;
try {
al = DbDAO.loadAllNamesNonPrepared();
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.err.println("Failed to load name");
System.exit(1);
} catch (SQLException e) {
e.printStackTrace();
System.err.println("Failed to load name");
System.exit(1);
}
return al;
}
public static String loadNameNonPrepared(String name) {
String result = null;
try {
result = DbDAO.loadNameNonPrepared(name);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.err.println("Failed to load name");
System.exit(1);
} catch (SQLException e) {
e.printStackTrace();
System.err.println("Failed to load name");
System.exit(1);
}
return result;
}
