Index: core-module/pom.xml =================================================================== diff -u -rc8a9e5fcc948be14411b35898998951792029080 -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/pom.xml (.../pom.xml) (revision c8a9e5fcc948be14411b35898998951792029080) +++ core-module/pom.xml (.../pom.xml) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -7,7 +7,7 @@ 313devgrp java-service-tree-framework-core-library - 22.12.06 + 22.12.07 ../pom.xml @@ -31,7 +31,7 @@ 313devgrp lib-module - 22.12.06 + 22.12.07 pom Index: core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/controller/CoreController.java =================================================================== diff -u -r085c7685610b32da87d43577e26d614fb864286e -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/controller/CoreController.java (.../CoreController.java) (revision 085c7685610b32da87d43577e26d614fb864286e) +++ core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/controller/CoreController.java (.../CoreController.java) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -35,30 +35,6 @@ private final Logger logger = LoggerFactory.getLogger(this.getClass()); @ResponseBody - @RequestMapping(value="/ddlExecute.do", method=RequestMethod.GET) - public ModelAndView ddlExecute(ComprehensiveTree comprehensiveTree, ModelMap model, - HttpServletRequest request) throws Exception { - - logger.info("CoreController :: ddlExecute :: tableName = " + comprehensiveTree.getC_title()); - coreService.ddlExecuteWithJSTF(comprehensiveTree); - ModelAndView modelAndView = new ModelAndView("jsonView"); - modelAndView.addObject("result", "good"); - return modelAndView; - } - - @ResponseBody - @RequestMapping(value="/dmlExecute.do", method=RequestMethod.GET) - public ModelAndView dmlExecute(ComprehensiveTree comprehensiveTree, ModelMap model, - HttpServletRequest request) throws Exception { - - logger.info("CoreController :: dmlExecute :: tableName = " + comprehensiveTree.getC_title()); - coreService.dmlExecuteWithJSTF(comprehensiveTree); - ModelAndView modelAndView = new ModelAndView("jsonView"); - modelAndView.addObject("result", "good"); - return modelAndView; - } - - @ResponseBody @RequestMapping(value="/getChildNode.do", method=RequestMethod.GET) public ModelAndView getChildNode(ComprehensiveTree comprehensiveTree, ModelMap model, HttpServletRequest request) throws Exception { Index: core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDao.java =================================================================== diff -u -r085c7685610b32da87d43577e26d614fb864286e -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDao.java (.../CoreDao.java) (revision 085c7685610b32da87d43577e26d614fb864286e) +++ core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDao.java (.../CoreDao.java) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -6,9 +6,6 @@ public interface CoreDao { - public void ddlExecute(T comprehensiveTree) throws Exception; - public void dmlExecute(T comprehensiveTree) throws Exception; - public List getChildNode(T comprehensiveTree) throws Exception; public List searchNodeByString(T comprehensiveTree) throws Exception; Index: core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDaoImpl.java =================================================================== diff -u -rfc720cc6fd25edf992b27bf852cf694c532b0032 -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDaoImpl.java (.../CoreDaoImpl.java) (revision fc720cc6fd25edf992b27bf852cf694c532b0032) +++ core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/dao/CoreDaoImpl.java (.../CoreDaoImpl.java) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -14,27 +14,6 @@ @Qualifier("CoreDao") public class CoreDaoImpl extends EgovComiBatisAbstractDAO implements CoreDao{ - public void ddlExecute(T comprehensiveTree) throws Exception { - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_1", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_2", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_3", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_4", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_5", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_6", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_7", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_8", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlExecute_comment_9", comprehensiveTree); - - } - - public void dmlExecute(T comprehensiveTree) throws Exception { - update(comprehensiveTree.getSqlMapSelector() + "." + "dmlExecute_1", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "dmlExecute_2", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "dmlExecute_3", comprehensiveTree); - update(comprehensiveTree.getSqlMapSelector() + "." + "dmlExecute_4", comprehensiveTree); - } - @SuppressWarnings("unchecked") public List getChildNode( T comprehensiveTree ) throws Exception{ Index: core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreService.java =================================================================== diff -u -r085c7685610b32da87d43577e26d614fb864286e -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreService.java (.../CoreService.java) (revision 085c7685610b32da87d43577e26d614fb864286e) +++ core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreService.java (.../CoreService.java) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -8,10 +8,6 @@ public interface CoreService { - public void ddlExecuteWithJSTF(T comprehensiveTree) throws Exception; - - public void dmlExecuteWithJSTF(T comprehensiveTree) throws Exception; - public T getNode(T comprehensiveTree) throws Exception; public List getChildNode(T comprehensiveTree) throws Exception; Index: core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreServiceImpl.java =================================================================== diff -u -r085c7685610b32da87d43577e26d614fb864286e -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreServiceImpl.java (.../CoreServiceImpl.java) (revision 085c7685610b32da87d43577e26d614fb864286e) +++ core-module/src/main/java/egovframework/com/ext/jstree/springiBatis/core/service/CoreServiceImpl.java (.../CoreServiceImpl.java) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -29,17 +29,6 @@ @Resource(name = "CoreDao") private CoreDao coreDao; - @Override - public void ddlExecuteWithJSTF(T comprehensiveTree) throws Exception { - coreDao.ddlExecute(comprehensiveTree); - } - - @Override - @Transactional(readOnly = false, rollbackFor = { Exception.class }, propagation = Propagation.REQUIRED) - public void dmlExecuteWithJSTF(T comprehensiveTree) throws Exception { - coreDao.dmlExecute(comprehensiveTree); - } - public T getNode(T comprehensiveTree) throws Exception { T getNode = ((T) coreDao.getNode(comprehensiveTree)); return getNode; Index: core-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml =================================================================== diff -u -r8488c3c64d5e6e990e19de95aee1ca3355cad430 -r21e895f74b6f8da382b881044d11165fece6dc41 --- core-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (.../jstreeCoreManage_SQL_Oracle_iBatis.xml) (revision 8488c3c64d5e6e990e19de95aee1ca3355cad430) +++ core-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (.../jstreeCoreManage_SQL_Oracle_iBatis.xml) (revision 21e895f74b6f8da382b881044d11165fece6dc41) @@ -38,66 +38,6 @@ ORDER BY A.C_POSITION ASC - - CREATE TABLE $c_title$( - C_ID NUMBER NOT NULL, - C_PARENTID NUMBER NOT NULL, - C_POSITION NUMBER NOT NULL, - C_LEFT NUMBER NOT NULL, - C_RIGHT NUMBER NOT NULL, - C_LEVEL NUMBER NOT NULL, - C_TITLE VARCHAR2(4000 BYTE), - C_TYPE VARCHAR2(4000 BYTE), - CONSTRAINT $c_title$_PK PRIMARY KEY (C_ID) - /* - * CONSTRAINT T_ARMS_REQADD_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_ARMS_REQADD(C_ID) ON DELETE CASCADE - */) - - - COMMENT ON TABLE $c_title$ IS '기본 트리 스키마' - - - COMMENT ON COLUMN $c_title$.C_ID IS '노드 아이디' - - - COMMENT ON COLUMN $c_title$.C_PARENTID IS '부모 노드 아이디' - - - COMMENT ON COLUMN $c_title$.C_POSITION IS '노드 포지션' - - - COMMENT ON COLUMN $c_title$.C_LEFT IS '노드 좌측 끝 포인트' - - - COMMENT ON COLUMN $c_title$.C_RIGHT IS '노드 우측 끝 포인트' - - - COMMENT ON COLUMN $c_title$.C_LEVEL IS '노드 DEPTH ' - - - COMMENT ON COLUMN $c_title$.C_TITLE IS '노드 명' - - - COMMENT ON COLUMN $c_title$.C_TYPE IS '노드 타입' - - - - Insert into $c_title$ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE) - Values (1, 0, 0, 1, 8, 0, 'Root Node', 'root') - - - Insert into $c_title$ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE) - Values (2, 1, 0, 2, 7, 1, 'First Child', 'drive') - - - Insert into $c_title$ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE) - Values (3, 2, 0, 3, 4, 2, 'Leaf Node', 'default') - - - Insert into $c_title$ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE) - Values (4, 2, 1, 5, 6, 2, 'Branch Node', 'folder') - -