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

Introduction

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

Prototype

boolean next() throws InvalidResultSetAccessException;

Source Link

Document

Move the cursor to the next row.

Usage

From source file:repository.EventLogDAO.java

/**
 * Gets a count of the events in the Event Log, mainly for pagination
 * @return//  ww w .  j  av a  2  s  . c  o  m
 */
public int getEventsCount() {
    String sql = "SELECT COUNT(EventID) AS rowcount FROM interactions";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:repository.EventLogDAO.java

/**
 * Gets a map of Clients, mainly for adding and editing events
 * @return/*from   w  ww .j  a  va 2s .c o  m*/
 */
public Map<Integer, String> getClientsMap() {
    Map<Integer, String> clients = new LinkedHashMap<Integer, String>();
    String sql = "SELECT ClientID,First_Name,Last_Name FROM clients";

    SqlRowSet srs = template.queryForRowSet(sql);

    while (srs.next()) {
        clients.put(srs.getInt("ClientID"), srs.getString("First_Name") + " " + srs.getString("Last_Name"));
    }
    return clients;
}

From source file:repository.EventLogDAO.java

/**
 * Gets a map of Users, mainly for adding and editing events
 * @return// w ww.j av  a 2  s  .co m
 */
public Map<Integer, String> getUsersMap() {
    Map<Integer, String> users = new LinkedHashMap<Integer, String>();
    String sql = "SELECT UserID,Username FROM users";

    SqlRowSet srs = template.queryForRowSet(sql);

    while (srs.next()) {
        users.put(srs.getInt(1), srs.getString(2));
    }
    return users;
}

From source file:edu.mayo.cts2.uriresolver.dao.UriDAOJdbc.java

@Override
public String getIdentifierByID(String type, String id) {
    String resourceName = "";
    String sql = UriSQL.createSQLgetIdentifierByID(type, id);

    logger.info("getIdentifierByID");
    logger.info(sql);/*from  ww  w  .j  a  v a  2  s .  c  o  m*/

    SqlRowSet data = this.jdbcTemplateObject.queryForRowSet(sql);

    if (data.next()) {
        resourceName = data.getString("ResourceName");
        logger.info("resourceName: " + resourceName);

    } else {
        logger.info("data returned is NULL");
    }

    return resourceName;
}

From source file:edu.mayo.cts2.uriresolver.dao.UriDAOJdbc.java

@Override
public String getVersionIdentifierByVersionID(String type, String resourceName, String versionID) {
    String versionName = "";
    String sql = UriSQL.createSQLgetVersionIdentifierByVersionID(type, resourceName, versionID);

    logger.info("getVersionIdentifierByVersionID");
    logger.info(sql);/*from  ww w .  j  av  a 2s  . com*/

    SqlRowSet data = this.jdbcTemplateObject.queryForRowSet(sql);

    if (data.next()) {
        versionName = data.getString("VersionName");
        logger.info("versionName: " + versionName);

    } else {
        logger.info("data returned is NULL");
    }

    return versionName;
}

From source file:edu.mayo.cts2.uriresolver.dao.UriDAOJdbc.java

@Override
public UriResourceNames getAllResourceNames(String type) {
    UriResourceNames uriResourceNames = new UriResourceNames();
    List<String> resourceNames = new ArrayList<String>();

    String sql = UriSQL.createSQLgetAllResourceNames(type);

    logger.info("getAllResourceNames");
    logger.info(sql);/*from   w ww. j  a va2s . c  o  m*/

    SqlRowSet data = this.jdbcTemplateObject.queryForRowSet(sql);

    while (data.next()) {
        resourceNames.add(data.getString("resourcename"));
    }

    uriResourceNames.setResourceType(type);
    uriResourceNames.setResourceNames(resourceNames);
    return uriResourceNames;
}

From source file:edu.mayo.cts2.uriresolver.dao.UriDAOJdbc.java

@Override
public UriVersionIds getAllVersionIds(String type, String identifier) {
    UriVersionIds uriVersionIds = new UriVersionIds();
    List<String> versionIds = new ArrayList<String>();

    String sql = UriSQL.createSQLgetAllVersionIds(type, identifier);

    logger.info("getAllVersionIds");
    logger.info(sql);/*from www .ja v a 2s .  co m*/

    SqlRowSet data = this.jdbcTemplateObject.queryForRowSet(sql);

    while (data.next()) {
        versionIds.add(data.getString("versionid"));
    }

    uriVersionIds.setResourceType(type);
    uriVersionIds.setResourceName(identifier);
    uriVersionIds.setVersionIds(versionIds);
    return uriVersionIds;
}

From source file:com.fns.grivet.repo.JdbcEntityRepository.java

private List<EntityAttributeValue> mapRows(SqlRowSet rowSet) {
    List<EntityAttributeValue> result = new ArrayList<>();
    EntityAttributeValue eav = null;/*w ww  .  ja v  a 2  s .  c om*/
    if (rowSet != null) {
        while (rowSet.next()) {
            eav = EntityAttributeValue.of((Long) rowSet.getObject("eid"),
                    (Integer) rowSet.getObject("attribute_id"), (String) rowSet.getObject("attribute_name"),
                    (String) rowSet.getObject("attribute_value"),
                    ((Timestamp) rowSet.getObject("created_time")).toLocalDateTime(), getCurrentUsername());
            result.add(eav);
        }
    }
    Collections.sort(result, new EAVComparator());
    return result;
}

From source file:com.hs.mail.imap.dao.MySqlMessageDao.java

public Map<String, String> getHeader(long physMessageID, String[] fields) {
    String sql = "SELECT headername, headervalue FROM headername n, headervalue v WHERE v.physmessageid = ? AND v.headernameid = n.id AND n.headername IN ";
    Object[] param = new Object[fields.length + 1];
    param[0] = new Long(physMessageID);
    sql += duplicate(fields, param, 1);//  w w  w  .  j ava  2  s. c o  m
    Map<String, String> results = new HashMap<String, String>();
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(sql, param);
    while (rs.next()) {
        results.put(rs.getString(1), rs.getString(2));
    }
    return results;
}