gnu.caf.db.impl
Class RchRowSaveUpdate

java.lang.Object
  extended by gnu.caf.db.impl.RchRowSaveUpdate
All Implemented Interfaces:
RowCallbackHandler

public class RchRowSaveUpdate
extends java.lang.Object
implements RowCallbackHandler

µ¥ÀÌŸ Àüȯ¿ë Rch¿ëµµ·Î »ç¿ëÇϸç, list¿¡ ÇØ´çÇÏ´Â sqlID¸¦ ½ÇÇàÇÏ¿© ±× ÇØ´ç list ¿¡ ´ëÇÏ¿© º°µµÀÇ executeUpdate sqlID¸¦ ½ÇÇàÇÏ´Â °æ¿ì¿¡ »ç¿ëÇÑ´Ù. rs.next() ¸¶´Ù executeUpdate sqlID°¡ ½ÇÇàµÊ. °á°ú°ªÀº nullÀ» ¸®ÅÏÇÔ.

                String sqlFilename = "convert_tra_reg_no/Q_data_init";
                String tableName = "mgrp_mmbr";
                String listSqlID = "list_"+tableName;
                String executeSqlID = "save_"+tableName;
                DBManager2 dbmanager = new DBManager2Oracle();
                Attribute params = new Attribute();
                try{
                        dbmanager.getConnection(TargetServer.className, TargetServer.url, TargetServer.username, TargetServer.password);
                        dbmanager.setAutoCommit(false);
                        RchRowSaveUpdate.queryForList(dbmanager, sqlFilename, listSqlID, params)
                                                        .executeUpdate(sqlFilename, executeSqlID);
                        dbmanager.commit();
                }catch(Exception e) {
                        e.printStackTrace();//¿¡·¯Ã³¸®.
                        dbmanager.rollback();
                }finally {
                        dbmanager.close();
                }               
    

Since:
2.0
Author:
ÀÌÈ£¼º
See Also:
RowCallbackHandler

Method Summary
 void executeUpdate(java.lang.String sqlFilename, java.lang.String sqlID)
          ¸®½ºÆ®ÀÇ °¢ ·Î¿ìº°·Î sqlID¿¡ ÇØ´çÇÏ´Â Äõ¸®°¡ executeUpdate °¡ ½ÇÇàµÊ.
 java.lang.String getDatePattern()
           
 java.util.List getRsList(java.sql.ResultSet rs, int startRow, int maxRows)
          ResultSet ¿¡ ´ëÇÏ¿© firstRow¿¡ ÇØ´çÇÏ´Â ¸¸Å­ rs.next() ó¸®ÈÄ maxResults ¸¸Å­ µ¥ÀÌŸ¸¦ ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ.
 boolean isDate2String()
           
static RchRowSaveUpdate queryForList(DBManager2 dbmanager, java.lang.String sqlFilename, java.lang.String sqlID, Attribute params)
           
 RchRowSaveUpdate setDate2String(boolean date2String)
          Row󸮽à ¼³Á¤°ªÀÌ trueÀΰæ¿ì DateŸÀÔ¿¡ ´ëÇÏ¿© StringÀ¸·Î ÀÚµ¿º¯È¯ÇÔ.
 RchRowSaveUpdate setDatePattern(java.lang.String datePattern)
          setDatePattern - µðÆúÆ®°ªÀº yyyy-MM-dd HH:mm:ss
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getRsList

public java.util.List getRsList(java.sql.ResultSet rs,
                                int startRow,
                                int maxRows)
                         throws java.sql.SQLException
Description copied from interface: RowCallbackHandler
ResultSet ¿¡ ´ëÇÏ¿© firstRow¿¡ ÇØ´çÇÏ´Â ¸¸Å­ rs.next() ó¸®ÈÄ maxResults ¸¸Å­ µ¥ÀÌŸ¸¦ ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ. maxResults °¡ -1 ÀÎ °æ¿ì¿¡´Â Àüü rs ¿¡ ´ëÇÏ¿© ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ.

Specified by:
getRsList in interface RowCallbackHandler
Returns:
List
Throws:
java.sql.SQLException
See Also:
RowCallbackHandler.getRsList(ResultSet, int, int)

queryForList

public static RchRowSaveUpdate queryForList(DBManager2 dbmanager,
                                            java.lang.String sqlFilename,
                                            java.lang.String sqlID,
                                            Attribute params)

executeUpdate

public void executeUpdate(java.lang.String sqlFilename,
                          java.lang.String sqlID)
                   throws java.sql.SQLException
¸®½ºÆ®ÀÇ °¢ ·Î¿ìº°·Î sqlID¿¡ ÇØ´çÇÏ´Â Äõ¸®°¡ executeUpdate °¡ ½ÇÇàµÊ.

Parameters:
sqlID -
Throws:
java.sql.SQLException

getDatePattern

public java.lang.String getDatePattern()

isDate2String

public boolean isDate2String()

setDate2String

public RchRowSaveUpdate setDate2String(boolean date2String)
Row󸮽à ¼³Á¤°ªÀÌ trueÀΰæ¿ì DateŸÀÔ¿¡ ´ëÇÏ¿© StringÀ¸·Î ÀÚµ¿º¯È¯ÇÔ. µðÆúÆ® º¯È¯ Æ÷¸ËÀº yyyy-MM-dd HH:mm:ss ·Î ´Ù¸¥ Æ÷¸ËÀ» º¯°æ½Ã setDatePatter ¸Þ¼Òµå·Î ÁöÁ¤.

Parameters:
date2String -
Returns:
RchRowSaveUpdate

setDatePattern

public RchRowSaveUpdate setDatePattern(java.lang.String datePattern)
setDatePattern - µðÆúÆ®°ªÀº yyyy-MM-dd HH:mm:ss

Parameters:
datePattern -
Returns:
RchRowSaveUpdate


Copyright © 2003 All Rights Reserved.