java.sql.Statementとjava.sql.PreparedStatementについての性能テスト

/**
* Simple select preformance test.
*/
public void select() {
	// Get connection and create statement.
	Connection con = getConnection();
	Statement stmt = null;
	PreparedStatement pstmt = null;
	int numberOfSQL = 1000;
	int numberOfTests = 10;
	long startTime = 0;
	long endTime = 0;
	long totalTime = 0;
	float averageTime = 0.0F;
	try {
		// Statement Test.
		System.out.println("Test Statement...");
		for(int j=0;j<numberOfTests;j++){
			startTime = System.currentTimeMillis();
			for(int i=0;i<numberOfSQL;i++){
				String sql1 = "SELECT id FROM table WHERE value2="+i;
				stmt = con.createStatement();
				stmt.executeQuery(sql1);
		}
		endTime = System.currentTimeMillis();
		System.out.println("Time: " + (endTime-startTime) + " miliseconds");
		totalTime += (endTime-startTime);
	}
	averageTime = (float)(totalTime/numberOfTests);
	System.out.println("Total Time: " + totalTime + " miliseconds");
	System.out.println("Average Time: " + averageTime + " miliseconds");

	// PreparedStatement Test.
	totalTime = 0;
	System.out.println("Test PreparedStatement...");
	for(int j=0;j<numberOfTests;j++){
		startTime = System.currentTimeMillis();
		String sql2 = "SELECT id FROM table WHERE value2=?";
		pstmt = con.prepareStatement(sql2);
		for(int i=0;i<numberOfSQL;i++){
			pstmt.setInt(1,i);
			pstmt.executeQuery();
		}
		endTime = System.currentTimeMillis();
		System.out.println("Time: " + (endTime-startTime) + " miliseconds");
		totalTime += (endTime-startTime);
	}
	averageTime = (float)(totalTime/numberOfTests);
	System.out.println("Total Time: " + totalTime + " miliseconds");
	System.out.println("Average Time: " + averageTime + " miliseconds");

	} catch (Exception e) {
		e.printStackTrace();
	} finally {
	try {
		if(stmt!=null) stmt.close();
		if(pstmt!=null) pstmt.close();
		if(con!=null) con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}