Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java =================================================================== diff -u -rdd4ce97155dc52356cdd88e9c41fa50aaea72a84 -rb7d001cae3c47a72ac7063c1e046f8079affdc8f --- web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java (.../UserReqAddController.java) (revision dd4ce97155dc52356cdd88e9c41fa50aaea72a84) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java (.../UserReqAddController.java) (revision b7d001cae3c47a72ac7063c1e046f8079affdc8f) @@ -92,7 +92,7 @@ value = {"{changeReqTableName}/addNode.do"}, method = {RequestMethod.POST} ) - public ModelAndView addNode( + public ModelAndView addNode( @PathVariable(value ="changeReqTableName") String changeReqTableName, @Validated({AddNode.class}) ReqAddDTO reqAddDTO, BindingResult bindingResult, ModelMap model) throws Exception { @@ -118,7 +118,7 @@ value = {"/getTest.do"}, method = {RequestMethod.GET} ) - public ModelAndView getTest(V reqAddSqlMaaperDTO, HttpServletRequest request) throws Exception { + public ModelAndView getTest(ReqAddSqlMaaperDTO reqAddSqlMaaperDTO, HttpServletRequest request) throws Exception { ParameterParser parser = new ParameterParser(request); Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/model/ReqAddDTO.java =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -rb7d001cae3c47a72ac7063c1e046f8079affdc8f --- web-module/src/main/java/egovframework/api/arms/module_reqadd/model/ReqAddDTO.java (.../ReqAddDTO.java) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/model/ReqAddDTO.java (.../ReqAddDTO.java) (revision b7d001cae3c47a72ac7063c1e046f8079affdc8f) @@ -26,7 +26,7 @@ @DynamicInsert(value=true) @DynamicUpdate(value=true) @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) -@SequenceGenerator(name = "JsTreeSequence", sequenceName = "S_ARMS_REQADD", allocationSize = 1) +@SequenceGenerator(name = "JsTreeSequence", sequenceName = "S_T_ARMS_REQADD", allocationSize = 1) public class ReqAddDTO extends JsTreeHibernateSearchDTO implements Serializable { public ReqAddDTO() { @@ -39,7 +39,141 @@ } //@Getter @Setter + private Long c_pdService_Link; + @Column(name="C_PDSERVICE_LINK") + public Long getC_pdService_Link() { + return c_pdService_Link; + } + + public void setC_pdService_Link(Long c_pdService_Link) { + this.c_pdService_Link = c_pdService_Link; + } + + private String c_version_Link; + + @Column(name="C_VERSION_LINK") + public String getC_version_Link() { + return c_version_Link; + } + + public void setC_version_Link(String c_version_Link) { + this.c_version_Link = c_version_Link; + } + + private String c_reviewer01; + + @Column(name="C_REVIEWER01") + public String getC_reviewer01() { + return c_reviewer01; + } + + public void setC_reviewer01(String c_reviewer01) { + this.c_reviewer01 = c_reviewer01; + } + + private String c_reviewer02; + + @Column(name="C_REVIEWER02") + public String getC_reviewer02() { + return c_reviewer02; + } + + public void setC_reviewer02(String c_reviewer02) { + this.c_reviewer02 = c_reviewer02; + } + + private String c_reviewer03; + + @Column(name="C_REVIEWER03") + public String getC_reviewer03() { + return c_reviewer03; + } + + public void setC_reviewer03(String c_reviewer03) { + this.c_reviewer03 = c_reviewer03; + } + + private String c_reviewer04; + + @Column(name="C_REVIEWER04") + public String getC_reviewer04() { + return c_reviewer04; + } + + public void setC_reviewer04(String c_reviewer04) { + this.c_reviewer04 = c_reviewer04; + } + + private String c_reviewer05; + + @Column(name="C_REVIEWER05") + public String getC_reviewer05() { + return c_reviewer05; + } + + public void setC_reviewer05(String c_reviewer05) { + this.c_reviewer05 = c_reviewer05; + } + + private String c_writer_name; + + @Column(name="C_WRITER_NAME") + public String getC_writer_name() { + return c_writer_name; + } + + public void setC_writer_name(String c_writer_name) { + this.c_writer_name = c_writer_name; + } + + private String c_writer_cn; + + @Column(name="C_WRITER_CN") + public String getC_writer_cn() { + return c_writer_cn; + } + + public void setC_writer_cn(String c_writer_cn) { + this.c_writer_cn = c_writer_cn; + } + + private String c_writer_date; + + @Column(name="C_WRITER_DATE") + public String getC_writer_date() { + return c_writer_date; + } + + public void setC_writer_date(String c_writer_date) { + this.c_writer_date = c_writer_date; + } + + private Long c_priority; + + @Column(name="C_PRIORITY") + public Long getC_priority() { + return c_priority; + } + + public void setC_priority(Long c_priority) { + this.c_priority = c_priority; + } + + // 요구사항 제목은 c_title 로. + + private String c_contents; + + @Lob + @Column(name="C_CONTENTS") + public String getC_contents() { + return c_contents; + } + + public void setC_contents(String c_contents) { + this.c_contents = c_contents; + } + /* * Extend Bean Field */ Index: web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -rb7d001cae3c47a72ac7063c1e046f8079affdc8f --- web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml (.../moduleJSTF_SQL_Oracle_iBatis.xml) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml (.../moduleJSTF_SQL_Oracle_iBatis.xml) (revision b7d001cae3c47a72ac7063c1e046f8079affdc8f) @@ -14,6 +14,19 @@ C_LEVEL NUMBER NOT NULL, C_TITLE VARCHAR2(4000 BYTE), C_TYPE VARCHAR2(4000 BYTE), + + C_PDSERVICE_LINK NUMBER, + C_VERSION_LINK VARCHAR2(4000 BYTE), + C_REVIEWER01 VARCHAR2(4000 BYTE), + C_REVIEWER02 VARCHAR2(4000 BYTE), + C_REVIEWER03 VARCHAR2(4000 BYTE), + C_REVIEWER04 VARCHAR2(4000 BYTE), + C_REVIEWER05 VARCHAR2(4000 BYTE), + C_WRITER_NAME VARCHAR2(4000 BYTE), + C_WRITER_CN VARCHAR2(4000 BYTE), + C_WRITER_DATE VARCHAR2(4000 BYTE), + C_PRIORITY NUMBER, + C_CONTENTS CLOB, 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 @@ -95,7 +108,20 @@ C_TYPE VARCHAR2(4000 BYTE), C_METHOD VARCHAR2(4000 BYTE), C_STATE VARCHAR2(4000 BYTE), - C_DATE DATE NOT NULL + C_DATE DATE NOT NULL, + + C_PDSERVICE_LINK NUMBER, + C_VERSION_LINK VARCHAR2(4000 BYTE), + C_REVIEWER01 VARCHAR2(4000 BYTE), + C_REVIEWER02 VARCHAR2(4000 BYTE), + C_REVIEWER03 VARCHAR2(4000 BYTE), + C_REVIEWER04 VARCHAR2(4000 BYTE), + C_REVIEWER05 VARCHAR2(4000 BYTE), + C_WRITER_NAME VARCHAR2(4000 BYTE), + C_WRITER_CN VARCHAR2(4000 BYTE), + C_WRITER_DATE VARCHAR2(4000 BYTE), + C_PRIORITY NUMBER, + C_CONTENTS CLOB )