public JwSqlSelect getSelectCount() {
JwSqlSelect st = createSelect();
st.selectCount();
st.from(TABLE, ALIAS);
return st;
}
/** Return the maximum ID; return null if the table is empty. */
public Integer getMaximumId() {
JwSqlSelect st = createSelect();
st.selectMaximum(ALIAS, ID);
st.from(TABLE, ALIAS);
return composeFirstInteger(st);
}
public JwSqlSelect getSelect() {
JwSqlSelect st = createSelect();
populateSelectColumnsToCompose(st, ALIAS);
st.from(TABLE, ALIAS);
return st;
}
public JwList<Integer> getAllIds() {
JwSqlSelect st = createSelect();
st.selectInteger(ALIAS, ID);
st.from(TABLE, ALIAS);
return composeIntegerList(st);
}