RecordSet

java.lang.Object
- ra.db.record.RecordSet

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable, Record, RecordCursor
```
public class RecordSet
extends java.lang.Object
implements Record
```
The record of query database.

Author:

Ray Li

Constructor Summary

Constructors
Constructor and Description

RecordSet(DatabaseCategory category)
Initialize.

Constructors
Constructor and Description
`RecordSet(DatabaseCategory category)` Initialize.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`close()` Clear the catch data.
`void`	`convert(java.sql.ResultSet result)` Convert the result of a query.
`void`	`end()` Change the current row index to the end index.
`java.lang.String`	`field(int index)` Take the column value of the earmark index.
`java.lang.String`	`field(java.lang.String name)` Take the column value of the name and the current index.
`<T> java.util.List<T>`	`fieldArray(java.lang.String name, java.lang.Class<T[]> castClass)` Get value by specified field name.
`java.math.BigDecimal`	`fieldBigDecimal(java.lang.String name)` Get value by specified field name.
`byte[]`	`fieldBytes(java.lang.String name)` Take the column value of the name and the current index， Return Object null, if the value is null.
`double`	`fieldDouble(java.lang.String name)` Get value by specified field name.
`float`	`fieldFloat(java.lang.String name)` Get value by specified field name.
`int`	`fieldInt(java.lang.String name)` Get value by specified field name.
`long`	`fieldLong(java.lang.String name)` Get value by specified field name.
`void`	`fieldNames(java.util.function.Consumer<java.lang.String> consumer)` Get name of table fields.
`java.lang.Object`	`fieldObject(java.lang.String name)` Get value by specified field name.
`void`	`first()` Change the current row index to the first index.
`void`	`forEach(java.util.function.Consumer<RowSet> action)` Take the row data by row data.
`java.lang.String`	`getColumnName(int index)` Returns name of column.
`int`	`getFieldCount()` Take count in the table`s column.
`LastInsertId`	`getLastInsertId(java.sql.Statement statement)` Returns last insert id.
`int`	`getRecordCount()` Take the row count in SQL statement execute finish.
`boolean`	`isBof()` Is the current row index equal first index.
`boolean`	`isEof()` is the current row index equal end index.
`boolean`	`isNull(java.lang.String name)` If the query database specifies a field name and its value is null, it will return null.
`void`	`move(int index)` Change the current row index.
`void`	`next()` Add one up the current row index.
`java.util.stream.Stream<RowSet>`	`parallelStream()` Return the parallel stream in SQL statement execute finish.
`void`	`previous()` Subtract one from the current row index.
`java.util.stream.Stream<RowSet>`	`stream()` Return the serialization stream in SQL statement execute finish.
`java.lang.String`	`toString()`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - RecordSet
```
public RecordSet(DatabaseCategory category)
```
    Initialize.
    
    Parameters:
    
    category - database mode
- Method Detail
  - getFieldCount
```
public int getFieldCount()
```
    Take count in the table`s column.
    
    Specified by:
    
    getFieldCount in interface RecordCursor
    
    Returns:
    
    count in the table`s column.
  - fieldNames
```
public void fieldNames(java.util.function.Consumer<java.lang.String> consumer)
```
    Description copied from interface: RecordCursor
    
    Get name of table fields.
    
    Specified by:
    
    fieldNames in interface RecordCursor
    
    Parameters:
    
    consumer - Consumer
  - isNull
```
public boolean isNull(java.lang.String name)
```
    If the query database specifies a field name and its value is null, it will return null.
    
    Specified by:
    
    isNull in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    boolean
  - convert
```
public void convert(java.sql.ResultSet result)
             throws java.sql.SQLException
```
    Convert the result of a query.
    
    Specified by:
    
    convert in interface Record
    
    Parameters:
    
    result - Result of query.
    
    Throws:
    
    java.sql.SQLException - SQLException
  - field
```
public java.lang.String field(int index)
```
    Take the column value of the earmark index.
    
    Specified by:
    
    field in interface RecordCursor
    
    Parameters:
    
    index - earmark index
    
    Returns:
    
    value
  - field
```
public java.lang.String field(java.lang.String name)
```
    Take the column value of the name and the current index. Returns null if the value in the database is null.
    
    Specified by:
    
    field in interface RecordCursor
    
    Parameters:
    
    name - column`s name
    
    Returns:
    
    String || null
  - fieldBytes
```
public byte[] fieldBytes(java.lang.String name)
```
    Take the column value of the name and the current index， Return Object null, if the value is null.
    
    Specified by:
    
    fieldBytes in interface RecordCursor
    
    Parameters:
    
    name - column`s name
    
    Returns:
    
    byte[] || null
  - fieldLong
```
public long fieldLong(java.lang.String name)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldLong in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    bytes
  - fieldInt
```
public int fieldInt(java.lang.String name)
             throws java.lang.NumberFormatException
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldInt in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    bytes
    
    Throws:
    
    java.lang.NumberFormatException
  - fieldFloat
```
public float fieldFloat(java.lang.String name)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldFloat in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    bytes
  - fieldDouble
```
public double fieldDouble(java.lang.String name)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldDouble in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    bytes
  - fieldBigDecimal
```
public java.math.BigDecimal fieldBigDecimal(java.lang.String name)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldBigDecimal in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    bytes
  - fieldArray
```
public <T> java.util.List<T> fieldArray(java.lang.String name,
                                        java.lang.Class<T[]> castClass)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldArray in interface RecordCursor
    
    Type Parameters:
    
    T - list element
    
    Parameters:
    
    name - Field name
    
    castClass - Cast class
    
    Returns:
    
    List
  - fieldObject
```
public java.lang.Object fieldObject(java.lang.String name)
```
    Description copied from interface: RecordCursor
    
    Get value by specified field name. If field value is null will return null.
    
    Specified by:
    
    fieldObject in interface RecordCursor
    
    Parameters:
    
    name - Field name
    
    Returns:
    
    Object
  - next
```
public void next()
```
    Add one up the current row index.
    
    Specified by:
    
    next in interface RecordCursor
  - previous
```
public void previous()
```
    Subtract one from the current row index.
    
    Specified by:
    
    previous in interface RecordCursor
  - move
```
public void move(int index)
```
    Change the current row index.
    
    Specified by:
    
    move in interface RecordCursor
    
    Parameters:
    
    index - Earmark row index.
  - first
```
public void first()
```
    Change the current row index to the first index.
    
    Specified by:
    
    first in interface RecordCursor
  - end
```
public void end()
```
    Change the current row index to the end index.
    
    Specified by:
    
    end in interface RecordCursor
  - isBof
```
public boolean isBof()
```
    Is the current row index equal first index.
    
    Specified by:
    
    isBof in interface RecordCursor
    
    Returns:
    
    If first row returns true.
  - isEof
```
public boolean isEof()
```
    is the current row index equal end index.
    
    Specified by:
    
    isEof in interface RecordCursor
    
    Returns:
    
    If last row returns true.
  - getRecordCount
```
public int getRecordCount()
```
    Take the row count in SQL statement execute finish.
    
    Specified by:
    
    getRecordCount in interface RecordCursor
    
    Returns:
    
    row count
  - forEach
```
public void forEach(java.util.function.Consumer<RowSet> action)
```
    Take the row data by row data.
    Execute situation like the program show
```
 RecordSet record = ...

 while(!record.isEOF()){

   //do get record data

   record.next();
 }
 
```
    Specified by:
    
    forEach in interface RecordCursor
    
    Parameters:
    
    action - Take the row data.The instance RowSet would be reused.
  - stream
```
public java.util.stream.Stream<RowSet> stream()
```
    Return the serialization stream in SQL statement execute finish.
    
    Specified by:
    
    stream in interface RecordCursor
    
    Returns:
    
    Stream
  - parallelStream
```
public java.util.stream.Stream<RowSet> parallelStream()
```
    Return the parallel stream in SQL statement execute finish.
    
    Specified by:
    
    parallelStream in interface RecordCursor
    
    Returns:
    
    Stream
  - toString
```
public java.lang.String toString()
```
    Overrides:
    
    toString in class java.lang.Object
  - close
```
public void close()
```
    Clear the catch data.
    
    Specified by:
    
    close in interface java.io.Closeable
    
    Specified by:
    
    close in interface java.lang.AutoCloseable
  - getColumnName
```
public java.lang.String getColumnName(int index)
```
    Returns name of column.
    
    Specified by:
    
    getColumnName in interface Record
    
    Parameters:
    
    index - index (range : 1 ~ column.length - 1)
    
    Returns:
    
    column name
  - getLastInsertId
```
public LastInsertId getLastInsertId(java.sql.Statement statement)
                             throws java.sql.SQLException
```
    Returns last insert id.
    
    Specified by:
    
    getLastInsertId in interface Record
    
    Parameters:
    
    statement - statement
    
    Returns:
    
    id auto-increment id
    
    Throws:
    
    java.sql.SQLException - SQLException

Class RecordSet

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

RecordSet

Method Detail

getFieldCount

fieldNames

isNull

convert

field

field

fieldBytes

fieldLong

fieldInt

fieldFloat

fieldDouble

fieldBigDecimal

fieldArray

fieldObject

next

previous

move

first

end

isBof

isEof

getRecordCount

forEach

stream

parallelStream

toString

close

getColumnName

getLastInsertId