public class DbAccessKeyWord
extends n4e.core.database.DbAccess
DbAccessKeyWord
class reads fields and put to data sink of KeyWord 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 |
---|
DbAccessKeyWord()
The constructor
DbAccessKeyWord initialized the object. |
DbAccessKeyWord(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
DbAccessKeyWord initialized the object. |
DbAccessKeyWord(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
DbAccessKeyWord initialized the object with additional sqlwhere. |
DbAccessKeyWord(n4e.core.list.List4SysUser sysUser)
The constructor
DbAccessKeyWord initialized the object. |
DbAccessKeyWord(n4e.core.list.List4SysUser pUser,
java.lang.String uniqueid,
java.lang.String fieldlist,
java.lang.String privfkey,
java.lang.String publfkey)
The constructor
DbAccessKeyWord initialized the object. |
DbAccessKeyWord(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
DbAccessKeyWord 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. |
int |
getCanchangename() |
int |
getCandelete() |
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 |
getFieldAsStringKey(java.lang.String fieldname,
java.lang.Boolean getkey)
The method
getFieldAsStringKey returns the field contens as a string. |
DbAccessKeySet |
getMyDbAccessKeySet() |
java.lang.String |
getName() |
java.lang.String |
getName2() |
java.lang.String |
getName3() |
java.lang.String |
getName4() |
java.lang.String |
getName5() |
java.lang.String |
getParameter1() |
java.lang.String |
getParameter2() |
java.lang.String |
getParameter3() |
java.lang.String |
getParameter4() |
java.lang.String |
getParameter5() |
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 |
setCanchangename(int input) |
void |
setCandelete(int input) |
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 |
setFieldAsString(java.lang.String fieldname,
java.lang.String value)
The method
setFieldAsString returns the field contens as a string. |
void |
setMyDbAccessKeySet(DbAccessKeySet input) |
void |
setName(java.lang.String input) |
void |
setName2(java.lang.String input) |
void |
setName3(java.lang.String input) |
void |
setName4(java.lang.String input) |
void |
setName5(java.lang.String input) |
void |
setParameter1(java.lang.String input) |
void |
setParameter2(java.lang.String input) |
void |
setParameter3(java.lang.String input) |
void |
setParameter4(java.lang.String input) |
void |
setParameter5(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 DbAccessKeyWord()
DbAccessKeyWord
initialized the object.public DbAccessKeyWord(n4e.core.list.List4SysUser sysUser)
DbAccessKeyWord
initialized the object.sysUser
- the system user.public DbAccessKeyWord(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
DbAccessKeyWord
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 DbAccessKeyWord(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
DbAccessKeyWord
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 DbAccessKeyWord(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
DbAccessKeyWord
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 DbAccessKeyWord(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
DbAccessKeyWord
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 setName2(java.lang.String input)
public java.lang.String getName2()
public void setName3(java.lang.String input)
public java.lang.String getName3()
public void setName4(java.lang.String input)
public java.lang.String getName4()
public void setName5(java.lang.String input)
public java.lang.String getName5()
public void setCanchangename(int input)
public int getCanchangename()
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 setParameter1(java.lang.String input)
public java.lang.String getParameter1()
public void setParameter2(java.lang.String input)
public java.lang.String getParameter2()
public void setParameter3(java.lang.String input)
public java.lang.String getParameter3()
public void setParameter4(java.lang.String input)
public java.lang.String getParameter4()
public void setParameter5(java.lang.String input)
public java.lang.String getParameter5()
public void setCandelete(int input)
public int getCandelete()
public void setMyDbAccessKeySet(DbAccessKeySet input)
public DbAccessKeySet getMyDbAccessKeySet()
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 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