public List<Document> getAll() {
List<Document> result = new ArrayList<Document>();
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
Document document = null;
Type type = null;
try {
connection = dataSource.getConnection();
statement = connection.createStatement();
resultSet = statement.executeQuery(queryAll);
while (resultSet.next()) {
document = new Document();
document.setDocumentId(resultSet.getString("documentId"));
document.setName(resultSet.getString("name"));
document.setLocation(resultSet.getString("location"));
document.setCreated(resultSet.getDate("created"));
document.setModified(resultSet.getDate("modified"));
document.setDescription("doc_desc");
type = new Type();
type.setTypeId(resultSet.getString("typeId"));
type.setName(resultSet.getString("type_name"));
type.setDesc(resultSet.getString("type_desc"));
type.setExtension(resultSet.getString("extension"));
document.setType(type);
result.add(document);
}
} catch (SQLException ex) {
throw new RuntimeException(ex);
} finally {
if (null != connection) {
try {
connection.close();
} catch (SQLException ex) {
}
}
}
return result;
}
