public class DbAccessProtocol extends DbAccess
DbAccessProtocol
class reads fields and put to data sink of Protocol 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 |
---|
DbAccessProtocol()
The constructor
DbAccessProtocol initialized the object. |
DbAccessProtocol(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
DbAccessProtocol initialized the object. |
DbAccessProtocol(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
DbAccessProtocol initialized the object with additional sqlwhere. |
DbAccessProtocol(n4e.core.list.List4SysUser sysUser)
The constructor
DbAccessProtocol initialized the object. |
DbAccessProtocol(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessProtocol initialized the object. |
DbAccessProtocol(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
DbAccessProtocol initialized the object with additional sqlwhere. |
Modifier and Type | Method and Description |
---|---|
boolean |
deleteInSink(DatabaseConnection conn)
The method
deleteInSink deletes the data in database (data sink). |
java.util.Date |
getActiondate() |
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. |
java.lang.String |
getKeyWord(java.lang.String uid)
The method
getKeyWord gets a keyword from keyset. |
java.util.ArrayList |
getKeyWordList(java.lang.String keyset,
java.lang.String dontshowaskey)
The method
getKeyWordList gets a list of all keywords from keyset. |
java.lang.String |
getName() |
java.lang.String |
getProtocoltype() |
java.lang.String |
getShorttext() |
java.lang.String |
getTableuid() |
java.lang.String |
getText() |
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(DatabaseConnection conn)
The method
putCurrentDataToSink executes an sql update. |
boolean |
putNewDataToSink(DatabaseConnection conn)
The method
putNewDataToSink executes an sql insert. |
boolean |
putNewDataToSink(DatabaseConnection conn,
java.lang.Boolean dotrigger)
The method
putNewDataToSink executes an sql insert. |
boolean |
putToSink(DatabaseConnection conn)
The method
putToSink stores the data to database (data sink). |
void |
setActiondate(java.util.Date input) |
void |
setFieldAsString(java.lang.String fieldname,
java.lang.String value)
The method
setFieldAsString returns the field contens as a string. |
void |
setName(java.lang.String input) |
void |
setProtocoltype(java.lang.String input) |
void |
setShorttext(java.lang.String input) |
void |
setTableuid(java.lang.String input) |
void |
setText(java.lang.String input) |
void |
setWorkFields()
The method
setWorkFields sets the work fiels to current values. |
setKeyWordsAsUsed, setProtocol
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 DbAccessProtocol()
DbAccessProtocol
initialized the object.public DbAccessProtocol(n4e.core.list.List4SysUser sysUser)
DbAccessProtocol
initialized the object.sysUser
- the system user.public DbAccessProtocol(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
DbAccessProtocol
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 DbAccessProtocol(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
DbAccessProtocol
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 DbAccessProtocol(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
DbAccessProtocol
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 DbAccessProtocol(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
DbAccessProtocol
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 setProtocoltype(java.lang.String input)
public java.lang.String getProtocoltype()
public void setActiondate(java.util.Date input)
public java.util.Date getActiondate()
public void setTableuid(java.lang.String input)
public java.lang.String getTableuid()
public void setShorttext(java.lang.String input)
public java.lang.String getShorttext()
public void setText(java.lang.String input)
public java.lang.String getText()
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 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 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 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(DatabaseConnection conn) throws java.lang.Exception
putToSink
stores the data to database (data sink).public boolean putNewDataToSink(DatabaseConnection conn) throws java.lang.Exception
putNewDataToSink
executes an sql insert.conn
- the database connection.java.lang.Exception
- if errorpublic boolean putNewDataToSink(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(DatabaseConnection conn) throws java.lang.Exception
putCurrentDataToSink
executes an sql update.conn
- connectionjava.lang.Exception
- if errorpublic boolean deleteInSink(DatabaseConnection conn) throws java.lang.Exception
deleteInSink
deletes the data in database (data sink).deleteInSink
in class 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 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 DbAccess
fieldname
- the name of table fieldvalue
- of the field.java.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 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 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 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 errorpublic java.lang.String getKeyWord(java.lang.String uid) throws java.lang.Exception
getKeyWord
gets a keyword from keyset.uid
- uniqueid of keywordjava.lang.Exception
- if errorpublic java.util.ArrayList getKeyWordList(java.lang.String keyset, java.lang.String dontshowaskey) throws java.lang.Exception
getKeyWordList
gets a list of all keywords from keyset.keyset
- name of keysetdontshowaskey
- key word uniqueids without showing separated by semicolon.java.lang.Exception
- if error