mali.db

Class BaseTableimpl

java.lang.Object

mali.object.CommonFieldObject

mali.db.BaseCommonBoImpl

mali.db.BaseTableimpl

All Implemented Interfaces:

java.io.Serializable, BaseCommonBo, BaseTable

Direct Known Subclasses:

AJAXMESGObject, BULLETINImpl, EMPImpl, EMSGImpl, MailMessageObject, ORGImpl, ParameterObject, PRJBaseTableImpl, SYSAUTONOImpl, SYSCODEImpl, SYSJOBSCHEDULELOGImpl, SYSLOCKImpl, SYSLOGINLOGImpl, SYSMEMBERImpl, SYSMEMCGLOGImpl, SYSMENUImpl, SYSMYCERTImpl, SYSORGImpl, SYSPKIFLOWTMPImpl, SYSPROGRAMImpl, SYSROAUCODEImpl, SYSROLEAUTHImpl, SYSSERIALNOImpl, SYSSIGNONImpl, SYSUNIQSEQNOImpl, SYSUSRImpl, SYSWRITELOGImpl

public class BaseTableimpl
extends BaseCommonBoImpl
implements BaseTable, java.io.Serializable

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
boolean	dataisexists
java.lang.String	errMesg
static java.lang.String[]	KEY_ACTION
static java.lang.String[]	KEY_ALLFIELDList
static java.lang.String	KEY_Parameters
java.util.Vector	tmpRowdata
static java.lang.String[]	VALUE_ACTION
static java.lang.String	VALUE_ACTION_ADD
static java.lang.String	VALUE_ACTION_DELETE
static java.lang.String	VALUE_ACTION_REPLACE
static java.lang.String	VALUE_ACTION_UPDATE
static java.lang.String	VALUE_Parameters_使用TABLE介面

Constructor Summary

Constructors

Constructor and Description
BaseTableimpl()
BaseTableimpl(MaliContext inContext)
BaseTableimpl(MaliContext inContext, java.lang.Object inTable)
BaseTableimpl(MaliContext inContext, java.lang.String inTablename)
BaseTableimpl(java.lang.Object inTable)
BaseTableimpl(java.lang.String inTablename) 建購方式用 tablename
BaseTableimpl(java.lang.String Sysid, java.lang.String inTablename) 建購方式用 系統別,tablename

Method Summary

Methods

Modifier and Type	Method and Description
void	checkSQLAction()
void	ConvertToBaseTable(java.lang.Object obj)
java.lang.Object	createObjectByByteArray(byte[] theDataBytes)
void	delete() 刪除
void	execute() 執行資料庫存檔動作
void	execute(boolean R_mode)
void	fillColumns() 將table 中非此table 之欄位清除
void	generatePrimaryId() 產生 primaryid唯一序號,針對有設定 primaryidkey 者執行generatePrimaryid才有效
java.lang.String	getActionmode()
java.util.Vector	getAllFieldList()
BaseTable	getBaseTable() 取 此介面的 BaseTable
BaseTable	getBasetablefield(java.lang.String infield)
java.util.Calendar	getCalendarfield(java.lang.String fieldname) 取 Calendarfield 資料
clsSqlData	getclsSqlData(java.lang.String infield) 取 clsSqlData 格式的值 參數為欄位名稱
java.lang.String	getCommitActionMode() 處理完成的sqlaction mode
ConnDbCom	getConnDbCom() get 資料庫連結ConndbCom
java.lang.String[]	getCurTablePrimaryKey() 實際的primarykey 若未設定則取系統的primarykey
java.lang.String	getDBColumnType(java.lang.String infield) 取db table 的data column
java.lang.Double	getDoublefield(java.lang.String fieldname) 取資料值 Double 格式
java.lang.String	getErrMesg() 取處理的錯誤訊息;
java.util.Vector	geterrorMesgRowData() 取解析錯誤的欄位資訊
int	getFieldColumnIndex(java.lang.String infieldname) 取 field 欄位是在第幾個Column可提供sort 用, 找不到給 -1
java.lang.Object	getFieldValue(int colnum) 取某個欄位值(依欄位序號)
BaseTable	getInstance()
java.lang.Integer	getIntegerfield(java.lang.String fieldname) 取資料值 Integer 格式
MaliContext	getMaliContext() get MaliContext
java.lang.Object	getObjectfield(java.lang.String fieldname) 取資料值Object 格式
BaseTable	getOldData()
java.lang.String	getPimaryId() 若有設定 primaryid key 則取 primaryidkey 中的欄位值, 拼錯字, 請改取 getPrimaryId
BaseQuery[]	getPostexecuteBatchQuery()
BaseTable[]	getPostExecuteTable() 取 postExecuteTable
BaseTable[]	getPreExecuteTable() 取 preExecuteTable
java.lang.String	getPrimaryId() 若有設定 primaryid key 則取 primaryidkey 中的欄位值,
java.lang.String[]	getPrimaryKey()
java.util.Vector	getPrimaryKeyValue() 取 屬basetable中primarykey 的 Value
java.util.Vector	getRowData()
java.lang.String	getROWID()
java.lang.String	getStringfield(java.lang.String fieldname) 取資料值String 格式
java.lang.String	getTableName() 取Table Name
java.sql.Timestamp	getTimestampfield(java.lang.String fieldname) 取資料值 TimeStamp 格式(即資料庫的日期格式)
java.lang.String	getUpdateLog()
java.util.Vector	getVectorfield(java.lang.String fieldname)
void	init()
void	inputRowData() 有曾執行過is資料是否存在,可執行inputRowData();
void	insert() 新增
boolean	isDeleteed() 要準備delete
boolean	isexecuteupdate()
boolean	isFieldError() 檢查解析是否有誤
boolean	isInserted() 要準備insert
boolean	isPrimaryKey() 是否有primarykey
boolean	isSaveed() 目前為沒有異動狀態
boolean	isStringSpacetoNull()
boolean	isUpdated() 要準備update
boolean	is資料是否存在() 檢查資料是否存在
void	modifyoldFieldvalue()
void	postDelete() 若有需要在delete 成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行
void	postInsert() 若有需要在insert 成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行
void	postUpdate() 若有需要在update成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行
boolean	preDelete() delete 前 若有要做檢查動作,可放在 preDelete中, true 再繼續執行 setDeleteTrigger, 失敗,則 Exception 錯誤訊息;
boolean	preInsert() insert 前 若有要做檢查動作,可放在 preInsert中, true 再繼續執行 setInsertTrigger, 失敗,則 Exception 錯誤訊息;
boolean	preUpdate() update 前 若有要做檢查動作,可放在 preUpdate中, true 再繼續執行 setUpdateTrigger, 失敗,則 Exception 錯誤訊息;
void	removeField(java.lang.String infield) remove field ,刪除欄位
void	reset() reset DataRow 的內容
void	rollBack()
void	setActionmode(java.lang.String value) 設定execute 的mode
void	setALLFIELDSList(java.lang.String[] infieldvalue)
void	setConnDbCom(ConnDbCom inConn) 若有特別做特殊資料庫連結由此設定 set ConnDbCom
void	setDataBaseType(java.lang.String intype) set 連線database 代號, 未設是用default
void	setDeleteMode() set 刪除mode
void	setDeleteTrigger()
void	setErrMesg(java.lang.String infield) set 處理錯誤訊息
void	setErrorMesg(java.lang.String errmesg) set 錯誤訊息
void	setFielddata(java.lang.String fieldname, java.lang.Object fieldvalue) set 欄位名稱, 資料值
void	setFielddata(java.lang.String fieldname, java.lang.Object fieldvalue, java.lang.String errmesg) 配合DataLoader 暫存 Loader 每個欄位的錯誤訊息
void	setInsertDefaultValue() set insert時預設defaultValue
void	setInsertMode() set 新增mode
void	setInsertTrigger() 可執行 insertTrigger ,在insert會先執行
void	setMaliContext(MaliContext inContext) set MaliContext
void	setPostexecuteBatchQuery(BaseQuery[] inbaseQuery) set 在執行任何異動包括insert.update.delete之後若有整批異動.採用baseQuery 方式異動, 異動完成.會將executeBaseQuery的內容清空待下次再執行送入時再重覆執行
void	setPostExecuteTable(BaseTable[] intables) 在執行 insert 或是 update 或是 delet 時要同時一併異動的資料,是在異動此筆之後
void	setPreExecuteTable(BaseTable[] intables) 在執行 insert 或是 update 或是 delete 時要同時一併異動的資料, 在是異動 此筆之前
void	setPrimaryId(java.lang.String fieldvalue) 若有設定 primaryid key ,則 set priamryid 會將 primaryid 放入 primaryidkey 欄位中
void	setPrimaryKey(java.lang.String[] value)
void	setReplaceMode() set replace mode
void	setRowData(java.util.Vector s)
void	setROWID(java.lang.String fieldvalue) 進資料庫處理時先將原畫面上的筆數序號送入rowid,提供後面使用
void	setStringSpaceToNull(boolean in) set 欄位為String 若是space 是否轉為null
void	setStringValue(java.lang.String inValue)
void	setTableName(java.lang.String value) set table name
void	setUpdateDefaultValue() set update 時預設defaultValue
void	setUpdateMode() set 更新mode
void	setUpdateTrigger() udpate trigger , 在 update 前會先執行
java.lang.String	toString()
void	update() 修改 update 不做修改 實際primarykey
void	update(boolean isupdateprimarykey) 修改 update 時,可自行決定是否修正實際的primarykey

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.BaseCommonBo

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

Field Detail

errMesg

public java.lang.String errMesg

VALUE_ACTION_ADD

public static final java.lang.String VALUE_ACTION_ADD

See Also:

Constant Field Values

VALUE_ACTION_UPDATE

public static final java.lang.String VALUE_ACTION_UPDATE

See Also:

Constant Field Values

VALUE_ACTION_DELETE

public static final java.lang.String VALUE_ACTION_DELETE

See Also:

Constant Field Values

VALUE_ACTION_REPLACE

public static final java.lang.String VALUE_ACTION_REPLACE

See Also:

Constant Field Values

KEY_Parameters

public static final java.lang.String KEY_Parameters

See Also:

Constant Field Values

VALUE_Parameters_使用TABLE介面

public static final java.lang.String VALUE_Parameters_使用TABLE介面

See Also:

Constant Field Values

VALUE_ACTION

public static final java.lang.String[] VALUE_ACTION

KEY_ACTION

public static final java.lang.String[] KEY_ACTION

dataisexists

public boolean dataisexists

tmpRowdata

public java.util.Vector tmpRowdata

KEY_ALLFIELDList

public static java.lang.String[] KEY_ALLFIELDList

Constructor Detail

BaseTableimpl

public BaseTableimpl(java.lang.String Sysid,
             java.lang.String inTablename)

建購方式用 系統別,tablename

Parameters:

Sysid - 系統別

inTablename - TABLE 名稱

BaseTableimpl

public BaseTableimpl(MaliContext inContext,
             java.lang.String inTablename)

BaseTableimpl

public BaseTableimpl(MaliContext inContext)

BaseTableimpl

public BaseTableimpl()

BaseTableimpl

public BaseTableimpl(MaliContext inContext,
             java.lang.Object inTable)

BaseTableimpl

public BaseTableimpl(java.lang.Object inTable)

BaseTableimpl

public BaseTableimpl(java.lang.String inTablename)

建購方式用 tablename

Parameters:

inTablename -

Method Detail

getRowData

public java.util.Vector getRowData()

Specified by:

getRowData in interface BaseTable

delete

public void delete()
            throws java.lang.Exception

刪除

Specified by:

delete in interface BaseTable

Throws:

java.lang.Exception

getErrMesg

public java.lang.String getErrMesg()

Description copied from interface: BaseTable

取處理的錯誤訊息;

Specified by:

getErrMesg in interface BaseTable

Returns:

insert

public void insert()
            throws java.lang.Exception

Description copied from interface: BaseTable

新增

Specified by:

insert in interface BaseTable

Throws:

java.lang.Exception

update

public void update()
            throws java.lang.Exception

Description copied from interface: BaseTable

修改 update 不做修改 實際primarykey

Specified by:

update in interface BaseTable

Throws:

java.lang.Exception

setFielddata

public void setFielddata(java.lang.String fieldname,
                java.lang.Object fieldvalue)

Description copied from interface: BaseTable

set 欄位名稱, 資料值

Specified by:

setFielddata in interface BaseTable

setFielddata

public void setFielddata(java.lang.String fieldname,
                java.lang.Object fieldvalue,
                java.lang.String errmesg)

Description copied from interface: BaseTable

配合DataLoader 暫存 Loader 每個欄位的錯誤訊息

Specified by:

setFielddata in interface BaseTable

reset

public void reset()

Description copied from interface: BaseTable

reset DataRow 的內容

Specified by:

reset in interface BaseTable

getIntegerfield

public java.lang.Integer getIntegerfield(java.lang.String fieldname)

Description copied from interface: BaseTable

取資料值 Integer 格式

Specified by:

getIntegerfield in interface BaseTable

Returns:

getObjectfield

public java.lang.Object getObjectfield(java.lang.String fieldname)

Description copied from interface: BaseTable

取資料值Object 格式

Specified by:

getObjectfield in interface BaseTable

Returns:

getStringfield

public java.lang.String getStringfield(java.lang.String fieldname)

Description copied from interface: BaseTable

取資料值String 格式

Specified by:

getStringfield in interface BaseTable

Parameters:

fieldname - 欄位名稱

Returns:

getVectorfield

public java.util.Vector getVectorfield(java.lang.String fieldname)

getTimestampfield

public java.sql.Timestamp getTimestampfield(java.lang.String fieldname)

Description copied from interface: BaseTable

取資料值 TimeStamp 格式(即資料庫的日期格式)

Specified by:

getTimestampfield in interface BaseTable

Returns:

getDoublefield

public java.lang.Double getDoublefield(java.lang.String fieldname)

Description copied from interface: BaseTable

取資料值 Double 格式

Specified by:

getDoublefield in interface BaseTable

Returns:

setRowData

public void setRowData(java.util.Vector s)

Specified by:

setRowData in interface BaseTable

geterrorMesgRowData

public java.util.Vector geterrorMesgRowData()

取解析錯誤的欄位資訊

Specified by:

geterrorMesgRowData in interface BaseTable

Returns:

isFieldError

public boolean isFieldError()

檢查解析是否有誤

Specified by:

isFieldError in interface BaseTable

Returns:

getTableName

public java.lang.String getTableName()

Description copied from interface: BaseTable

取Table Name

Specified by:

getTableName in interface BaseTable

Returns:

isPrimaryKey

public boolean isPrimaryKey()

Description copied from interface: BaseTable

是否有primarykey

Specified by:

isPrimaryKey in interface BaseTable

Returns:

execute

public void execute()
             throws java.lang.Exception

Description copied from interface: BaseTable

執行資料庫存檔動作

Specified by:

execute in interface BaseTable

Throws:

java.lang.Exception

execute

public void execute(boolean R_mode)
             throws java.lang.Exception

Specified by:

execute in interface BaseTable

Parameters:

R_mode - 若 為 false ,則依原正常作業, replace 用 delete & insert 若是 true 則判斷有資料則做update

Throws:

java.lang.Exception

setActionmode

public void setActionmode(java.lang.String value)

Description copied from interface: BaseTable

設定execute 的mode

Specified by:

setActionmode in interface BaseTable

setPrimaryKey

public void setPrimaryKey(java.lang.String[] value)

Specified by:

setPrimaryKey in interface BaseTable

getPrimaryKey

public java.lang.String[] getPrimaryKey()

Specified by:

getPrimaryKey in interface BaseTable

setTableName

public void setTableName(java.lang.String value)

Description copied from interface: BaseTable

set table name

Specified by:

setTableName in interface BaseTable

getCalendarfield

public java.util.Calendar getCalendarfield(java.lang.String fieldname)

取 Calendarfield 資料

update

public void update(boolean isupdateprimarykey)
            throws java.lang.Exception

Description copied from interface: BaseTable

修改 update 時,可自行決定是否修正實際的primarykey

Specified by:

update in interface BaseTable

Throws:

java.lang.Exception

inputRowData

public void inputRowData()

有曾執行過is資料是否存在,可執行inputRowData();

Specified by:

inputRowData in interface BaseTable

is資料是否存在

public boolean is資料是否存在()
                 throws java.lang.Exception

檢查資料是否存在

Specified by:

is資料是否存在 in interface BaseTable

Returns:

Throws:

java.lang.Exception

setStringValue

public void setStringValue(java.lang.String inValue)

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getActionmode

public java.lang.String getActionmode()

Specified by:

getActionmode in interface BaseTable

getInstance

public BaseTable getInstance()

Specified by:

getInstance in interface BaseTable

getBasetablefield

public BaseTable getBasetablefield(java.lang.String infield)

Specified by:

getBasetablefield in interface BaseTable

createObjectByByteArray

public java.lang.Object createObjectByByteArray(byte[] theDataBytes)
                                         throws java.lang.Exception

Overrides:

createObjectByByteArray in class CommonFieldObject

Throws:

java.lang.Exception

setMaliContext

public void setMaliContext(MaliContext inContext)

Description copied from interface: BaseTable

set MaliContext

Specified by:

setMaliContext in interface BaseTable

getConnDbCom

public ConnDbCom getConnDbCom()

Description copied from interface: BaseTable

get 資料庫連結ConndbCom

Specified by:

getConnDbCom in interface BaseTable

Returns:

setConnDbCom

public void setConnDbCom(ConnDbCom inConn)

Description copied from interface: BaseTable

若有特別做特殊資料庫連結由此設定 set ConnDbCom

Specified by:

setConnDbCom in interface BaseTable

ConvertToBaseTable

public void ConvertToBaseTable(java.lang.Object obj)

Specified by:

ConvertToBaseTable in interface BaseTable

setErrMesg

public void setErrMesg(java.lang.String infield)

Description copied from interface: BaseTable

set 處理錯誤訊息

Specified by:

setErrMesg in interface BaseTable

removeField

public void removeField(java.lang.String infield)

Description copied from interface: BaseTable

remove field ,刪除欄位

Specified by:

removeField in interface BaseTable

Parameters:

infield - 欄位名稱 fieldname

getFieldValue

public java.lang.Object getFieldValue(int colnum)

Description copied from interface: BaseTable

取某個欄位值(依欄位序號)

Specified by:

getFieldValue in interface BaseTable

Returns:

getDBColumnType

public java.lang.String getDBColumnType(java.lang.String infield)

Description copied from interface: BaseTable

取db table 的data column

Specified by:

getDBColumnType in interface BaseTable

Returns:

getOldData

public BaseTable getOldData()

Specified by:

getOldData in interface BaseTable

getBaseTable

public BaseTable getBaseTable()

Description copied from interface: BaseTable

取 此介面的 BaseTable

Specified by:

getBaseTable in interface BaseTable

Returns:

isexecuteupdate

public boolean isexecuteupdate()

Specified by:

isexecuteupdate in interface BaseTable

Returns:

getclsSqlData

public clsSqlData getclsSqlData(java.lang.String infield)

取 clsSqlData 格式的值 參數為欄位名稱

Specified by:

getclsSqlData in interface BaseTable

setPrimaryId

public void setPrimaryId(java.lang.String fieldvalue)

Description copied from interface: BaseTable

若有設定 primaryid key ,則 set priamryid 會將 primaryid 放入 primaryidkey 欄位中

Specified by:

setPrimaryId in interface BaseTable

getPimaryId

public java.lang.String getPimaryId()

Description copied from interface: BaseTable

若有設定 primaryid key 則取 primaryidkey 中的欄位值, 拼錯字, 請改取 getPrimaryId

Specified by:

getPimaryId in interface BaseTable

Returns:

init

public void init()

Specified by:

init in interface BaseTable

setInsertDefaultValue

public void setInsertDefaultValue()

Description copied from interface: BaseTable

set insert時預設defaultValue

Specified by:

setInsertDefaultValue in interface BaseTable

setUpdateDefaultValue

public void setUpdateDefaultValue()

Description copied from interface: BaseTable

set update 時預設defaultValue

Specified by:

setUpdateDefaultValue in interface BaseTable

setInsertMode

public void setInsertMode()

set 新增mode

Specified by:

setInsertMode in interface BaseTable

setUpdateMode

public void setUpdateMode()

set 更新mode

Specified by:

setUpdateMode in interface BaseTable

setDeleteMode

public void setDeleteMode()

set 刪除mode

Specified by:

setDeleteMode in interface BaseTable

setReplaceMode

public void setReplaceMode()

set replace mode

Specified by:

setReplaceMode in interface BaseTable

getPrimaryKeyValue

public java.util.Vector getPrimaryKeyValue()

Description copied from interface: BaseTable

取 屬basetable中primarykey 的 Value

Specified by:

getPrimaryKeyValue in interface BaseTable

Returns:

getMaliContext

public MaliContext getMaliContext()

Description copied from interface: BaseTable

get MaliContext

Specified by:

getMaliContext in interface BaseTable

Returns:

setPreExecuteTable

public void setPreExecuteTable(BaseTable[] intables)

Description copied from interface: BaseTable

在執行 insert 或是 update 或是 delete 時要同時一併異動的資料, 在是異動 此筆之前

Specified by:

setPreExecuteTable in interface BaseTable

setPostExecuteTable

public void setPostExecuteTable(BaseTable[] intables)

Description copied from interface: BaseTable

在執行 insert 或是 update 或是 delet 時要同時一併異動的資料,是在異動此筆之後

Specified by:

setPostExecuteTable in interface BaseTable

getPreExecuteTable

public BaseTable[] getPreExecuteTable()

Description copied from interface: BaseTable

取 preExecuteTable

Specified by:

getPreExecuteTable in interface BaseTable

Returns:

getPostExecuteTable

public BaseTable[] getPostExecuteTable()

Description copied from interface: BaseTable

取 postExecuteTable

Specified by:

getPostExecuteTable in interface BaseTable

Returns:

getCommitActionMode

public java.lang.String getCommitActionMode()

Description copied from interface: BaseTable

處理完成的sqlaction mode

Specified by:

getCommitActionMode in interface BaseTable

Returns:

setInsertTrigger

public void setInsertTrigger()

可執行 insertTrigger ,在insert會先執行

Specified by:

setInsertTrigger in interface BaseTable

setUpdateTrigger

public void setUpdateTrigger()

udpate trigger , 在 update 前會先執行

Specified by:

setUpdateTrigger in interface BaseTable

setDeleteTrigger

public void setDeleteTrigger()

Specified by:

setDeleteTrigger in interface BaseTable

getFieldColumnIndex

public int getFieldColumnIndex(java.lang.String infieldname)

Description copied from interface: BaseTable

取 field 欄位是在第幾個Column可提供sort 用, 找不到給 -1

Specified by:

getFieldColumnIndex in interface BaseTable

Returns:

preInsert

public boolean preInsert()
                  throws java.lang.Exception

insert 前 若有要做檢查動作,可放在 preInsert中, true 再繼續執行 setInsertTrigger, 失敗,則 Exception 錯誤訊息;

Specified by:

preInsert in interface BaseTable

Returns:

Throws:

java.lang.Exception

preUpdate

public boolean preUpdate()
                  throws java.lang.Exception

update 前 若有要做檢查動作,可放在 preUpdate中, true 再繼續執行 setUpdateTrigger, 失敗,則 Exception 錯誤訊息;

Specified by:

preUpdate in interface BaseTable

Returns:

Throws:

java.lang.Exception

preDelete

public boolean preDelete()
                  throws java.lang.Exception

delete 前 若有要做檢查動作,可放在 preDelete中, true 再繼續執行 setDeleteTrigger, 失敗,則 Exception 錯誤訊息;

Specified by:

preDelete in interface BaseTable

Returns:

Throws:

java.lang.Exception

setErrorMesg

public void setErrorMesg(java.lang.String errmesg)

set 錯誤訊息

Parameters:

errmesg -

getCurTablePrimaryKey

public java.lang.String[] getCurTablePrimaryKey()

Description copied from interface: BaseTable

實際的primarykey 若未設定則取系統的primarykey

Specified by:

getCurTablePrimaryKey in interface BaseTable

Returns:

setDataBaseType

public void setDataBaseType(java.lang.String intype)

Description copied from class: BaseCommonBoImpl

set 連線database 代號, 未設是用default

Specified by:

setDataBaseType in class BaseCommonBoImpl

isUpdated

public boolean isUpdated()

Description copied from interface: BaseTable

要準備update

Specified by:

isUpdated in interface BaseTable

Returns:

isInserted

public boolean isInserted()

Description copied from interface: BaseTable

要準備insert

Specified by:

isInserted in interface BaseTable

Returns:

isDeleteed

public boolean isDeleteed()

Description copied from interface: BaseTable

要準備delete

Specified by:

isDeleteed in interface BaseTable

Returns:

isSaveed

public boolean isSaveed()

Description copied from interface: BaseTable

目前為沒有異動狀態

Specified by:

isSaveed in interface BaseTable

Returns:

checkSQLAction

public void checkSQLAction()

Specified by:

checkSQLAction in interface BaseTable

generatePrimaryId

public void generatePrimaryId()

Description copied from interface: BaseTable

產生 primaryid唯一序號,針對有設定 primaryidkey 者執行generatePrimaryid才有效

Specified by:

generatePrimaryId in interface BaseTable

setROWID

public void setROWID(java.lang.String fieldvalue)

Description copied from interface: BaseTable

進資料庫處理時先將原畫面上的筆數序號送入rowid,提供後面使用

Specified by:

setROWID in interface BaseTable

getROWID

public java.lang.String getROWID()

Specified by:

getROWID in interface BaseTable

setPostexecuteBatchQuery

public void setPostexecuteBatchQuery(BaseQuery[] inbaseQuery)

Description copied from interface: BaseTable

set 在執行任何異動包括insert.update.delete之後若有整批異動.採用baseQuery 方式異動, 異動完成.會將executeBaseQuery的內容清空待下次再執行送入時再重覆執行

Specified by:

setPostexecuteBatchQuery in interface BaseTable

getPostexecuteBatchQuery

public BaseQuery[] getPostexecuteBatchQuery()

Specified by:

getPostexecuteBatchQuery in interface BaseTable

getPrimaryId

public java.lang.String getPrimaryId()

Description copied from interface: BaseTable

若有設定 primaryid key 則取 primaryidkey 中的欄位值,

Specified by:

getPrimaryId in interface BaseTable

Returns:

setStringSpaceToNull

public void setStringSpaceToNull(boolean in)

Description copied from interface: BaseTable

set 欄位為String 若是space 是否轉為null

Specified by:

setStringSpaceToNull in interface BaseTable

isStringSpacetoNull

public boolean isStringSpacetoNull()

Specified by:

isStringSpacetoNull in interface BaseTable

getAllFieldList

public java.util.Vector getAllFieldList()

setALLFIELDSList

public void setALLFIELDSList(java.lang.String[] infieldvalue)

fillColumns

public void fillColumns()

Description copied from interface: BaseTable

將table 中非此table 之欄位清除

Specified by:

fillColumns in interface BaseTable

getUpdateLog

public java.lang.String getUpdateLog()

modifyoldFieldvalue

public void modifyoldFieldvalue()

rollBack

public void rollBack()
              throws java.lang.Exception

Throws:

java.lang.Exception

postInsert

public void postInsert()
                throws java.lang.Exception

Description copied from interface: BaseTable

若有需要在insert 成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行

Specified by:

postInsert in interface BaseTable

Throws:

java.lang.Exception

postUpdate

public void postUpdate()
                throws java.lang.Exception

Description copied from interface: BaseTable

若有需要在update成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行

Specified by:

postUpdate in interface BaseTable

Throws:

java.lang.Exception

postDelete

public void postDelete()
                throws java.lang.Exception

Description copied from interface: BaseTable

若有需要在delete 成功後再做判斷和執行時,可於postInsert method處理, 此method 是於所有sql異動處理完成後才執行

Specified by:

postDelete in interface BaseTable

Throws:

java.lang.Exception