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

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

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

ResultSet.getShort介绍

[英]Gets the value of a column specified by column index as a short value.
[中]获取列索引指定为短值的列的值。

代码示例

代码示例来源：origin: speedment/speedment

static TypeInfoMetaData of(ResultSet rs) throws SQLException {
  final String sqlTypeName = rs.getString("TYPE_NAME");
  final int javaSqlTypeInt = rs.getInt("DATA_TYPE");
  final int precision = rs.getInt("PRECISION");
  final short nullable = rs.getShort("NULLABLE");
  final boolean unsigned = rs.getBoolean("UNSIGNED_ATTRIBUTE");
  return of(sqlTypeName, javaSqlTypeInt, precision, precision, nullable, unsigned);
}

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

private void initIndexes(DatabaseMetaData meta) throws SQLException {
  ResultSet rs = null;
  try {
    rs = meta.getIndexInfo( catalog, schema, name, false, true );
    while ( rs.next() ) {
      if ( rs.getShort( "TYPE" ) == DatabaseMetaData.tableIndexStatistic ) {
        continue;
      }
      addIndex( rs );
    }
  }
  finally {
    if ( rs != null ) {
      rs.close();
    }
  }
}

代码示例来源：origin: com.h2database/h2

public DbProcedure(DbSchema schema, ResultSet rs) throws SQLException {
  this.schema = schema;
  name = rs.getString("PROCEDURE_NAME");
  returnsResult = rs.getShort("PROCEDURE_TYPE") ==
      DatabaseMetaData.procedureReturnsResult;
  quotedName = schema.getContents().quoteIdentifier(name);
}

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

while (rs.next()) {
      out.print(rs.getString(columnIndex));
    } else if (type == Types.DATE) {
      Date date = rs.getDate(columnIndex);
      short value = rs.getShort(columnIndex);
      if (rs.wasNull()) {
        out.print("null");
      int value = rs.getInt(columnIndex);
      if (rs.wasNull()) {
        out.print("null");
      out.print(String.valueOf(rs.getBigDecimal(columnIndex)));
    } else if (type == Types.CLOB) {
      out.print(String.valueOf(rs.getString(columnIndex)));
    } else if (type == Types.JAVA_OBJECT) {
      Object object = rs.getObject(columnIndex);
      Object object = rs.getString(columnIndex);

代码示例来源：origin: com.h2database/h2

StringUtils.escapeMetaDataPattern(tableName),
    new String[] { "TABLE" });
if (!rs.next()) {
  return;
if (rs.getString("SQL") == null) {
String table = rs.getString("TABLE_NAME");
    StringUtils.escapeMetaDataPattern(schemaName),
    tableName);
while (rs.next()) {
  String c = rs.getString("COLUMN_NAME");
  key.add(toUpper ? StringUtils.toUpperEnglish(c) : c);
    StringUtils.escapeMetaDataPattern(schemaName),
    tableName, true, true);
while (rs.next()) {
  int pos = rs.getShort("ORDINAL_POSITION");
  if (pos == 1) {

代码示例来源：origin: jtablesaw/tablesaw

while (resultSet.next()) {
  for (int i = 1; i <= metaData.getColumnCount(); i++) {
    Column<?> column = table.column(i - 1); // subtract 1 because results sets originate at 1 not 0
    if (column instanceof ShortColumn) {
      column.appendObj(resultSet.getShort(i));
    } else if (column instanceof IntColumn) {
      column.appendObj(resultSet.getInt(i));
    } else if (column instanceof LongColumn) {
      column.appendObj(resultSet.getLong(i));

代码示例来源：origin: speedment/speedment

protected Store apply(ResultSet resultSet, int offset) throws SQLException {
  return createEntity()
    .setStoreId(        resultSet.getShort(1 + offset))
    .setManagerStaffId( resultSet.getShort(2 + offset))
    .setAddressId(      resultSet.getInt(3 + offset))
    .setLastUpdate(     resultSet.getTimestamp(4 + offset))
    ;
}

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

final ResultSet resultSet = metaData.getTypeInfo();
try {
  while ( resultSet.next() ) {
    typeInfoSet.add(
        new TypeInfo(
            resultSet.getString( "TYPE_NAME" ),
            resultSet.getInt( "DATA_TYPE" ),
            interpretCreateParams( resultSet.getString( "CREATE_PARAMS" ) ),
            resultSet.getBoolean( "UNSIGNED_ATTRIBUTE" ),
            resultSet.getInt( "PRECISION" ),
            resultSet.getShort( "MINIMUM_SCALE" ),
            resultSet.getShort( "MAXIMUM_SCALE" ),
            resultSet.getBoolean( "FIXED_PREC_SCALE" ),
            resultSet.getString( "LITERAL_PREFIX" ),
            resultSet.getString( "LITERAL_SUFFIX" ),
            resultSet.getBoolean( "CASE_SENSITIVE" ),
            TypeSearchability.interpret( resultSet.getShort( "SEARCHABLE" ) ),
            TypeNullability.interpret( resultSet.getShort( "NULLABLE" ) )

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

return rs.getString(index);
value = rs.getShort(index);
value = rs.getInt(index);
  return rs.getString(index);

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

while (rs.next()) {
  String idxName = rs.getString("INDEX_NAME");
  String field = rs.getString("COLUMN_NAME");
  String ascOrDesc = rs.getString("ASC_OR_DESC");
  assert rs.getShort("TYPE") == DatabaseMetaData.tableIndexOther;

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

@Override public void run(Connection conn) throws Exception {
    try (PreparedStatement stmt = conn.prepareStatement("SELECT 'zzz'")) {
      ResultSet rs = stmt.executeQuery();
      rs.next();
      rs.getShort(1);
    }
  }
}, "0700B", "Cannot convert to short");

代码示例来源：origin: alibaba/canal

value = rs.getString(index);
} else if (boolean.class.equals(requiredType) || Boolean.class.equals(requiredType)) {
  value = Boolean.valueOf(rs.getBoolean(index));
  wasNullCheck = true;
} else if (short.class.equals(requiredType) || Short.class.equals(requiredType)) {
  value = new Short(rs.getShort(index));
  wasNullCheck = true;
} else if (int.class.equals(requiredType) || Integer.class.equals(requiredType)) {
  value = rs.getString(index);// 尝试拿为string对象，0000无法用Time表示
  value = rs.getString(index);

代码示例来源：origin: speedment/speedment

protected FilmCategory apply(ResultSet resultSet, int offset) throws SQLException {
  return createEntity()
    .setFilmId(     resultSet.getInt(1 + offset))
    .setCategoryId( resultSet.getShort(2 + offset))
    .setLastUpdate( resultSet.getTimestamp(3 + offset))
    ;
}

代码示例来源：origin: apache/storm

try (ResultSet resultSet = preparedStatement.executeQuery()) {
  List<List<Column>> rows = Lists.newArrayList();
  while (resultSet.next()) {
    ResultSetMetaData metaData = resultSet.getMetaData();
    int columnCount = metaData.getColumnCount();
      Class columnJavaType = Util.getJavaType(columnType);
      if (columnJavaType.equals(String.class)) {
        row.add(new Column<String>(columnLabel, resultSet.getString(columnLabel), columnType));
      } else if (columnJavaType.equals(Integer.class)) {
        row.add(new Column<Integer>(columnLabel, resultSet.getInt(columnLabel), columnType));
      } else if (columnJavaType.equals(Double.class)) {
        row.add(new Column<Double>(columnLabel, resultSet.getDouble(columnLabel), columnType));
        row.add(new Column<Float>(columnLabel, resultSet.getFloat(columnLabel), columnType));
      } else if (columnJavaType.equals(Short.class)) {
        row.add(new Column<Short>(columnLabel, resultSet.getShort(columnLabel), columnType));
      } else if (columnJavaType.equals(Boolean.class)) {
        row.add(new Column<Boolean>(columnLabel, resultSet.getBoolean(columnLabel), columnType));

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

private static Serializable extractIdentifier(ResultSet rs, String identifier, Type type, Class clazz)
    throws SQLException {
  if ( clazz == Long.class ) {
    return rs.getLong( identifier );
  }
  else if ( clazz == Integer.class ) {
    return rs.getInt( identifier );
  }
  else if ( clazz == Short.class ) {
    return rs.getShort( identifier );
  }
  else if ( clazz == String.class ) {
    return rs.getString( identifier );
  }
  else if ( clazz == BigInteger.class ) {
    return rs.getBigDecimal( identifier ).setScale( 0, BigDecimal.ROUND_UNNECESSARY ).toBigInteger();
  }
  else if ( clazz == BigDecimal.class ) {
    return rs.getBigDecimal( identifier ).setScale( 0, BigDecimal.ROUND_UNNECESSARY );
  }
  else {
    throw new IdentifierGenerationException(
        "unrecognized id type : " + type.getName() + " -> " + clazz.getName()
    );
  }
}

代码示例来源：origin: lealone/Lealone

ResultSet rs = meta.getTables(null, StringUtils.escapeMetaDataPattern(schemaName),
    StringUtils.escapeMetaDataPattern(tableName), new String[] { "TABLE" });
if (!rs.next()) {
  return;
if (rs.getString("SQL") == null) {
String table = rs.getString("TABLE_NAME");
key = Utils.newSmallArrayList();
rs = meta.getPrimaryKeys(null, StringUtils.escapeMetaDataPattern(schemaName), tableName);
while (rs.next()) {
  String c = rs.getString("COLUMN_NAME");
  key.add(toUpper ? StringUtils.toUpperEnglish(c) : c);
while (rs.next()) {
  int pos = rs.getShort("ORDINAL_POSITION");
  if (pos == 1) {

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

/**
 * @throws Exception If failed.
 */
@Test
public void testShort() throws Exception {
  ResultSet rs = stmt.executeQuery(SQL);
  int cnt = 0;
  while (rs.next()) {
    if (cnt == 0) {
      assert rs.getShort("shortVal") == 1;
      assert rs.getShort(4) == 1;
    }
    cnt++;
  }
  assert cnt == 1;
}

代码示例来源：origin: speedment/speedment

protected Category apply(ResultSet resultSet, int offset) throws SQLException {
  return createEntity()
    .setCategoryId( resultSet.getShort(1 + offset))
    .setName(       resultSet.getString(2 + offset))
    .setLastUpdate( resultSet.getTimestamp(3 + offset))
    ;
}

代码示例来源：origin: speedment/speedment

protected Inventory apply(ResultSet resultSet, int offset) throws SQLException {
  return createEntity()
    .setInventoryId( resultSet.getInt(1 + offset))
    .setFilmId(      resultSet.getInt(2 + offset))
    .setStoreId(     resultSet.getShort(3 + offset))
    .setLastUpdate(  resultSet.getTimestamp(4 + offset))
    ;
}

代码示例来源：origin: stackoverflow.com

while (rs.next()) {
      l = rs.getInt(i + 1);
      if (rs.wasNull()) {
        jgen.writeNull();
    case Types.LONGNVARCHAR:
    case Types.LONGVARCHAR:
      jgen.writeString(rs.getString(i + 1));
      break;
      l = rs.getShort(i + 1);
      if (rs.wasNull()) {
        jgen.writeNull();

内容来源于网络，如有侵权，请联系作者删除！

resultset

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    ResultSet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com