develog

--트리거 생성CREATE OR REPLACE TRIGGER ATEST_TRIGGERBEFORE INSERT OR UPDATE OR DELETE ON ATESTREFERENCING OLD AS O NEW AS NFOR EACH ROWDECLARE BEGIN IF INSERTING THEN INSERT INTO ATEST_LOG (SEQ, TITLE, NOTE, USE_YN, REG_TS, MOD_TS, LOG_TS, LOG_TYPE) VALUES (:O.SEQ, :O.TITLE, :O.NOTE, :O.USE_YN, :O.REG_TS, :O.MOD_TS, SYSTIMESTAMP, 'I'); END IF; IF UPDATING THEN INSERT INTO ATEST_LOG (SEQ, TITLE, NOTE,..

test.xml--------------------------------------------------------------------------XML1홍길동100고길동200200김철수300300이영희400400 XmlTest.java--------------------------------------------------------------------------import java.io.File; import javax.xml.parsers.DocumentBuilder;import javax.xml.parsers.DocumentBuilderFactory;import javax.xml.transform.Transformer;import javax.xml.transform.TransformerFacto..

import java.math.BigInteger; import javax.crypto.Cipher;import javax.crypto.KeyGenerator;import javax.crypto.SecretKey;import javax.crypto.spec.SecretKeySpec; public class AES {public static void main(String[] args) throws Exception {AES main = new AES();SecretKey key = main.generateSecretKey();String message = "암호화 테스트";System.out.println("암호전 : " + message);String encrypted = main.encrypt(mess..

/*여러 개의 row를한 개 row, column 으로 변환*/ SELECT WMSYS.WM_CONCAT(A.COL1) RET_VALFROM ( SELECT 'A' COL1 FROM DUAL UNION ALL SELECT 'B' COL1 FROM DUAL UNION ALL SELECT 'C' COL1 FROM DUAL UNION ALL SELECT 'D' COL1 FROM DUAL UNION ALL SELECT 'E' COL1 FROM DUAL) A; --RET_VAL => A,B,C,D,E

import java.io.FileOutputStream; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.util.CellReference; import org.apache.poi.xssf.streaming.SXSSFWorkbook; public class TestMain { public static void main(String[] args) throws Throwable { Workbook wb = new ..

private void test() {try {ApplicationContext context = new ClassPathXmlApplicationContext("classpath:spring-config.xml");Service service = (Service) context.getBean("service");JobDataMap jobDataMap = new JobDataMap();jobDataMap.put("service", service);JobDetail jobDetail = new JobDetail("job1", "group1", JobB.class);jobDetail.setJobDataMap(jobDataMap);CronTrigger cronTrigger = new CronTrigger("c..