mali.util

Class ConnDbCom

java.lang.Object

mali.util.ConnDbCom

All Implemented Interfaces:

java.io.Serializable

public class ConnDbCom
extends java.lang.Object
implements java.io.Serializable

Title: ConnDbCom

Description: 資料庫連結介面, jsp 中的 bean 名稱為 myQuery

Copyright: Copyright (c) 2005

Company:

Version:

1.0

Author:

Amman

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
java.lang.String	errMesg
static java.lang.String	KEY_DATABASE_DB2
static java.lang.String	KEY_DATABASE_MYSQL
static java.lang.String	KEY_DATABASE_ORACLE
static java.lang.String	KEY_DATABASE_PostgreSQL
static java.lang.String	KEY_DATABASE_SQLite
static java.lang.String	KEY_DATABASE_SQLSERVER
static java.lang.String	KEY_DATABASE_SYBASE
static java.lang.String	KEY_DATABASE_UCANAccess
static java.util.Hashtable	vtableFieldlist

Constructor Summary

Constructors

Constructor and Description
ConnDbCom()
ConnDbCom(javax.servlet.http.HttpServletRequest req)
ConnDbCom(MaliConfig Asmyconfig) Deprecated.
ConnDbCom(maliConnection inconnection)
ConnDbCom(MaliContext incontext)
ConnDbCom(MaliContext incontext, java.lang.String indatabase_type)
ConnDbCom(java.lang.String cursysid) Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	CheckColumnType(java.lang.String tablename, java.lang.String columnname)
BaseTable[]	convertBaseTable(java.util.Vector qryrows)
java.util.Vector	convertRsToVector(java.sql.ResultSet inrs) 將 ResultSet convert to Vector
java.sql.PreparedStatement	DataPreparedByQuery(java.sql.Connection inconn, java.lang.String sqltext) 提供給查詢用,只有Read不可異資料庫,可進行資料的 First & Last處理
java.sql.PreparedStatement	DataPreparSt(java.sql.Connection inConn, java.lang.String sqltext)
java.sql.PreparedStatement	DataPreparSt(java.lang.String sqltext)
java.sql.ResultSet	DataResultSet(java.sql.Connection conn, java.lang.String sqltext)
boolean	DBFExecSQL(java.lang.String sql) 提供給DBF 使用EXECSQL
void	delete(BaseTable inobj)
void	delete(java.sql.Connection Conn, java.lang.String tablename, java.util.Vector Rowdata) 刪除資料by para Connection
void	delete(java.lang.String tablename, java.util.Vector Rowdata) 刪除資料
boolean	ExecSQL(java.lang.String sql)
boolean	ExecSQL(java.lang.String[] sql)
boolean	ExecSQL(java.lang.String[] sql, boolean writelog)
boolean	ExecSQL(java.lang.String sql, boolean writelog)
void	execute(BaseTable[] objs) 同時執行insert.update.delete 且同步transaction
int	executeSQL(java.lang.String sql, java.util.Vector inKeyVector, java.lang.String intable)
int	getAllrowcount()
BaseTable[]	getBaseTableDataContent(java.lang.String sqltext)
BaseTable[]	getBaseTableDataContent(java.lang.String sqltext, java.lang.String databasetype)
java.sql.Connection	getConnection()
java.sql.Connection	getConnection(java.lang.String sysid, java.lang.String indbtype)
java.util.Vector	getConvertDBFieldDataType(java.lang.String tablename, java.util.Vector allRow) Convert data field 取得datatype
java.lang.String	getDatabasetype()
java.util.Vector	GetDataContent_byKey(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable)
java.util.Vector	GetDataContent_byKey(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable, int rowstart, int rowend)
java.util.ArrayList	GetDataContent()
java.util.ArrayList	GetDataContent(java.sql.ResultSet rs, int startRow, int endRow) 由 Rs 取符合筆數之資料
java.util.ArrayList	GetDataContent(java.lang.String insql) 取得 SQL 指令資料內容
java.util.ArrayList	GetDataContent(java.lang.String insql, int startRow, int endRow)
java.util.ArrayList	GetDataContent(java.lang.String insql, java.lang.String databasetype) 取得 SQL 指令資料內容
BaseTable[]	GetDataContent(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable)
BaseTable[]	GetDataContent(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable, int rowstart, int rowend)
java.util.Vector	GetDataContentVector() 取 Vector 型態的 DataContent
java.util.Vector	GetDataContentVector(java.lang.String insql) 取 Vector 型態的 DataContent
BaseTable[]	GetDatatent(java.lang.String sqltext) 取得 SQL 指令資料內容,可直接給 SQL 指令
java.util.Vector	getDBFieldDataType(java.lang.String tablename, java.util.Vector allRow, java.sql.Connection Conn)
java.lang.String	getDbmergString(java.lang.String[] args)
java.lang.String	getDBType()
java.lang.String	getDBType(java.sql.Connection inconn)
java.lang.String	getDsname()
int	getExecSQL_Rowcount() 執行ExecSQL 後的執行筆數 0 則表示沒有異動成功任何筆數
BaseTable	getExistsData(BaseTable inobj) 檢查table資料是否存在
BaseTable	getFirstRecordDataContent(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable)
java.lang.String	getIdentity(java.sql.Connection inConn, java.lang.String astable, java.lang.String ascolumn)
BaseTable	getLastRecordDataContent(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable) 取依條件最後一筆資料
java.util.ArrayList	getPrimary(java.sql.Connection inConn, java.lang.String astable)
int	getRecordCount(java.lang.String sqltext)
int	getRecordCount(java.lang.String sqltext, java.util.Vector inWhereKeyVector, java.lang.String intable) 產生RECORDCOUNT 不需另外轉換,直接顯示筆數
clsRequestData	getRequestvalue(java.util.ArrayList Ary_request, int idx)
static java.lang.String	getRequestvalue(java.util.ArrayList Ary_request, java.lang.String para)
void	GetRSDataContent(java.lang.String insql)
static java.lang.String	getSessionvalue(java.util.ArrayList Ary_request, java.lang.String para)
static java.lang.String	getSQLname(java.util.ArrayList asList, int asParameter)
java.lang.String	getSqltext()
static java.lang.String	getSQLvalue(java.util.ArrayList asList, int asParameter)
static java.lang.String	getSQLvalue(java.util.ArrayList asList, java.lang.String asParameter) 取 sql value
java.lang.String	getSysid()
java.util.Vector	getTableAllFieldList(java.lang.String astable) 取 table 全部 field list
java.util.ArrayList	getTablePrimaryKey(java.lang.String astable)
int	getupdateRecordCount()
void	insert(BaseTable intable)
void	insert(java.sql.Connection conn, BaseTable intable) 標準 insert by basetable
void	insert(java.sql.Connection Conn, java.lang.String tablename, java.util.Vector Rowdata)
void	insert(java.lang.String tablename, java.util.Vector Rowdata) insert 資料
void	insertTableValue(java.lang.String tablename, java.util.Vector values)
boolean	isCheckExistsData(java.lang.String insql, java.util.Vector inKeyVector)
boolean	isExistsDatas(java.lang.String sql, java.util.Vector inKeyVector) 檢查是否資料, 只取一筆資料判斷
boolean	processRequest(javax.servlet.http.HttpServletRequest req)
ProcessRequest	processRequest(javax.servlet.http.HttpServletRequest req, java.lang.String invalue)
void	processSession(javax.servlet.http.HttpSession ses)
void	setAllrowcount(int value)
void	setContext(MaliContext incontext)
void	setDatabasetype(java.lang.String value)
void	setds(java.lang.String inds)
void	setDsname(java.lang.String value)
void	setExecSQL_Rowcount(int value)
void	setRequestdata(javax.servlet.http.HttpServletRequest req)
void	setSqltext(Sqlbean theSqlbean)
void	setSqltext(java.lang.String value)
void	setSysid(java.lang.String value)
java.sql.PreparedStatement	setWhereKeyPreparedStatement(java.sql.PreparedStatement inps, java.util.Vector rowdata)
java.util.ArrayList	SortSQLDataArray(java.util.ArrayList Ary_ArrayList, java.lang.String[] args)
BaseTable[]	SortSQLDataBaseTable(BaseTable[] Ary_BaseTable, java.lang.String[] args)
java.util.Vector	SortSQLDataVector(java.util.Vector Ary_ArrayList, java.lang.String[] args)
java.lang.String[]	toencodings(java.lang.String[] value)
void	update(BaseTable intable, boolean isupdateprimarykey)
void	update(java.sql.Connection conn, BaseTable intable, boolean isupdateprimarykey) 標準 update by basetable
void	update(java.sql.Connection Conn, java.lang.String tablename, java.util.Vector Rowdata, java.lang.String[] checkprimarykey, boolean isupdateprimarykey) update by connection
void	update(java.lang.String tablename, java.util.Vector Rowdata, java.lang.String[] checkprimarykey, boolean isupdateprimarykey) 執行 update 指令
void	WriteSysLog(java.lang.String log_kind, java.lang.String log_type, java.lang.String str)
java.lang.String	ws_equal_field(java.lang.String key, java.lang.String varvalue) for 如果 oracle and sybase 的 where 條件 is null 不等於 = ''

Methods inherited from class java.lang.Object

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

Field Detail

errMesg

public java.lang.String errMesg

KEY_DATABASE_SYBASE

public static java.lang.String KEY_DATABASE_SYBASE

KEY_DATABASE_ORACLE

public static java.lang.String KEY_DATABASE_ORACLE

KEY_DATABASE_SQLSERVER

public static java.lang.String KEY_DATABASE_SQLSERVER

KEY_DATABASE_MYSQL

public static java.lang.String KEY_DATABASE_MYSQL

KEY_DATABASE_DB2

public static java.lang.String KEY_DATABASE_DB2

KEY_DATABASE_SQLite

public static java.lang.String KEY_DATABASE_SQLite

KEY_DATABASE_PostgreSQL

public static java.lang.String KEY_DATABASE_PostgreSQL

KEY_DATABASE_UCANAccess

public static java.lang.String KEY_DATABASE_UCANAccess

vtableFieldlist

public static java.util.Hashtable vtableFieldlist

Constructor Detail

ConnDbCom

public ConnDbCom(maliConnection inconnection)

ConnDbCom

public ConnDbCom(javax.servlet.http.HttpServletRequest req)

ConnDbCom

public ConnDbCom(MaliContext incontext,
         java.lang.String indatabase_type)

ConnDbCom

public ConnDbCom(MaliContext incontext)

ConnDbCom

public ConnDbCom(java.lang.String cursysid)

Deprecated.

以系統代號帶入,以後均改用MaliContext

Parameters:

cursysid -

ConnDbCom

public ConnDbCom(MaliConfig Asmyconfig)

Deprecated.

Parameters:

Asmyconfig -

ConnDbCom

public ConnDbCom()

Method Detail

getConnection

public java.sql.Connection getConnection()
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getConnection

public java.sql.Connection getConnection(java.lang.String sysid,
                                java.lang.String indbtype)

setContext

public void setContext(MaliContext incontext)

setAllrowcount

public void setAllrowcount(int value)

getAllrowcount

public int getAllrowcount()

setExecSQL_Rowcount

public void setExecSQL_Rowcount(int value)

getExecSQL_Rowcount

public int getExecSQL_Rowcount()

執行ExecSQL 後的執行筆數 0 則表示沒有異動成功任何筆數

Returns:

setSqltext

public void setSqltext(java.lang.String value)
                throws java.lang.Exception

Throws:

java.lang.Exception

setSqltext

public void setSqltext(Sqlbean theSqlbean)
                throws java.lang.Exception

Throws:

java.lang.Exception

getSqltext

public java.lang.String getSqltext()
                            throws java.lang.Exception

Throws:

java.lang.Exception

setDsname

public void setDsname(java.lang.String value)
               throws java.lang.Exception

Throws:

java.lang.Exception

getDsname

public java.lang.String getDsname()
                           throws java.lang.Exception

Throws:

java.lang.Exception

setSysid

public void setSysid(java.lang.String value)

getSysid

public java.lang.String getSysid()

setDatabasetype

public void setDatabasetype(java.lang.String value)

getDatabasetype

public java.lang.String getDatabasetype()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

GetDataContent

public java.util.ArrayList GetDataContent(java.lang.String insql)
                                   throws java.lang.Exception,
                                          MaliException

取得 SQL 指令資料內容

Parameters:

sqltext - SQL 指令

Returns:

Throws:

java.lang.Exception

MaliException

GetDataContent

public java.util.ArrayList GetDataContent(java.lang.String insql,
                                 java.lang.String databasetype)
                                   throws MaliException,
                                          java.lang.Exception

取得 SQL 指令資料內容

Parameters:

insql -

databasetype - //設定資料庫

Returns:

Throws:

java.lang.Exception

MaliException

GetDataContent

public BaseTable[] GetDataContent(java.lang.String sqltext,
                         java.util.Vector inWhereKeyVector,
                         java.lang.String intable,
                         int rowstart,
                         int rowend)
                           throws java.lang.Exception

Throws:

java.lang.Exception

getLastRecordDataContent

public BaseTable getLastRecordDataContent(java.lang.String sqltext,
                                 java.util.Vector inWhereKeyVector,
                                 java.lang.String intable)
                                   throws java.lang.Exception

取依條件最後一筆資料

Parameters:

sqltext -

inWhereKeyVector -

intable -

Returns:

Throws:

java.lang.Exception

getFirstRecordDataContent

public BaseTable getFirstRecordDataContent(java.lang.String sqltext,
                                  java.util.Vector inWhereKeyVector,
                                  java.lang.String intable)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

convertRsToVector

public java.util.Vector convertRsToVector(java.sql.ResultSet inrs)
                                   throws java.sql.SQLException

將 ResultSet convert to Vector

Parameters:

inrs -

Returns:

Throws:

java.sql.SQLException

convertBaseTable

public BaseTable[] convertBaseTable(java.util.Vector qryrows)

GetDataContent

public BaseTable[] GetDataContent(java.lang.String sqltext,
                         java.util.Vector inWhereKeyVector,
                         java.lang.String intable)
                           throws java.lang.Exception

Throws:

java.lang.Exception

setWhereKeyPreparedStatement

public java.sql.PreparedStatement setWhereKeyPreparedStatement(java.sql.PreparedStatement inps,
                                                      java.util.Vector rowdata)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getConvertDBFieldDataType

public java.util.Vector getConvertDBFieldDataType(java.lang.String tablename,
                                         java.util.Vector allRow)
                                           throws java.sql.SQLException

Convert data field 取得datatype

Parameters:

inconn -

tablename -

allRow -

Returns:

Throws:

java.sql.SQLException

DataPreparedByQuery

public java.sql.PreparedStatement DataPreparedByQuery(java.sql.Connection inconn,
                                             java.lang.String sqltext)

提供給查詢用,只有Read不可異資料庫,可進行資料的 First & Last處理

Returns:

DataPreparSt

public java.sql.PreparedStatement DataPreparSt(java.sql.Connection inConn,
                                      java.lang.String sqltext)

GetDataContent_byKey

public java.util.Vector GetDataContent_byKey(java.lang.String sqltext,
                                    java.util.Vector inWhereKeyVector,
                                    java.lang.String intable,
                                    int rowstart,
                                    int rowend)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

GetDataContent_byKey

public java.util.Vector GetDataContent_byKey(java.lang.String sqltext,
                                    java.util.Vector inWhereKeyVector,
                                    java.lang.String intable)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

getBaseTableDataContent

public BaseTable[] getBaseTableDataContent(java.lang.String sqltext,
                                  java.lang.String databasetype)
                                    throws java.lang.Exception,
                                           MaliException

Throws:

java.lang.Exception

MaliException

getBaseTableDataContent

public BaseTable[] getBaseTableDataContent(java.lang.String sqltext)
                                    throws java.lang.Exception,
                                           MaliException

Throws:

java.lang.Exception

MaliException

GetDatatent

public BaseTable[] GetDatatent(java.lang.String sqltext)
                        throws java.lang.Exception,
                               MaliException

取得 SQL 指令資料內容,可直接給 SQL 指令

Parameters:

sqltext -

Returns:

BaseTable[] 格式資料

Throws:

java.lang.Exception

MaliException

GetDataContent

public java.util.ArrayList GetDataContent(java.lang.String insql,
                                 int startRow,
                                 int endRow)
                                   throws java.lang.Exception,
                                          MaliException

Parameters:

insql -

startRow - 取資料內容 開始第幾筆

endRow - 取資料內容 結束至第幾筆

Returns:

Throws:

java.lang.Exception - startRow = 0 & endRow = 0 則 表示取全部的資料

MaliException

GetDataContent

public java.util.ArrayList GetDataContent()
                                   throws java.lang.Exception,
                                          MaliException

Throws:

java.lang.Exception

MaliException

GetDataContentVector

public java.util.Vector GetDataContentVector(java.lang.String insql)
                                      throws java.lang.Exception,
                                             MaliException

取 Vector 型態的 DataContent

Parameters:

insql - String sql 指令

Returns:

Throws:

java.lang.Exception

MaliException

GetDataContentVector

public java.util.Vector GetDataContentVector()
                                      throws java.lang.Exception,
                                             MaliException

取 Vector 型態的 DataContent

Returns:

Throws:

java.lang.Exception

MaliException

GetRSDataContent

public void GetRSDataContent(java.lang.String insql)
                      throws java.lang.Exception

Throws:

java.lang.Exception

GetDataContent

public java.util.ArrayList GetDataContent(java.sql.ResultSet rs,
                                 int startRow,
                                 int endRow)

由 Rs 取符合筆數之資料

Parameters:

rs -

startRow -

endRow -

Returns:

getTablePrimaryKey

public java.util.ArrayList getTablePrimaryKey(java.lang.String astable)
                                       throws java.lang.Exception,
                                              java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

getPrimary

public java.util.ArrayList getPrimary(java.sql.Connection inConn,
                             java.lang.String astable)
                               throws java.lang.Exception,
                                      java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

getIdentity

public java.lang.String getIdentity(java.sql.Connection inConn,
                           java.lang.String astable,
                           java.lang.String ascolumn)
                             throws java.lang.Exception,
                                    java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

processSession

public void processSession(javax.servlet.http.HttpSession ses)
                    throws java.lang.Exception

Throws:

java.lang.Exception

processRequest

public ProcessRequest processRequest(javax.servlet.http.HttpServletRequest req,
                            java.lang.String invalue)
                              throws java.lang.Exception

Throws:

java.lang.Exception

processRequest

public boolean processRequest(javax.servlet.http.HttpServletRequest req)
                       throws java.lang.Exception

Throws:

java.lang.Exception

DBFExecSQL

public boolean DBFExecSQL(java.lang.String sql)
                   throws java.lang.Exception,
                          java.sql.SQLException

提供給DBF 使用EXECSQL

Parameters:

sql -

Returns:

Throws:

java.lang.Exception

java.sql.SQLException

ExecSQL

public boolean ExecSQL(java.lang.String sql)
                throws java.lang.Exception,
                       java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ExecSQL

public boolean ExecSQL(java.lang.String[] sql)
                throws java.lang.Exception,
                       java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ExecSQL

public boolean ExecSQL(java.lang.String[] sql,
              boolean writelog)
                throws java.lang.Exception,
                       java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ExecSQL

public boolean ExecSQL(java.lang.String sql,
              boolean writelog)
                throws java.lang.Exception,
                       java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

getSQLvalue

public static java.lang.String getSQLvalue(java.util.ArrayList asList,
                           java.lang.String asParameter)

取 sql value

Parameters:

asList - 取出的ArrayList 必須是SQLD 的 ArrayList,否則會解析錯誤

asParameter - 給欄位名稱

Returns:

getSQLvalue

public static java.lang.String getSQLvalue(java.util.ArrayList asList,
                           int asParameter)

getSQLname

public static java.lang.String getSQLname(java.util.ArrayList asList,
                          int asParameter)

DataResultSet

public java.sql.ResultSet DataResultSet(java.sql.Connection conn,
                               java.lang.String sqltext)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

SortSQLDataBaseTable

public BaseTable[] SortSQLDataBaseTable(BaseTable[] Ary_BaseTable,
                               java.lang.String[] args)

SortSQLDataVector

public java.util.Vector SortSQLDataVector(java.util.Vector Ary_ArrayList,
                                 java.lang.String[] args)

SortSQLDataArray

public java.util.ArrayList SortSQLDataArray(java.util.ArrayList Ary_ArrayList,
                                   java.lang.String[] args)

WriteSysLog

public void WriteSysLog(java.lang.String log_kind,
               java.lang.String log_type,
               java.lang.String str)
                 throws java.lang.Exception,
                        java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ws_equal_field

public java.lang.String ws_equal_field(java.lang.String key,
                              java.lang.String varvalue)

for 如果 oracle and sybase 的 where 條件 is null 不等於 = ''

Parameters:

key - table 的欄位

varvalue - 變數值

Returns:

getRequestvalue

public static java.lang.String getRequestvalue(java.util.ArrayList Ary_request,
                               java.lang.String para)

getRequestvalue

public clsRequestData getRequestvalue(java.util.ArrayList Ary_request,
                             int idx)

getSessionvalue

public static java.lang.String getSessionvalue(java.util.ArrayList Ary_request,
                               java.lang.String para)

Parameters:

Ary_request -

para -

Returns:

setRequestdata

public void setRequestdata(javax.servlet.http.HttpServletRequest req)

insert

public void insert(java.sql.Connection Conn,
          java.lang.String tablename,
          java.util.Vector Rowdata)
            throws java.lang.Exception

Throws:

java.lang.Exception

insert

public void insert(java.lang.String tablename,
          java.util.Vector Rowdata)
            throws java.lang.Exception

insert 資料

Parameters:

tablename -

Rowdata -

Throws:

java.lang.Exception

insert

public void insert(java.sql.Connection conn,
          BaseTable intable)
            throws java.lang.Exception

標準 insert by basetable

Parameters:

intable -

Throws:

java.lang.Exception

insert

public void insert(BaseTable intable)
            throws java.lang.Exception

Throws:

java.lang.Exception

update

public void update(java.sql.Connection conn,
          BaseTable intable,
          boolean isupdateprimarykey)
            throws java.lang.Exception

標準 update by basetable

Parameters:

intable -

isupdateprimarykey -

Throws:

java.lang.Exception

update

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

Throws:

java.lang.Exception

update

public void update(java.sql.Connection Conn,
          java.lang.String tablename,
          java.util.Vector Rowdata,
          java.lang.String[] checkprimarykey,
          boolean isupdateprimarykey)
            throws java.sql.SQLException,
                   java.lang.Exception

update by connection

Parameters:

Conn -

tablename -

Rowdata -

checkprimarykey -

isupdateprimarykey -

Throws:

java.sql.SQLException

java.lang.Exception

update

public void update(java.lang.String tablename,
          java.util.Vector Rowdata,
          java.lang.String[] checkprimarykey,
          boolean isupdateprimarykey)
            throws java.sql.SQLException,
                   java.lang.Exception

執行 update 指令

Parameters:

tablename -

Rowdata -

checkprimarykey -

isupdateprimarykey - boolean 是否update 實際 primarykey true 是要做update , false 是不做update

Throws:

java.sql.SQLException

java.lang.Exception

execute

public void execute(BaseTable[] objs)
             throws java.lang.Exception

同時執行insert.update.delete 且同步transaction

Parameters:

objs -

Throws:

java.lang.Exception

delete

public void delete(java.sql.Connection Conn,
          java.lang.String tablename,
          java.util.Vector Rowdata)
            throws java.lang.Exception

刪除資料by para Connection

Parameters:

Conn -

tablename -

Rowdata -

Throws:

java.lang.Exception

delete

public void delete(java.lang.String tablename,
          java.util.Vector Rowdata)
            throws java.lang.Exception

刪除資料

Parameters:

tablename -

Rowdata - Vector 是指刪除的where 欄位

Throws:

java.lang.Exception

delete

public void delete(BaseTable inobj)
            throws java.lang.Exception

Throws:

java.lang.Exception

CheckColumnType

public java.lang.String CheckColumnType(java.lang.String tablename,
                               java.lang.String columnname)

DataPreparSt

public java.sql.PreparedStatement DataPreparSt(java.lang.String sqltext)
                                        throws java.lang.Exception

Throws:

java.lang.Exception

toencodings

public java.lang.String[] toencodings(java.lang.String[] value)

getDBType

public java.lang.String getDBType(java.sql.Connection inconn)

getDBType

public java.lang.String getDBType()

insertTableValue

public void insertTableValue(java.lang.String tablename,
                    java.util.Vector values)
                      throws java.lang.Exception

Throws:

java.lang.Exception

getDBFieldDataType

public java.util.Vector getDBFieldDataType(java.lang.String tablename,
                                  java.util.Vector allRow,
                                  java.sql.Connection Conn)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

getRecordCount

public int getRecordCount(java.lang.String sqltext)

getRecordCount

public int getRecordCount(java.lang.String sqltext,
                 java.util.Vector inWhereKeyVector,
                 java.lang.String intable)
                   throws java.rmi.RemoteException,
                          java.lang.Exception

產生RECORDCOUNT 不需另外轉換,直接顯示筆數

Parameters:

sqltext -

inWhereKeyVector -

intable -

Returns:

Throws:

java.rmi.RemoteException

java.lang.Exception

setds

public void setds(java.lang.String inds)

getDbmergString

public java.lang.String getDbmergString(java.lang.String[] args)

getExistsData

public BaseTable getExistsData(BaseTable inobj)
                        throws java.sql.SQLException,
                               java.lang.Exception

檢查table資料是否存在

Parameters:

inobj -

Returns:

Throws:

java.sql.SQLException

java.lang.Exception

executeSQL

public int executeSQL(java.lang.String sql,
             java.util.Vector inKeyVector,
             java.lang.String intable)
               throws java.lang.Exception

Throws:

java.lang.Exception

isCheckExistsData

public boolean isCheckExistsData(java.lang.String insql,
                        java.util.Vector inKeyVector)
                          throws java.lang.Exception

Throws:

java.lang.Exception

isExistsDatas

public boolean isExistsDatas(java.lang.String sql,
                    java.util.Vector inKeyVector)
                      throws java.lang.Exception

檢查是否資料, 只取一筆資料判斷

Throws:

java.lang.Exception

getupdateRecordCount

public int getupdateRecordCount()
                         throws java.rmi.RemoteException,
                                java.lang.Exception

Throws:

java.rmi.RemoteException

java.lang.Exception

getTableAllFieldList

public java.util.Vector getTableAllFieldList(java.lang.String astable)
                                      throws java.lang.Exception

取 table 全部 field list

Parameters:

astable -

Returns:

Throws:

java.lang.Exception