일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |
- Eclipse
- VirtualBox
- xargs
- import
- maVen
- Quartz
- port
- Windows
- 네트워크
- ssh
- Source
- GIT
- context
- 공통표준용어
- 단축키
- grep
- tomcat
- DB 도메인
- lsof
- Mac
- copy-dependencies
- resource
- JavaScript
- IntelliJ
- profile
- Windows 10
- netsh
- bash
- web.xml
- find
- Today
- Total
목록전체 글 (1649)
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
출처: http://stackoverflow.com/questions/6582034/ibatis-mybatis-select-dynamically-without-need-to-create-any-pojo-mapper select * from userselect * from user where id=#{value}select name from user // returns a list of mapsList test = sqlSession.selectList("test1"); // returns a single mapObject map = sqlSession.selectOne("test2", 0); // returns a list of stringsList names = sqlSession.selectList(..
selectOne1 row 리턴 selectListmulti row 리턴 selectMapit is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
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..