Example usage for org.springframework.jdbc.support JdbcUtils getResultSetValue

Introduction

In this page you can find the example usage for org.springframework.jdbc.support JdbcUtils getResultSetValue.

Prototype

@Nullable
public static Object getResultSetValue(ResultSet rs, int index, @Nullable Class<?> requiredType)
        throws SQLException 

Source Link

Document

Retrieve a JDBC column value from a ResultSet, using the specified value type.

Usage

From source file:com.sinosoft.one.data.jade.rowmapper.ArrayRowMapper.java

public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Object array = Array.newInstance(componentType, columnSize);
    for (int i = 0; i < columnSize; i++) {
        Object value = JdbcUtils.getResultSetValue(rs, (i + 1), componentType);
        Array.set(array, i, value);
    }//from   ww  w .  j  a  v  a2  s  .  co  m
    return array;
}

---

From source file:com.gzj.tulip.jade.rowmapper.ArrayRowMapper.java

@Override
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Object array = Array.newInstance(componentType, columnSize);
    for (int i = 0; i < columnSize; i++) {
        Object value = JdbcUtils.getResultSetValue(rs, (i + 1), componentType);
        Array.set(array, i, value);
    }//from   ww w.j  a v  a 2  s . co  m
    return array;
}

---

From source file:ch.digitalfondue.npjt.mapper.DefaultMapper.java

public Object getObject(ResultSet rs) throws SQLException {
    int columnIdx = rs.findColumn(name);
    return JdbcUtils.getResultSetValue(rs, columnIdx, paramType);
}

---

From source file:com.wantscart.jade.core.mapper.AbstractCollectionRowMapper.java

@Override
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Collection<Object> collection = createCollection(columnSize);
    // columnIndex1
    for (int columnIndex = 1; columnIndex <= columnSize; columnIndex++) {
        collection.add(JdbcUtils.getResultSetValue(rs, columnIndex, elementType));
    }/*from w w w . j  ava 2 s  .com*/
    return collection;
}

---

From source file:com.gzj.tulip.jade.rowmapper.AbstractCollectionRowMapper.java

@Override
@SuppressWarnings("unchecked")
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Collection collection = createCollection(columnSize);
    // columnIndex1
    for (int columnIndex = 1; columnIndex <= columnSize; columnIndex++) {
        collection.add(JdbcUtils.getResultSetValue(rs, columnIndex, elementType));
    }/* w  w w .  j a  va 2 s  .  c  o m*/
    return collection;
}

---

From source file:com.sinosoft.one.data.jade.rowmapper.AbstractCollectionRowMapper.java

@SuppressWarnings("unchecked")
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Collection collection = createCollection(columnSize);
    // columnIndex1
    for (int columnIndex = 1; columnIndex <= columnSize; columnIndex++) {
        collection.add(JdbcUtils.getResultSetValue(rs, columnIndex, elementType));
    }//from ww  w  .  j a  v a  2  s.c  om
    return collection;
}

---

From source file:com.laxser.blitz.lama.core.mapper.AbstractCollectionRowMapper.java

@Override
@SuppressWarnings({ "unchecked", "rawtypes" })
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    int columnSize = rs.getMetaData().getColumnCount();
    Collection collection = createCollection(columnSize);
    // columnIndex1
    for (int columnIndex = 1; columnIndex <= columnSize; columnIndex++) {
        collection.add(JdbcUtils.getResultSetValue(rs, columnIndex, elementType));
    }//from w  w  w  . j av  a  2s. c  o m
    return collection;
}

---

From source file:com.gzj.tulip.jade.rowmapper.MapEntryRowMapper.java

@Override
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    if (rowNum == 0) {
        if (StringUtils.isNotEmpty(keyColumn)) {
            keyColumnIndex = rs.findColumn(keyColumn);
            if (keyColumnIndex <= 0) {
                throw new IllegalArgumentException(
                        String.format("wrong key name %s for method: %s ", keyColumn, modifier.getMethod()));
            }//  ww  w  . ja  v  a 2 s  . c  o m
            keyColumn = null;
        }

        if (logger.isDebugEnabled()) {
            logger.debug(String.format("keyIndex=%s; for method: %s ", keyColumnIndex, modifier.getMethod()));
        }
    }

    //   JDBC ResultSet ? Key
    Object key = JdbcUtils.getResultSetValue(rs, keyColumnIndex, keyType);
    if (key != null && !keyType.isInstance(key)) {
        ResultSetMetaData rsmd = rs.getMetaData();
        throw new TypeMismatchDataAccessException( // NL
                "Type mismatch affecting row number " + rowNum + " and column type '"
                        + rsmd.getColumnTypeName(keyColumnIndex) + "' expected type is '" + keyType + "'");
    }

    return new MapEntryImpl<Object, Object>(key, mapper.mapRow(rs, rowNum));
}

---

From source file:com.sinosoft.one.data.jade.rowmapper.MapEntryRowMapper.java

public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    if (rowNum == 0) {
        if (StringUtils.isNotEmpty(keyColumn)) {
            keyColumnIndex = rs.findColumn(keyColumn);
            if (keyColumnIndex <= 0) {
                throw new IllegalArgumentException(
                        String.format("wrong key name %s for method: %s ", keyColumn, modifier.getMethod()));
            }/*from   w w w. j av  a 2  s.c om*/
            keyColumn = null;
        }

        if (logger.isDebugEnabled()) {
            logger.debug(String.format("keyIndex=%s; for method: %s ", keyColumnIndex, modifier.getMethod()));
        }
    }

    //   JDBC ResultSet ? Key
    Object key = JdbcUtils.getResultSetValue(rs, keyColumnIndex, keyType);
    if (key != null && !keyType.isInstance(key)) {
        ResultSetMetaData rsmd = rs.getMetaData();
        throw new TypeMismatchDataAccessException( // NL
                "Type mismatch affecting row number " + rowNum + " and column type '"
                        + rsmd.getColumnTypeName(keyColumnIndex) + "' expected type is '" + keyType + "'");
    }

    return new MapEntryImpl<Object, Object>(key, mapper.mapRow(rs, rowNum));
}

---

From source file:com.gzj.tulip.jade.rowmapper.MapEntryColumnRowMapper.java

public Object mapRow(ResultSet rs, int rowNum) throws SQLException {

    // ?/*from   w w w. j  a  v a 2  s  .  c o m*/
    if (rowNum == 0) {
        ResultSetMetaData rsmd = rs.getMetaData();
        int nrOfColumns = rsmd.getColumnCount();
        if (nrOfColumns != 2) {
            throw new IncorrectResultSetColumnCountException(2, nrOfColumns);
        }

        if (StringUtils.isNotEmpty(keyColumn)) {
            keyColumnIndex = rs.findColumn(keyColumn);
            if (keyColumnIndex == 1) {
                valueColumnIndex = 2;
            } else if (keyColumnIndex == 2) {
                valueColumnIndex = 1;
            } else {
                throw new IllegalArgumentException(
                        String.format("wrong key name %s for method: %s ", keyColumn, modifier.getMethod()));
            }
            keyColumn = null;
        }
        if (logger.isDebugEnabled()) {
            logger.debug(String.format("keyIndex=%s; valueIndex=%s; for method: %s ", keyColumnIndex,
                    valueColumnIndex, modifier.getMethod()));
        }
    }

    //   JDBC ResultSet ?  Key
    Object key = JdbcUtils.getResultSetValue(rs, keyColumnIndex, keyType);
    if (key != null && !keyType.isInstance(key)) {
        ResultSetMetaData rsmd = rs.getMetaData();
        throw new TypeMismatchDataAccessException( // NL
                "Type mismatch affecting row number " + rowNum + " and column type '"
                        + rsmd.getColumnTypeName(keyColumnIndex) + "' expected type is '" + keyType + "'");
    }

    //   JDBC ResultSet ?  Value
    Object value = JdbcUtils.getResultSetValue(rs, valueColumnIndex, valueType);
    if (value != null && !valueType.isInstance(value)) {
        ResultSetMetaData rsmd = rs.getMetaData();
        throw new TypeMismatchDataAccessException( // NL
                "Type mismatch affecting row number " + rowNum + " and column type '"
                        + rsmd.getColumnTypeName(valueColumnIndex) + "' expected type is '" + valueType + "'");
    }

    // key?null??
    return new MapEntryImpl<Object, Object>(key, value);
}

---

• «
• 1
• 2
• 3
• »