도담도담

myBatis 콘솔 출력 결과에 대한 설명 본문

IT 공부/KH 정보교육원

myBatis 콘솔 출력 결과에 대한 설명

Zinisang 2021. 6. 29. 23:14

결과 화면(콘솔)

각 결과물과 연관된 내용들


// ibatis-core 라이브러리 => myBatis 프레임워크

14:19:56.380 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.

 

// PooledDataSource => <dataSource type="POOLED">

14:19:56.533 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.

14:19:56.533 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.

14:19:56.533 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.

14:19:56.533 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.

 

// BoardDAO.java => public void insertBoard(BoardVO vo) { System.out.println(vo.toString()); ~~}

BoardVO [seq=0, title=myBaits 제목, writer=홍길동, content=myBatis 내용입니다....., regDate=null, cnt=0, searchCondition=null, searchKeyword=null]

 

// sql-map-config.xml => <transactionManager type="JDBC" />

14:19:56.592 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection

 

// PooledDataSource => <dataSource type="POOLED">

14:19:56.937 [main] DEBUG o.a.i.d.pooled.PooledDataSource - Created connection 1218593486.

 

//  JDBC Connection 와 <property name="driver" value="${jdbc.driverClassName}" />

14:19:56.937 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [oracle.jdbc.driver.T4CConnection@48a242ce]

 

// BoardDAO.java => public void insertBoard(BoardVO vo) { ~~ mybatis.insert("BoardDAO.insertBoard", vo); }

// "BoardDAO.insertBoard" => board-mapping.xml  => <insert id="insertBoard">

14:19:56.938 [main] DEBUG BoardDAO.insertBoard - ==>  Preparing: insert into board (seq, title, writer, content) values ((select nvl(max(seq), 0)+1 from board),?,?,?) 

 

// BoardVO vo => myBaits 제목(String), 홍길동(String), myBatis 내용입니다.....(String)

14:19:57.014 [main] DEBUG BoardDAO.insertBoard - ==> Parameters: myBaits 제목(String), 홍길동(String), myBatis 내용입니다.....(String)

 

// BoardDAO.java => public void insertBoard(BoardVO vo) { ~~ mybatis.insert("BoardDAO.insertBoard", vo);  mybatis.commit(); }

14:19:57.018 [main] DEBUG BoardDAO.insertBoard - <==    Updates: 1


//  BoardDAO.java => public List<BoardVO> getBoardList(BoardVO vo) { mybatis.selectList("BoardDAO.getBoardList", vo); }
// "BoardDAO.getBoardList" => board-mapping.xml  => <select id="getBoardList" resultType="board">

14:19:57.019 [main] DEBUG BoardDAO.getBoardList - ==>  Preparing: select * from board where title like '%'||?||'%'order by seq desc 

 

// vo.setSearchKeyword("");

14:19:57.019 [main] DEBUG BoardDAO.getBoardList - ==> Parameters: (String)

 

//  board-mapping.xml  => <select id="getBoardList" resultType="board">
// List<BoardVO> boardList = boardDAO.getBoardList(vo);

14:19:57.089 [main] DEBUG BoardDAO.getBoardList - <==      Total: 19

 

// for (BoardVO board : boardList) {
//     System.out.println("---> " + board.toString());
// }

---> BoardVO [seq=40, title=myBaits 제목, writer=홍길동, content=myBatis 내용입니다....., regDate=Tue Jun 29 14:19:57 KST 2021, cnt=0, searchCondition=null, searchKeyword=null]

---> BoardVO [seq=39, title=Mapper XML 제목, writer=Mapper, content=Mapper XML 내용입니다....., regDate=Mon Jun 28 16:52:33 KST 2021, cnt=0, searchCondition=null, searchKeyword=null]

---> BoardVO [seq=38, title=myBaits 제목, writer=홍길동, content=myBatis 내용입니다....., regDate=Mon Jun 28 16:48:26 KST 2021, cnt=0, searchCondition=null, searchKeyword=null]

---> BoardVO [seq=37, title=ㅂㅈㅂㅈ, writer=ㅂㅈㅂㅈ, content=ㅂㅈㅂㅈ, regDate=Mon Jun 28 12:04:03 KST 2021, cnt=0, searchCondition=null, searchKeyword=null]

 중략~~~

'IT 공부 > KH 정보교육원' 카테고리의 다른 글

Spring에서 패키지별 역할  (0) 2021.06.30
Spring + myBatis 연동하기  (0) 2021.06.29
myBatis  (0) 2021.06.29
프레젠테이션, 비지니스 레이어 통합  (0) 2021.06.28
Spring MVC를 이용한 구현  (0) 2021.06.23
Comments