public class DbAccessRead
extends java.lang.Object
DbAccessRead
class is the parent of all read classes.Modifier and Type | Field and Description |
---|---|
java.util.Date |
changed
date of last change data.
|
java.lang.String |
changedfrom
user changed.
|
java.lang.String |
client
foreign key to client table.
|
DatabaseConnection |
conn |
java.util.Date |
created
date of creation.
|
java.lang.String |
creator
user created.
|
java.lang.String |
databasename
name of own database.
|
java.lang.String |
dbtablename
name of own database table.
|
int |
errCode
internal error code of class.
|
java.lang.String |
errMess
internal error message of class.
|
static int |
ERROR_0001
The constant
ERROR_0001
no data found in this table (table). no uniqueid and no sqladd. |
static int |
ERROR_0002
The constant
ERROR_0002
no data found in this table (table). |
java.lang.String |
fields4load
field list which has to load from the database system.
|
boolean |
hasdata
true, if the fetch gets data from the database system.
|
java.lang.String |
indivTableFields
list of inidividual table fields.
|
int |
inuse
read but not updated.
|
java.lang.String |
keynameofpublvk
list of key names of table names of public foreign keys.
|
int |
LIST_OF_INDIV_TABLE_FIELDS
constant for controlling of getting a field list.
|
int |
LIST_OF_NAMES_OF_PUBLIC_FOREIGN_KEYS
constant for controlling of getting a field list.
|
int |
LIST_OF_PRIVATE_FOREIGN_KEYS
constant for controlling of getting a field list.
|
int |
LIST_OF_PUBLIC_FOREIGN_KEYS
constant for controlling of getting a field list.
|
int |
LIST_OF_STD_TABLE_FIELDS
constant for controlling of getting a field list.
|
int |
LIST_OF_TABLES_OWNER_KEYS
constant for controlling of getting a field list.
|
int |
LIST_OF_TABLES_PRIVATE_FOREIGN_KEYS
constant for controlling of getting a field list.
|
int |
LIST_OF_TABLES_PUBLIC_FOREIGN_KEYS
constant for controlling of getting a field list.
|
boolean |
myconn |
DatabaseConnectionSet |
myDatabaseConnectionSet
the own connection.
|
java.lang.String |
privateforeignkey
list of private foreign key fields.
|
java.util.Hashtable |
privateforeignkeytable
private foreign key hash table which contains the keys.
|
java.lang.String |
privfkey4load
private foreign key list which has to load from the database system.
|
java.lang.String |
publfkey4load
public foreign key list which has to load from the database system.
|
java.lang.String |
publicforeignkey
list of public foreign key fields.
|
java.util.Hashtable |
publicforeignkeytable
public foreign key hash table which contains the keys.
|
boolean |
read_with_client
flag, if read with clienbt id.
|
java.lang.String |
sqlAdd
addition to the sql statement.
|
java.lang.String |
stdTableFields
list of standard fields.
|
boolean |
success
true, if database operation was done with success.
|
n4e.core.list.List4SysUser |
sysUser
the current user object.
|
n4e.core.tool.Tool4Date |
t4d
the tool for date.
|
Tool4DbMessages |
t4m
the tool to give the language dependent message.
|
n4e.core.tool.Tool4Number |
t4n
the tool for number.
|
n4e.core.tool.Tool4String |
t4st
the tool for string.
|
java.lang.String |
tblnameofownerfield
list of names of table names of owner key.
|
java.lang.String |
tblnameofprivk
list of table names of private foreign keys.
|
java.lang.String |
tblnameofpublvk
list of table names of public foreign keys.
|
java.lang.String |
uniqueid
unique key.
|
long |
version
version counter for database store without locking.
|
Constructor and Description |
---|
DbAccessRead()
The constructor
DbAccessRead creates a new instance(object) of the class. |
DbAccessRead(n4e.core.list.List4SysUser pUser)
The constructor
DbAccessForm initialized the object. |
DbAccessRead(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessRead initialized the object |
DbAccessRead(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey,
java.lang.String sqlAdd)
The constructor
DbAccessRead initialized the object with additional sqlwhere |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getByteStringFromByteArray(byte[] data)
The method
getByteStringFromByteArray gets the byte code from byte array. |
java.util.Date |
getChanged()
get field: date of last change data.
|
java.lang.String |
getChangedfrom()
get field: user changed.
|
java.lang.String |
getClient()
get field: foreign key to client table.
|
java.util.Date |
getCreated()
get field: date of creation.
|
java.lang.String |
getCreator()
get field: user created.
|
java.lang.String |
getDatabasename()
get field: name of own database.
|
java.util.ArrayList |
getDataSet(java.lang.String addsqlorder)
The method
getDataSet returns a data set from table. |
java.lang.String |
getDbTablename()
get field: name of own database table.
|
java.lang.String |
getDefData(java.lang.String fieldname,
java.lang.String datatype)
The method
getDefData returns data concerning a table field. |
java.lang.String |
getFieldAsString(java.lang.String fieldname)
The method
getFieldAsString returns the field contens as a string. |
java.lang.String |
getFieldAsStringKey(java.lang.String fieldname,
java.lang.Boolean getkey)
The method
getFieldAsStringKey returns the field contens as a string. |
java.lang.String |
getIndivTableFields()
get field: list of individual table fields.
|
int |
getInuse()
get field: read but not updated.
|
java.lang.String |
getKeynameofpublvk()
get field: list of key names of table names of public foreign keys.
|
java.util.ArrayList |
getListOfFields(int ndx)
The method
getListOfFields returns a list of key values. |
java.util.ArrayList |
getListOfFields(java.lang.Integer ondx)
The method
getListOfFields returns a list of key values. |
java.lang.String |
getPrivateforeignkey()
get field: list of private foreign key fields.
|
java.lang.String |
getPublicforeignkey()
get field: list of public foreign key fields.
|
java.lang.String |
getStdTableFields()
get field: list of standard fields.
|
n4e.core.list.List4SysUser |
getSystemUser()
get field: the current user object.
|
java.lang.String |
getTblnameofownerfield()
get field: list of names of table names of owner key.
|
java.lang.String |
getTblnameofprivk()
get field: list of table names of private foreign keys.
|
java.lang.String |
getTblnameofpublvk()
get field: list of table names of public foreign keys.
|
java.lang.String |
getUniqueid()
get field: unique key.
|
long |
getVersion()
get field: version counter for database store without locking.
|
void |
initiate(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey,
java.lang.String sqlAdd,
boolean read_with_client)
The method
Initialize initializes the object with additional sqlwhere. |
boolean |
loadFromTable(java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey,
java.lang.String sqlAdd)
The method
loadFromTable gets tabledata from database. |
void |
setChanged(java.util.Date input)
set field: date of last change data.
|
void |
setChangedfrom(java.lang.String input)
set field: user changed.
|
void |
setClient(java.lang.String input)
set field: foreign key to client table.
|
void |
setCreated(java.util.Date input)
set field: date of creation.
|
void |
setCreator(java.lang.String input)
set field: user created.
|
void |
setInuse(int input)
set field: read but not updated.
|
void |
setInuse(java.lang.Integer input)
set field: read but not updated.
|
void |
setSystemUser(n4e.core.list.List4SysUser input)
set field: the current user object.
|
void |
setUniqueid(java.lang.String input)
set field: unique key.
|
void |
setVersion(long input)
set field: version counter for database store without locking.
|
void |
setVersion(java.lang.Long input)
set field: version counter for database store without locking.
|
void |
setWorkFields()
The method
setWorkFields sets the work fiels to current values. |
public static final int ERROR_0001
ERROR_0001
no data found in this table (table). no uniqueid and no sqladd.public static final int ERROR_0002
ERROR_0002
no data found in this table (table).public final int LIST_OF_STD_TABLE_FIELDS
public final int LIST_OF_INDIV_TABLE_FIELDS
public final int LIST_OF_PRIVATE_FOREIGN_KEYS
public final int LIST_OF_TABLES_PRIVATE_FOREIGN_KEYS
public final int LIST_OF_PUBLIC_FOREIGN_KEYS
public final int LIST_OF_TABLES_PUBLIC_FOREIGN_KEYS
public final int LIST_OF_TABLES_OWNER_KEYS
public final int LIST_OF_NAMES_OF_PUBLIC_FOREIGN_KEYS
public int errCode
public java.lang.String errMess
public boolean success
public boolean hasdata
public java.lang.String dbtablename
public java.lang.String databasename
public java.lang.String tblnameofprivk
public java.lang.String tblnameofpublvk
public java.lang.String keynameofpublvk
public java.lang.String tblnameofownerfield
public java.lang.String sqlAdd
public final java.lang.String stdTableFields
public java.lang.String indivTableFields
public java.lang.String privateforeignkey
public java.lang.String publicforeignkey
public java.lang.String fields4load
public java.lang.String privfkey4load
public java.lang.String publfkey4load
public n4e.core.list.List4SysUser sysUser
public java.util.Hashtable publicforeignkeytable
public java.util.Hashtable privateforeignkeytable
public DatabaseConnectionSet myDatabaseConnectionSet
public DatabaseConnection conn
public boolean myconn
public Tool4DbMessages t4m
public java.lang.String uniqueid
public long version
public java.util.Date created
public java.lang.String creator
public java.util.Date changed
public java.lang.String changedfrom
public int inuse
public java.lang.String client
public boolean read_with_client
public n4e.core.tool.Tool4String t4st
public n4e.core.tool.Tool4Number t4n
public n4e.core.tool.Tool4Date t4d
public DbAccessRead()
DbAccessRead
creates a new instance(object) of the class.public DbAccessRead(n4e.core.list.List4SysUser pUser)
DbAccessForm
initialized the object.pUser
- the system user.public DbAccessRead(n4e.core.list.List4SysUser pUser, java.lang.String uniqueid, java.lang.String fieldlist, java.lang.String privfkey, java.lang.String publfkey) throws java.lang.Exception
DbAccessRead
initialized the objectpUser
- the user object.uniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadjava.lang.Exception
- if error.public DbAccessRead(n4e.core.list.List4SysUser pUser, java.lang.String uniqueid, java.lang.String fieldlist, java.lang.String privfkey, java.lang.String publfkey, java.lang.String sqlAdd) throws java.lang.Exception
DbAccessRead
initialized the object with additional sqlwherepUser
- the user object.uniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadsqlAdd
- additional where clausejava.lang.Exception
- if error.public java.lang.String getDbTablename()
public java.lang.String getDatabasename()
public java.lang.String getTblnameofprivk()
public java.lang.String getTblnameofpublvk()
public java.lang.String getKeynameofpublvk()
public java.lang.String getTblnameofownerfield()
public java.lang.String getStdTableFields()
public java.lang.String getIndivTableFields()
public java.lang.String getPrivateforeignkey()
public java.lang.String getPublicforeignkey()
public void setSystemUser(n4e.core.list.List4SysUser input)
input
- user objectpublic n4e.core.list.List4SysUser getSystemUser()
public void setUniqueid(java.lang.String input)
input
- unique keypublic java.lang.String getUniqueid()
public void setVersion(long input)
input
- versionpublic void setVersion(java.lang.Long input)
input
- versionpublic long getVersion()
public void setCreated(java.util.Date input)
input
- date of creationpublic java.util.Date getCreated()
public void setCreator(java.lang.String input)
input
- user createdpublic java.lang.String getCreator()
public void setChanged(java.util.Date input)
input
- date of last change datapublic java.util.Date getChanged()
public void setChangedfrom(java.lang.String input)
input
- user changedpublic java.lang.String getChangedfrom()
public void setInuse(int input)
input
- read but not updatedpublic int getInuse()
public void setInuse(java.lang.Integer input)
input
- read but not updatedpublic void setClient(java.lang.String input)
input
- foreign key to client tablepublic java.lang.String getClient()
public void initiate(n4e.core.list.List4SysUser pUser, java.lang.String uniqueid, java.lang.String fieldlist, java.lang.String privfkey, java.lang.String publfkey, java.lang.String sqlAdd, boolean read_with_client) throws java.lang.Exception
Initialize
initializes the object with additional sqlwhere.pUser
- the user object.uniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadsqlAdd
- additional where clauseread_with_client
- read with clientjava.lang.Exception
- if error.public void setWorkFields()
setWorkFields
sets the work fiels to current values.public java.util.ArrayList getListOfFields(java.lang.Integer ondx)
getListOfFields
returns a list of key values.ondx
- index of informationpublic java.util.ArrayList getListOfFields(int ndx)
getListOfFields
returns a list of key values.ndx
- index of informationpublic boolean loadFromTable(java.lang.String uniqueid, java.lang.String fieldlist, java.lang.String privfkey, java.lang.String publfkey, java.lang.String sqlAdd) throws java.lang.Exception
loadFromTable
gets tabledata from database.uniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadsqlAdd
- additional where clausejava.lang.Exception
- if error.public java.lang.String getDefData(java.lang.String fieldname, java.lang.String datatype) throws java.lang.Exception
getDefData
returns data concerning a table field.fieldname
- the name of table fielddatatype
- type of data to returnjava.lang.Exception
- if error.public java.lang.String getFieldAsString(java.lang.String fieldname) throws java.lang.Exception
getFieldAsString
returns the field contens as a string.fieldname
- the name of table fieldjava.lang.Exception
- if errorpublic java.lang.String getFieldAsStringKey(java.lang.String fieldname, java.lang.Boolean getkey) throws java.lang.Exception
getFieldAsStringKey
returns the field contens as a string.fieldname
- the name of table field.getkey,
- get the key value.java.lang.Exception
- if errorpublic java.util.ArrayList getDataSet(java.lang.String addsqlorder) throws java.lang.Exception
getDataSet
returns a data set from table.addsqlorder
- order of sql resultjava.lang.Exception
- if error.public java.lang.String getByteStringFromByteArray(byte[] data)
getByteStringFromByteArray
gets the byte code from byte array.data,
- the byte array.