gnu.caf.db.impl
Class DBManager2Oracle

java.lang.Object
  extended by gnu.caf.db.impl.SqlUtilOracle
      extended by 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> ¿¡ ¼³Á¤µÈ °ªÀ¸·Î ¸®½ºÆ®°´Ã¼¸¦ ¹ÝȯÇÔ. ¸®½ºÆ® 󸮽à À§ÀÇ 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°´Ã¼¸¦ ¸®ÅÏÇÔ. ·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î, À§ÀÇ °æ¿ì ³»ºÎÀûÀ¸·Î 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¸¦ È£ÃâÇÔ. ·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î, À§ÀÇ °æ¿ì ³»ºÎÀûÀ¸·Î 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


Copyright © 2003 All Rights Reserved.