Examples with CuSqlQuery edu.cornell.kfs.sys.util.CuSqlQuery used on opensource projects

Example 1 with CuSqlQuery

use of edu.cornell.kfs.sys.util.CuSqlQuery in project cu-kfs by CU-CommunityApps.

the class DocumentMaintenanceDaoJdbc method getActionNotesToBeRequeued.

@Override
public List<ActionItemNoteDetailDto> getActionNotesToBeRequeued() {
    CuSqlQuery sqlQuery = buildActionNoteQuery();
    RowMapper<ActionItemNoteDetailDto> actionItemNoteMapper = (resultSet, rowNum) -> {
        ActionItemNoteDetailDto actionItemNote = new ActionItemNoteDetailDto();
        actionItemNote.setPrincipalId(resultSet.getString(1));
        actionItemNote.setDocHeaderId(resultSet.getString(2));
        actionItemNote.setActionNote(resultSet.getString(3));
        actionItemNote.setNoteTimeStamp(resultSet.getTimestamp(4, Calendar.getInstance()));
        actionItemNote.setOriginalActionItemId(resultSet.getString(5));
        return actionItemNote;
    };
    return queryForValues(sqlQuery, actionItemNoteMapper);
}

Example 2 with CuSqlQuery

use of edu.cornell.kfs.sys.util.CuSqlQuery in project cu-kfs by CU-CommunityApps.

the class DocumentMaintenanceDaoJdbc method getDocumentRequeueValues.

@Override
public Collection<String> getDocumentRequeueValues() {
    CuSqlQuery sqlQuery = buildRequeueSqlQuery();
    RowMapper<String> documentIdMapper = (resultSet, rowNum) -> resultSet.getString(1);
    return queryForValues(sqlQuery, documentIdMapper);
}