mali.table.impl

Class SYSMYCERTImpl

java.lang.Object

mali.object.CommonFieldObject

mali.db.BaseCommonBoImpl

mali.db.BaseTableimpl

mali.table.impl.SYSMYCERTImpl

All Implemented Interfaces:

java.io.Serializable, SYSMYCERT, BaseCommonBo, BaseTable

public class SYSMYCERTImpl
extends BaseTableimpl
implements SYSMYCERT

SYSMYCERT 帳號憑證管理檔#

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	KEY_CERT_CARDSN 憑證卡號
static java.lang.String	KEY_CERT_CREADATETIME 建檔日期時間
static java.lang.String	KEY_CERT_CREUSERID 建檔人員
static java.lang.String	KEY_CERT_IDNO 身份證號(統編)
static java.lang.String	KEY_CERT_MEMBERSEQNO 帳號檔唯一序號
static java.lang.String	KEY_CERT_MTNDATETIME 異動日期時間
static java.lang.String	KEY_CERT_MTNUSERID 異動人員
static java.lang.String	KEY_CERT_PUBLICKEY 憑證公KEY
static java.lang.String	KEY_CERT_REGCOUNT 憑證註冊次數
static java.lang.String	KEY_CERT_SEQNO 唯一序號
static java.lang.String	KEY_CERT_STOPTIME 憑證到期日期
static java.lang.String	KEY_CERT_TYPE 憑證類別
static java.lang.String[]	KEY_PRIMARYID
static java.lang.String	TABLENAME

Fields inherited from class mali.db.BaseTableimpl

dataisexists, errMesg, KEY_ACTION, KEY_ALLFIELDList, KEY_Parameters, tmpRowdata, VALUE_ACTION, VALUE_ACTION_ADD, VALUE_ACTION_DELETE, VALUE_ACTION_REPLACE, VALUE_ACTION_UPDATE, VALUE_Parameters_使用TABLE介面

Constructor Summary

Constructors

Constructor and Description
SYSMYCERTImpl()
SYSMYCERTImpl(BaseTable therow)
SYSMYCERTImpl(MaliContext inContext)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	getCERT_CARDSN() get 憑證卡號
java.lang.String	getCERT_CREADATETIME() get 建檔日期時間
java.lang.String	getCERT_CREUSERID() get 建檔人員
java.lang.String	getCERT_IDNO() get 身份證號(統編)
java.lang.String	getCERT_MEMBERSEQNO() get 帳號檔唯一序號
java.lang.String	getCERT_MTNDATETIME() get 異動日期時間
java.lang.String	getCERT_MTNUSERID() get 異動人員
java.security.PublicKey	getCERT_PUBLICKEY() get 憑證公KEY
java.lang.Integer	getCERT_REGCOUNT() get 憑證註冊次數
java.lang.String	getCERT_SEQNO() get 唯一序號
java.lang.String	getCERT_STOPTIME() get 憑證到期日期
java.lang.String	getCERT_TYPE() get 憑證類別
static java.lang.Object	getinstance(MaliContext inContext)
void	init()
boolean	preDelete() if preDelete is true then use setDeleteTrigger method, if false then Exception error Message,don't execute delete;
boolean	preInsert() if preInsert is true then use setInsertTrigger method else if false then Exception error Message, don't execute insert;
boolean	preUpdate() if preUpdate is true then use setUpateTrriger method , if false then Exception error Message,don't execute update ;
void	setCERT_CARDSN(java.lang.String fieldvalue) set 憑證卡號
void	setCERT_CREADATETIME(java.lang.String fieldvalue) set 建檔日期時間
void	setCERT_CREUSERID(java.lang.String fieldvalue) set 建檔人員
void	setCERT_IDNO(java.lang.String fieldvalue) set 身份證號(統編)
void	setCERT_MEMBERSEQNO(java.lang.String fieldvalue) set 帳號檔唯一序號
void	setCERT_MTNDATETIME(java.lang.String fieldvalue) set 異動日期時間
void	setCERT_MTNUSERID(java.lang.String fieldvalue) set 異動人員
void	setCERT_PUBLICKEY(java.lang.String fieldvalue) set 憑證公KEY
void	setCERT_REGCOUNT(java.lang.Integer fieldvalue) set 憑證註冊次數
void	setCERT_SEQNO(java.lang.String fieldvalue) set 唯一序號
void	setCERT_STOPTIME(java.lang.String fieldvalue) SET 憑證到期日期
void	setCERT_TYPE(java.lang.String fieldvalue) set 憑證類別
void	setDeleteTrigger() using delete executed before setDeleteTrigger
void	setInsertTrigger() using insert executed before setInsertTrigger
void	setMaliContext(MaliContext inContext) set MaliContext
void	setUpdateTrigger() using update executed before setUpdateTrigger

Methods inherited from class mali.db.BaseTableimpl

checkSQLAction, ConvertToBaseTable, createObjectByByteArray, delete, execute, execute, fillColumns, generatePrimaryId, getActionmode, getAllFieldList, getBaseTable, getBasetablefield, getCalendarfield, getclsSqlData, getCommitActionMode, getConnDbCom, getCurTablePrimaryKey, getDBColumnType, getDoublefield, getErrMesg, geterrorMesgRowData, getFieldColumnIndex, getFieldValue, getInstance, getIntegerfield, getMaliContext, getObjectfield, getOldData, getPimaryId, getPostexecuteBatchQuery, getPostExecuteTable, getPreExecuteTable, getPrimaryId, getPrimaryKey, getPrimaryKeyValue, getRowData, getROWID, getStringfield, getTableName, getTimestampfield, getUpdateLog, getVectorfield, inputRowData, insert, isDeleteed, isexecuteupdate, isFieldError, isInserted, isPrimaryKey, isSaveed, isStringSpacetoNull, isUpdated, is資料是否存在, modifyoldFieldvalue, postDelete, postInsert, postUpdate, removeField, reset, rollBack, setActionmode, setALLFIELDSList, setConnDbCom, setDataBaseType, setDeleteMode, setErrMesg, setErrorMesg, setFielddata, setFielddata, setInsertDefaultValue, setInsertMode, setPostexecuteBatchQuery, setPostExecuteTable, setPreExecuteTable, setPrimaryId, setPrimaryKey, setReplaceMode, setRowData, setROWID, setStringSpaceToNull, setStringValue, setTableName, setUpdateDefaultValue, setUpdateMode, toString, update, update

Methods inherited from class mali.db.BaseCommonBoImpl

getcreateDateTimeKey, getcreateUserIdKey, getcreateUserOrgIdKey, getmodifyDateTimeKey, getmodifyUserIdKey, getmodifyUserOrgIdKey, getPrimaryIdKey, isFieldbyBaseTable, setcreateDateTimeKey, setcreateUserIdKey, setcreateUserOrgIdKey, setFieldbyBaseTable, setmodifyDateTimeKey, setmodifyUserIdKey, setmodifyUserOrgIdkey, setPrimaryIdKey

Methods inherited from class mali.object.CommonFieldObject

createObjectByteArray, getHashTableContent, setVectorFielddata

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface mali.type.BaseTable

checkSQLAction, ConvertToBaseTable, delete, execute, execute, fillColumns, generatePrimaryId, getActionmode, getBaseTable, getBasetablefield, getclsSqlData, getCommitActionMode, getConnDbCom, getCurTablePrimaryKey, getDBColumnType, getDoublefield, getErrMesg, geterrorMesgRowData, getFieldColumnIndex, getFieldValue, getInstance, getIntegerfield, getMaliContext, getObjectfield, getOldData, getPimaryId, getPostexecuteBatchQuery, getPostExecuteTable, getPreExecuteTable, getPrimaryId, getPrimaryKey, getPrimaryKeyValue, getRowData, getROWID, getStringfield, getTableName, getTimestampfield, inputRowData, insert, isDeleteed, isexecuteupdate, isFieldError, isInserted, isPrimaryKey, isSaveed, isStringSpacetoNull, isUpdated, is資料是否存在, postDelete, postInsert, postUpdate, removeField, reset, setActionmode, setConnDbCom, setDeleteMode, setErrMesg, setFielddata, setFielddata, setInsertDefaultValue, setInsertMode, setPostexecuteBatchQuery, setPostExecuteTable, setPreExecuteTable, setPrimaryId, setPrimaryKey, setReplaceMode, setRowData, setROWID, setStringSpaceToNull, setTableName, setUpdateDefaultValue, setUpdateMode, update, update

Methods inherited from interface mali.type.BaseCommonBo

getcreateDateTimeKey, getcreateUserIdKey, getcreateUserOrgIdKey, getmodifyDateTimeKey, getmodifyUserIdKey, getmodifyUserOrgIdKey, getPrimaryIdKey, isFieldbyBaseTable, setcreateDateTimeKey, setcreateUserIdKey, setcreateUserOrgIdKey, setmodifyDateTimeKey, setmodifyUserIdKey, setmodifyUserOrgIdkey, setPrimaryIdKey

Field Detail

TABLENAME

public static final java.lang.String TABLENAME

See Also:

Constant Field Values

KEY_CERT_MEMBERSEQNO

public static java.lang.String KEY_CERT_MEMBERSEQNO

帳號檔唯一序號

KEY_CERT_SEQNO

public static java.lang.String KEY_CERT_SEQNO

唯一序號

KEY_CERT_CARDSN

public static java.lang.String KEY_CERT_CARDSN

憑證卡號

KEY_CERT_PUBLICKEY

public static java.lang.String KEY_CERT_PUBLICKEY

憑證公KEY

KEY_CERT_TYPE

public static java.lang.String KEY_CERT_TYPE

憑證類別

KEY_CERT_CREADATETIME

public static java.lang.String KEY_CERT_CREADATETIME

建檔日期時間

KEY_CERT_CREUSERID

public static java.lang.String KEY_CERT_CREUSERID

建檔人員

KEY_CERT_MTNDATETIME

public static java.lang.String KEY_CERT_MTNDATETIME

異動日期時間

KEY_CERT_MTNUSERID

public static java.lang.String KEY_CERT_MTNUSERID

異動人員

KEY_CERT_REGCOUNT

public static java.lang.String KEY_CERT_REGCOUNT

憑證註冊次數

KEY_CERT_IDNO

public static java.lang.String KEY_CERT_IDNO

身份證號(統編)

KEY_CERT_STOPTIME

public static java.lang.String KEY_CERT_STOPTIME

憑證到期日期

KEY_PRIMARYID

public static java.lang.String[] KEY_PRIMARYID

Constructor Detail

SYSMYCERTImpl

public SYSMYCERTImpl()

SYSMYCERTImpl

public SYSMYCERTImpl(BaseTable therow)

SYSMYCERTImpl

public SYSMYCERTImpl(MaliContext inContext)

Method Detail

getinstance

public static java.lang.Object getinstance(MaliContext inContext)

setMaliContext

public void setMaliContext(MaliContext inContext)

Description copied from interface: BaseTable

set MaliContext

Specified by:

setMaliContext in interface BaseTable

Overrides:

setMaliContext in class BaseTableimpl

init

public void init()

Specified by:

init in interface BaseTable

Overrides:

init in class BaseTableimpl

setInsertTrigger

public void setInsertTrigger()

using insert executed before setInsertTrigger

Specified by:

setInsertTrigger in interface BaseTable

Overrides:

setInsertTrigger in class BaseTableimpl

setUpdateTrigger

public void setUpdateTrigger()

using update executed before setUpdateTrigger

Specified by:

setUpdateTrigger in interface BaseTable

Overrides:

setUpdateTrigger in class BaseTableimpl

setDeleteTrigger

public void setDeleteTrigger()

using delete executed before setDeleteTrigger

Specified by:

setDeleteTrigger in interface BaseTable

Overrides:

setDeleteTrigger in class BaseTableimpl

preInsert

public boolean preInsert()
                  throws java.lang.Exception

if preInsert is true then use setInsertTrigger method else if false then Exception error Message, don't execute insert;

Specified by:

preInsert in interface BaseTable

Overrides:

preInsert in class BaseTableimpl

Returns:

Throws:

java.lang.Exception

preUpdate

public boolean preUpdate()
                  throws java.lang.Exception

if preUpdate is true then use setUpateTrriger method , if false then Exception error Message,don't execute update ;

Specified by:

preUpdate in interface BaseTable

Overrides:

preUpdate in class BaseTableimpl

Returns:

Throws:

java.lang.Exception

preDelete

public boolean preDelete()
                  throws java.lang.Exception

if preDelete is true then use setDeleteTrigger method, if false then Exception error Message,don't execute delete;

Specified by:

preDelete in interface BaseTable

Overrides:

preDelete in class BaseTableimpl

Returns:

Throws:

java.lang.Exception

getCERT_MEMBERSEQNO

public java.lang.String getCERT_MEMBERSEQNO()

get 帳號檔唯一序號

Specified by:

getCERT_MEMBERSEQNO in interface SYSMYCERT

getCERT_SEQNO

public java.lang.String getCERT_SEQNO()

get 唯一序號

Specified by:

getCERT_SEQNO in interface SYSMYCERT

getCERT_CARDSN

public java.lang.String getCERT_CARDSN()

get 憑證卡號

Specified by:

getCERT_CARDSN in interface SYSMYCERT

getCERT_PUBLICKEY

public java.security.PublicKey getCERT_PUBLICKEY()

get 憑證公KEY

Specified by:

getCERT_PUBLICKEY in interface SYSMYCERT

getCERT_TYPE

public java.lang.String getCERT_TYPE()

get 憑證類別

Specified by:

getCERT_TYPE in interface SYSMYCERT

getCERT_CREADATETIME

public java.lang.String getCERT_CREADATETIME()

get 建檔日期時間

Specified by:

getCERT_CREADATETIME in interface SYSMYCERT

getCERT_CREUSERID

public java.lang.String getCERT_CREUSERID()

get 建檔人員

Specified by:

getCERT_CREUSERID in interface SYSMYCERT

getCERT_MTNDATETIME

public java.lang.String getCERT_MTNDATETIME()

get 異動日期時間

Specified by:

getCERT_MTNDATETIME in interface SYSMYCERT

getCERT_MTNUSERID

public java.lang.String getCERT_MTNUSERID()

get 異動人員

Specified by:

getCERT_MTNUSERID in interface SYSMYCERT

getCERT_REGCOUNT

public java.lang.Integer getCERT_REGCOUNT()

get 憑證註冊次數

Specified by:

getCERT_REGCOUNT in interface SYSMYCERT

getCERT_IDNO

public java.lang.String getCERT_IDNO()

get 身份證號(統編)

Specified by:

getCERT_IDNO in interface SYSMYCERT

setCERT_MEMBERSEQNO

public void setCERT_MEMBERSEQNO(java.lang.String fieldvalue)

set 帳號檔唯一序號

Specified by:

setCERT_MEMBERSEQNO in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_SEQNO

public void setCERT_SEQNO(java.lang.String fieldvalue)

set 唯一序號

Specified by:

setCERT_SEQNO in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_CARDSN

public void setCERT_CARDSN(java.lang.String fieldvalue)

set 憑證卡號

Specified by:

setCERT_CARDSN in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_PUBLICKEY

public void setCERT_PUBLICKEY(java.lang.String fieldvalue)

set 憑證公KEY

Specified by:

setCERT_PUBLICKEY in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_TYPE

public void setCERT_TYPE(java.lang.String fieldvalue)

set 憑證類別

Specified by:

setCERT_TYPE in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_CREADATETIME

public void setCERT_CREADATETIME(java.lang.String fieldvalue)

set 建檔日期時間

Specified by:

setCERT_CREADATETIME in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_CREUSERID

public void setCERT_CREUSERID(java.lang.String fieldvalue)

set 建檔人員

Specified by:

setCERT_CREUSERID in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_MTNDATETIME

public void setCERT_MTNDATETIME(java.lang.String fieldvalue)

set 異動日期時間

Specified by:

setCERT_MTNDATETIME in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_MTNUSERID

public void setCERT_MTNUSERID(java.lang.String fieldvalue)

set 異動人員

Specified by:

setCERT_MTNUSERID in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_REGCOUNT

public void setCERT_REGCOUNT(java.lang.Integer fieldvalue)

set 憑證註冊次數

Specified by:

setCERT_REGCOUNT in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_IDNO

public void setCERT_IDNO(java.lang.String fieldvalue)

set 身份證號(統編)

Specified by:

setCERT_IDNO in interface SYSMYCERT

Parameters:

fieldvalue -

setCERT_STOPTIME

public void setCERT_STOPTIME(java.lang.String fieldvalue)

Description copied from interface: SYSMYCERT

SET 憑證到期日期

Specified by:

setCERT_STOPTIME in interface SYSMYCERT

getCERT_STOPTIME

public java.lang.String getCERT_STOPTIME()

Description copied from interface: SYSMYCERT

get 憑證到期日期

Specified by:

getCERT_STOPTIME in interface SYSMYCERT

Returns: