public class DbAccessResultValue
extends n4e.core.database.DbAccess
DbAccessResultValue
class reads fields and put to data sink of ResultValue table in database.ERROR_0003, ERROR_0004, ERROR_0005, ERROR_0104, ERROR_0105, key_words_used, MSG_0006, MSG_0007, MSG_0008, protocol
changed, changedfrom, client, conn, created, creator, databasename, dbtablename, errCode, errMess, ERROR_0001, ERROR_0002, fields4load, hasdata, indivTableFields, inuse, keynameofpublvk, LIST_OF_INDIV_TABLE_FIELDS, LIST_OF_NAMES_OF_PUBLIC_FOREIGN_KEYS, LIST_OF_PRIVATE_FOREIGN_KEYS, LIST_OF_PUBLIC_FOREIGN_KEYS, LIST_OF_STD_TABLE_FIELDS, LIST_OF_TABLES_OWNER_KEYS, LIST_OF_TABLES_PRIVATE_FOREIGN_KEYS, LIST_OF_TABLES_PUBLIC_FOREIGN_KEYS, myconn, myDatabaseConnectionSet, privateforeignkey, privateforeignkeytable, privfkey4load, publfkey4load, publicforeignkey, publicforeignkeytable, read_with_client, sqlAdd, stdTableFields, success, sysUser, t4d, t4m, t4n, t4st, tblnameofownerfield, tblnameofprivk, tblnameofpublvk, uniqueid, version
Constructor and Description |
---|
DbAccessResultValue()
The constructor
DbAccessResultValue initialized the object. |
DbAccessResultValue(n4e.core.database.DatabaseConnection conn,
n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessResultValue initialized the object. |
DbAccessResultValue(n4e.core.database.DatabaseConnection conn,
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
DbAccessResultValue initialized the object with additional sqlwhere. |
DbAccessResultValue(n4e.core.list.List4SysUser sysUser)
The constructor
DbAccessResultValue initialized the object. |
DbAccessResultValue(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessResultValue initialized the object. |
DbAccessResultValue(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
DbAccessResultValue initialized the object with additional sqlwhere. |
Modifier and Type | Method and Description |
---|---|
boolean |
deleteInSink(n4e.core.database.DatabaseConnection conn)
The method
deleteInSink deletes the data in database (data sink). |
byte[] |
getBlobField(java.lang.String fieldname)
The method
getBlobField returns the field contens of blob fields. |
java.util.ArrayList |
getDataSet(java.lang.String addsqlorder)
The method
getDataSet returns a data set from 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 |
getFieldAsStringKey(java.lang.String fieldname,
java.lang.Boolean getkey)
The method
getFieldAsStringKey returns the field contens as a string. |
DbAccessResultAtt |
getMyDbAccessResultAtt() |
long |
getRuleno() |
java.lang.String |
getTranslationText(int ndx)
The method
getTranslationText returns the translated text. |
java.lang.String |
getValue() |
boolean |
hasChanged(java.lang.String fieldname)
The method
hasChanged returns the status of field change. |
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
initiate 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 with fieldcheck. |
boolean |
putCurrentDataToSink(n4e.core.database.DatabaseConnection conn)
The method
putCurrentDataToSink executes an sql update. |
boolean |
putNewDataToSink(n4e.core.database.DatabaseConnection conn)
The method
putNewDataToSink executes an sql insert. |
boolean |
putNewDataToSink(n4e.core.database.DatabaseConnection conn,
java.lang.Boolean dotrigger)
The method
putNewDataToSink executes an sql insert. |
boolean |
putToSink(n4e.core.database.DatabaseConnection conn)
The method
putToSink stores the data to database (data sink). |
void |
setFieldAsString(java.lang.String fieldname,
java.lang.String valuexyz)
The method
setFieldAsString returns the field contens as a string. |
void |
setMyDbAccessResultAtt(DbAccessResultAtt input) |
void |
setRuleno(long input) |
void |
setValue(java.lang.String input) |
void |
setWorkFields()
The method
setWorkFields sets the work fiels to current values. |
getByteStringFromByteArray, getChanged, getChangedfrom, getClient, getCreated, getCreator, getDatabasename, getDbTablename, getFieldAsString, getIndivTableFields, getInuse, getKeynameofpublvk, getListOfFields, getListOfFields, getPrivateforeignkey, getPublicforeignkey, getStdTableFields, getSystemUser, getTblnameofownerfield, getTblnameofprivk, getTblnameofpublvk, getUniqueid, getVersion, setChanged, setChangedfrom, setClient, setCreated, setCreator, setInuse, setInuse, setSystemUser, setUniqueid, setVersion, setVersion
public DbAccessResultValue()
DbAccessResultValue
initialized the object.public DbAccessResultValue(n4e.core.list.List4SysUser sysUser)
DbAccessResultValue
initialized the object.sysUser
- the system user.public DbAccessResultValue(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
DbAccessResultValue
initialized the object.pUser
- 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 errorpublic DbAccessResultValue(n4e.core.database.DatabaseConnection conn, 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
DbAccessResultValue
initialized the object.conn
- the database connection.pUser
- the user objectuniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadjava.lang.Exception
- if errorpublic DbAccessResultValue(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
DbAccessResultValue
initialized the object with additional sqlwhere.pUser
- the user objectuniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadsqlAdd
- additional where clausejava.lang.Exception
- if errorpublic DbAccessResultValue(n4e.core.database.DatabaseConnection conn, 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
DbAccessResultValue
initialized the object with additional sqlwhere.conn
- the database connection.pUser
- the user objectuniqueid
- the unique keyfieldlist
- List of fields to loadprivfkey
- List of privfkeys to loadpublfkey
- List of publfkeys to loadsqlAdd
- additional where clausejava.lang.Exception
- if errorpublic void setValue(java.lang.String input)
public java.lang.String getValue()
public void setRuleno(long input)
public long getRuleno()
public void setMyDbAccessResultAtt(DbAccessResultAtt input)
public DbAccessResultAtt getMyDbAccessResultAtt()
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
initiate
initializes the object with additional sqlwhere.initiate
in class n4e.core.database.DbAccessRead
pUser
- the user object.uniqueid
- the unique key.fieldlist
- List of fields to load.privfkey
- List of privfkeys to load.publfkey
- List of publfkeys to load.sqlAdd
- additional where clause.read_with_client
- read with use of the clientid.java.lang.Exception
- if error.public void setWorkFields()
setWorkFields
sets the work fiels to current values.setWorkFields
in class n4e.core.database.DbAccessRead
public 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 with fieldcheck.loadFromTable
in class n4e.core.database.DbAccessRead
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 errorpublic boolean putToSink(n4e.core.database.DatabaseConnection conn) throws java.lang.Exception
putToSink
stores the data to database (data sink).putToSink
in class n4e.core.database.DbAccess
conn
- Connection to Database, if null: make own connectionjava.lang.Exception
- if errorpublic boolean putNewDataToSink(n4e.core.database.DatabaseConnection conn) throws java.lang.Exception
putNewDataToSink
executes an sql insert.conn
- the database connection.java.lang.Exception
- if errorpublic boolean putNewDataToSink(n4e.core.database.DatabaseConnection conn, java.lang.Boolean dotrigger) throws java.lang.Exception
putNewDataToSink
executes an sql insert.conn
- the database connection.dotrigger,
- do the trigger.java.lang.Exception
- if errorpublic boolean putCurrentDataToSink(n4e.core.database.DatabaseConnection conn) throws java.lang.Exception
putCurrentDataToSink
executes an sql update.conn
- a database connectionjava.lang.Exception
- if errorpublic boolean deleteInSink(n4e.core.database.DatabaseConnection conn) throws java.lang.Exception
deleteInSink
deletes the data in database (data sink).deleteInSink
in class n4e.core.database.DbAccess
conn
- Connection to Database, if null: make own connectionjava.lang.Exception
- if errorpublic java.lang.String getDefData(java.lang.String fieldname, java.lang.String datatype) throws java.lang.Exception
getDefData
returns data concerning a table field.getDefData
in class n4e.core.database.DbAccessRead
fieldname
- the name of table fielddatatype
- type of data to returnjava.lang.Exception
- if errorpublic void setFieldAsString(java.lang.String fieldname, java.lang.String valuexyz) throws java.lang.Exception
setFieldAsString
returns the field contens as a string.setFieldAsString
in class n4e.core.database.DbAccess
fieldname
- the name of table fieldvaluexyz
- the value of table fieldjava.lang.Exception
- if errorpublic byte[] getBlobField(java.lang.String fieldname) throws java.lang.Exception
getBlobField
returns the field contens of blob fields.fieldname
- the name of table field.java.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.getFieldAsStringKey
in class n4e.core.database.DbAccessRead
fieldname
- the name of table field.getkey,
- get the key value.java.lang.Exception
- if errorpublic boolean hasChanged(java.lang.String fieldname) throws java.lang.Exception
hasChanged
returns the status of field change.hasChanged
in class n4e.core.database.DbAccess
fieldname
- the name of table fieldjava.lang.Exception
- if errorpublic java.util.ArrayList getDataSet(java.lang.String addsqlorder) throws java.lang.Exception
getDataSet
returns a data set from table.getDataSet
in class n4e.core.database.DbAccessRead
addsqlorder
- order of sql resultjava.lang.Exception
- if errorpublic java.lang.String getTranslationText(int ndx) throws java.lang.Exception
getTranslationText
returns the translated text.ndx
- the text index.java.lang.Exception
- if error