gnu.caf.db.impl
Class DBManager2Oracle

java.lang.Object
  gnu.caf.db.impl.SqlUtilOracle
      gnu.caf.db.impl.DBManager2Oracle

All Implemented Interfaces:

DBManager2, SqlUtil

Direct Known Subclasses:

DBManager2MSSQL

public class DBManager2Oracle
extends SqlUtilOracle
implements DBManager2

DBManager2 ÀÇ Oracle ±¸Çö Ŭ·¡½ºÀÓ.

Since:

1.0

Author:

ÀÌÈ£¼º

Field Summary

static java.lang.String	blobClessName
static java.lang.String	clobClessName
protected Attribute	globalParams
protected boolean	pagingTypeRsNext
protected java.lang.String	resourceSqlPath
protected boolean	sqlIdTracable
protected java.util.ArrayList	sqlIdTraceList

Fields inherited from class gnu.caf.db.impl.SqlUtilOracle

bDEBUG, connection, dataSource, isAutoCommit, jndiDataSourceName, rowCallbackHandler, transaction

Constructor Summary

DBManager2Oracle()

Method Summary

void	close() close 󸮸¦ ÇÔ.
void	close(Attribute params) Connection close½Ã sql TypeÀÌ uid À¸·Î ÁöÁ¤µÈ sqlid¿¡ ´ëÇÑ °á°ú°ªÀ» params º¯¼ö¿¡ ÇÒ´çÇÏ°í, close ó¸®ÇÔ.
int	executeBatchUpdateByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlID, java.util.List attributeList) Batch¼º µ¥ÀÌŸ 󸮽à »ç¿ëÇϸç, sqlID¿¡ ÇØ´çÇÏ´Â queryGroupÀÌ groupÇüÅ°¡ ¾Æ´Ñ°æ¿ì batch󸮰¡ °¡´ÉÇÔ.
protected java.util.List	executeProcedureCallByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params)
int	executeQueryForIntByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) Jdbc Ãß»óÈ­ Layer ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ.
java.util.List	executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.
java.util.List	executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int firstResult, int maxResults)
java.util.List	executeQueryForListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ.
java.util.List	executeQueryForListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int firstResult, int maxResults) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ.
java.util.Map	executeQueryForMapByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ Map ¸¦ ¸®ÅÏ.
PagingList	executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int pageNo, int pageSize) QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.
PagingList	executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int pageNo, int pageSize, int totalCount) QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.
PagingList	executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int pageNo, int pageSize) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸Å­ÀÇ PagingList ¸¦ ¸®ÅÏÇÔ.
PagingList	executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int pageNo, int pageSize, int totalCount) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸Å­ÀÇ PagingList ¸¦ ¸®ÅÏÇÔ.
protected PagingList	executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize) sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ.
protected PagingList	executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize, int totalCount)
java.util.List	executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ.
java.util.List	executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int randomResults) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ.
java.util.List	executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int randomResults, int totalCount) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ.
protected java.util.List	executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params)
protected java.util.List	executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int randomResults, int totalCount)
int	executeQueryForTotalCountByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.
int	executeQueryForTotalCountByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) sqlID¿¡ ÇØ´çÇÏ´Â sql À» count_sql·Î º¯È¯ ( select count(*) from ( sql ) ) ÈÄ COUNT¿¡ ÇØ´çÇÏ´Â °ªÀ» ¸®ÅÏÇÔ.
protected int	executeQueryForTotalCountByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, boolean logPrint)
protected void	executeQueryForXlobByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params)
int	executeUpdateByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.
int	executeUpdateByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ.
int	executeUpdateByQueryGroupDelete(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ.
int	executeUpdateByQueryGroupInsert(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ.
int	executeUpdateByQueryGroupUpdate(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ.
Attribute	getGlobalParams() DBManager ¼öÇà½Ã ³»ºÎÀûÀ¸·Î sql type="uid" ÀÎ °æ¿ì¿¡´Â DBManager ³»ºÎ ±Û·Î¹ú º¯¼ö¿¡ ÀúÀåÇÏ°Ô µÇ´Â µ¥, ÀÌ ±Û·Î¹ú Parameter¸¦ °¡Á®¿È.
java.lang.String	getResourceSqlPath() Ŭ·¡½ºÆнº»óÀÇ sql.xml ÆÄÀÏÀ» ·ÎµåÇÏ´Â °æ¿ì¼³Á¤.
boolean	isPagingTypeRsNext()
boolean	isSqlIdTracable()
static void	main(java.lang.String[] args)
int	saveByQueryGroup(java.lang.String sqlFilename, java.lang.String viewSqlId, java.lang.String insertSqlId, java.lang.String updateSqlId, Attribute params) viewSqlID ÀÇ ½ÇÇà°á°ú°¡ µ¥ÀÌŸ°¡ ÀÖ´Â °æ¿ì(rs.next() °¡ Á¸ÀçÇϸé) , updateSqlID ¿¡ ÇØ´çÇÏ´Â Äõ¸®°¡ ½ÇÇà, ¾øÀ¸¸é, insertSqlID°¡ ½ÇÇàµÊ.
void	setPagingTypeRsNext(boolean pagingTypeRsNext) ÆäÀÌÁö¡ 󸮽à rs.next() ¹æ½ÄÀ¸·Î ÆäÀ̡󸮸¦ ÇÒ ½Ã »ç¿ëÇÔ.
void	setResourceSqlPath(java.lang.String resourceSqlPath) Ŭ·¡½ºÆнº»óÀÇ sql.xml ÆÄÀÏÀ» ·ÎµåÇÏ´Â °æ¿ì¼³Á¤ÇÔ.
void	setSqlIdTracable(boolean sqlIdTracable) ½ÇÇàµÇ´Â executeUpdate¿¡ ´ëÇÏ¿© sqlid¸¦ Ãâ·ÂÇÏ°íÀÚ ÇÒ ¶§ »ç¿ëÇÔ.
void	sqlIdAppend(java.lang.String method, java.lang.String sqlFilename, java.lang.String sqlId)

Methods inherited from class gnu.caf.db.impl.SqlUtilOracle

clearParams, commit, executeQueryForFixedSequenceString, executeQueryForFixedSequenceString, executeQueryForInt, executeQueryForInt, executeQueryForList, executeQueryForList, executeQueryForList, executeQueryForMap, executeQueryForMap, executeQueryForPagingList, executeQueryForPagingList, executeUpdate, executeUpdate, executeUpdateClob, executeUpdateClob, executeUpdateNCHAR, finalize, getAutoCommit, getConnection, getConnection, getConnection, getDataSource, getJndiDataSourceName, getRowCallbackHandler, isDebug, loadParams, prepareCall, rollback, setAutoCommit, setConnection, setDataSource, setDebug, setJndiDataSourceName, setRowCallbackHandler

Methods inherited from class java.lang.Object

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

Methods inherited from interface gnu.caf.db.DBManager2

setDebug

Methods inherited from interface gnu.caf.db.SqlUtil

clearParams, commit, executeQueryForFixedSequenceString, executeQueryForFixedSequenceString, executeQueryForInt, executeQueryForInt, executeQueryForList, executeQueryForList, executeQueryForList, executeQueryForMap, executeQueryForMap, executeQueryForPagingList, executeQueryForPagingList, executeUpdate, executeUpdate, executeUpdateClob, executeUpdateClob, executeUpdateNCHAR, getAutoCommit, getConnection, getConnection, getConnection, getDataSource, getJndiDataSourceName, getRowCallbackHandler, prepareCall, rollback, setAutoCommit, setConnection, setDataSource, setJndiDataSourceName, setRowCallbackHandler

Field Detail

globalParams

protected Attribute globalParams

pagingTypeRsNext

protected boolean pagingTypeRsNext

sqlIdTracable

protected boolean sqlIdTracable

sqlIdTraceList

protected java.util.ArrayList sqlIdTraceList

resourceSqlPath

protected java.lang.String resourceSqlPath

clobClessName

public static java.lang.String clobClessName

blobClessName

public static java.lang.String blobClessName

Constructor Detail

DBManager2Oracle

public DBManager2Oracle()

Method Detail

sqlIdAppend

public void sqlIdAppend(java.lang.String method,
                        java.lang.String sqlFilename,
                        java.lang.String sqlId)

getGlobalParams

public Attribute getGlobalParams()

Description copied from interface: DBManager2

DBManager ¼öÇà½Ã ³»ºÎÀûÀ¸·Î sql type="uid" ÀÎ °æ¿ì¿¡´Â DBManager ³»ºÎ ±Û·Î¹ú º¯¼ö¿¡ ÀúÀåÇÏ°Ô µÇ´Â µ¥, ÀÌ ±Û·Î¹ú Parameter¸¦ °¡Á®¿È.

Specified by:

getGlobalParams in interface DBManager2

Returns:

Attribute

close

public void close()

Description copied from class: SqlUtilOracle

close 󸮸¦ ÇÔ.

ex)
String sql = "update .... ";
SqlUtil sqlutil = new SqlUtil();
try{
sqlutil.getConnection("maags");
sqlutil.setAutoCommit(false);
sqlutil.executeUpdate(sql);
sqlutil.commit();
}catch(SQLException e) {
e.printStackTrace();
sqlutil.rollback();
}finally{
sqlutil.close();
}


Specified by:

close in interface SqlUtil

Overrides:

close in class SqlUtilOracle

close

public void close(Attribute params)

Description copied from interface: DBManager2

Connection close½Ã sql TypeÀÌ uid À¸·Î ÁöÁ¤µÈ sqlid¿¡ ´ëÇÑ °á°ú°ªÀ» params º¯¼ö¿¡ ÇÒ´çÇÏ°í, close ó¸®ÇÔ.

Specified by:

close in interface DBManager2

executeQueryForListByQueryGroup

public java.util.List executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                                      Attribute params)
                                               throws java.sql.SQLException

Description copied from interface: DBManager2

QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.

Specified by:

executeQueryForListByQueryGroup in interface DBManager2

Returns:

List

Throws:

java.sql.SQLException

executeQueryForListByQueryGroup

public java.util.List executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                                      Attribute params,
                                                      int firstResult,
                                                      int maxResults)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryGroup

public PagingList executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename,
                                                        java.lang.String sqlId,
                                                        Attribute params,
                                                        int pageNo,
                                                        int pageSize,
                                                        int totalCount)
                                                 throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸Å­ÀÇ PagingList ¸¦ ¸®ÅÏÇÔ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ³»ºÎÀûÀ¸·Î µðºñ±âÁØÀÇ ÆäÀ̡󸮱â¹ýÀ» »ç¿ëÇÔ. ¿À¶óŬÀÇ °æ¿ì, pageNo °¡ 1 , pageSize 10 ÀÎ °æ¿ì¿¡ rownum > 0 and rownum <= 10 Á¶°ÇÀÌ Ãß°¡µÈ sql¸¦ ½ÇÇàÇÏ¿© PagingList ¸¦ ¸®ÅÏÇÔ.

Specified by:

executeQueryForPagingListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

pageNo - ÆäÀÌÁö¹øÈ£

pageSize - ÆäÀÌÁö»çÀÌ

totalCount - Àüüµ¥ÀÌŸ¼ö ( executeQueryForPagingListByQueryGroup(String sqlFilename, String sqlId, Attribute params, int pageNo, int pageSize) ÀÇ °æ¿ì¿¡ totalCount °è»êÀ» À§ÇØ ³»ºÎÀûÀ¸·Î sqlÀ» µÎ¹ø½ÇÇàµÇÁö¸¸, Àüüµ¥ÀÌŸ¼ö¸¦ ÁöÁ¤ÇÏ´Â °æ¿ì totalCount °è»êÀ» À§ÇÑ sql ½ÇÇàÀ» ÇÏÁö ¾ÊÀ½)

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryGroup

public PagingList executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                                        Attribute params,
                                                        int pageNo,
                                                        int pageSize,
                                                        int totalCount)
                                                 throws java.sql.SQLException

Description copied from interface: DBManager2

QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.

Specified by:

executeQueryForPagingListByQueryGroup in interface DBManager2

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryGroup

public PagingList executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                                        Attribute params,
                                                        int pageNo,
                                                        int pageSize)
                                                 throws java.sql.SQLException

Description copied from interface: DBManager2

QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.

Specified by:

executeQueryForPagingListByQueryGroup in interface DBManager2

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryGroup

public PagingList executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename,
                                                        java.lang.String sqlId,
                                                        Attribute params,
                                                        int pageNo,
                                                        int pageSize)
                                                 throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸Å­ÀÇ PagingList ¸¦ ¸®ÅÏÇÔ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ³»ºÎÀûÀ¸·Î µðºñ±âÁØÀÇ ÆäÀ̡󸮱â¹ýÀ» »ç¿ëÇÔ. ¿À¶óŬÀÇ °æ¿ì, pageNo °¡ 1 , pageSize 10 ÀÎ °æ¿ì¿¡ rownum > 0 and rownum <= 10 Á¶°ÇÀÌ Ãß°¡µÈ sql¸¦ ½ÇÇàÇÏ¿© PagingList ¸¦ ¸®ÅÏÇÔ.

Specified by:

executeQueryForPagingListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

pageNo - ÆäÀÌÁö¹øÈ£

pageSize - ÆäÀÌÁö»çÀÌÁî

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForListByQueryGroup

public java.util.List executeQueryForListByQueryGroup(java.lang.String sqlFilename,
                                                      java.lang.String sqlId,
                                                      Attribute params)
                                               throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. È£Ãâ½Ã <sql> ¿¡ ¼³Á¤µÈ °ªÀ¸·Î ¸®½ºÆ®°´Ã¼¸¦ ¹ÝȯÇÔ.

• 1. executeQueryForRandomListByQueryGroup(sqlFilename, sqlId, params, randomResults) - randomResults °¡ ¼³Á¤µÈ °æ¿ì.
• 2. executeQueryForListByQueryGroup(sqlFilename, sqlId, params, firstResult, maxResults ) - firstResult ³ª maxResults °¡ ¼³Á¤µÈ °æ¿ì.
• 3. executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, -1 ) - ±âº»Çü(randomResults, firstResult, maxResults °¡ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì)

¸®½ºÆ® 󸮽à À§ÀÇ 3°¡Áö À¯ÇüÀ¸·Î 󸮵Ê. ±âº»ÀûÀ¸·Î 3¹øÀÇ Äڵ尡 ½ÇÇàÀÌ µÇ¸ç, sqlFilename.xml¿¡ ¼³Á¤µÈ <sql id="sqlId" firstResult="" maxResults=""> ÀÌ·±½ÄÀ¸·Î ¼³Á¤µÈ °æ¿ì, firstReuslt, maxResults ¿¡ ÇØ´çÇÏ´Â °ªÀ¸·Î ½ÇÇàµÊ.

Specified by:

executeQueryForListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

List

Throws:

java.sql.SQLException

executeQueryForMapByQueryGroup

public java.util.Map executeQueryForMapByQueryGroup(java.lang.String sqlFilename,
                                                    java.lang.String sqlId,
                                                    Attribute params)
                                             throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ Map ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeQueryForMapByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

Map

Throws:

java.sql.SQLException

executeQueryForRandomListByQueryGroup

public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename,
                                                            java.lang.String sqlId,
                                                            Attribute params)
                                                     throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. <sql id="sqlID" randomResult="10"> ÀÌ·±½ÄÀ¸·Î ¼³Á¤µÇ¾îÀÖ´Â °æ¿ì. ÇØ´ç randomResults °¹¼ö¸¸Å­ List°´Ã¼¸¦ ¸®ÅÏÇÔ. ·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î,

• 10°³ randomResults ·Î ¼³Á¤Çߴµ¥ Àüüī¿îÆ®°¡ 5°³ÀÎ °æ¿ì
• 10°³ÀÇ ·£´ý¼ö¸¦ ÃßÃâÇÏÁö ¸øÇÑ °æ¿ì(³»ºÎÀûÀ¸·Î Àüüµ¥ÀÌŸ°¡ 10°³ ·£´ý¼ö10°³ÀÎ °æ¿ì Àüüµ¥ÀÌŸ¼ö¸¸Å­ ·£´ýÀ» ¼öÇàÇϱ⠶§¹®¿¡ 10¹ø ¼öÇàµÈ´Ù°í ÇÏ´õ¶óµµ 10°³ÀÇ µ¥ÀÌŸ¸¦ ÃßÃâÇÒ È®·üÀÌ ³·À½)

À§ÀÇ °æ¿ì ³»ºÎÀûÀ¸·Î randomResults ¿¡ ÇØ´çÇÏ´Â executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, maxResults ) °¡ ½ÇÇàÀÌ µÈ´Ù.

Specified by:

executeQueryForRandomListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

List

Throws:

java.sql.SQLException

executeQueryForRandomListByQueryGroup

public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename,
                                                            java.lang.String sqlId,
                                                            Attribute params,
                                                            int randomResults)
                                                     throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î,

• 10°³ randomResults ·Î ¼³Á¤Çߴµ¥ Àüüī¿îÆ®°¡ 5°³ÀÎ °æ¿ì
• 10°³ÀÇ ·£´ý¼ö¸¦ ÃßÃâÇÏÁö ¸øÇÑ °æ¿ì(³»ºÎÀûÀ¸·Î Àüüµ¥ÀÌŸ°¡ 10°³ ·£´ý¼ö10°³ÀÎ °æ¿ì Àüüµ¥ÀÌŸ¼ö¸¸Å­ ·£´ýÀ» ¼öÇàÇϱ⠶§¹®¿¡ 10¹ø ¼öÇàµÈ´Ù°í ÇÏ´õ¶óµµ 10°³ÀÇ µ¥ÀÌŸ¸¦ ÃßÃâÇÒ È®·üÀÌ ³·À½)

À§ÀÇ °æ¿ì ³»ºÎÀûÀ¸·Î randomResults ¿¡ ÇØ´çÇÏ´Â executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, maxResults ) °¡ ½ÇÇàÀÌ µÈ´Ù.

Specified by:

executeQueryForRandomListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

randomResults - ÀÓÀÇÃßÃâµ¥ÀÌŸ¼ö.

Returns:

List

Throws:

java.sql.SQLException

executeQueryForIntByQueryGroup

public int executeQueryForIntByQueryGroup(java.lang.String sqlFilename,
                                          java.lang.String sqlId,
                                          Attribute params)
                                   throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ Layer ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeQueryForIntByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

int

Throws:

java.sql.SQLException

executeQueryForListByQueryGroup

public java.util.List executeQueryForListByQueryGroup(java.lang.String sqlFilename,
                                                      java.lang.String sqlId,
                                                      Attribute params,
                                                      int firstResult,
                                                      int maxResults)
                                               throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ¸®½ºÆ® 󸮽à firstResult ¿¡ ÇØ´çÇÏ´Â µ¥ÀÌŸºÎÅÍ maxResults °¹¼ö¸¸Å­ µ¥ÀÌŸ¸¦ ¸®½ºÆ®°´Ã¼·Î ¸®ÅÏÇÔ. ±âº»ÀûÀ¸·Î ¾Æ·¡ÀÇ Äڵ尡 ½ÇÇàÀÌ µÇ¸ç, sqlFilename.xml¿¡ ¼³Á¤µÈ <sql id="sqlId" firstResult="" maxResults=""> ÀÌ·±½ÄÀ¸·Î ¼³Á¤µÈ °æ¿ì, firstReuslt, maxResults ¿¡ ÇØ´çÇÏ´Â °ªÀ¸·Î ½ÇÇàµÊ.

executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, -1 )

À§ÀÇ ÄÚµå´Â sql½ÇÇàÈÄ ½ÇÇàÇÑ °á°ú Àüü¸¦ °¡Á®¿À´Â °ÍÀÓ. ³»ºÎÀûÀ¸·Î firstResult ¼ö¸¸Å­ rs.next() 󸮸¦ ÇÔ. maxResults °¡ -1 ÀÎ °æ¿ì Àüü¸¦ °¡Á®¿È.

È£Ãâ½Ã <sql> ¿¡ ¼³Á¤µÈ °ªÀÌ ÀÖ´õ¶óµµ firstResult, maxResuls¸¦ ÁöÁ¤ÇÑ ¸¸Å­ ½ÇÇàµÊ.

Specified by:

executeQueryForListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

firstResult - rs.next() ½ÇÇàȽ¼ö.

maxResults - µ¥ÀÌŸ¸¦ °¡Á®¿Ã °¹¼ö.

Returns:

List

Throws:

java.sql.SQLException

executeUpdateByQueryGroupInsert

public int executeUpdateByQueryGroupInsert(java.lang.String sqlFilename,
                                           java.lang.String sqlID,
                                           Attribute params)
                                    throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <insert> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeUpdateByQueryGroupInsert in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

int

Throws:

java.sql.SQLException

executeQueryForRandomListByQueryGroup

public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename,
                                                            java.lang.String sqlId,
                                                            Attribute params,
                                                            int randomResults,
                                                            int totalCount)
                                                     throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ List ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.
executeQueryForRandomListByQueryGroup(String sqlFilename, String sqlId, Attribute params, int randomResults) ½ÇÇà½Ã , ·£´ý¼ö ÃßÃâÇϱâ À§ÇÏ¿© totalCount-sql ¸¦ ½ÇÇàÇÏ°Ô µÇ´Âµ¥, totalCount¸¦ ÁöÁ¤½Ã totalCount-sql ¸¦ ¼öÇàÇÏÁö ¾Ê´Â´Ù.

Specified by:

executeQueryForRandomListByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

List

Throws:

java.sql.SQLException

executeUpdateByQueryGroupUpdate

public int executeUpdateByQueryGroupUpdate(java.lang.String sqlFilename,
                                           java.lang.String sqlID,
                                           Attribute params)
                                    throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <update> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeUpdateByQueryGroupUpdate in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

int

Throws:

java.sql.SQLException

executeUpdateByQueryGroupDelete

public int executeUpdateByQueryGroupDelete(java.lang.String sqlFilename,
                                           java.lang.String sqlID,
                                           Attribute params)
                                    throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <delete> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeUpdateByQueryGroupDelete in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

int

Throws:

java.sql.SQLException

executeUpdateByQueryGroup

public int executeUpdateByQueryGroup(java.lang.String sqlFilename,
                                     java.lang.String sqlID,
                                     Attribute params)
                              throws java.sql.SQLException

Description copied from interface: DBManager2

Jdbc Ãß»óÈ­ ·¹ÀÌ¾î ¿¡¼­ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ ½ÇÇàÈÄ int ¸¦ ¸®ÅÏ. sqlFilename.xml¿¡¼­ <executeUpdate> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.

Specified by:

executeUpdateByQueryGroup in interface DBManager2

params - Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö

Returns:

int

Throws:

java.sql.SQLException

executeBatchUpdateByQueryGroup

public int executeBatchUpdateByQueryGroup(java.lang.String sqlFilename,
                                          java.lang.String sqlID,
                                          java.util.List attributeList)
                                   throws java.sql.SQLException

Description copied from interface: DBManager2

Batch¼º µ¥ÀÌŸ 󸮽à »ç¿ëÇϸç, sqlID¿¡ ÇØ´çÇÏ´Â queryGroupÀÌ groupÇüÅ°¡ ¾Æ´Ñ°æ¿ì batch󸮰¡ °¡´ÉÇÔ. ³»ºÎÀûÀ¸·Î executeBatchUpdate °¡ »ç¿ëµÊ.

Specified by:

executeBatchUpdateByQueryGroup in interface DBManager2

attributeList - - List<Attribute>

Returns:

int

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)

executeUpdateByQueryGroup

public int executeUpdateByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                     Attribute params)
                              throws java.sql.SQLException

Description copied from interface: DBManager2

QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.

Specified by:

executeUpdateByQueryGroup in interface DBManager2

Returns:

int

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryItem

protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                          Attribute params,
                                                          int pageNo,
                                                          int pageSize)
                                                   throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ. ÆäÀ̡󸮽à ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®¸¦ °¡Á®¿È. 󸮽à Àüü Ä«¿îÆ®¿Í ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®°´Ã¼¸¦ ¹ÝȯÇÔ. PagingList paginglist = executeQueryForPagingList(queryitem, params, 1, 10); int totalCount = paginglist.getTotalCount(); List list = paginglist.getList();

Parameters:

query -

params -

pageNo -

pageSize -

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForTotalCountByQueryItem

protected int executeQueryForTotalCountByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                   Attribute params,
                                                   boolean logPrint)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryForPagingListByQueryItem

protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                          Attribute params,
                                                          int pageNo,
                                                          int pageSize,
                                                          int totalCount)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryForXlobByQueryItem

protected void executeQueryForXlobByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                              Attribute params)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

executeProcedureCallByQueryItem

protected java.util.List executeProcedureCallByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                         Attribute params)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryForTotalCountByQueryGroup

public int executeQueryForTotalCountByQueryGroup(java.lang.String sqlFilename,
                                                 java.lang.String sqlId,
                                                 Attribute params)
                                          throws java.sql.SQLException

Description copied from interface: DBManager2

sqlID¿¡ ÇØ´çÇÏ´Â sql À» count_sql·Î º¯È¯ ( select count(*) from ( sql ) ) ÈÄ COUNT¿¡ ÇØ´çÇÏ´Â °ªÀ» ¸®ÅÏÇÔ.

Specified by:

executeQueryForTotalCountByQueryGroup in interface DBManager2

Returns:

int

Throws:

java.sql.SQLException

executeQueryForTotalCountByQueryGroup

public int executeQueryForTotalCountByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup,
                                                 Attribute params)
                                          throws java.sql.SQLException

Description copied from interface: DBManager2

QueryGroup°´Ã¼¸¦ Á÷Á¢ÀûÀ¸·Î Çڵ鸵ÇÒ °æ¿ì¸¸ »ç¿ëÇÔ.

Specified by:

executeQueryForTotalCountByQueryGroup in interface DBManager2

Returns:

int

Throws:

java.sql.SQLException

executeQueryForRandomListByQueryItem

protected java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                              Attribute params)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryForRandomListByQueryItem

protected java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                              Attribute params,
                                                              int randomResults,
                                                              int totalCount)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

saveByQueryGroup

public int saveByQueryGroup(java.lang.String sqlFilename,
                            java.lang.String viewSqlId,
                            java.lang.String insertSqlId,
                            java.lang.String updateSqlId,
                            Attribute params)
                     throws java.sql.SQLException

Description copied from interface: DBManager2

viewSqlID ÀÇ ½ÇÇà°á°ú°¡ µ¥ÀÌŸ°¡ ÀÖ´Â °æ¿ì(rs.next() °¡ Á¸ÀçÇϸé) , updateSqlID ¿¡ ÇØ´çÇÏ´Â Äõ¸®°¡ ½ÇÇà, ¾øÀ¸¸é, insertSqlID°¡ ½ÇÇàµÊ.

Specified by:

saveByQueryGroup in interface DBManager2

Returns:

int

Throws:

java.sql.SQLException

isPagingTypeRsNext

public boolean isPagingTypeRsNext()

setPagingTypeRsNext

public void setPagingTypeRsNext(boolean pagingTypeRsNext)

Description copied from interface: DBManager2

ÆäÀÌÁö¡ 󸮽à rs.next() ¹æ½ÄÀ¸·Î ÆäÀ̡󸮸¦ ÇÒ ½Ã »ç¿ëÇÔ. ÀϺΠ¼º´É»óÀÇ ¹®Á¦·Î »ç¿ëÇØ¾ß ÇÒ °æ¿ì°¡ ÀÖÀ½.

Specified by:

setPagingTypeRsNext in interface DBManager2

isSqlIdTracable

public boolean isSqlIdTracable()

setSqlIdTracable

public void setSqlIdTracable(boolean sqlIdTracable)

Description copied from interface: DBManager2

½ÇÇàµÇ´Â executeUpdate¿¡ ´ëÇÏ¿© sqlid¸¦ Ãâ·ÂÇÏ°íÀÚ ÇÒ ¶§ »ç¿ëÇÔ. µðÆúÆ®°ªÀº true ÀÓ.

Specified by:

setSqlIdTracable in interface DBManager2

getResourceSqlPath

public java.lang.String getResourceSqlPath()

Description copied from interface: DBManager2

Ŭ·¡½ºÆнº»óÀÇ sql.xml ÆÄÀÏÀ» ·ÎµåÇÏ´Â °æ¿ì¼³Á¤.(Ejb»ç¿ë½Ã À¯¿ëÇÔ.)

Specified by:

getResourceSqlPath in interface DBManager2

Returns:

String

setResourceSqlPath

public void setResourceSqlPath(java.lang.String resourceSqlPath)

Description copied from interface: DBManager2

Ŭ·¡½ºÆнº»óÀÇ sql.xml ÆÄÀÏÀ» ·ÎµåÇÏ´Â °æ¿ì¼³Á¤ÇÔ.(Ejb»ç¿ë½Ã jar »ý¼º½Ã sqlFilename µµ °°ÀÌ ¹èÆ÷.)

Specified by:

setResourceSqlPath in interface DBManager2