A Tour of Paradigms - Java Closures and Lambda - page 167

while (rs.next()) {
if (lineNumber % 20 == 0) {
System.out.println("text\tline-offset\tword\tword-offset");
System.out.println("----\t-----------\t----\t-----------");
}
lineNumber += 1;
String text = rs.getString(1);
if (!text.equals(lastText)) {
lastText = text;
}
int lineOffset = rs.getInt(2);
String word = rs.getString(3);
int wordOffset = rs.getInt(4);
if (lineOffset != lastLine) {
lastLine = lineOffset;
}
System.out.println(
String.format("%s\t%d\t%s\t%d", text, lineOffset, word, wordOffset));
}
}
}
public static void main(String[] args) throws Exception {
ShakespeareAnthologyParser textParser = new ShakespeareAnthologyParser();
Collection<ShakespeareText> texts = textParser.parseTexts();
TextDatabase db = new TextDatabase("shakespeare");
db.createDatabase();
db.insertTexts(texts);
printWordUsages(db.getConnection());
printDatabaseSizing(db.getConnection());
}
}
### TextDatabase.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;
/**
* Represents the database for holding texts, their lines, and words.
*/
public class TextDatabase {
private final String schema;