mali.db

Class BaseQueryImpl

java.lang.Object

mali.object.CommonFieldObject

mali.db.BaseCommonBoImpl

mali.db.BaseQueryImpl

All Implemented Interfaces:

java.io.Serializable, BaseCommonBo, BaseQuery

Direct Known Subclasses:

BULLETINQueryImpl, EMPQueryImpl, EMSGQueryImpl, ORGQueryImpl, PRJBaseQueryImpl, SYSAUTONOQueryImpl, SYSCODEQueryImpl, SYSJOBSCHEDULELOGQueryImpl, SYSLOCKQueryImpl, SYSLOGINLOGQueryImpl, SYSMEMBERQueryImpl, SYSMEMCGLOGQueryImpl, SYSMENUQueryImpl, SYSMYCERTQueryImpl, SYSORGQueryImpl, SYSPKIFLOWTMPQueryImpl, SYSROAUCODEQueryImpl, SYSROLEAUTHQueryImpl, SYSSERIALNOQueryImpl, SYSSIGNONQueryImpl, SYSUSRQueryImpl

public class BaseQueryImpl
extends BaseCommonBoImpl
implements BaseQuery, java.io.Serializable

BaseTable 查詢

Author:

amman 取得符合資料 增加 getCodeBuffer 提供給各介面可自行設定 BaseQueryImpl default return null; 增加 alias name ,若有設定.則全部的key 均加上 alias name

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	codebuffertype_by代碼加名稱
static java.lang.String	codebuffertype_default
static java.lang.String	codeidvarString
static java.lang.String	codename_formatString
static java.lang.String	codenamevarString
static java.lang.String	KEY_aliasName

Constructor Summary

Constructors

Constructor and Description
BaseQueryImpl()
BaseQueryImpl(MaliContext inContext)
BaseQueryImpl(MaliContext inContext, java.lang.String intable)
BaseQueryImpl(java.lang.String intable)

Method Summary

Methods

Modifier and Type	Method and Description
void	addEqualBooleanYN(java.lang.String inkey, java.lang.Boolean infieldvalue) equal boolean 轉換成 Y/N 若 BOOEALN 為 false ,資料庫有可能為null 或是 N , 因此用此FUNCTION 轉換
void	addNotEqualCondition(java.lang.String infieldName, java.lang.Object infieldvalue) 不等於
void	addWhereBetweenCondition(java.lang.String infieldName, java.lang.Object inminfieldvalue, java.lang.Object inmaxfieldvalue)
void	addWhereBetweenKeyCondition(java.lang.Object fieldvalue, java.lang.String inminKeyFieldName, java.lang.String inmaxKeyFieldName) data 內容大於等於 minKeyField(欄位) and data內容小於等於 maxKeyField
void	addWhereBetweenMoreCondition(java.lang.String infieldName, java.lang.Object inminfieldvalue, java.lang.Object inmaxfieldvalue)
void	addWhereCondition(java.lang.String inCondition)
void	addWhereCondition(java.lang.String inCondition, java.util.Vector inSubKeyVector) 增加子sql and
void	addWhereEqualCondition(java.lang.String infieldName, java.lang.Object infieldvalue)
void	addWhereEqualCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereEqualKeyFieldCondition(java.lang.String infieldNames, java.lang.String infieldNamev) key field conditoin key部份欄位的 alias 部份自行設定
void	addWhereEqualMoreCondition(java.lang.String infieldName, java.lang.Object infieldvalue) equal more equal 多筆時.則使用 or for 相同key時
void	addWhereGrantthanAndEqualCondition(java.lang.String infield, java.lang.Object infiledvalue)
void	addWhereGrantthanAndEqualCondition(java.lang.String infield, java.lang.String infiledvalue)
void	addWhereGrantthanCondition(java.lang.String infield, java.lang.Object infieldvalue)
void	addWhereInCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereInCondition(java.lang.String infieldName, java.lang.String[] infieldvalue)
void	addWhereLikeCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereLikeKeyFieldCondition(java.lang.String infieldNames, java.lang.String infieldNamev) key field condition key 部份欄位的alias 部份自行設定
void	addWhereLikeMoreCondition(clsSqlData[] infieldvalues) 設定多個欄位 like 用 or 方式串起
void	addWhereLikeMoreCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereLikeValueLikeLeftKeyFieldCondition(java.lang.String infieldvalue, java.lang.String infieldNames) like 放在KeyField 前面 , value like %keyfield
void	addWhereNotEqualCondition(java.lang.String infieldName, java.lang.Object infieldvalue)
void	addWhereNotEqualCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereNotInCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereNotInCondition(java.lang.String infieldName, java.lang.String[] infieldvalue)
void	addWhereNotLikeCondition(java.lang.String infieldName, java.lang.String infieldvalue)
void	addWhereOrCodition(java.lang.String[] inConditions, java.util.Vector inSubKeyVector)
void	addWhereSmallthanAndEqualCondition(java.lang.String infield, java.lang.Object infiledvalue)
void	addWhereSmallthanAndEqualCondition(java.lang.String infield, java.lang.String infiledvalue)
void	addWhereSmallthanCondition(java.lang.String infield, java.lang.Object infieldvalue)
BaseQuery	CopyNewQuery() 產生新的BaseQuery 包括原來已有的條件值
boolean	executeBatch() 執行batch 動作
void	executeBatch(BaseTable[] indatas)
java.lang.String	getAliasName()
BaseTable[]	getBaseTableDataContent()
BaseTable[]	getBaseTableDataContent(int rowstart, int maxrownumbers) 若 set usingsession 等於 true 則直接取 暫存記錄中的資料筆數, 若false 則直接由資料庫取記錄
java.lang.String[]	getCodeBuffer(java.lang.String infield_id, java.lang.String infield_name) 取代碼內容
java.lang.String	getCodeBuffer顯示方式()
ConnDbCom	getConnDbCom()
java.lang.String	getfieldMergString(java.lang.String[] infields) 合併資料庫欄位或是欄位值,為配合不同資料庫處理方式
java.lang.String	getJoinKeyConditionString()
java.util.Vector	getJoinKeyCondtionKeys()
MaliContext	getMaliContext()
java.lang.Object	getmaxData(java.lang.String infieldname) 取回最大值的資料
java.lang.Object	getminData(java.lang.String infieldname) 取回最小值的資料 找不到欄位時,則return null
int	getRecordCount() get資料筆數
BaseTable	getRecordFirstRow() 取第一筆資料
BaseTable	getRecordLastRow() 取最後一筆資料
java.lang.String[]	getSelectField()
java.lang.String[]	getSortfield()
java.lang.String	getSQLString()
java.lang.String	getSQLText() 與 getSQLString 相同 function
java.lang.String	getTableName()
int	getupdateRecordCount()
java.util.Vector	getWhereConditionKeys() 查詢條件值
java.lang.String	getWhereConditionString()
java.util.Hashtable	getWhereEqualMoreTable()
java.lang.String	getWhereEqualString(java.lang.String infieldName, java.lang.String infieldvalue)
java.util.Hashtable	getWhereKeyVector()
java.util.Hashtable	getWhereVector()
java.lang.String	getXMLRows() 查詢資料轉成XML格式 轉成xml String 格式
java.lang.String	getXMLRows(java.lang.String inRootName) 查詢資料轉成XML格式
boolean	isaddCondition(java.lang.String Key) 是否己add 查詢條件
boolean	isExistsData() 檢查資料是否存在,不做任何處理
boolean	isnotWhereCondition() 沒有where條件
boolean	isSelectDistinct()
void	resetCondition()
void	setAliasName(java.lang.String inpara) 設定 table 有alias 別名,若有設定.則where key 欄位均會加上 alias name
void	setCodeBuffer顯示方式(java.lang.String intype) CodeBuffer顯示方式 若不設定則依正常一般方式顯示
void	setConnDbCom(ConnDbCom inConn)
void	setCopyCondition(java.lang.String inWhereString, java.util.Vector inWhereKey) 固定where 條件, 原條件清除
void	setDataBaseType(java.lang.String intype) 設定資料庫連線代碼
void	setDefaultlogicoperatorsUsingAnd() sql where condition default using and link, default and
void	setDefaultlogicoperatorsUsingOr() sql where condition default using or link
void	setDESCSortfield(java.lang.String[] infieldvalue)
void	setexecuteToDelete() 設定 execute 為 delete 主要是提供多筆delete
void	setexecuteToQuery() 設定 execute 為Query
void	setexecuteToUpdate() 設定 execute 為 update 主要是提供多筆 update
void	setexecuteType(java.lang.String intype) default 是 select , 若是要做update 或是 delete 需set
void	setGroupField(java.lang.String[] infieldname) set group by field
void	setJoinKeyCondition(java.lang.String inCondition)
void	setJoinKeyConditoin(java.lang.String inCondition, java.util.Vector inkeyVector)
void	setJoinTableName(java.lang.String[] inpara, java.lang.String injointype) set join table(應只有兩個)
void	setMaliContext(MaliContext inContext)
void	setSelectDistinct(boolean in) 是否增加distinct
void	setSelectField(java.lang.String[] infieldname)
void	setSortfield(java.lang.String[] infieldvalue)
void	setSQLText(java.lang.String insql)
void	setSQLText(java.lang.String insqltext, java.util.Vector inKeyVector)
void	setTableName(java.lang.String inpara)
void	setUpdatefield(java.lang.String infieldname, java.lang.Object infieldvalue) 要設為update 才可setupdatefield, 若set updatefield 則將execute 設為update
void	setUpdateKeyField(java.lang.String infieldname, java.lang.String sourcefieldname) update table 欄位至某個欄位
void	setUsingSession(java.lang.Boolean in) 使用暫存資料
void	sort(int[] in) 只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位序號排序,預設由小到大
void	sort(int[] in, boolean ascsort) 只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位序號進行排序動作
void	sort(java.lang.String[] in) 只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位名稱進行排序, sort 預設由小到大
void	sort(java.lang.String[] in, boolean ascsort) 只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 下 要準備依什麼欄位進行排序動作,針對有做暫存 isusession 的部份去執行 sort, 若有,則sort 進去,可用 BaseTableDataContent() 顯示資料

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

createObjectByByteArray, createObjectByteArray, getHashTableContent, setVectorFielddata

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, 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

codebuffertype_default

public static java.lang.String codebuffertype_default

codebuffertype_by代碼加名稱

public static java.lang.String codebuffertype_by代碼加名稱

codename_formatString

public static java.lang.String codename_formatString

codeidvarString

public static java.lang.String codeidvarString

codenamevarString

public static java.lang.String codenamevarString

KEY_aliasName

public static java.lang.String KEY_aliasName

Constructor Detail

BaseQueryImpl

public BaseQueryImpl()

BaseQueryImpl

public BaseQueryImpl(MaliContext inContext)

BaseQueryImpl

public BaseQueryImpl(MaliContext inContext,
             java.lang.String intable)

BaseQueryImpl

public BaseQueryImpl(java.lang.String intable)

Method Detail

addWhereCondition

public void addWhereCondition(java.lang.String inCondition)

Specified by:

addWhereCondition in interface BaseQuery

getWhereEqualMoreTable

public java.util.Hashtable getWhereEqualMoreTable()

addWhereBetweenCondition

public void addWhereBetweenCondition(java.lang.String infieldName,
                            java.lang.Object inminfieldvalue,
                            java.lang.Object inmaxfieldvalue)

Specified by:

addWhereBetweenCondition in interface BaseQuery

getWhereEqualString

public java.lang.String getWhereEqualString(java.lang.String infieldName,
                                   java.lang.String infieldvalue)

addWhereEqualCondition

public void addWhereEqualCondition(java.lang.String infieldName,
                          java.lang.String infieldvalue)

Specified by:

addWhereEqualCondition in interface BaseQuery

addWhereInCondition

public void addWhereInCondition(java.lang.String infieldName,
                       java.lang.String infieldvalue)

Specified by:

addWhereInCondition in interface BaseQuery

addWhereLikeCondition

public void addWhereLikeCondition(java.lang.String infieldName,
                         java.lang.String infieldvalue)

Specified by:

addWhereLikeCondition in interface BaseQuery

getBaseTableDataContent

public BaseTable[] getBaseTableDataContent()

Specified by:

getBaseTableDataContent in interface BaseQuery

getWhereConditionString

public java.lang.String getWhereConditionString()

Specified by:

getWhereConditionString in interface BaseQuery

resetCondition

public void resetCondition()

Specified by:

resetCondition in interface BaseQuery

setSelectField

public void setSelectField(java.lang.String[] infieldname)

Specified by:

setSelectField in interface BaseQuery

setTableName

public void setTableName(java.lang.String inpara)

Specified by:

setTableName in interface BaseQuery

addWhereEqualCondition

public void addWhereEqualCondition(java.lang.String infieldName,
                          java.lang.Object infieldvalue)

Specified by:

addWhereEqualCondition in interface BaseQuery

setSortfield

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

Specified by:

setSortfield in interface BaseQuery

setDESCSortfield

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

Specified by:

setDESCSortfield in interface BaseQuery

getTableName

public java.lang.String getTableName()

Specified by:

getTableName in interface BaseQuery

addWhereSmallthanAndEqualCondition

public void addWhereSmallthanAndEqualCondition(java.lang.String infield,
                                      java.lang.Object infiledvalue)

Specified by:

addWhereSmallthanAndEqualCondition in interface BaseQuery

addWhereSmallthanAndEqualCondition

public void addWhereSmallthanAndEqualCondition(java.lang.String infield,
                                      java.lang.String infiledvalue)

Specified by:

addWhereSmallthanAndEqualCondition in interface BaseQuery

getSQLString

public java.lang.String getSQLString()

Specified by:

getSQLString in interface BaseQuery

setMaliContext

public void setMaliContext(MaliContext inContext)

Specified by:

setMaliContext in interface BaseQuery

getConnDbCom

public ConnDbCom getConnDbCom()

Specified by:

getConnDbCom in interface BaseQuery

setConnDbCom

public void setConnDbCom(ConnDbCom inConn)

Specified by:

setConnDbCom in interface BaseQuery

addWhereNotInCondition

public void addWhereNotInCondition(java.lang.String infieldName,
                          java.lang.String infieldvalue)

Specified by:

addWhereNotInCondition in interface BaseQuery

addWhereGrantthanAndEqualCondition

public void addWhereGrantthanAndEqualCondition(java.lang.String infield,
                                      java.lang.Object infiledvalue)

Specified by:

addWhereGrantthanAndEqualCondition in interface BaseQuery

addWhereGrantthanAndEqualCondition

public void addWhereGrantthanAndEqualCondition(java.lang.String infield,
                                      java.lang.String infiledvalue)

Specified by:

addWhereGrantthanAndEqualCondition in interface BaseQuery

addWhereGrantthanCondition

public void addWhereGrantthanCondition(java.lang.String infield,
                              java.lang.Object infieldvalue)

Specified by:

addWhereGrantthanCondition in interface BaseQuery

setCodeBuffer顯示方式

public void setCodeBuffer顯示方式(java.lang.String intype)

CodeBuffer顯示方式 若不設定則依正常一般方式顯示

Specified by:

setCodeBuffer顯示方式 in interface BaseQuery

Parameters:

intype - 0 是一般 代碼 , 顯示中文, intype 1 是代碼, 顯示 代碼+中文

getCodeBuffer顯示方式

public java.lang.String getCodeBuffer顯示方式()

Specified by:

getCodeBuffer顯示方式 in interface BaseQuery

getCodeBuffer

public java.lang.String[] getCodeBuffer(java.lang.String infield_id,
                               java.lang.String infield_name)

Description copied from interface: BaseQuery

取代碼內容

Specified by:

getCodeBuffer in interface BaseQuery

Parameters:

infield_id - 設定 id 欄位名稱

infield_name - 設定 name 欄位名稱

Returns:

setSQLText

public void setSQLText(java.lang.String insql)

Specified by:

setSQLText in interface BaseQuery

setSQLText

public void setSQLText(java.lang.String insqltext,
              java.util.Vector inKeyVector)

Specified by:

setSQLText in interface BaseQuery

getSQLText

public java.lang.String getSQLText()

與 getSQLString 相同 function

Specified by:

getSQLText in interface BaseQuery

addNotEqualCondition

public void addNotEqualCondition(java.lang.String infieldName,
                        java.lang.Object infieldvalue)

Description copied from interface: BaseQuery

不等於

Specified by:

addNotEqualCondition in interface BaseQuery

infieldvalue - String 格式

addWhereInCondition

public void addWhereInCondition(java.lang.String infieldName,
                       java.lang.String[] infieldvalue)

Specified by:

addWhereInCondition in interface BaseQuery

getRecordCount

public int getRecordCount()

Description copied from interface: BaseQuery

get資料筆數

Specified by:

getRecordCount in interface BaseQuery

Returns:

getXMLRows

public java.lang.String getXMLRows()

Description copied from interface: BaseQuery

查詢資料轉成XML格式 轉成xml String 格式

Specified by:

getXMLRows in interface BaseQuery

Returns:

getXMLRows

public java.lang.String getXMLRows(java.lang.String inRootName)

Description copied from interface: BaseQuery

查詢資料轉成XML格式

Specified by:

getXMLRows in interface BaseQuery

Parameters:

inRootName - 可設定 RootName

Returns:

addWhereOrCodition

public void addWhereOrCodition(java.lang.String[] inConditions,
                      java.util.Vector inSubKeyVector)

Specified by:

addWhereOrCodition in interface BaseQuery

getWhereVector

public java.util.Hashtable getWhereVector()

getWhereKeyVector

public java.util.Hashtable getWhereKeyVector()

getWhereConditionKeys

public java.util.Vector getWhereConditionKeys()

Description copied from interface: BaseQuery

查詢條件值

Specified by:

getWhereConditionKeys in interface BaseQuery

Returns:

setGroupField

public void setGroupField(java.lang.String[] infieldname)

Description copied from interface: BaseQuery

set group by field

Specified by:

setGroupField in interface BaseQuery

addWhereEqualKeyFieldCondition

public void addWhereEqualKeyFieldCondition(java.lang.String infieldNames,
                                  java.lang.String infieldNamev)

key field conditoin key部份欄位的 alias 部份自行設定

Specified by:

addWhereEqualKeyFieldCondition in interface BaseQuery

addWhereLikeKeyFieldCondition

public void addWhereLikeKeyFieldCondition(java.lang.String infieldNames,
                                 java.lang.String infieldNamev)

key field condition key 部份欄位的alias 部份自行設定

Specified by:

addWhereLikeKeyFieldCondition in interface BaseQuery

getBaseTableDataContent

public BaseTable[] getBaseTableDataContent(int rowstart,
                                  int maxrownumbers)

Description copied from interface: BaseQuery

若 set usingsession 等於 true 則直接取 暫存記錄中的資料筆數, 若false 則直接由資料庫取記錄

Specified by:

getBaseTableDataContent in interface BaseQuery

maxrownumbers - 最多取幾筆

Returns:

addWhereCondition

public void addWhereCondition(java.lang.String inCondition,
                     java.util.Vector inSubKeyVector)

Description copied from interface: BaseQuery

增加子sql and

Specified by:

addWhereCondition in interface BaseQuery

getSortfield

public java.lang.String[] getSortfield()

Specified by:

getSortfield in interface BaseQuery

setJoinTableName

public void setJoinTableName(java.lang.String[] inpara,
                    java.lang.String injointype)

Description copied from interface: BaseQuery

set join table(應只有兩個)

Specified by:

setJoinTableName in interface BaseQuery

setJoinKeyCondition

public void setJoinKeyCondition(java.lang.String inCondition)

Specified by:

setJoinKeyCondition in interface BaseQuery

CopyNewQuery

public BaseQuery CopyNewQuery()

Description copied from interface: BaseQuery

產生新的BaseQuery 包括原來已有的條件值

Specified by:

CopyNewQuery in interface BaseQuery

Returns:

setCopyCondition

public void setCopyCondition(java.lang.String inWhereString,
                    java.util.Vector inWhereKey)

Description copied from interface: BaseQuery

固定where 條件, 原條件清除

Specified by:

setCopyCondition in interface BaseQuery

addWhereLikeValueLikeLeftKeyFieldCondition

public void addWhereLikeValueLikeLeftKeyFieldCondition(java.lang.String infieldvalue,
                                              java.lang.String infieldNames)

Description copied from interface: BaseQuery

like 放在KeyField 前面 , value like %keyfield

Specified by:

addWhereLikeValueLikeLeftKeyFieldCondition in interface BaseQuery

addWhereNotEqualCondition

public void addWhereNotEqualCondition(java.lang.String infieldName,
                             java.lang.String infieldvalue)

Specified by:

addWhereNotEqualCondition in interface BaseQuery

getminData

public java.lang.Object getminData(java.lang.String infieldname)

取回最小值的資料 找不到欄位時,則return null

Specified by:

getminData in interface BaseQuery

Parameters:

infieldname -

Returns:

getmaxData

public java.lang.Object getmaxData(java.lang.String infieldname)

取回最大值的資料

Specified by:

getmaxData in interface BaseQuery

Parameters:

infieldname -

Returns:

setUsingSession

public void setUsingSession(java.lang.Boolean in)

使用暫存資料

Specified by:

setUsingSession in interface BaseQuery

getRecordFirstRow

public BaseTable getRecordFirstRow()

Description copied from interface: BaseQuery

取第一筆資料

Specified by:

getRecordFirstRow in interface BaseQuery

Returns:

getRecordLastRow

public BaseTable getRecordLastRow()

Description copied from interface: BaseQuery

取最後一筆資料

Specified by:

getRecordLastRow in interface BaseQuery

Returns:

sort

public void sort(java.lang.String[] in,
        boolean ascsort)

只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 下 要準備依什麼欄位進行排序動作,針對有做暫存 isusession 的部份去執行 sort, 若有,則sort 進去,可用 BaseTableDataContent() 顯示資料

Specified by:

sort in interface BaseQuery

Parameters:

in -

ascsort, - true 表示 由小到大, false 表示由大到小

sort

public void sort(java.lang.String[] in)

Description copied from interface: BaseQuery

只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位名稱進行排序, sort 預設由小到大

Specified by:

sort in interface BaseQuery

sort

public void sort(int[] in,
        boolean ascsort)

Description copied from interface: BaseQuery

只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位序號進行排序動作

Specified by:

sort in interface BaseQuery

sort

public void sort(int[] in)

Description copied from interface: BaseQuery

只針對 isusesession 為true 處理, 且已有取回過資料,要另外進行sort 時作業 以欄位序號排序,預設由小到大

Specified by:

sort in interface BaseQuery

getSelectField

public java.lang.String[] getSelectField()

Specified by:

getSelectField in interface BaseQuery

setexecuteToDelete

public void setexecuteToDelete()

Description copied from interface: BaseQuery

設定 execute 為 delete 主要是提供多筆delete

Specified by:

setexecuteToDelete in interface BaseQuery

setexecuteToUpdate

public void setexecuteToUpdate()

Description copied from interface: BaseQuery

設定 execute 為 update 主要是提供多筆 update

Specified by:

setexecuteToUpdate in interface BaseQuery

setexecuteToQuery

public void setexecuteToQuery()

Description copied from interface: BaseQuery

設定 execute 為Query

Specified by:

setexecuteToQuery in interface BaseQuery

setUpdatefield

public void setUpdatefield(java.lang.String infieldname,
                  java.lang.Object infieldvalue)

Description copied from interface: BaseQuery

要設為update 才可setupdatefield, 若set updatefield 則將execute 設為update

Specified by:

setUpdatefield in interface BaseQuery

executeBatch

public boolean executeBatch()

Description copied from interface: BaseQuery

執行batch 動作

Specified by:

executeBatch in interface BaseQuery

setexecuteType

public void setexecuteType(java.lang.String intype)

Description copied from interface: BaseQuery

default 是 select , 若是要做update 或是 delete 需set

Specified by:

setexecuteType in interface BaseQuery

Parameters:

intype - delete or update

addWhereNotLikeCondition

public void addWhereNotLikeCondition(java.lang.String infieldName,
                            java.lang.String infieldvalue)

Specified by:

addWhereNotLikeCondition in interface BaseQuery

addWhereLikeMoreCondition

public void addWhereLikeMoreCondition(java.lang.String infieldName,
                             java.lang.String infieldvalue)

Specified by:

addWhereLikeMoreCondition in interface BaseQuery

executeBatch

public void executeBatch(BaseTable[] indatas)
                  throws java.lang.Exception

Specified by:

executeBatch in interface BaseQuery

Throws:

java.lang.Exception

addWhereBetweenKeyCondition

public void addWhereBetweenKeyCondition(java.lang.Object fieldvalue,
                               java.lang.String inminKeyFieldName,
                               java.lang.String inmaxKeyFieldName)

Description copied from interface: BaseQuery

data 內容大於等於 minKeyField(欄位) and data內容小於等於 maxKeyField

Specified by:

addWhereBetweenKeyCondition in interface BaseQuery

addWhereNotInCondition

public void addWhereNotInCondition(java.lang.String infieldName,
                          java.lang.String[] infieldvalue)

Specified by:

addWhereNotInCondition in interface BaseQuery

addWhereBetweenMoreCondition

public void addWhereBetweenMoreCondition(java.lang.String infieldName,
                                java.lang.Object inminfieldvalue,
                                java.lang.Object inmaxfieldvalue)

Specified by:

addWhereBetweenMoreCondition in interface BaseQuery

setDataBaseType

public void setDataBaseType(java.lang.String intype)

設定資料庫連線代碼

Specified by:

setDataBaseType in class BaseCommonBoImpl

addEqualBooleanYN

public void addEqualBooleanYN(java.lang.String inkey,
                     java.lang.Boolean infieldvalue)

equal boolean 轉換成 Y/N 若 BOOEALN 為 false ,資料庫有可能為null 或是 N , 因此用此FUNCTION 轉換

Specified by:

addEqualBooleanYN in interface BaseQuery

Parameters:

inkey -

infieldvalue -

addWhereLikeMoreCondition

public void addWhereLikeMoreCondition(clsSqlData[] infieldvalues)

Description copied from interface: BaseQuery

設定多個欄位 like 用 or 方式串起

Specified by:

addWhereLikeMoreCondition in interface BaseQuery

setUpdateKeyField

public void setUpdateKeyField(java.lang.String infieldname,
                     java.lang.String sourcefieldname)

Description copied from interface: BaseQuery

update table 欄位至某個欄位

Specified by:

setUpdateKeyField in interface BaseQuery

Parameters:

infieldname - tokeyfield

sourcefieldname - fromkeyfield

setAliasName

public void setAliasName(java.lang.String inpara)

Description copied from interface: BaseQuery

設定 table 有alias 別名,若有設定.則where key 欄位均會加上 alias name

Specified by:

setAliasName in interface BaseQuery

getAliasName

public java.lang.String getAliasName()

Specified by:

getAliasName in interface BaseQuery

addWhereEqualMoreCondition

public void addWhereEqualMoreCondition(java.lang.String infieldName,
                              java.lang.Object infieldvalue)

Description copied from interface: BaseQuery

equal more equal 多筆時.則使用 or for 相同key時

Specified by:

addWhereEqualMoreCondition in interface BaseQuery

addWhereNotEqualCondition

public void addWhereNotEqualCondition(java.lang.String infieldName,
                             java.lang.Object infieldvalue)

Specified by:

addWhereNotEqualCondition in interface BaseQuery

setJoinKeyConditoin

public void setJoinKeyConditoin(java.lang.String inCondition,
                       java.util.Vector inkeyVector)

Specified by:

setJoinKeyConditoin in interface BaseQuery

getMaliContext

public MaliContext getMaliContext()

setDefaultlogicoperatorsUsingOr

public void setDefaultlogicoperatorsUsingOr()

Description copied from interface: BaseQuery

sql where condition default using or link

Specified by:

setDefaultlogicoperatorsUsingOr in interface BaseQuery

setDefaultlogicoperatorsUsingAnd

public void setDefaultlogicoperatorsUsingAnd()

Description copied from interface: BaseQuery

sql where condition default using and link, default and

Specified by:

setDefaultlogicoperatorsUsingAnd in interface BaseQuery

getupdateRecordCount

public int getupdateRecordCount()

Specified by:

getupdateRecordCount in interface BaseQuery

isaddCondition

public boolean isaddCondition(java.lang.String Key)

Description copied from interface: BaseQuery

是否己add 查詢條件

Specified by:

isaddCondition in interface BaseQuery

Returns:

isExistsData

public boolean isExistsData()
                     throws java.lang.Exception

Description copied from interface: BaseQuery

檢查資料是否存在,不做任何處理

Specified by:

isExistsData in interface BaseQuery

Returns:

Throws:

java.lang.Exception

setSelectDistinct

public void setSelectDistinct(boolean in)

Description copied from interface: BaseQuery

是否增加distinct

Specified by:

setSelectDistinct in interface BaseQuery

isSelectDistinct

public boolean isSelectDistinct()

Specified by:

isSelectDistinct in interface BaseQuery

getJoinKeyConditionString

public java.lang.String getJoinKeyConditionString()

Specified by:

getJoinKeyConditionString in interface BaseQuery

getJoinKeyCondtionKeys

public java.util.Vector getJoinKeyCondtionKeys()

Specified by:

getJoinKeyCondtionKeys in interface BaseQuery

addWhereSmallthanCondition

public void addWhereSmallthanCondition(java.lang.String infield,
                              java.lang.Object infieldvalue)

Specified by:

addWhereSmallthanCondition in interface BaseQuery

getfieldMergString

public java.lang.String getfieldMergString(java.lang.String[] infields)

Description copied from interface: BaseQuery

合併資料庫欄位或是欄位值,為配合不同資料庫處理方式

Specified by:

getfieldMergString in interface BaseQuery

Returns:

isnotWhereCondition

public boolean isnotWhereCondition()

沒有where條件

Specified by:

isnotWhereCondition in interface BaseQuery

Returns: