행정용어 사전이라는게 있어서
단어장을 만들 수 있다.
이것을 활용하면 단어장 만들기 쉽겠다. ㅋ
단어 목록조회
SELECT A.ADMINIST_WORD_ID, A.ADMINIST_WORD_NM, A.ADMINIST_WORD_ENG_NM, A.ADMINIST_WORD_ABRV_NM
ADMINIST_WORD_ABRV, A.THEMA_RELM, A.WORD_SE WORD_DOMN, A.RELATE_STD_WORD, A.ADMINIST_WORD_DFN,
A.ADMINIST_WORD_DC, A.FRST_REGISTER_ID, DATE_FORMAT(A.FRST_REGIST_PNTTM,'%Y-%m-%d') FRST_REGISTER_PNTTM,
(SELECT USER_NM FROM COMTNEMPLYRINFO WHERE ESNTL_ID = A.FRST_REGISTER_ID) FRST_REGISTER_NM
FROM COMTNADMINISTRATIONWORD A WHERE 1=1 ORDER BY A.FRST_REGIST_PNTTM DESC LIMIT 10 OFFSET
0
등록버튼 눌렀을 때
SELECT A.CNTC_ID, A.TEST_CLASS_NM, A.MNGR_NM, A.MNGR_EMAIL_ADRES, A.MNTRNG_STTUS, DATE_FORMAT(A.LAST_UPDT_PNTTM,
'%Y-%m-%d %H:%i:%S') AS LAST_UPDT_PNTTM, A.LAST_UPDUSR_ID, A.FRST_REGISTER_ID, DATE_FORMAT(A.FRST_REGIST_PNTTM,
'%Y-%m-%d %H:%i:%S') AS FRST_REGIST_PNTTM, DATE_FORMAT(A.CREAT_DT, '%Y-%m-%d %H:%i:%S') AS
CREAT_DT, B.CODE_NM MNTRNG_STTUS_NM, C.CNTC_NM, D.INSTT_NM PROVD_INSTT_NM, E.SYS_NM PROVD_SYS_NM,
F.SVC_NM PROVD_SVC_NM, G.INSTT_NM REQUST_INSTT_NM, H.SYS_NM REQUST_SYS_NM FROM COMTNTRSMRCVMNTRNG
A, COMTCCMMNDETAILCODE B, COMTNSYSTEMCNTC C, COMTNCNTCINSTT D, COMTNCNTCSYSTEM E, COMTNCNTCSERVICE
F, COMTNCNTCINSTT G, COMTNCNTCSYSTEM H WHERE B.CODE_ID = 'COM046' AND A.MNTRNG_STTUS = B.CODE
AND A.CNTC_ID = C.CNTC_ID AND D.INSTT_ID = C.PROVD_INSTT_ID AND E.INSTT_ID = C.PROVD_INSTT_ID
AND E.SYS_ID = C.PROVD_SYS_ID AND F.INSTT_ID = C.PROVD_INSTT_ID AND F.SYS_ID = C.PROVD_SYS_ID
AND F.SVC_ID = C.PROVD_SVC_ID AND G.INSTT_ID = C.REQUST_INSTT_ID AND H.INSTT_ID = C.REQUST_INSTT_ID
AND H.SYS_ID = C.REQUST_SYS_ID AND A.CNTC_ID = C.CNTC_ID ORDER BY A.CNTC_ID ASC LIMIT 10000
OFFSET 0
저장 버튼 눌렀을 때
[IDGeneration Service] key_table에 대한 10 ID의 새로운 블록을 할당 ADMINIST_WORD_ID.
SELECT next_id FROM COMTECOPSEQ WHERE table_name = ?
2018-09-30 12:51:08,783 INFO [jdbc.sqltiming] SELECT next_id FROM COMTECOPSEQ WHERE table_name = 'ADMINIST_WORD_ID'
UPDATE COMTECOPSEQ SET next_id = 11 WHERE table_name = 'ADMINIST_WORD_ID'
INSERT INTO COMTNADMINISTRATIONWORD ( ADMINIST_WORD_ID, ADMINIST_WORD_NM, ADMINIST_WORD_ENG_NM,
ADMINIST_WORD_ABRV_NM, THEMA_RELM, WORD_SE, RELATE_STD_WORD, ADMINIST_WORD_DFN, ADMINIST_WORD_DC,
FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID )VALUES( 'ADMINIST_00000000001',
'사무실', 'Office', 'office', '장소', '1', '사무실', '행정전문용어정의', '행정전문용어설명', sysdate(), 'USRCNFRM_00000000000',
sysdate(), 'USRCNFRM_00000000000' )
-- 목록조회
SELECT A.ADMINIST_WORD_ID, A.ADMINIST_WORD_NM, A.ADMINIST_WORD_ENG_NM, A.ADMINIST_WORD_ABRV_NM
ADMINIST_WORD_ABRV, A.THEMA_RELM, A.WORD_SE WORD_DOMN, A.RELATE_STD_WORD, A.ADMINIST_WORD_DFN,
A.ADMINIST_WORD_DC, A.FRST_REGISTER_ID, DATE_FORMAT(A.FRST_REGIST_PNTTM,'%Y-%m-%d') FRST_REGISTER_PNTTM,
(SELECT USER_NM FROM COMTNEMPLYRINFO WHERE ESNTL_ID = A.FRST_REGISTER_ID) FRST_REGISTER_NM
FROM COMTNADMINISTRATIONWORD A WHERE 1=1 ORDER BY A.FRST_REGIST_PNTTM DESC LIMIT 10 OFFSET
0
