Refine search
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); }
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(); } } }
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);
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) {
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));
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" ) )
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);
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));
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() ); } }
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) {