|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object gnu.caf.db.impl.SqlUtilOracle gnu.caf.db.impl.DBManager2Oracle
public class DBManager2Oracle
DBManager2 ÀÇ Oracle ±¸Çö Ŭ·¡½ºÀÓ.
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 java.lang.Object |
---|
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface gnu.caf.db.DBManager2 |
---|
setDebug |
Field Detail |
---|
protected Attribute globalParams
protected boolean pagingTypeRsNext
protected boolean sqlIdTracable
protected java.util.ArrayList sqlIdTraceList
protected java.lang.String resourceSqlPath
public static java.lang.String clobClessName
public static java.lang.String blobClessName
Constructor Detail |
---|
public DBManager2Oracle()
Method Detail |
---|
public void sqlIdAppend(java.lang.String method, java.lang.String sqlFilename, java.lang.String sqlId)
public Attribute getGlobalParams()
DBManager2
getGlobalParams
in interface DBManager2
public void close()
SqlUtilOracle
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();
}
close
in interface SqlUtil
close
in class SqlUtilOracle
public void close(Attribute params)
DBManager2
close
in interface DBManager2
public java.util.List executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) throws java.sql.SQLException
DBManager2
executeQueryForListByQueryGroup
in interface DBManager2
java.sql.SQLException
public java.util.List executeQueryForListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int firstResult, int maxResults) throws java.sql.SQLException
java.sql.SQLException
public PagingList executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int pageNo, int pageSize, int totalCount) throws java.sql.SQLException
DBManager2
Jdbc Ãß»óÈ ·¹ÀÌ¾î ¿¡¼ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸ÅÀÇ PagingList ¸¦ ¸®ÅÏÇÔ. sqlFilename.xml¿¡¼ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ³»ºÎÀûÀ¸·Î µðºñ±âÁØÀÇ ÆäÀ̡󸮱â¹ýÀ» »ç¿ëÇÔ. ¿À¶óŬÀÇ °æ¿ì, pageNo °¡ 1 , pageSize 10 ÀÎ °æ¿ì¿¡ rownum > 0 and rownum <= 10 Á¶°ÇÀÌ Ãß°¡µÈ sql¸¦ ½ÇÇàÇÏ¿© PagingList ¸¦ ¸®ÅÏÇÔ.
executeQueryForPagingListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼öpageNo
- ÆäÀÌÁö¹øÈ£pageSize
- ÆäÀÌÁö»çÀÌtotalCount
- Àüüµ¥ÀÌŸ¼ö ( executeQueryForPagingListByQueryGroup(String sqlFilename, String sqlId, Attribute params, int pageNo, int pageSize) ÀÇ
°æ¿ì¿¡ totalCount °è»êÀ» À§ÇØ ³»ºÎÀûÀ¸·Î sqlÀ» µÎ¹ø½ÇÇàµÇÁö¸¸, Àüüµ¥ÀÌŸ¼ö¸¦ ÁöÁ¤ÇÏ´Â °æ¿ì totalCount °è»êÀ» À§ÇÑ sql ½ÇÇàÀ» ÇÏÁö ¾ÊÀ½)
java.sql.SQLException
public PagingList executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int pageNo, int pageSize, int totalCount) throws java.sql.SQLException
DBManager2
executeQueryForPagingListByQueryGroup
in interface DBManager2
java.sql.SQLException
public PagingList executeQueryForPagingListByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params, int pageNo, int pageSize) throws java.sql.SQLException
DBManager2
executeQueryForPagingListByQueryGroup
in interface DBManager2
java.sql.SQLException
public PagingList executeQueryForPagingListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int pageNo, int pageSize) throws java.sql.SQLException
DBManager2
Jdbc Ãß»óÈ ·¹ÀÌ¾î ¿¡¼ È£ÃâµÇ´Â sqlFilename, sqlID ¿¡ ÇØ´çÇÏ´Â sql¸¦ pageNo, pageSize ¸¸ÅÀÇ PagingList ¸¦ ¸®ÅÏÇÔ. sqlFilename.xml¿¡¼ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ. ³»ºÎÀûÀ¸·Î µðºñ±âÁØÀÇ ÆäÀ̡󸮱â¹ýÀ» »ç¿ëÇÔ. ¿À¶óŬÀÇ °æ¿ì, pageNo °¡ 1 , pageSize 10 ÀÎ °æ¿ì¿¡ rownum > 0 and rownum <= 10 Á¶°ÇÀÌ Ãß°¡µÈ sql¸¦ ½ÇÇàÇÏ¿© PagingList ¸¦ ¸®ÅÏÇÔ.
executeQueryForPagingListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼öpageNo
- ÆäÀÌÁö¹øÈ£pageSize
- ÆäÀÌÁö»çÀÌÁî
java.sql.SQLException
public java.util.List executeQueryForListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) throws java.sql.SQLException
DBManager2
sqlFilename.xml
¿¡ ¼³Á¤µÈ <sql id="sqlId" firstResult="" maxResults="">
ÀÌ·±½ÄÀ¸·Î ¼³Á¤µÈ °æ¿ì, firstReuslt, maxResults ¿¡ ÇØ´çÇÏ´Â °ªÀ¸·Î ½ÇÇàµÊ.
executeQueryForListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public java.util.Map executeQueryForMapByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) throws java.sql.SQLException
DBManager2
executeQueryForMapByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) throws java.sql.SQLException
DBManager2
sqlFilename.xml
¿¡¼ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.
<sql id="sqlID" randomResult="10"> ÀÌ·±½ÄÀ¸·Î ¼³Á¤µÇ¾îÀÖ´Â °æ¿ì. ÇØ´ç randomResults °¹¼ö¸¸Å
List°´Ã¼¸¦ ¸®ÅÏÇÔ.
·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î,
executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, maxResults )
°¡ ½ÇÇàÀÌ µÈ´Ù.
executeQueryForRandomListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int randomResults) throws java.sql.SQLException
DBManager2
sqlFilename.xml
¿¡¼ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.
·£´ýÀ¸·Î ½ÇÇà½Ã ·£´ý°¹¼ö°¡ ÃæÁ·µÇÁö ¸øÇÑ°æ¿ì ¿¹¸¦ µé¾î,
executeQueryForListByQueryGroup(sqlFilename, sqlId, params, 0, maxResults )
°¡ ½ÇÇàÀÌ µÈ´Ù.
executeQueryForRandomListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼örandomResults
- ÀÓÀÇÃßÃâµ¥ÀÌŸ¼ö.
java.sql.SQLException
public int executeQueryForIntByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) throws java.sql.SQLException
DBManager2
executeQueryForIntByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public java.util.List executeQueryForListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int firstResult, int maxResults) throws java.sql.SQLException
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¸¦ ÁöÁ¤ÇÑ ¸¸Å ½ÇÇàµÊ.
executeQueryForListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼öfirstResult
- rs.next() ½ÇÇàȽ¼ö.maxResults
- µ¥ÀÌŸ¸¦ °¡Á®¿Ã °¹¼ö.
java.sql.SQLException
public int executeUpdateByQueryGroupInsert(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) throws java.sql.SQLException
DBManager2
executeUpdateByQueryGroupInsert
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public java.util.List executeQueryForRandomListByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params, int randomResults, int totalCount) throws java.sql.SQLException
DBManager2
sqlFilename.xml
¿¡¼ <select> ű׿¡ ÇØ´çÇÏ´Â sqlID¸¦ È£ÃâÇÔ.
executeQueryForRandomListByQueryGroup(String sqlFilename, String sqlId, Attribute params, int randomResults)
½ÇÇà½Ã ,
·£´ý¼ö ÃßÃâÇϱâ À§ÇÏ¿© totalCount-sql ¸¦ ½ÇÇàÇÏ°Ô µÇ´Âµ¥, totalCount¸¦ ÁöÁ¤½Ã totalCount-sql ¸¦ ¼öÇàÇÏÁö ¾Ê´Â´Ù.
executeQueryForRandomListByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public int executeUpdateByQueryGroupUpdate(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) throws java.sql.SQLException
DBManager2
executeUpdateByQueryGroupUpdate
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public int executeUpdateByQueryGroupDelete(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) throws java.sql.SQLException
DBManager2
executeUpdateByQueryGroupDelete
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public int executeUpdateByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlID, Attribute params) throws java.sql.SQLException
DBManager2
executeUpdateByQueryGroup
in interface DBManager2
params
- Attribute µðºñ󸮽à »ç¿ëµÇ´Â º¯¼ö
java.sql.SQLException
public int executeBatchUpdateByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlID, java.util.List attributeList) throws java.sql.SQLException
DBManager2
executeBatchUpdateByQueryGroup
in interface DBManager2
attributeList
- - List<Attribute>
java.sql.SQLException
public static void main(java.lang.String[] args)
public int executeUpdateByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) throws java.sql.SQLException
DBManager2
executeUpdateByQueryGroup
in interface DBManager2
java.sql.SQLException
protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize) throws java.sql.SQLException
query
- params
- pageNo
- pageSize
-
java.sql.SQLException
protected int executeQueryForTotalCountByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, boolean logPrint) throws java.sql.SQLException
java.sql.SQLException
protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize, int totalCount) throws java.sql.SQLException
java.sql.SQLException
protected void executeQueryForXlobByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params) throws java.sql.SQLException
java.sql.SQLException
protected java.util.List executeProcedureCallByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params) throws java.sql.SQLException
java.sql.SQLException
public int executeQueryForTotalCountByQueryGroup(java.lang.String sqlFilename, java.lang.String sqlId, Attribute params) throws java.sql.SQLException
DBManager2
select count(*) from ( sql )
) ÈÄ COUNT¿¡ ÇØ´çÇÏ´Â °ªÀ» ¸®ÅÏÇÔ.
executeQueryForTotalCountByQueryGroup
in interface DBManager2
java.sql.SQLException
public int executeQueryForTotalCountByQueryGroup(gnu.caf.db.querymanager.QueryGroup querygroup, Attribute params) throws java.sql.SQLException
DBManager2
executeQueryForTotalCountByQueryGroup
in interface DBManager2
java.sql.SQLException
protected java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params) throws java.sql.SQLException
java.sql.SQLException
protected java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int randomResults, int totalCount) throws java.sql.SQLException
java.sql.SQLException
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
DBManager2
saveByQueryGroup
in interface DBManager2
java.sql.SQLException
public boolean isPagingTypeRsNext()
public void setPagingTypeRsNext(boolean pagingTypeRsNext)
DBManager2
setPagingTypeRsNext
in interface DBManager2
public boolean isSqlIdTracable()
public void setSqlIdTracable(boolean sqlIdTracable)
DBManager2
setSqlIdTracable
in interface DBManager2
public java.lang.String getResourceSqlPath()
DBManager2
getResourceSqlPath
in interface DBManager2
public void setResourceSqlPath(java.lang.String resourceSqlPath)
DBManager2
setResourceSqlPath
in interface DBManager2
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |