1、maven安装依赖

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>org.wlj</groupId>

    <artifactId>project-name</artifactId>

    <packaging>war</packaging>

    <version>1.0.0</version>

    <name>project-name</name>

    <url>http://maven.apache.org</url>

    <properties>

        <!-- spring版本号 -->

        <spring.version>4.0.9.RELEASE</spring.version>

        <!-- mybatis版本号 -->

        <mybatis.version>3.2.8</mybatis.version>

        <!-- log4j日志文件管理包版本 -->

        <slf4j.version>1.7.12</slf4j.version>

        <log4j.version>1.2.17</log4j.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>junit</groupId>

            <artifactId>junit</artifactId>

            <version>4.10</version>

            <scope>test</scope>

        </dependency>

        <!-- spring -->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-core</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-beans</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-web</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-oxm</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-tx</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jdbc</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-webmvc</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-aop</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context-support</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-expression</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-aspects</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-orm</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-test</artifactId>

            <version>${spring.version}</version>

            <scope>test</scope>

        </dependency>

        <!-- mybatis -->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>${mybatis.version}</version>

        </dependency>

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId>

            <version>1.2.2</version>

        </dependency>

        <!-- 导入javaee -->

        <dependency>

            <groupId>javax</groupId>

            <artifactId>javaee-api</artifactId>

            <version>7.0</version>

            <scope>provided</scope>

            <exclusions>

                <exclusion>

                    <groupId>com.sun.mail</groupId>

                    <artifactId>javax.mail</artifactId>

                </exclusion>

            </exclusions>

        </dependency>

        <dependency>

            <groupId>javax.servlet</groupId>

            <artifactId>jstl</artifactId>

            <version>1.2</version>

            <scope>provided</scope>

        </dependency>

        <!-- database -->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.30</version>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>c3p0</groupId>

            <artifactId>c3p0</artifactId>

            <version>0.9.1.2</version>

        </dependency>

        <!-- logger -->

        <dependency>

            <groupId>commons-logging</groupId>

            <artifactId>commons-logging</artifactId>

            <version>1.2</version>

        </dependency>

        <dependency>

            <groupId>log4j</groupId>

            <artifactId>log4j</artifactId>

            <version>${log4j.version}</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <version>${slf4j.version}</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-log4j12</artifactId>

            <version>${slf4j.version}</version>

        </dependency>

        <dependency>

            <groupId>org.lazyluke</groupId>

            <artifactId>log4jdbc-remix</artifactId>

            <version>0.2.7</version>

        </dependency>

        <!-- jackson -->

        <dependency>

            <groupId>org.codehaus.jackson</groupId>

            <artifactId>jackson-mapper-asl</artifactId>

            <version>1.9.13</version>

        </dependency>

        <dependency>

            <groupId>org.codehaus.jackson</groupId>

            <artifactId>jackson-core-asl</artifactId>

            <version>1.9.13</version>

        </dependency>

        <!-- commons -->

        <dependency>

            <groupId>commons-fileupload</groupId>

            <artifactId>commons-fileupload</artifactId>

            <version>1.3.1</version>

        </dependency>

        <dependency>

            <groupId>commons-io</groupId>

            <artifactId>commons-io</artifactId>

            <version>2.4</version>

        </dependency>

        <dependency>

            <groupId>commons-codec</groupId>

            <artifactId>commons-codec</artifactId>

            <version>1.9</version>

        </dependency>

        <dependency>

            <groupId>commons-lang</groupId>

            <artifactId>commons-lang</artifactId>

            <version>2.6</version>

        </dependency>

        <!-- HttpClent -->

        <dependency>

            <groupId>commons-httpclient</groupId>

            <artifactId>commons-httpclient</artifactId>

            <version>3.1</version>

        </dependency>

        <!-- aspectj -->

        <dependency>

            <groupId>org.aspectj</groupId>

            <artifactId>aspectjweaver</artifactId>

            <version>1.8.5</version>

        </dependency>

        <dependency>

            <groupId>org.aspectj</groupId>

            <artifactId>aspectjrt</artifactId>

            <version>1.8.5</version>

        </dependency>

        <dependency>

            <groupId>aopalliance</groupId>

            <artifactId>aopalliance</artifactId>

            <version>1.0</version>

        </dependency>

        <!-- jsr349 -->

        <dependency>

            <groupId>org.hibernate</groupId>

            <artifactId>hibernate-validator</artifactId>

            <version>5.1.3.Final</version>

        </dependency>

        <dependency>

            <groupId>javax.el</groupId>

            <artifactId>javax.el-api</artifactId>

            <version>3.0.0</version>

        </dependency>

    </dependencies>

    <repositories>

        <repository>

            <id>center</id>

            <name>center custom nexus</name>

            <url>http://192.168.1.60:8081/nexus/content/groups/public/</url>

            <releases>

                <enabled>true</enabled>

                <updatePolicy>never</updatePolicy>

            </releases>

            <snapshots>

                <enabled>true</enabled>

                <updatePolicy>never</updatePolicy>

            </snapshots>

        </repository>

    </repositories>

    <distributionManagement>

        <repository>

            <id>releases server</id>

            <name>center custom nexus</name>

            <url>http://192.168.1.60:8081/nexus/content/repositories/releases/</url>

        </repository>

        <snapshotRepository>

            <id>center</id>

            <name>center custom nexus</name>

            <url>http://192.168.1.60:8081/nexus/content/repositories/snapshots/</url>

        </snapshotRepository>

    </distributionManagement>

    <build>

        <finalName>project-name</finalName>

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-compiler-plugin</artifactId>

                <version>3.3</version>

                <configuration>

                    <source>1.7</source>

                    <target>1.7</target>

                    <encoding>UTF-8</encoding>

                </configuration>

            </plugin>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-surefire-plugin</artifactId>

                <version>2.17</version>

                <configuration>

                    <skipTests>false</skipTests>

                    <includes>

                        <include>**/*Test.java</include>

                    </includes>

                    <excludes>

                        <exclude>**/Test*.java</exclude>

                    </excludes>

                </configuration>

            </plugin>

            <plugin>

                <groupId>org.apache.tomcat.maven</groupId>

                <artifactId>tomcat7-maven-plugin</artifactId>

                <version>2.2</version>

            </plugin>

        </plugins>

    </build>

</project>

2、jdbc.properties的配置

jdbc.driverClassName=net.sf.log4jdbc.DriverSpy
jdbc.url=jdbc:log4jdbc:mysql://localhost:3306/xdptest?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true

jdbc.username=root

jdbc.password=root

3、spring中的配置：

<bean id="dataSourceSpied" class="...">

    <property name="driverClass" value="${jdbc.driverClassName}"/>

    <property name="jdbcUrl" value="${jdbc.url}"/>

    <property name="user" value="${jdbc.username}"/>

    <property name="password" value="${jdbc.password}"/>

    ...

  </bean>

 <!-- 注意：其它引用（如事务管理配置），用dataSource，而不是dataSourceSpied -->

  <bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">

    <constructor-arg ref="dataSourceSpied" />

  </bean>

也可以格式化一下sql输出，配置如下：

<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">

    <constructor-arg ref="dataSourceSpied" />

    <property name="logFormatter">

      <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">

        <property name="loggingType" value="MULTI_LINE" />

        <property name="margin" value="19" />

        <property name="sqlPrefix" value="SQL:::" />

      </bean>

    </property>

  </bean>

4、log4j.properties配置：

##-------------log4jdbc 配置方式示例---------------##

#值设置方式 ：如果关闭设置为OFF，如果开启设置为ON(默认debug级别)或(设置输出级别,输出器)

log4j.logger.jdbc.sqlonly=OFF

log4j.logger.jdbc.sqltiming=INFO,sql

log4j.logger.jdbc.audit=OFF

log4j.logger.jdbc.resultset=ON

log4j.logger.jdbc.connection=OFF

log4j.logger.jdbc.resultsettable=INFO,sql

log4j.additivity.jdbc.sqlonly=false

log4j.additivity.jdbc.sqltiming=false

log4j.additivity.jdbc.audidt=false

log4j.additivity.jdbc.resultset=false

log4j.additivity.jdbc.connection=false

log4j.additivity.jdbc.resultsettable=false

! the appender used for the JDBC API layer call logging above, sql only

log4j.appender.sql=org.apache.log4j.FileAppender

log4j.appender.sql.File=D:/logs/sql.log

log4j.appender.sql.Append=false

log4j.appender.sql.layout=org.apache.log4j.PatternLayout

log4j.appender.sql.layout.ConversionPattern= %d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n

log4j.additivity.sql=false

5、参考文章

log4jdbc-remix官网：https://code.google.com/p/log4jdbc-remix/

http://houfeng0923.iteye.com/blog/1266375

最新文章

  1. 9套Android实战经典项目资料分享给大家
  2. OA项目之弹出层中再弹出层
  3. Java Collection好文章
  4. 【转】IOS图像拉伸解决方案
  5. 20145305 《Java程序设计》实验五
  6. Intel HD4000的驱动-黑苹果之路
  7. Ubuntu 14.04 eclipse 提示框背景色更改
  8. POJ 1129 Channel Allocation 四色定理dfs
  9. ckeditor 使用手册
  10. 网页头部 lang的声明
  11. python的join(string)函数
  12. HTML之间互相传参
  13. EF学习笔记（九）：异步处理和存储过程
  14. 关于PHP的那些坑
  15. PHP一维数组转二维数组正则表达式
  16. Mybatis的mapper文件中#和$的区别 以及 resultType和resultMap的区别
  17. WebSocket原理与实践(三)--解析数据帧
  18. How to Pronounce T + Dark L
  19. canvas验证码 - 滑块拼图
  20. myeclipse debug不显示变量值解决的方法

热门文章

  1. feature.shape和feature.shapecopy的区别
  2. WaitForSingleObject用法
  3. poj 3046 Ant Counting
  4. Gitlab 与 Git Windows 客户端一起使用的入门流程
  5. 离线文档(DocSet)下载地址汇总
  6. C# winfrom中的布局 控件Anchor和Dock的区别
  7. webpack减少打包后文件体积的几种方法
  8. PHPExcel导出excel文件
  9. PHP随机生成广告图片的实例 代码
  10. Spark Streaming揭秘 Day5 初步贯通源码