develog

type 1----------------------------------------------------------for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) { Row row = rit.next(); for (Iterator cit = row.cellIterator(); cit.hasNext(); ) { Cell cell = cit.next(); System.out.print(cell + "\t"); } System.out.println();} type 2---------------------------------------------------------- for (Row row : sheet) { for (Cell cell : row) { ..

private static void jdbcTest() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SID", username, password); DatabaseMetaData metaData = conn.getMetaData(); System.out.println(metaData.getDatabaseProductVersion()); System.out.println(metaData.getDriverName()); System.out.println(metaData.getDriverVersion()); }..

Java------------------------------------- public static void exceptionTest() { System.out.println("1"); try { System.out.println("2"); throwException(); // 예외발생! System.out.println("3"); } catch (Exception e) { System.out.println("4"); } finally { System.out.println("5"); } System.out.println("6");} 결과-------------------------------------12456

Java----------------------------------------------------------------public void testProc(SqlSession session) throws SQLException { HashMap param = new HashMap(); param.put("param1", "aa"); param.put("param2", "cc"); param.put("resultCd", ""); param.put("resultMsg", ""); session.selectOne("UserStatOld.testProc", param); System.out.println("resultCd : " + param.get("resultCd")); System.out.println..

Java----------------------------------------------------------------public void testProc(SqlSession session) throws SQLException { ProcVo vo = new ProcVo(); vo.setParam1("11"); vo.setParam2("bb"); session.update("UserStatOld.testProc", vo); System.out.println("resultCd : " + vo.getResultCd()); System.out.println("resultMsg : " + vo.getResultMsg());} Vo--------------------------------------------..

● ibatisSELECT * FROM TB_TEMP WHERE 1=1AND USER_ID = #USER_ID# ● mybatisSELECT * FROM TB_TEMP WHERE 1=1AND USER_ID = #{USER_ID}