public interface DBService
Modifier and Type | Method and Description |
---|---|
int |
addNewSessionConnectionURL(int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password)
Add a new db URL to db configuration, and return its sequence number
|
int |
addNewSessionConnectionURL(int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password,
int minConnCount,
int maxConnCount)
Add a new db URL to db configuration, and return its sequence number
|
int |
addNewSessionConnectionURL(int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password,
int minConnCount,
int maxConnCount,
boolean isSession3X)
Add a new db URL to db configuration, and return its sequence number
|
void |
addSessionConnectionURL(int seq,
int type,
java.lang.String dburl,
java.lang.String username,
java.lang.String password)
Add a db URL to db configuration, and specify its sequence number in it.
|
void |
addSessionConnectionURL(int seq,
int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password)
Add a db URL to db configuration, and specify its sequence number in it
|
void |
addSessionConnectionURL(int seq,
int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password,
int minConnCount,
int maxConnCount)
Add a db URL to db configuration, and specify its sequence number in it
|
void |
addSessionConnectionURL(int seq,
int type,
java.lang.String name,
java.lang.String dburl,
java.lang.String username,
java.lang.String password,
int minConnCount,
int maxConnCount,
boolean isSession3X)
Add a db URL to db configuration, and specify its sequence number in it
|
java.util.List |
ArtSQLloadValue(java.lang.String sql)
Deprecated.
Using SQLloadValue instead for performance and flexibility
|
int[] |
batchSQLupdateValue(java.lang.String[] sql) |
int[] |
batchSQLupdateValue(java.lang.String sql,
org.springframework.jdbc.core.BatchPreparedStatementSetter bpss) |
void |
closeAllSessionConnection()
Close a SessionConnection object
|
void |
closeOpenedSessionConnection()
Close all SessionConnection object opened by current thread
|
void |
closeSessionConnection(java.lang.String session)
Close a SessionConnection object
|
void |
closeSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session) |
void |
commitSessionConnection(java.lang.String session)
Make commit on the connection
|
void |
commitSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session) |
SessionConnection |
createSessionConnection(int sequence)
Create a SessionConnection
|
SessionConnection |
createSessionConnection(java.lang.String name)
Create a SessionConnection
|
boolean |
delete(java.lang.String sqlcmd)
Database delete
|
boolean |
delete(java.lang.String sqlcmd,
java.util.Vector record,
java.util.Vector columnTypeList)
Database delete
|
java.util.HashMap |
deleteSessionConnectionURL(java.lang.String name)
Remove a db URL from db configuration by given name, return the
configuration which has been deleted
|
java.util.Map |
executeStoredProcedureWithSessionConnection(java.lang.String mSession,
java.lang.String storedProcedureName,
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params,
java.lang.String returnType) |
java.util.Map |
executeStoredProcedureWithSessionConnection(java.lang.String mIp,
java.lang.String mPort,
java.lang.String mSession,
java.lang.String storedProcedureName,
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params,
java.lang.String returnType) |
java.util.HashMap |
getSessionConnectionURL(int sequence)
Get the db configuration info with the specific sequence number
|
java.util.HashMap |
getSessionConnectionURL(java.lang.String name)
Get the db configuration info with the specific name
|
java.util.HashMap |
getSessionConnectionURL(java.lang.String ip,
java.lang.String port,
int sequence) |
java.util.HashMap |
getSessionConnectionURL(java.lang.String ip,
java.lang.String port,
java.lang.String name) |
java.util.Vector |
getSessionConnectionURLList()
Get the db configuration info list
|
boolean |
insert(java.lang.String sqlcmd,
java.util.Vector record,
java.util.Vector columnTypeList)
Database insert
|
boolean |
isTableExist(java.lang.String tableName) |
java.util.Vector |
loadValueWithSessionConnection(java.lang.String session,
java.lang.String sqlcmd)
Invoke the connection to load value
|
java.util.Vector |
loadValueWithSessionConnection(java.lang.String session,
java.lang.String sqlcmd,
java.lang.Object[] args) |
java.util.Vector |
loadValueWithSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session,
java.lang.String sqlcmd) |
java.util.Vector |
loadValueWithSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session,
java.lang.String sqlcmd,
java.lang.Object[] args) |
java.util.HashMap |
query(java.lang.String sqlcmd)
Deprecated.
Using SQLloadValue instead for performance and flexibility
|
java.util.HashMap |
query(java.lang.String sqlcmd,
int top)
Deprecated.
Using SQLloadValue instead for performance and flexibility
|
java.util.HashMap |
query1(java.lang.String sqlcmd)
Deprecated.
Using SQLloadValue instead for performance and flexibility
|
java.util.HashMap |
query2(java.lang.String sqlcmd,
java.lang.Object[] params)
Deprecated.
Using SQLloadValue instead for performance and flexibility
|
void |
rollbackSessionConnection(java.lang.String session)
Make rollback on the connection
|
void |
rollbackSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session) |
boolean |
SQLdeleteValue(java.lang.String sql)
The method is used to delete value from database (the RTRepository)
|
boolean |
SQLdeleteValue(java.lang.String sql,
java.lang.Object[] args) |
java.util.Map |
SQLexecuteStoredProcedure(java.lang.String storedProcedureName,
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params,
java.lang.String returnType) |
boolean |
SQLinsertValue(java.lang.String sql)
The method is used to insert value to database (the RTRepository)
|
boolean |
SQLinsertValue(java.lang.String sql,
java.lang.Object[] args) |
java.util.List |
SQLloadValue(java.lang.String sql)
The method is used to load value from database (the RTRepository)
|
java.util.List |
SQLloadValue(java.lang.String sql,
java.lang.Object[] args) |
boolean |
SQLupdateValue(java.lang.String sql)
The method is used to update value to database (the RTRepository)
|
boolean |
SQLupdateValue(java.lang.String sql,
java.lang.Object[] args) |
boolean |
testSessionConnection(int sequence)
Test a SessionConnection
|
boolean |
testSessionConnection(java.lang.String name)
Test a SessionConnection
|
boolean |
update(java.lang.String sqlcmd,
java.util.Vector newRecord,
java.util.Vector newColumnTypeList,
java.util.Vector oldRecord,
java.util.Vector oldColumnTypeList)
Database update
|
boolean |
updateValueWithSessionConnection(java.lang.String session,
java.lang.String sqlcmd)
Invoke the connection to update value
|
boolean |
updateValueWithSessionConnection(java.lang.String session,
java.lang.String sqlcmd,
java.lang.Object[] args) |
boolean |
updateValueWithSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session,
java.lang.String sqlcmd) |
boolean |
updateValueWithSessionConnection(java.lang.String ip,
java.lang.String port,
java.lang.String session,
java.lang.String sqlcmd,
java.lang.Object[] args) |
java.util.List SQLloadValue(java.lang.String sql)
sql
- the input SQL data stringjava.util.List SQLloadValue(java.lang.String sql, java.lang.Object[] args)
boolean SQLinsertValue(java.lang.String sql)
sql
- the input SQL data stringboolean SQLinsertValue(java.lang.String sql, java.lang.Object[] args)
boolean SQLupdateValue(java.lang.String sql)
sql
- the input SQL data stringboolean SQLupdateValue(java.lang.String sql, java.lang.Object[] args)
int[] batchSQLupdateValue(java.lang.String[] sql)
int[] batchSQLupdateValue(java.lang.String sql, org.springframework.jdbc.core.BatchPreparedStatementSetter bpss)
boolean SQLdeleteValue(java.lang.String sql)
sql
- the input SQL data stringboolean SQLdeleteValue(java.lang.String sql, java.lang.Object[] args)
java.util.List ArtSQLloadValue(java.lang.String sql)
java.util.HashMap query(java.lang.String sqlcmd)
java.util.HashMap query(java.lang.String sqlcmd, int top)
java.util.HashMap query1(java.lang.String sqlcmd)
java.util.HashMap query2(java.lang.String sqlcmd, java.lang.Object[] params)
boolean insert(java.lang.String sqlcmd, java.util.Vector record, java.util.Vector columnTypeList)
boolean delete(java.lang.String sqlcmd)
boolean delete(java.lang.String sqlcmd, java.util.Vector record, java.util.Vector columnTypeList)
boolean update(java.lang.String sqlcmd, java.util.Vector newRecord, java.util.Vector newColumnTypeList, java.util.Vector oldRecord, java.util.Vector oldColumnTypeList)
void addSessionConnectionURL(int seq, int type, java.lang.String dburl, java.lang.String username, java.lang.String password)
seq
- the given DB sequencetype
- the given DB Typedburl
- the given DB URLusername
- the given Usernamepassword
- the given Passowrdvoid addSessionConnectionURL(int seq, int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password)
seq
- the given DB sequencetype
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given Passowrdvoid addSessionConnectionURL(int seq, int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password, int minConnCount, int maxConnCount)
seq
- the given DB sequencetype
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given PassowrdminConnCount
- the given Minimum Connection Number in pool.maxConnCount
- the given Maximum Connection Number in pool.void addSessionConnectionURL(int seq, int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password, int minConnCount, int maxConnCount, boolean isSession3X)
seq
- the given DB sequencetype
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given PassowrdminConnCount
- the given Minimum Connection Number in pool.maxConnCount
- the given Maximum Connection Number in pool.isSession3X
- the given isSession3Xint addNewSessionConnectionURL(int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password)
type
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given Passowrdint addNewSessionConnectionURL(int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password, int minConnCount, int maxConnCount)
type
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given PassowrdminConnCount
- the given Minimum Connection Number in pool.maxConnCount
- the given Maximum Connection Number in pool.int addNewSessionConnectionURL(int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password, int minConnCount, int maxConnCount, boolean isSession3X)
type
- the given DB Typename
- the given DB Namedburl
- the given DB URLusername
- the given Usernamepassword
- the given PassowrdminConnCount
- the given Minimum Connection Number in pool.maxConnCount
- the given Maximum Connection Number in pool.isSession3X
- the given isSession3Xjava.util.HashMap deleteSessionConnectionURL(java.lang.String name)
name
- the given DB Namejava.util.Vector getSessionConnectionURLList()
java.util.HashMap getSessionConnectionURL(int sequence)
sequence
- the given DB sequencejava.util.HashMap getSessionConnectionURL(java.lang.String ip, java.lang.String port, int sequence)
java.util.HashMap getSessionConnectionURL(java.lang.String name)
name
- the given DB Namejava.util.HashMap getSessionConnectionURL(java.lang.String ip, java.lang.String port, java.lang.String name)
SessionConnection createSessionConnection(int sequence)
sequence
- the given DB sequenceSessionConnection createSessionConnection(java.lang.String name)
name
- the given DB Namevoid closeSessionConnection(java.lang.String session)
session
- the given Session Keyvoid closeSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session)
void closeAllSessionConnection()
void closeOpenedSessionConnection()
java.util.Vector loadValueWithSessionConnection(java.lang.String session, java.lang.String sqlcmd) throws java.sql.SQLException
session
- the given Session Keysqlcmd
- the given SQL statementjava.sql.SQLException
ResultTable
java.util.Vector loadValueWithSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session, java.lang.String sqlcmd) throws java.sql.SQLException
java.sql.SQLException
java.util.Vector loadValueWithSessionConnection(java.lang.String session, java.lang.String sqlcmd, java.lang.Object[] args) throws java.sql.SQLException
java.sql.SQLException
java.util.Vector loadValueWithSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session, java.lang.String sqlcmd, java.lang.Object[] args) throws java.sql.SQLException
java.sql.SQLException
boolean updateValueWithSessionConnection(java.lang.String session, java.lang.String sqlcmd) throws java.sql.SQLException
session
- the given Session Keysqlcmd
- the given SQL statementjava.sql.SQLException
boolean updateValueWithSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session, java.lang.String sqlcmd) throws java.sql.SQLException
java.sql.SQLException
boolean updateValueWithSessionConnection(java.lang.String session, java.lang.String sqlcmd, java.lang.Object[] args) throws java.sql.SQLException
java.sql.SQLException
boolean updateValueWithSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session, java.lang.String sqlcmd, java.lang.Object[] args) throws java.sql.SQLException
java.sql.SQLException
void commitSessionConnection(java.lang.String session) throws java.sql.SQLException
session
- the given Session Keyjava.sql.SQLException
void commitSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session) throws java.sql.SQLException
java.sql.SQLException
void rollbackSessionConnection(java.lang.String session)
session
- the given Session Keyvoid rollbackSessionConnection(java.lang.String ip, java.lang.String port, java.lang.String session)
boolean testSessionConnection(int sequence)
sequence
- the given DB sequenceboolean testSessionConnection(java.lang.String name)
name
- the given DB Nameboolean isTableExist(java.lang.String tableName)
tableName
- true
if the given tableName
exists in databasejava.util.Map SQLexecuteStoredProcedure(java.lang.String storedProcedureName, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params, java.lang.String returnType)
java.util.Map executeStoredProcedureWithSessionConnection(java.lang.String mSession, java.lang.String storedProcedureName, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params, java.lang.String returnType)
java.util.Map executeStoredProcedureWithSessionConnection(java.lang.String mIp, java.lang.String mPort, java.lang.String mSession, java.lang.String storedProcedureName, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> params, java.lang.String returnType)
Copyright ? 2022. All Rights Reserved.