public void getDescriptionsByCharacter(String sCharacter)
throws SQLException, SAXException, IOException {
String sSql =
"SELECT hydc2.description FROM hydc2 AS hydc2, hydc3 AS hydc3 "
+ "WHERE hydc2.gbk = hydc3.gbk AND hydc3.unicode = ?";
PreparedStatement statement = connection.prepareStatement(sSql);
statement.setInt(1, sCharacter.codePointAt(0));
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
controller.setDescriptionByCharacter(resultSet.getClob("description"));
}
resultSet.close();
statement.close();
}
