Package | Description |
---|---|
fc.jdbc.dbo.generated |
These are sample tables, purely to show as an example of DBO generated code.
|
Modifier and Type | Method and Description |
---|---|
alltypes |
alltypes.dec_bigint_val()
Decrements bigint_val by 1
|
alltypes |
alltypes.dec_bigint_val(long amount)
Decrements bigint_val by the specified amount
|
alltypes |
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 |
alltypes.dec_int_val()
Decrements int_val by 1
|
alltypes |
alltypes.dec_int_val(int amount)
Decrements int_val by the specified amount
|
alltypes |
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)
|
static alltypes |
alltypesMgr.getByKey(Connection con,
int id)
Returns the row corresponding to the specified primary key(s) of this table
or null if no row was found.
|
static alltypes |
alltypesMgr.getFromRS(ResultSet rs)
Creates and returns a new alltypes object that represents a row from the specified ResultSet.
|
static alltypes |
alltypesMgr.getFromRS(ResultSet rs,
String prefix)
Creates and returns a new alltypes object that represents a row from the specified ResultSet.
|
static alltypes |
alltypesMgr.getFromRS1Table(ResultSet rs)
Creates and returns a new alltypes object that represents a row from the specified ResultSet.
|
alltypes |
alltypes.inc_bigint_val()
Increments bigint_val by 1
|
alltypes |
alltypes.inc_bigint_val(long amount)
Increments bigint_val by the specified amount
|
alltypes |
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 |
alltypes.inc_int_val()
Increments int_val by 1
|
alltypes |
alltypes.inc_int_val(int amount)
Increments int_val by the specified amount
|
alltypes |
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)
|
alltypes |
alltypes.set_array_val(Array array_val)
_varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10
|
alltypes |
alltypes.set_bigint_val(long bigint_val)
int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19
|
alltypes |
alltypes.set_bit_val(Boolean bit_val)
bit (BIT); Nullable=true; AutoInc=false; MaxSize=1
|
alltypes |
alltypes.set_boolean_val(Boolean boolean_val)
bool (BIT); Nullable=true; AutoInc=false; MaxSize=1
|
alltypes |
alltypes.set_char_val(String char_val)
bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10
|
alltypes |
alltypes.set_date_val(Date date_val)
date (DATE); Nullable=true; AutoInc=false; MaxSize=13
|
alltypes |
alltypes.set_double_val(double double_val)
float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17
|
alltypes |
alltypes.set_float_val(float float_val)
float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8
|
alltypes |
alltypes.set_int_val(int int_val)
int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10
|
alltypes |
alltypes.set_json_val(String json_val)
json (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647
|
alltypes |
alltypes.set_jsonb_val(String jsonb_val)
jsonb (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647
|
alltypes |
alltypes.set_longvarchar_val(String longvarchar_val)
text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647
|
alltypes |
alltypes.set_numeric_val(BigDecimal numeric_val)
numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5
|
alltypes |
alltypes.set_smallint_val(short smallint_val)
int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5
|
alltypes |
alltypes.set_time_val(Time time_val)
time (TIME); Nullable=true; AutoInc=false; MaxSize=15
|
alltypes |
alltypes.set_timestamp_val(Timestamp timestamp_val)
timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29
|
alltypes |
alltypes.set_varbinary_val(byte[] varbinary_val)
bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647
|
alltypes |
alltypes.set_varchar_val(String varchar_val)
varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10
|
alltypes |
alltypes.setNull_bigint_val() |
alltypes |
alltypes.setNull_double_val() |
alltypes |
alltypes.setNull_float_val() |
alltypes |
alltypes.setNull_smallint_val() |
Modifier and Type | Method and Description |
---|---|
static int |
alltypesMgr.countUsing(Connection con,
alltypes bean)
Convenience method that invokes
getUsing with an empty clause parameter. |
static int |
alltypesMgr.countUsing(Connection con,
alltypes bean,
String clause)
Returns the rows count by querying the table with the contents of the
specified instance of alltypes As many fields in alltypes can be set as needed and the
values of all set fields (including fields explicitly set to
null) are then used to perform the query.
|
static void |
alltypesMgr.delete(Connection con,
alltypes bean)
Deletes this object from the database.
|
static int |
alltypesMgr.deleteUsing(Connection con,
alltypes bean)
Convenience method that invokes
getUsing with an empty clause parameter. |
static int |
alltypesMgr.deleteUsing(Connection con,
alltypes bean,
String clause)
Returns the rows returned by querying the table with the contents of
the specified instance of alltypes or null if no
rows were found.
|
static boolean |
alltypesMgr.existsUsing(Connection con,
alltypes bean)
A thin wrapper around
getUsing
that returns false if no rows are returned, true otherwise. |
static List |
alltypesMgr.getUsing(Connection con,
alltypes bean)
Convenience method that invokes
getUsing with an empty clause parameter. |
static List |
alltypesMgr.getUsing(Connection con,
alltypes bean,
String clause)
Returns the rows returned by querying the table with the value of the
specified alltypes object or an empty list if no rows were found.
|
static int |
alltypesMgr.save(Connection con,
alltypes bean)
Saves the specified object into the database.
|
static int |
alltypesMgr.update(Connection con,
alltypes bean,
int id)
Uses the specified object to update existing data in the database.
|