fc.jdbc.dbo.generated
Class alltypes

java.lang.Object
  extended by fc.jdbc.dbo.DBO
      extended by fc.jdbc.dbo.generated.alltypes

public class alltypes
extends DBO

Represents a row in the alltypes table.


Constructor Summary
alltypes()
           
 
Method Summary
 Map allFieldsMap()
          Returns a map of all fields->values (as Strings) contained in this object.
 alltypes dec_bigint_val()
          Decrements bigint_val by 1
 alltypes dec_bigint_val(long amount)
          Decrements bigint_val by the specified amount
 alltypes dec_bigint_val(long amount, int lower_bound)
          Decrements bigint_val by the specified amount, upto but not below the lower bound (bound is inclusive)
 alltypes dec_int_val()
          Decrements int_val by 1
 alltypes dec_int_val(int amount)
          Decrements int_val by the specified amount
 alltypes dec_int_val(int amount, int lower_bound)
          Decrements int_val by the specified amount, upto but not below the lower bound (bound is inclusive)
 Array get_array_val()
          _varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10
 long get_bigint_val()
          int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19
 Boolean get_bit_val()
          bit (BIT); Nullable=true; AutoInc=false; MaxSize=1
 Boolean get_boolean_val()
          bool (BIT); Nullable=true; AutoInc=false; MaxSize=1
 String get_char_val()
          bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10
 Date get_date_val()
          date (DATE); Nullable=true; AutoInc=false; MaxSize=13
 double get_double_val()
          float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17
 float get_float_val()
          float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8
 int get_id()
          serial (INTEGER); PK=yes; Nullable=false; AutoInc=true; MaxSize=10
 int get_int_val()
          int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10
 String get_longvarchar_val()
          text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647
 BigDecimal get_numeric_val()
          numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5
 short get_smallint_val()
          int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5
 Time get_time_val()
          time (TIME); Nullable=true; AutoInc=false; MaxSize=15
 Timestamp get_timestamp_val()
          timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29
 byte[] get_varbinary_val()
          bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647
 String get_varchar_val()
          varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10
 Object getExtraData(Object key)
          Allows retrieving arbitrary object-specific data from this object.
 alltypes inc_bigint_val()
          Increments bigint_val by 1
 alltypes inc_bigint_val(long amount)
          Increments bigint_val by the specified amount
 alltypes inc_bigint_val(long amount, int upper_bound)
          Increments bigint_val by the specified amount, upto but not above the upper bound (bound is inclusive)
 alltypes inc_int_val()
          Increments int_val by 1
 alltypes inc_int_val(int amount)
          Increments int_val by the specified amount
 alltypes inc_int_val(int amount, int upper_bound)
          Increments int_val by the specified amount, upto but not above the upper bound (bound is inclusive)
 boolean isModified_array_val()
          returns true if array_val has changed since it was created/loaded, false otherwise
 boolean isModified_bigint_val()
          returns true if bigint_val has changed since it was created/loaded, false otherwise
 boolean isModified_bit_val()
          returns true if bit_val has changed since it was created/loaded, false otherwise
 boolean isModified_boolean_val()
          returns true if boolean_val has changed since it was created/loaded, false otherwise
 boolean isModified_char_val()
          returns true if char_val has changed since it was created/loaded, false otherwise
 boolean isModified_date_val()
          returns true if date_val has changed since it was created/loaded, false otherwise
 boolean isModified_double_val()
          returns true if double_val has changed since it was created/loaded, false otherwise
 boolean isModified_float_val()
          returns true if float_val has changed since it was created/loaded, false otherwise
 boolean isModified_id()
          returns true if id has changed since it was created/loaded, false otherwise
 boolean isModified_int_val()
          returns true if int_val has changed since it was created/loaded, false otherwise
 boolean isModified_longvarchar_val()
          returns true if longvarchar_val has changed since it was created/loaded, false otherwise
 boolean isModified_numeric_val()
          returns true if numeric_val has changed since it was created/loaded, false otherwise
 boolean isModified_smallint_val()
          returns true if smallint_val has changed since it was created/loaded, false otherwise
 boolean isModified_time_val()
          returns true if time_val has changed since it was created/loaded, false otherwise
 boolean isModified_timestamp_val()
          returns true if timestamp_val has changed since it was created/loaded, false otherwise
 boolean isModified_varbinary_val()
          returns true if varbinary_val has changed since it was created/loaded, false otherwise
 boolean isModified_varchar_val()
          returns true if varchar_val has changed since it was created/loaded, false otherwise
 boolean isModified()
          returns true if this object's data (for any field) has changed since it was created/loaded, false otherwise
 boolean isModifiedSetNull_bigint_val()
          returns is primitive type bigint_val has been set to null via the setNull mechanism
 boolean isModifiedSetNull_double_val()
          returns is primitive type double_val has been set to null via the setNull mechanism
 boolean isModifiedSetNull_float_val()
          returns is primitive type float_val has been set to null via the setNull mechanism
 boolean isModifiedSetNull_smallint_val()
          returns is primitive type smallint_val has been set to null via the setNull mechanism
 boolean isNew()
          returns true if this object is newly created and has not been loaded from the database, false otherwise
 boolean isNullInDB_array_val()
          returns true if array_val was null in the database
 boolean isNullInDB_bigint_val()
          returns true if bigint_val was null in the database
 boolean isNullInDB_bit_val()
          returns true if bit_val was null in the database
 boolean isNullInDB_boolean_val()
          returns true if boolean_val was null in the database
 boolean isNullInDB_char_val()
          returns true if char_val was null in the database
 boolean isNullInDB_date_val()
          returns true if date_val was null in the database
 boolean isNullInDB_double_val()
          returns true if double_val was null in the database
 boolean isNullInDB_float_val()
          returns true if float_val was null in the database
 boolean isNullInDB_id()
          returns true if id was null in the database
 boolean isNullInDB_int_val()
          returns true if int_val was null in the database
 boolean isNullInDB_longvarchar_val()
          returns true if longvarchar_val was null in the database
 boolean isNullInDB_numeric_val()
          returns true if numeric_val was null in the database
 boolean isNullInDB_smallint_val()
          returns true if smallint_val was null in the database
 boolean isNullInDB_time_val()
          returns true if time_val was null in the database
 boolean isNullInDB_timestamp_val()
          returns true if timestamp_val was null in the database
 boolean isNullInDB_varbinary_val()
          returns true if varbinary_val was null in the database
 boolean isNullInDB_varchar_val()
          returns true if varchar_val was null in the database
 void putExtraData(Object key, Object value)
          Allows putting arbitrary object-specific data into this object.
 alltypes set_array_val(Array array_val)
          _varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10
 alltypes set_bigint_val(long bigint_val)
          int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19
 alltypes set_bit_val(Boolean bit_val)
          bit (BIT); Nullable=true; AutoInc=false; MaxSize=1
 alltypes set_boolean_val(Boolean boolean_val)
          bool (BIT); Nullable=true; AutoInc=false; MaxSize=1
 alltypes set_char_val(String char_val)
          bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10
 alltypes set_date_val(Date date_val)
          date (DATE); Nullable=true; AutoInc=false; MaxSize=13
 alltypes set_double_val(double double_val)
          float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17
 alltypes set_float_val(float float_val)
          float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8
 alltypes set_int_val(int int_val)
          int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10
 alltypes set_longvarchar_val(String longvarchar_val)
          text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647
 alltypes set_numeric_val(BigDecimal numeric_val)
          numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5
 alltypes set_smallint_val(short smallint_val)
          int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5
 alltypes set_time_val(Time time_val)
          time (TIME); Nullable=true; AutoInc=false; MaxSize=15
 alltypes set_timestamp_val(Timestamp timestamp_val)
          timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29
 alltypes set_varbinary_val(byte[] varbinary_val)
          bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647
 alltypes set_varchar_val(String varchar_val)
          varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10
 alltypes setNull_bigint_val()
           
 alltypes setNull_double_val()
           
 alltypes setNull_float_val()
           
 alltypes setNull_smallint_val()
           
 String toString()
           
 
Methods inherited from class fc.jdbc.dbo.DBO
discard, isDiscarded
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

alltypes

public alltypes()
Method Detail

isModified_id

public boolean isModified_id()
returns true if id has changed since it was created/loaded, false otherwise


isNullInDB_id

public boolean isNullInDB_id()
returns true if id was null in the database


isModified_smallint_val

public boolean isModified_smallint_val()
returns true if smallint_val has changed since it was created/loaded, false otherwise


isModifiedSetNull_smallint_val

public boolean isModifiedSetNull_smallint_val()
returns is primitive type smallint_val has been set to null via the setNull mechanism


isNullInDB_smallint_val

public boolean isNullInDB_smallint_val()
returns true if smallint_val was null in the database


isModified_int_val

public boolean isModified_int_val()
returns true if int_val has changed since it was created/loaded, false otherwise


isNullInDB_int_val

public boolean isNullInDB_int_val()
returns true if int_val was null in the database


isModified_bigint_val

public boolean isModified_bigint_val()
returns true if bigint_val has changed since it was created/loaded, false otherwise


isModifiedSetNull_bigint_val

public boolean isModifiedSetNull_bigint_val()
returns is primitive type bigint_val has been set to null via the setNull mechanism


isNullInDB_bigint_val

public boolean isNullInDB_bigint_val()
returns true if bigint_val was null in the database


isModified_float_val

public boolean isModified_float_val()
returns true if float_val has changed since it was created/loaded, false otherwise


isModifiedSetNull_float_val

public boolean isModifiedSetNull_float_val()
returns is primitive type float_val has been set to null via the setNull mechanism


isNullInDB_float_val

public boolean isNullInDB_float_val()
returns true if float_val was null in the database


isModified_double_val

public boolean isModified_double_val()
returns true if double_val has changed since it was created/loaded, false otherwise


isModifiedSetNull_double_val

public boolean isModifiedSetNull_double_val()
returns is primitive type double_val has been set to null via the setNull mechanism


isNullInDB_double_val

public boolean isNullInDB_double_val()
returns true if double_val was null in the database


isModified_numeric_val

public boolean isModified_numeric_val()
returns true if numeric_val has changed since it was created/loaded, false otherwise


isNullInDB_numeric_val

public boolean isNullInDB_numeric_val()
returns true if numeric_val was null in the database


isModified_char_val

public boolean isModified_char_val()
returns true if char_val has changed since it was created/loaded, false otherwise


isNullInDB_char_val

public boolean isNullInDB_char_val()
returns true if char_val was null in the database


isModified_varchar_val

public boolean isModified_varchar_val()
returns true if varchar_val has changed since it was created/loaded, false otherwise


isNullInDB_varchar_val

public boolean isNullInDB_varchar_val()
returns true if varchar_val was null in the database


isModified_longvarchar_val

public boolean isModified_longvarchar_val()
returns true if longvarchar_val has changed since it was created/loaded, false otherwise


isNullInDB_longvarchar_val

public boolean isNullInDB_longvarchar_val()
returns true if longvarchar_val was null in the database


isModified_date_val

public boolean isModified_date_val()
returns true if date_val has changed since it was created/loaded, false otherwise


isNullInDB_date_val

public boolean isNullInDB_date_val()
returns true if date_val was null in the database


isModified_time_val

public boolean isModified_time_val()
returns true if time_val has changed since it was created/loaded, false otherwise


isNullInDB_time_val

public boolean isNullInDB_time_val()
returns true if time_val was null in the database


isModified_timestamp_val

public boolean isModified_timestamp_val()
returns true if timestamp_val has changed since it was created/loaded, false otherwise


isNullInDB_timestamp_val

public boolean isNullInDB_timestamp_val()
returns true if timestamp_val was null in the database


isModified_bit_val

public boolean isModified_bit_val()
returns true if bit_val has changed since it was created/loaded, false otherwise


isNullInDB_bit_val

public boolean isNullInDB_bit_val()
returns true if bit_val was null in the database


isModified_array_val

public boolean isModified_array_val()
returns true if array_val has changed since it was created/loaded, false otherwise


isNullInDB_array_val

public boolean isNullInDB_array_val()
returns true if array_val was null in the database


isModified_boolean_val

public boolean isModified_boolean_val()
returns true if boolean_val has changed since it was created/loaded, false otherwise


isNullInDB_boolean_val

public boolean isNullInDB_boolean_val()
returns true if boolean_val was null in the database


isModified_varbinary_val

public boolean isModified_varbinary_val()
returns true if varbinary_val has changed since it was created/loaded, false otherwise


isNullInDB_varbinary_val

public boolean isNullInDB_varbinary_val()
returns true if varbinary_val was null in the database


isNew

public boolean isNew()
returns true if this object is newly created and has not been loaded from the database, false otherwise


isModified

public boolean isModified()
returns true if this object's data (for any field) has changed since it was created/loaded, false otherwise


putExtraData

public void putExtraData(Object key,
                         Object value)
Allows putting arbitrary object-specific data into this object. This is useful to store additional query-specific columns when performing arbitrary queries. For example:
String query = "select 1+1 as my_sum, 
                now() as my_time, alltypesMgr.columns() 
                from alltypes";
PreparedStatement ps = con.prepareStatment(query);
ResultSet rs = ps.executeQuery();
List list = new ArrayList();
while (rs.next()) {
        alltypes obj = alltypesMgr.getFromRS(rs);
        obj.putExtraData("my_sum", rs.getInt("my_sum"));
        obj.putExtraData("my_time", rs.getDate("my_time"));
        }
//use the list later on...each alltypes object in the list will 
//have the extra data..


getExtraData

public Object getExtraData(Object key)
Allows retrieving arbitrary object-specific data from this object. This data should have been put via the putExtraData method prior to invoking this method


toString

public String toString()
Overrides:
toString in class Object

allFieldsMap

public Map allFieldsMap()
Returns a map of all fields->values (as Strings) contained in this object. This is useful when sending auto converting the object to JSON, etc.


get_id

public int get_id()
serial (INTEGER); PK=yes; Nullable=false; AutoInc=true; MaxSize=10


get_smallint_val

public short get_smallint_val()
int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5


set_smallint_val

public alltypes set_smallint_val(short smallint_val)
int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5


setNull_smallint_val

public alltypes setNull_smallint_val()

get_int_val

public int get_int_val()
int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10


set_int_val

public alltypes set_int_val(int int_val)
int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10


get_bigint_val

public long get_bigint_val()
int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19


set_bigint_val

public alltypes set_bigint_val(long bigint_val)
int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19


setNull_bigint_val

public alltypes setNull_bigint_val()

get_float_val

public float get_float_val()
float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8


set_float_val

public alltypes set_float_val(float float_val)
float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8


setNull_float_val

public alltypes setNull_float_val()

get_double_val

public double get_double_val()
float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17


set_double_val

public alltypes set_double_val(double double_val)
float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17


setNull_double_val

public alltypes setNull_double_val()

get_numeric_val

public BigDecimal get_numeric_val()
numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5


set_numeric_val

public alltypes set_numeric_val(BigDecimal numeric_val)
numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5


get_char_val

public String get_char_val()
bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10


set_char_val

public alltypes set_char_val(String char_val)
bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10


get_varchar_val

public String get_varchar_val()
varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10


set_varchar_val

public alltypes set_varchar_val(String varchar_val)
varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10


get_longvarchar_val

public String get_longvarchar_val()
text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647


set_longvarchar_val

public alltypes set_longvarchar_val(String longvarchar_val)
text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647


get_date_val

public Date get_date_val()
date (DATE); Nullable=true; AutoInc=false; MaxSize=13


set_date_val

public alltypes set_date_val(Date date_val)
date (DATE); Nullable=true; AutoInc=false; MaxSize=13


get_time_val

public Time get_time_val()
time (TIME); Nullable=true; AutoInc=false; MaxSize=15


set_time_val

public alltypes set_time_val(Time time_val)
time (TIME); Nullable=true; AutoInc=false; MaxSize=15


get_timestamp_val

public Timestamp get_timestamp_val()
timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29


set_timestamp_val

public alltypes set_timestamp_val(Timestamp timestamp_val)
timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29


get_bit_val

public Boolean get_bit_val()
bit (BIT); Nullable=true; AutoInc=false; MaxSize=1


set_bit_val

public alltypes set_bit_val(Boolean bit_val)
bit (BIT); Nullable=true; AutoInc=false; MaxSize=1


get_array_val

public Array get_array_val()
_varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10


set_array_val

public alltypes set_array_val(Array array_val)
_varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10


get_boolean_val

public Boolean get_boolean_val()
bool (BIT); Nullable=true; AutoInc=false; MaxSize=1


set_boolean_val

public alltypes set_boolean_val(Boolean boolean_val)
bool (BIT); Nullable=true; AutoInc=false; MaxSize=1


get_varbinary_val

public byte[] get_varbinary_val()
bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647


set_varbinary_val

public alltypes set_varbinary_val(byte[] varbinary_val)
bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647


inc_int_val

public alltypes inc_int_val()
Increments int_val by 1


inc_int_val

public alltypes inc_int_val(int amount)
Increments int_val by the specified amount


inc_int_val

public alltypes inc_int_val(int amount,
                            int upper_bound)
Increments int_val by the specified amount, upto but not above the upper bound (bound is inclusive)


dec_int_val

public alltypes dec_int_val()
Decrements int_val by 1


dec_int_val

public alltypes dec_int_val(int amount)
Decrements int_val by the specified amount


dec_int_val

public alltypes dec_int_val(int amount,
                            int lower_bound)
Decrements int_val by the specified amount, upto but not below the lower bound (bound is inclusive)


inc_bigint_val

public alltypes inc_bigint_val()
Increments bigint_val by 1


inc_bigint_val

public alltypes inc_bigint_val(long amount)
Increments bigint_val by the specified amount


inc_bigint_val

public alltypes inc_bigint_val(long amount,
                               int upper_bound)
Increments bigint_val by the specified amount, upto but not above the upper bound (bound is inclusive)


dec_bigint_val

public alltypes dec_bigint_val()
Decrements bigint_val by 1


dec_bigint_val

public alltypes dec_bigint_val(long amount)
Decrements bigint_val by the specified amount


dec_bigint_val

public alltypes dec_bigint_val(long amount,
                               int lower_bound)
Decrements bigint_val by the specified amount, upto but not below the lower bound (bound is inclusive)