07 업무사용자 생성
작성자: 이백행<dlqorgod@naver.com>
작성일: 2017-03-18
일반로그인
업무사용자 COMTNEMPLYRINFO 업무사용자 정보를 관리한다.
COMTNEMPLYRINFO COM_TN_EMPLYR_INFO EMPLYR_INFO
Project name: godsoft.test20170318-uat
Commit message: 일반로그인
Repository https://github.com/LeeBaekHaeng/GodTest2016.git
https://github.com/LeeBaekHaeng/GodTest2016/tree/master/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
테이블 코멘트
공통컴포넌트 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