log4jdbc mix

log4jdbc와 결합해서 쓰면 좋은 것 - log4jdbc mix

select 결과가 실감나게 나온다.

 

 <logger name="jdbc.resultsettable" additivity="false">  
    <level value="info" />  
    <appender-ref ref="console-log4jdbc" />  
  </logger>

 

select * 
        from EMP 
|------|-------|----------|-----|----------------------|-----|-----|-------| 
|EMPNO |ENAME  |JOB       |MGR  |HIREDATE              |SAL  |COMM |DEPTNO | 
|------|-------|----------|-----|----------------------|-----|-----|-------| 
|7369  |SMITH  |CLERK     |7902 |1980-12-17 00:00:00.0 |800  |null |20     | 
|7499  |ALLEN  |SALESMAN  |7698 |1981-02-20 00:00:00.0 |1600 |300  |30     | 
|7521  |WARD   |SALESMAN  |7698 |1981-02-22 00:00:00.0 |1250 |500  |30     | 
|7566  |JONES  |MANAGER   |7839 |1981-04-02 00:00:00.0 |2975 |null |20     | 
|7654  |MARTIN |SALESMAN  |7698 |1981-09-28 00:00:00.0 |1250 |1400 |30     | 
|7698  |BLAKE  |MANAGER   |7839 |1981-05-01 00:00:00.0 |2850 |null |30     | 
|7782  |CLARK  |MANAGER   |7839 |1981-06-09 00:00:00.0 |2450 |null |10     | 
|7788  |SCOTT  |ANALYST   |7566 |1987-04-19 00:00:00.0 |3000 |null |20     | 
|7839  |KING   |PRESIDENT |null |1981-11-17 00:00:00.0 |5000 |null |10     | 
|7844  |TURNER |SALESMAN  |7698 |1981-09-08 00:00:00.0 |1500 |0    |30     | 
|7876  |ADAMS  |CLERK     |7788 |1987-05-23 00:00:00.0 |1100 |null |20     | 
|7900  |JAMES  |CLERK     |7698 |1981-12-03 00:00:00.0 |950  |null |30     | 
|7902  |FORD   |ANALYST   |7566 |1981-12-03 00:00:00.0 |3000 |null |20     | 
|7934  |MILLER |CLERK     |7782 |1982-01-23 00:00:00.0 |1300 |null |10     | 
|------|-------|----------|-----|----------------------|-----|-----|-------|

 

 

http://code.google.com/p/log4jdbc-remix/

 

http://beyondj2ee.tumblr.com/post/14507640070/spring-powerful-sql