首先maven的pom文件中

<dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

第二mapper的xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 命名空间mapper,如果有多个mapper文件，这个必须唯一 -->
<mapper namespace="com.course.model">

    <!--获取登陆接口case-->
    <select id="loginCase" parameterType="Integer"  resultType="loginCase">

        select * from loginCase
        where id = #{id}
    </select>
    <!--添加用户接口case-->
    <select id="addUserCase" parameterType="Integer" resultType="addUserCase">
        select * from addUserCase where id=#{id}
    </select>

    <!--获取用户信息case-->
    <select id="getUserInfoCase" parameterType="Integer" resultType="getUserInfoCase">
        <!-- SQL语句 -->
        select * from getUserInfoCase where id=#{id}
    </select>

    <!--获取用户列表case-->
    <select id="getUserListCase" parameterType="Integer" resultType="getUserListCase">
        <!-- SQL语句 -->
        select * from getUserListCase where id=#{id}
    </select>

    <!--更新/删除用户信息case-->
    <select id="updateUserInfoCase" parameterType="Integer" resultType="updateUserInfoCase">
        select * from updateUserInfoCase where id = #{id}
    </select>


    <!--添加用户接口-->
    <select id="addUser" parameterType="com.course.model.AddUserCase" resultType="user">
        select * from user where
        userName=#{userName}
        and password=#{password}
        and sex=#{sex}
        and age=#{age}
        and permission=#{permission}
        and isDelete=#{isDelete}

    </select>

    <!--获取用户信息-->
    <select id="getUserInfo" parameterType="com.course.model.GetUserInfoCase" resultType="user">
        <!-- SQL语句 -->
        select * from user where
        id=#{userId}
    </select>

    <!--获取用户列表-->
    <select id="getUserList" parameterType="com.course.model.GetUserListCase" resultType="user">
        <!-- SQL语句 -->
        select * from user
        <where>
            <if test="null != userName and '' !=userName">
                AND userName=#{userName}
            </if>
            <if test="null != sex and '' !=sex">
                AND sex=#{sex}
            </if>
            <if test="null != age and '' !=age">
                AND age=#{age}
            </if>
        </where>

    </select>

    <!--获取更新后的数据-->
    <select id="getUpdateUserInfo" parameterType="com.course.model.UpdateUserInfoCase" resultType="user">
        select * from user
        <where>
            <if test="null != userName and '' !=userName">
                AND userName=#{userName}
            </if>
            <if test="null != sex and '' !=sex">
                AND sex=#{sex}
            </if>
            <if test="null != age and '' !=age">
                AND age=#{age}
            </if>
            <if test="null != permission and '' !=permission">
                AND permission=#{permission}
            </if>
            <if test="null != isDelete and '' !=isDelete">
                AND isDelete=#{isDelete}
            </if>
        </where>
        And id = #{userId}
    </select>


</mapper>

第三 log4j.properties配置mapper的xml文件中的namespace的值

Set root category priority to INFO and its only appender to CONSOLE.

log4j.rootCategory=ERROR, CONSOLE
#log4j.rootCategory=INFO, CONSOLE, LOGFILE

#make level of queryAll method DEBUG # method level
#log4j.logger.com.bjsxt.mapper.PeopleMapper.queryAll=DEBUG
#log4j.logger.com.bjsxt.mapper.PeopleMapper.query2=DEBUG

class level

#log4j.logger.com.bjsxt.mapper.PeopleMapper=DEBUG

packet level,原来这里写的是mapper.xml中命名空间namespace的值

log4j.logger.com.course.model=DEBUG

CONSOLE is set to be a ConsoleAppender using a PatternLayout.

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
#this “-” means that it will writes what you write
log4j.appender.CONSOLE.layout.ConversionPattern=- %p %m%n

LOGFILE is set to be a File appender using a PatternLayout.

log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=E:/myclipse/Workspaces/MyEclipse 2017 CI/1030_log4j/log/test.log
#true is added at end,false is overwrite
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n

然后运行如下

本文地址：https://blog.csdn.net/thgjkgdrf/article/details/110687390