log4j 설정

FileName: log4j.properties

log4j.rootLogger=INFO, stdout, rolling
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n
log4j.appender.rolling=org.apache.log4j.DailyRollingFileAppender
log4j.appender.rolling.File=E:/workspace/distBoard/study.log
log4j.appender.rolling.Append=false
log4j.appender.rolling.DatePattern='.'yyyy-MM-dd
log4j.appender.rolling.layout=org.apache.log4j.PatternLayout
log4j.appender.rolling.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
#log4j.logger.java.sql.ResultSet=DEBUG



FileName: BoardView.java

.........
import org.apache.log4j.Logger;
.........

public class BoardView extends Action  {
............
    static Logger log = Logger.getLogger("BoardView.class");
    log.info("pageNo : " + boardForm.getPageNo());
............

Console:

...............
 2011-01-10 13:10:18,218 INFO  [http1-w06 [container1-16]] BoardView.class   (BoardView.java:40)     - pageNo : 1
 2011-01-10 13:10:18,218 DEBUG [http1-w06 [container1-16]] sql.Connection    (JakartaCommonsLoggingImpl.java:27)     - {conn-100016} Connection
 2011-01-10 13:10:18,234 DEBUG [http1-w06 [container1-16]] sql.PreparedStatement (JakartaCommonsLoggingImpl.java:27)     - {pstm-100017} Executing Statement:

        SELECT j.* FROM (
                SELECT k.*, ROWNUM rnum FROM(
                        SELECT
                                NUM,
                                NAME,
                                EMAIL,
                                TITLE,
                                CONTENTS AS content,
                                CRE_DATE
                        FROM STUDY_BOARD
                        ORDER BY NUM DESC
                ) k
        ) j
        WHERE j.rnum BETWEEN '1' AND '10'