public class DbAccessKeySet
extends n4e.core.database.DbAccess
DbAccessKeySet
class reads fields and put to data sink of KeySet table in database.ERROR_0003, ERROR_0004, ERROR_0005, ERROR_0104, 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 |
---|
DbAccessKeySet()
The constructor
DbAccessKeySet initialized the object. |
DbAccessKeySet(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
DbAccessKeySet initialized the object. |
DbAccessKeySet(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
DbAccessKeySet initialized the object with additional sqlwhere. |
DbAccessKeySet(n4e.core.list.List4SysUser sysUser)
The constructor
DbAccessKeySet initialized the object. |
DbAccessKeySet(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessKeySet initialized the object. |
DbAccessKeySet(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
DbAccessKeySet 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 |
getDescription() |
java.lang.String |
getDescription2() |
java.lang.String |
getDescription3() |
java.lang.String |
getDescription4() |
java.lang.String |
getDescription5() |
java.lang.String |
getExplanation1() |
java.lang.String |
getExplanation2() |
java.lang.String |
getExplanation3() |
java.lang.String |
getExplanation4() |
java.lang.String |
getExplanation5() |
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 |
getLabel1() |
java.lang.String |
getLabel2() |
java.lang.String |
getLabel3() |
java.lang.String |
getLabel4() |
java.lang.String |
getLabel5() |
java.util.ArrayList |
getMyDbAccessKeyWord() |
java.lang.String |
getName() |
int |
getShowatclients() |
java.lang.String |
getTranslationText(int ndx)
The method
getTranslationText returns the translated text. |
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 |
setDescription(java.lang.String input) |
void |
setDescription2(java.lang.String input) |
void |
setDescription3(java.lang.String input) |
void |
setDescription4(java.lang.String input) |
void |
setDescription5(java.lang.String input) |
void |
setExplanation1(java.lang.String input) |
void |
setExplanation2(java.lang.String input) |
void |
setExplanation3(java.lang.String input) |
void |
setExplanation4(java.lang.String input) |
void |
setExplanation5(java.lang.String input) |
void |
setFieldAsString(java.lang.String fieldname,
java.lang.String value)
The method
setFieldAsString returns the field contens as a string. |
void |
setLabel1(java.lang.String input) |
void |
setLabel2(java.lang.String input) |
void |
setLabel3(java.lang.String input) |
void |
setLabel4(java.lang.String input) |
void |
setLabel5(java.lang.String input) |
void |
setMyDbAccessKeyWord(java.util.ArrayList input) |
void |
setName(java.lang.String input) |
void |
setShowatclients(int 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 DbAccessKeySet()
DbAccessKeySet
initialized the object.public DbAccessKeySet(n4e.core.list.List4SysUser sysUser)
DbAccessKeySet
initialized the object.sysUser
- the system user.public DbAccessKeySet(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
DbAccessKeySet
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 DbAccessKeySet(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
DbAccessKeySet
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 DbAccessKeySet(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
DbAccessKeySet
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 DbAccessKeySet(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
DbAccessKeySet
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 setName(java.lang.String input)
public java.lang.String getName()
public void setDescription(java.lang.String input)
public java.lang.String getDescription()
public void setDescription2(java.lang.String input)
public java.lang.String getDescription2()
public void setDescription3(java.lang.String input)
public java.lang.String getDescription3()
public void setDescription4(java.lang.String input)
public java.lang.String getDescription4()
public void setDescription5(java.lang.String input)
public java.lang.String getDescription5()
public void setShowatclients(int input)
public int getShowatclients()
public void setLabel1(java.lang.String input)
public java.lang.String getLabel1()
public void setLabel2(java.lang.String input)
public java.lang.String getLabel2()
public void setLabel3(java.lang.String input)
public java.lang.String getLabel3()
public void setLabel4(java.lang.String input)
public java.lang.String getLabel4()
public void setLabel5(java.lang.String input)
public java.lang.String getLabel5()
public void setExplanation1(java.lang.String input)
public java.lang.String getExplanation1()
public void setExplanation2(java.lang.String input)
public java.lang.String getExplanation2()
public void setExplanation3(java.lang.String input)
public java.lang.String getExplanation3()
public void setExplanation4(java.lang.String input)
public java.lang.String getExplanation4()
public void setExplanation5(java.lang.String input)
public java.lang.String getExplanation5()
public void setMyDbAccessKeyWord(java.util.ArrayList input)
public java.util.ArrayList getMyDbAccessKeyWord()
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
- the 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 value) throws java.lang.Exception
setFieldAsString
returns the field contens as a string.setFieldAsString
in class n4e.core.database.DbAccess
fieldname
- the name 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