public static List findRezepte(Query q, Connection con) throws SQLException {
PreparedStatement stmt = null;
ResultSet rs = null;
try {
StatementBuilder builder = new StatementBuilder();
builder.add("id", q.getExpression("id"));
builder.add("name", q.getExpression("name"));
builder.add("anleitung", q.getExpression("anleitung"));
if (q.getResultType() == ResultType.NAMES) {
stmt = builder.buildQuery("select id, name from rezept", con);
return makeNameList(stmt.executeQuery());
} else {
stmt = builder.buildQuery("select id, name, anleitung, bzr_login from rezept ", con);
return makeObjectList(stmt.executeQuery());
}
} finally {
DbUtil.close(rs, stmt);
}
}
