Example usage for org.springframework.jdbc.support.rowset SqlRowSet last

Introduction

In this page you can find the example usage for org.springframework.jdbc.support.rowset SqlRowSet last.

Prototype

boolean last() throws InvalidResultSetAccessException;

Source Link

Document

Move the cursor to the last row of this row set.

Usage

From source file:transaction.script.ProjectTrScript.java

/**
 * @param template/*ww  w .  j  a  v  a 2s  .  c o  m*/
 * @param query
 * @param conditionsMapList
 * @return
 * @throws SQLException
 */
public static boolean query(JdbcTemplate template, String query, List<Map<String, Object>> conditionsMapList)
        throws SQLException {
    logger.info("Query to execute is: " + query);

    SqlRowSet set = template.queryForRowSet(query);
    boolean result = true;

    SqlRowSetMetaData mdata = set.getMetaData();
    int columnAmount = mdata.getColumnCount();
    logger.info("Columns: " + columnAmount);
    logger.info("Map size: " + conditionsMapList.size());

    //TODO
    if (set.first()) {
        set.last();
        int rowNum = set.getRow();
        result = (rowNum == conditionsMapList.size());
        set.beforeFirst();
    } else {
        if (!conditionsMapList.get(0).isEmpty()) {
            result = false;
        }
    }

    logger.info("Two maps comparison result is " + result);

    if (result) {
        while (set.next()) {
            int rowNum = set.getRow();

            Map<String, Object> map = conditionsMapList.get(rowNum - 1);

            for (int i = 1; i <= columnAmount; i++) {
                result &= map.containsKey(mdata.getColumnName(i))
                        && map.get(mdata.getColumnName(i)).toString().equals(set.getObject(i).toString());
            }
        }
    }
    return result;
}

---

From source file:org.obiba.onyx.jade.instrument.topcon.EyeExtractor.java

public Map<String, Data> extractData(JdbcTemplate jdbc, String patientUUID) {
    log.info("Extracting Data");
    Map<String, Data> data = new HashMap<String, Data>();
    SqlRowSet mediaRowSet = jdbc.queryForRowSet(//
            "SELECT FileName, FileExt, StoragePathUid, CreateDate" + //
                    " FROM dbo.Media" + //
                    " WHERE PatientUid = ?" + //
                    " AND EyeType = ? " + //
                    " AND Status = 1 " + //
                    " AND Display = 1 " + //
                    " ORDER BY CreateDate ASC",
            new Object[] { patientUUID, getEyeTypeIntValue() });

    if (mediaRowSet.last()) {
        String storagePathUid = mediaRowSet.getString("StoragePathUid");
        String fileName = mediaRowSet.getString("FileName").trim();
        String extension = mediaRowSet.getString("FileExt").trim();
        String location = EyeExtractorQueryUtil.getLocation(jdbc, storagePathUid);

        byte[] imageByteArray = pathToByteArray(location, fileName, extension);
        data.put(EYE_PICT_VENDOR, new Data(DataType.DATA, imageByteArray));
        data.put(EYE_SIDE_VENDOR, new Data(DataType.TEXT, getSideName()));
    } else {/*w  w w .  j a  v a 2 s  .  c o m*/
        log.warn("Missing Picture");
    }
    return data;
}

---