com.poscoict.glueframework.biz.activity
Class GlueJdbcModify
java.lang.Object
com.poscoict.glueframework.biz.activity.GlueActivity<GlueContext>
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 Äõ¸®¸¦ »ç¿ëÇÏ´Â °æ¿ì
»ç¿ë ¿¹# 2
- À¯Çü1 Äõ¸®ÀÇ Looping ó¸®. (Web)
»ç¿ë ¿¹# 3
- À¯Çü1 Äõ¸®ÀÇ Looping ó¸®. (NonUI)
»ç¿ë ¿¹# 4
- À¯Çü2 Äõ¸®¸¦ »ç¿ëÇÏ´Â °æ¿ì
»ç¿ë ¿¹# 5
- À¯Çü2 Äõ¸®ÀÇ Looping ó¸®. (Web)
»ç¿ë ¿¹# 6
- À¯Çü2 Äõ¸®ÀÇ Looping ó¸®. (NonUI)
»ç¿ë ¿¹# 7
- À¯Çü1 Äõ¸®ÀÇ auditÁ¤º¸
Âü°í : {name}-query.glue_sql
Âü°í : HTML Code
Âü°í : Java Code (Custom)
List
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 |
GlueJdbcModify
public GlueJdbcModify()
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 ÇÑ´Ù.
¿¹)
==> return "success"À̸é BizLogic Activity ¸¦ ½ÇÇàÇÔ.
Copyright © 2013–2016 POSCO ICT. All rights reserved.