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

List of usage examples for org.springframework.jdbc.support.rowset SqlRowSet getObject

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.support.rowset.*
  5. SqlRowSet
  6. getObject

Introduction

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

Prototype

Object getObject(String columnLabel) throws InvalidResultSetAccessException;

Source Link

Document

Retrieve the value of the indicated column in the current row as an Object.

Usage

From source file:flywayspike.Main.java

/**
 * Runs the sample.//from  w w  w. j a v a 2 s.c  om
 *
 * @param args None supported.
 */
public static void main(String[] args) throws Exception {
    DataSource dataSource = new SimpleDriverDataSource(new org.hsqldb.jdbcDriver(),
            "jdbc:hsqldb:file:db/flyway_sample;shutdown=true", "SA", "");
    Flyway flyway = new Flyway();
    flyway.setDataSource(dataSource);
    flyway.setLocations("flywayspike.migration", "abcd");
    flyway.clean();

    System.out.println("Started Migration");
    flyway.migrate();
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> results = jdbcTemplate.queryForList("select name from test_user");
    for (Map<String, Object> result : results) {
        System.out.println("Name: " + result.get("NAME"));
    }

    SqlRowSet rowSet = jdbcTemplate.queryForRowSet("select * from schema_version");
    while (rowSet.next()) {
        System.out.print(rowSet.getObject(1));
        System.out.println("  " + rowSet.getObject(2));
    }
}

From source file:net.kamhon.ieagle.jdbc.oracle.OracleUtil.java

/**
 * /*from   ww w  .j  av  a  2  s.  com*/
 * @param rowSet
 * @param fieldName
 * @return
 */
public static Date getDate(SqlRowSet rowSet, String fieldName) {
    Date date = null;

    Object object = rowSet.getObject(fieldName);
    if (object instanceof TIMESTAMP) {
        TIMESTAMP timestamp = (TIMESTAMP) object;
        try {
            date = new Date(timestamp.dateValue().getTime());
        } catch (Exception ex) {
        }
    } else if (object instanceof Timestamp) {
        Timestamp timestamp = (Timestamp) object;
        date = new Date(timestamp.getTime());
    } else if (object instanceof java.sql.Date) {
        java.sql.Date sqlDate = (java.sql.Date) object;
        date = new Date(sqlDate.getTime());
    }

    return date;
}

From source file:org.restsql.core.impl.SqlUtils.java

public static Object getObjectByColumnLabel(final ColumnMetaData column, final SqlRowSet resultSet) {
    Object value = null;//  w  w  w  .  j a  v  a  2s . c o  m
    if (column.getColumnType() == Types.DATE && column.getColumnTypeName().equals("YEAR")) {
        value = new Integer(resultSet.getInt(column.getColumnLabel()));
        if (resultSet.wasNull()) {
            value = null;
        }
    } else {
        value = resultSet.getObject(column.getColumnLabel());
    }

    return value;
}

From source file:org.restsql.core.impl.SqlUtils.java

public static Object getObjectByColumnNumber(final ColumnMetaData column, final SqlRowSet resultSet) {
    Object value = null;/*from   w  ww.j av a 2 s  .c om*/
    if (column.getColumnType() == Types.DATE && column.getColumnTypeName().equals("YEAR")) {
        value = new Integer(resultSet.getInt(column.getColumnNumber()));
        if (resultSet.wasNull()) {
            value = null;
        }
    } else {
        value = resultSet.getObject(column.getColumnNumber());
    }
    return value;
}

From source file:org.owasp.proxy.http.dao.JdbcMessageDAOTest.java

private static void dump(String sql) {
    logger.fine("\n" + sql);
    SqlRowSet rs = dao.getJdbcTemplate().queryForRowSet(sql);
    try {/*  ww w.  ja  v  a 2  s.  co  m*/
        SqlRowSetMetaData rsmd = rs.getMetaData();
        int c = rsmd.getColumnCount();
        StringBuffer buff = new StringBuffer();
        for (int i = 1; i <= c; i++) {
            buff.append(rsmd.getColumnLabel(i));
            buff.append(i == c ? "\n" : "\t");
        }
        logger.fine(buff.toString());
        buff.delete(0, buff.length());
        while (rs.next()) {
            for (int i = 1; i <= c; i++) {
                buff.append(rs.getObject(i));
                buff.append(i == c ? "\n" : "\t");
            }
            logger.fine(buff.toString());
            buff.delete(0, buff.length());
        }
        logger.fine("================\n\n");
    } catch (Exception e) {
        e.printStackTrace();
    }
}

From source file:org.beangle.ems.avatar.service.DataBaseAvatarBase.java

protected byte[] getBytes(String name) {
    SqlRowSet rowSet = jdbcTemplate.queryForRowSet(sql, name);
    Blob obj = null;//from ww  w  . j ava  2  s .  c  o m
    if (rowSet.next()) {
        obj = (Blob) rowSet.getObject(1);
        try {
            return obj.getBytes(1L, (int) obj.length());
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    } else {
        return null;
    }
}

From source file:transaction.script.ProjectTrScript.java

/**
 * @param template/*ww w.  ja v a2 s. 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:au.com.jwatmuff.genericdb.p2p.DatabaseUpdateStore.java

@Override
public Update loadUpdate() throws IOException {
    Update update = new Update();

    log.debug("Loading update data");
    SqlRowSet rows = template.queryForRowSet("SELECT data FROM update_log");
    while (rows.next()) {
        try {//from w ww  .ja  v a 2s .co m
            byte[] bytes = (byte[]) rows.getObject(1);
            //                Serializable object = ObjectCopier.bytesToObject(bytes);
            Object object = FST_CONFIG.asObject(bytes);

            if (object instanceof Update) {
                log.debug(object);
                try {
                    update.mergeWith((Update) object);
                } catch (RuntimeException e) {
                    if (update.size() > 0) {
                        log.error(
                                "POSSIBLE DATA CORRUPTION - Failed to merge update during load, may be due to out-of-order updates",
                                e);
                    } else {
                        log.error(
                                "Failed to merge update during load, but update was empty so no harm was done (check for other error messages though)");
                    }
                }
            }
            if (object instanceof UpdatePosition) {
                log.debug(object);
                committedPosition = (UpdatePosition) object;
            }
        } catch (InvalidResultSetAccessException e) {
            log.error("Error processing update log", e);
        }
    }

    log.debug("Finished update load");

    return update;
}

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

private List<EntityAttributeValue> mapRows(SqlRowSet rowSet) {
    List<EntityAttributeValue> result = new ArrayList<>();
    EntityAttributeValue eav = null;//from   w  w  w . j a v a 2  s .co m
    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:nl.surfnet.coin.teams.service.impl.GroupProviderServiceSQLImpl.java

/**
 * Gets the allowed options for a Group Provider
 *
 * @param groupProvider {@link GroupProvider}
 * @return Map with allowed options/* www.j a v  a 2 s .  c o m*/
 */
private Map<String, Object> getAllowedOptions(GroupProvider groupProvider) {
    Object[] args = { groupProvider.getId() };

    Map<String, Object> options = new HashMap<String, Object>();

    final SqlRowSet sqlRowSet = this.jdbcTemplate.queryForRowSet("SELECT gp_option.name, gp_option.value "
            + "FROM group_provider_option AS gp_option " + "WHERE gp_option.group_provider_id = ?;", args);

    while (sqlRowSet.next()) {
        options.put(sqlRowSet.getString("name"), sqlRowSet.getObject("value"));
    }
    return options;
}