dlqorgod
386
2017-03-18 11:33:01
0
1753

업무사용자정보 저장 테스트하기


godsoft 2017-03-18 업무사용자정보 저장 테스트하기

07 업무사용자 생성

  

작성자: 이백행<dlqorgod@naver.com>

작성일: 2017-03-18

  

일반로그인

http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:com:v2:uat:%EC%9D%BC%EB%B0%98%EB%A1%9C%EA%B7%B8%EC%9D%B8

  

업무사용자 COMTNEMPLYRINFO 업무사용자 정보를 관리한다.

  

COMTNEMPLYRINFO COM_TN_EMPLYR_INFO EMPLYR_INFO

  


Project name: godsoft.test20170318-uat

  


로그인 > 일반로그인

  


로그인 > 일반로그인

  

테이블 삭제

drop table "US_GODCOM351OBJ"."COMTCCMMNCLCODE" 

  

계단식 제약 조건

drop table "US_GODCOM351OBJ"."COMTCCMMNCLCODE" cascade constraints 

  

계단식 제약 조건, 비우기

drop table "US_GODCOM351OBJ"."COMTCCMMNCLCODE" cascade constraints PURGE

  

딕셔너리 조회

D:\eGovFrameDev-3.5.1-64bit\workspace-github\GodTest2016\godsoft.test20170318-uat\src\script2\oracle\dic

ALL_TABLES_V0.1_201318.sql

  

oracle dictionary view 검색

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables014.htm#ADMIN01508

  

ALL_TABLES

  

D:\eGovFrameDev-3.5.1-64bit\workspace-github\GodTest2016\godsoft.test20170318-uat\src\script2\oracle\dic

ALL_TABLES_V0.1_201318.sql

  


환경설정 > 코드 편집기 > 글꼴 > 글꼴 크기: 24

  

  

  

테이블 생성 create

D:\eGovFrameDev-3.5.1-64bit\workspace-github\GodTest2016\godsoft.test20170318-uat\src\script\oracle\ddl

uat.uia_create_oracle.sql

  

테이블 insert

D:\eGovFrameDev-3.5.1-64bit\workspace-github\GodTest2016\godsoft.test20170318-uat\src\script\oracle\dml

uat.uia_insert_oracle.sql

  

테이블 코멘트

http://www.egovframe.go.kr/cop/bbs/selectBoardArticle.do?nttId=1033&bbsId=BBSMSTR_000000000003&menu=7

공통컴포넌트 3.5.0 ERD 파일

COM_ERD v2.0.0.erwin [2,073,528 byte]

  

사용자지원 > 업무사용자정보

  

물리 이동 > 

  

%ForEachTable() {

  

COMMENT ON TABLE %TableName IS '%EntityName';

  

%ForEachColumn() {

COMMENT ON COLUMN %TableName.%ColName IS '%AttName';

}

  

}

  

CRUD 프로그램 자동 생성 기능

http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:dev2:imp:codegen:template:crud

  

COMTNEMPLYRINFO, comtnemplyrinfo

  

Author : 이백행<dlqorgod@naver.com>

Create Date : 2017-03-18

  

DataAccess

Create DataAccess: 체크

Resource(SQLMap) Folder: src/main/resources/godsoft/sqlmap/test/crud

DAO Package: godsoft.test.curd.comtnemplyrinfo.service.impl

VO Package: godsoft.test.curd.comtnemplyrinfo.service

  

Service

Create Service: 체크

Service Package: godsoft.test.curd.comtnemplyrinfo.service

Service Impl Package: godsoft.test.curd.comtnemplyrinfo.service.impl

  

Web

Create Web: 체크

Controller Package: godsoft.test.curd.comtnemplyrinfo.web

JSP Folder: src/main/webapp/WEB-INF/jsp/godsoft/test/crud


  


  

테스트 케이스 생성

  

@RunWith(SpringJUnit4ClassRunner.class)

  

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [godsoft.test.curd.comtnemplyrinfo.service.impl.ComtnemplyrinfoDAO] found for dependency: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}

  

/godsoft.test20170318-uat/src/main/resources/egovframework/spring/com/context-common.xml

<context:component-scan base-package="egovframework, godsoft">

  

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'sqlMapClient' is defined

  

/godsoft.test20170318-uat/src/main/resources/egovframework/egovProps/globals.properties

  

/godsoft.test20170318-uat/src/main/java/godsoft/test/curd/comtnemplyrinfo/service/impl/ComtnemplyrinfoDAO.java

public class ComtnemplyrinfoDAO extends EgovComAbstractDAO {

  

comtnemplyrinfoDAO : godsoft.test.curd.comtnemplyrinfo.service.impl.ComtnemplyrinfoDAO@30b0e8ae

  

There is no statement named comtnemplyrinfoDAO.insertComtnemplyrinfo_S in this SqlMap.

  

/godsoft.test20170318-uat/src/main/resources/godsoft/sqlmap/config/oracle/sql-map-config-oracle-uat-uia.xml

  

ibatis dtd 검색

http://storing.tistory.com/105

  

ibatis.apache.org

  

/godsoft.test20170318-uat/src/main/resources/egovframework/spring/com/context-sqlMap.xml

<value>classpath:/godsoft/sqlmap/config/${Globals.DbType}/*.xml</value>

  

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

  

/godsoft.test20170318-uat/pom.xml

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-test</artifactId>

<version>${spring.maven.artifact.version}</version>

</dependency>

  

<dependency>

<groupId>ojdbc</groupId>

<artifactId>ojdbc</artifactId>

<version>6</version>

</dependency>

  

D:\eGovFrameDev-3.5.1-64bit\workspace-github\GodTest2016\godsoft.test20170318-uat\src\script2\oracle\dml

COMTECOPSEQ_V0.1_20170318.sql


http://blog.naver.com/dlqorgod/220961022156




0
  • 댓글 0

  • 로그인을 하시면 댓글 을 등록할 수 있습니다.