com.poscoict.glueframework.biz.activity
Class GlueJdbcModify

java.lang.Object
  extended by com.poscoict.glueframework.biz.activity.GlueActivity<GlueContext>
      extended by com.poscoict.glueframework.biz.activity.GlueJdbcModify

public class GlueJdbcModify
extends GlueActivity<GlueContext>

Modify Activity. GlueJdbcModify Class´Â "update emp set ename=?, job=? where empno=?" ¿Í °°Àº SQL update statement¸¦ ¼öÇà ÇÏ´Â Activity ÀÌ´Ù. WebÈ­¸é°ú NonUI °øÅëÀ¸·Î »ç¿ëµÇ°í Binding Parameter TypeÀº WebÀÎ °æ¿ì String []ÀÇ {0}¹ø°·Î Binding ÇÏ°í WebÀÌ ¾Æ´Ñ °æ¿ì´Â ÇØ´ç Object¸¦ Binding ÇÑ´Ù. ¿©±â¼­ chk-nameÀÌ ÀÖ´Â °æ¿ì WebÀÇ CheckBox¿¡ Check µÈ ¼ö¸¸Å­ ¹Ýº¹ ÇÏ°í ¾ø´Â °æ¿ì´Â Context¿¡¼­ ¹Ù·Î String[] ·Î getÇÏ¿© Binding ÇÑ´Ù. NonUIÀÇ °æ¿ì Data TypeÀÌ String[]°¡ ¾Æ´Ñ °æ¿ì ¹Ù·Î ÇØ´ç Object·Î Binding ÇÑ´Ù.

 Activity Property
 
 - dao : (Çʼö) applicationContext.xmlÀÇ DAO id.
 
 - sql-key : (Çʼö) {name}-query.glue_sqlÀÇ query id 
 
 - param-count : (¼±ÅÃ) Binding ÇÒ °³¼ö ( update emp set ename=? job=? where empno=? )ÀÇ "?" ¼ö
 
 - param#(param0,param1...) : (¼±ÅÃ) Binding Value ("?"¿Í ¼ø¼­ ÀÏÄ¡ ÇÏ¿©¾ß ÇÔ)
 
 - param-bindings : (¼±ÅÃ) binding¿¡ »ç¿ëµÇ´Â °ª°ú Mapping µÇ´Â Key( bindName=ctxName[|bindName=ctxName] ).
         ctxÀÇ key°¡ binding variable name°ú °°Àº °æ¿ì »ý·«(´ë¼Ò¹®ÀÚ ±¸ºÐÇÔ).
         ctxName Àº GlueContextÀÇ Key À̰ųª list-key ¿¡ ÇØ´çÇÏ´Â mapÀÇ KeyÀÌ´Ù.
 
 - chk-name : (¼±ÅÃ) È­¸éÀÇ CheckBox ID(HttpRequestÀÇ parameter name).
         chk-name ¿¡ µû¶ó Looping 󸮸¦ ÇÑ´Ù. 
         chk-name¿¡ ÇØ´çÇÏ´Â °ÍÀÌ ´ÙÀ½°ú °°ÀÌ checkbox ¶ó¸é, ±× °ªÀº 0,1,2...,n À¸·Î ºÎ¿©µÇ¸ç 
         checked µÈ °ª¸¸ GlueContext¿¡ ´ã±ä´Ù. 
 
 - list-key : (¼±ÅÃ) SQL ¹®¿¡ Binding ÇÒ Data·Î¼­, Map ÇüÅÂÀÇ DataÀ» °®´Â List ±¸Á¶Ã¼¸¦ °¡¸£Å´.
 
 - result-key : (¼±ÅÃ) Context¿¡ ´ã±â´Â Query ¼öÇà °á°ú(µî·Ï record ¼ö) Key.
         [ default ] : {sql-key}_updateCnt
  
 - is-audit : insert½Ã Audit Ç׸ñ Àû¿ë Option
          Audit Ç׸ñÀº glue.properties¿¡ audit.insert.key ¿Í audit.update.key ¸¦ Âü°íÇÑ´Ù.
          ÁÖÀÇ»çÇ×: Audit Ç׸ñÀº SQL¿¡ ¹Ý¿µµÇ¾î ÀÖ¾î¾ß ÇÑ´Ù. 
                ¾Æ·¡ÀÇ 'emp.update.audit' ¿Í °°Àº À¯ÇüÀÇ SQLÀÎ °æ¿ì, 
                ColumnÀÇ ¼ø¼­´Â glue.properties¿¡ Á¤ÀÇÇÑ ¼ø¼­¿Í °°¾Æ¾ß Çϸç, 
                Audit Ç׸ñÀ» À§ SQLó·³ ¸Ç ¾Õ¿¡ ±â¼úµÇ¾î¾ß ÇÑ´Ù.
 
 
 
 ¿¹Á¦
 »ç¿ë ¿¹# 1
 - À¯Çü1 Äõ¸®¸¦ »ç¿ëÇÏ´Â °æ¿ì
 
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update" />
         <property name="param-count" value="3" />
         <property name="param0" value="SAL" />
         <property name="param1" value="ENAME" />
         <property name="param2" value="EMPNO" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 2
 - À¯Çü1 Äõ¸®ÀÇ Looping ó¸®. (Web)
 
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update" />
         <property name="param-count" value="3" />
         <property name="param0" value="SAL" />
         <property name="param1" value="ENAME" />
         <property name="param2" value="EMPNO" />
         <property name="chk-name" value="chk" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 3
 - À¯Çü1 Äõ¸®ÀÇ Looping ó¸®. (NonUI)
 
     <activity name="Custom" class="...">
         <transition name="success" value="Modify" />
     </activity>
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update" />
         <property name="param-count" value="3" />
         <property name="param0" value="SAL" />
         <property name="param1" value="ENAME" />
         <property name="param2" value="EMPNO" />
         <property name="list-key" value="dataList" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 4
 - À¯Çü2 Äõ¸®¸¦ »ç¿ëÇÏ´Â °æ¿ì
 
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update.named" />
         <property name="param-bindings" value="empno=EMPNO|ename=ENAME|sal=SAL" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 5
 - À¯Çü2 Äõ¸®ÀÇ Looping ó¸®. (Web)
 
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update.named" />
         <property name="param-bindings" value="empno=EMPNO|ename=ENAME|sal=SAL" />
         <property name="chk-name" value="chk" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 6
 - À¯Çü2 Äõ¸®ÀÇ Looping ó¸®. (NonUI)
 
     <activity name="Custom" class="...">
         <transition name="success" value="Modify" />
     </activity>
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update.named" />
         <property name="param-bindings" value="empno=EMPNO|ename=ENAME|sal=SAL" />
         <property name="list-key" value="dataList" />
         <transition name="success" value="Find" />
     </activity>
 
 
 »ç¿ë ¿¹# 7
 - À¯Çü1 Äõ¸®ÀÇ auditÁ¤º¸
 
     <activity name="Modify" class="com.poscoict.glueframework.biz.activity.GlueJdbcModify">
         <property name="dao" value="testdao" />
         <property name="sql-key" value="emp.update.audit" />
         <property name="param-count" value="3" />
         <property name="param0" value="ENAME" />
         <property name="param1" value="SAL" />
         <property name="param2" value="EMPNO" />
         <property name="is-audit" value="true" />
         <transition name="success" value="Find" />
     </activity>
 
 
 
 Âü°í : {name}-query.glue_sql
 
     <query id="emp.update" desc="Type #1">
         <![CDATA[ 
               update emp set sal=?, ename=? where empno=?
         ]]> 
     </query>
     <query id="emp.update.named" desc="Type #1" isNamed="true">
         <![CDATA[ 
               update emp set sal=:sal, ename=:ename where empno=:empno
         ]]>
     </query>
     <query id="emp.update.audit">
         <![CDATA[ 
               update emp_audit
               set audit_update_id=?, audit_update_ip=?, audit_update_dt=?, 
                 ename=?, job=?
               where empno=?
         ]]>
     </query> 
 
 
 Âü°í : HTML Code
 
     <input type="checkbox" name="chk" value="0">
     <input type="text" name="EMPNO" value="1111">
     <input type="text" name="ENAME" value="name1">
     <input type="text" name="SAL" value="1000">
     <input type="checkbox" name="chk" value="1">
     <input type="text" name="EMPNO" value="1112">
     <input type="text" name="ENAME" value="name2">
     <input type="text" name="SAL" value="1100">
 
 
 Âü°í : Java Code (Custom)
 
     List<Map<String, Object>> dataList = new ArrayList<Map<String, Object>>();
     Map<String, Object> data1 = new HashMap<String, Object>();
     data1.put("EMPNO","1111");
     data1.put("ENAME","name1");
     data1.put("SAL","1000");
     dataList.add(data1);
     Map<String, Object> data2 = new HashMap<String, Object>();
     data2.put("EMPNO","1112");
     data2.put("ENAME","name2");
     data2.put("SAL","1100");
     dataList.add(data2);
     ctx.put("dataList",dataList);
 
 
 Âü°í : glue.properties
 
     audit.insert.key=id,ip,cur_time,id,ip,cur_time
     audit.update.key=id,ip,cur_time
 


Field Summary
 
Fields inherited from class com.poscoict.glueframework.biz.activity.GlueActivity
dynamicProperties, logger
 
Constructor Summary
GlueJdbcModify()
           
 
Method Summary
 String runActivity(GlueContext ctx)
          Sub Class¿¡¼­ ¹Ýµå½Ã ±¸ÇöÇÏ¿©¾ß ÇÏ´Â Abstract Method À̸ç ÀÌ Method´Â F/W¿¡¼­ È£ÃâÇÑ´Ù.
 
Methods inherited from class com.poscoict.glueframework.biz.activity.GlueActivity
commitTransaction, commitTransaction, getDao, getEventList, getName, getProperty, getPropertyNames, getTransition, rollbackTransaction, rollbackTransaction, setEventList, setName, setProperty, setTransition
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

GlueJdbcModify

public GlueJdbcModify()
Method Detail

runActivity

public String runActivity(GlueContext ctx)
Description copied from class: GlueActivity
Sub Class¿¡¼­ ¹Ýµå½Ã ±¸ÇöÇÏ¿©¾ß ÇÏ´Â Abstract Method À̸ç ÀÌ Method´Â F/W¿¡¼­ È£ÃâÇÑ´Ù. °á°ú °ªÀº GlueContext¿¡ ´ã¾Æ¼­ ´ÙÀ½ Activity ¶Ç´Â F/W¿¡ Àü´ÞÇÏ°Ô µÈ´Ù. ÇÊ¿äÇÑ ¸ðµç Data´Â GlueContext¿¡¼­ È£ÃâÇÏ¿© »ç¿ëÇÏ°Ô µÈ´Ù.

Specified by:
runActivity in class GlueActivity<GlueContext>
Parameters:
ctx - GlueContext
Returns:
String Á¤»óÀûÀ̸é "success"¸¦ Return ÇÏ°í ºñÁ¤»ó 󸮸¦ ¿øÇϸé "failure"¸¦ Return ÇÑ´Ù.
 ¿¹) 
 <transition name="success" value="BizLogic"/>
 <transition name="failure" value="ErrorHandle"/>
 ==> return "success"À̸é BizLogic Activity ¸¦ ½ÇÇàÇÔ.
 


Copyright © 2013–2017 POSCO ICT. All rights reserved.