java.sql.ResultSet.findColumn()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(6.3k)|赞(0)|评价(0)|浏览(223)

本文整理了Java中java.sql.ResultSet.findColumn方法的一些代码示例,展示了ResultSet.findColumn的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。ResultSet.findColumn方法的具体详情如下:
包路径:java.sql.ResultSet
类名称:ResultSet
方法名:findColumn

ResultSet.findColumn介绍

[英]Gets the index number for a column in the ResultSet from the provided column name.
[中]从提供的列名获取ResultSet中某列的索引号。

代码示例

代码示例来源:origin: apache/incubator-shardingsphere

@Override
public final int findColumn(final String columnLabel) throws SQLException {
  return resultSets.get(0).findColumn(columnLabel);
}

代码示例来源:origin: spring-projects/spring-framework

@Override
@Nullable
public byte[] getBlobAsBytes(ResultSet rs, String columnName) throws SQLException {
  return getBlobAsBytes(rs, rs.findColumn(columnName));
}

代码示例来源:origin: spring-projects/spring-framework

@Override
@Nullable
public InputStream getClobAsAsciiStream(ResultSet rs, String columnName) throws SQLException {
  return getClobAsAsciiStream(rs, rs.findColumn(columnName));
}

代码示例来源:origin: spring-projects/spring-framework

@Override
@Nullable
public String getClobAsString(ResultSet rs, String columnName) throws SQLException {
  return getClobAsString(rs, rs.findColumn(columnName));
}

代码示例来源:origin: spring-projects/spring-framework

@Override
@Nullable
public InputStream getBlobAsBinaryStream(ResultSet rs, String columnName) throws SQLException {
  return getBlobAsBinaryStream(rs, rs.findColumn(columnName));
}

代码示例来源:origin: spring-projects/spring-framework

@Override
public Reader getClobAsCharacterStream(ResultSet rs, String columnName) throws SQLException {
  return getClobAsCharacterStream(rs, rs.findColumn(columnName));
}

代码示例来源:origin: alibaba/druid

@Override
public int findColumn(String columnLabel) throws SQLException {
  try {
    return rs.findColumn(columnLabel);
  } catch (Throwable t) {
    throw checkException(t);
  }
}

代码示例来源:origin: spring-projects/spring-framework

/**
 * @see java.sql.ResultSet#findColumn(String)
 */
@Override
public int findColumn(String columnLabel) throws InvalidResultSetAccessException {
  Integer columnIndex = this.columnLabelMap.get(columnLabel);
  if (columnIndex != null) {
    return columnIndex;
  }
  else {
    try {
      return this.resultSet.findColumn(columnLabel);
    }
    catch (SQLException se) {
      throw new InvalidResultSetAccessException(se);
    }
  }
}

代码示例来源:origin: hibernate/hibernate-orm

public int resolveColumnPosition(String columnName) throws HibernateException {
  try {
    return resultSet.findColumn( columnName );
  }
  catch( SQLException e ) {
    throw new HibernateException( "Could not resolve column name in result set [" + columnName + "]", e );
  }
}

代码示例来源:origin: apache/ignite

@Override public Object call() throws Exception {
    rs.findColumn("wrong");
    return null;
  }
},

代码示例来源:origin: apache/ignite

@Override public Object call() throws Exception {
    rs.findColumn("wrong");
    return null;
  }
},

代码示例来源:origin: apache/ignite

@Override public Object call() throws Exception {
    rs.findColumn("wrong");
    return null;
  }
},

代码示例来源:origin: apache/ignite

@Override public void run() throws Exception {
    rs.findColumn("id");
  }
});

代码示例来源:origin: alibaba/druid

@Override
public int resultSet_findColumn(ResultSetProxy rs, String columnLabel) throws SQLException {
  if (this.pos < filterSize) {
    return nextFilter()
        .resultSet_findColumn(this, rs, columnLabel);
  }
  return rs.getResultSetRaw()
      .findColumn(columnLabel);
}

代码示例来源:origin: hibernate/hibernate-orm

@Override
public MyDate nullSafeGet(
    ResultSet rs,
    String[] names,
    SharedSessionContractImplementor session,
    Object owner) throws HibernateException, SQLException {
  return new MyDate(rs.getDate(rs.findColumn(names[0])));
}

代码示例来源:origin: hibernate/hibernate-orm

@Override
public DollarValue nullSafeGet(
    ResultSet rs,
    String[] names,
    SharedSessionContractImplementor session,
    Object owner) throws HibernateException, SQLException {
  return new DollarValue( rs.getBigDecimal( rs.findColumn( names[0])));
}

代码示例来源:origin: hibernate/hibernate-orm

@Override
public Object nullSafeGet(ResultSet rs, String[] names, SharedSessionContractImplementor session, Object owner)
    throws HibernateException, SQLException {
  return new Age( rs.getInt( rs.findColumn( names[0] ) ) );
}

代码示例来源:origin: spring-projects/spring-framework

private void doTest(Method rsetMethod, Method rowsetMethod, Object arg, Object ret) throws Exception {
  if (arg instanceof String) {
    given(resultSet.findColumn((String) arg)).willReturn(1);
    given(rsetMethod.invoke(resultSet, 1)).willReturn(ret).willThrow(new SQLException("test"));
  }
  else {
    given(rsetMethod.invoke(resultSet, arg)).willReturn(ret).willThrow(new SQLException("test"));
  }
  rowsetMethod.invoke(rowSet, arg);
  try {
    rowsetMethod.invoke(rowSet, arg);
    fail("InvalidResultSetAccessException should have been thrown");
  }
  catch (InvocationTargetException ex) {
    assertEquals(InvalidResultSetAccessException.class, ex.getTargetException().getClass());
  }
}

代码示例来源:origin: alibaba/druid

@Override
public Object resultSet_getObject(FilterChain chain, ResultSetProxy result, String columnLabel) throws SQLException {
  ResultSet rawResultSet = result.getResultSetRaw();
  ResultSetMetaData metadata = rawResultSet.getMetaData();
  int columnIndex = rawResultSet.findColumn(columnLabel);
  int columnType = metadata.getColumnType(columnIndex);
  Object value = null;
  switch (columnType) {
    case Types.CHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.CLOB:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.LONGVARCHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.VARCHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    default:
      value = super.resultSet_getObject(chain, result, columnLabel);
  }
  return decodeObject(result.getStatementProxy().getConnectionProxy(), value);
}

代码示例来源:origin: alibaba/druid

@Override
public Object resultSet_getObject(FilterChain chain, ResultSetProxy result, String columnLabel,
                 java.util.Map<String, Class<?>> map) throws SQLException {
  ResultSet rawResultSet = result.getResultSetRaw();
  ResultSetMetaData metadata = rawResultSet.getMetaData();
  int columnIndex = rawResultSet.findColumn(columnLabel);
  int columnType = metadata.getColumnType(columnIndex);
  Object value = null;
  switch (columnType) {
    case Types.CHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.CLOB:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.LONGVARCHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    case Types.VARCHAR:
      value = super.resultSet_getString(chain, result, columnLabel);
      break;
    default:
      value = super.resultSet_getObject(chain, result, columnLabel, map);
  }
  return decodeObject(result.getStatementProxy().getConnectionProxy(), value);
}

相关文章

微信公众号

最新文章

更多

ResultSet类方法