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