CREATE TABLE `log_message`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '操作日志id',
  `operationUser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
  `path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求路徑',
  `time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作時間',
  `parameter` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '參數',
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求模塊',
  `action` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求內容',
  `ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人IP地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

package com.df.pojo.po;

import java.io.Serializable;

public class LogMessage implements Serializable {
    private Integer id;

    private String operationuser;    //操作人
    
    private String path;    //請求方法

    private String time;    //請求時間

    private String parameter;    //請求參數

    private String title;    //title

    private String action;    //操作內容

    private String ip;    //操作人員ip
    
    private String start_time;    //用于輸入框時間查詢
    private String end_time;  //用于輸入框時間查詢
    

    public String getStart_time() {
        return start_time;
    }

    public void setStart_time(String start_time) {
        this.start_time = start_time;
    }

    public String getEnd_time() {
        return end_time;
    }

    public void setEnd_time(String end_time) {
        this.end_time = end_time;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getOperationuser() {
        return operationuser;
    }

    public void setOperationuser(String operationuser) {
        this.operationuser = operationuser == null ? null : operationuser.trim();
    }

    public String getPath() {
        return path;
    }

    public void setPath(String path) {
        this.path = path == null ? null : path.trim();
    }

    public String getTime() {
        return time;
    }

    public void setTime(String time) {
        this.time = time == null ? null : time.trim();
    }

    public String getParameter() {
        return parameter;
    }

    public void setParameter(String parameter) {
        this.parameter = parameter == null ? null : parameter.trim();
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title == null ? null : title.trim();
    }

    public String getAction() {
        return action;
    }

    public void setAction(String action) {
        this.action = action == null ? null : action.trim();
    }

    public String getIp() {
        return ip;
    }

    public void setIp(String ip) {
        this.ip = ip == null ? null : ip.trim();
    }

    public LogMessage(String operationuser, String path, String time, String parameter, String title, String action,
            String ip) {
        super();
        this.operationuser = operationuser;
        this.path = path;
        this.time = time;
        this.parameter = parameter;
        this.title = title;
        this.action = action;
        this.ip = ip;
    }

    public LogMessage() {
        super();
    }

    @Override
    public String toString() {
        return "LogMessage [id=" + id + ", operationuser=" + operationuser + ", path=" + path + ", time=" + time
                + ", parameter=" + parameter + ", title=" + title + ", action=" + action + ", ip=" + ip
                + ", start_time=" + start_time + ", end_time=" + end_time + "]";
    }  
    
}

package com.df.base.dao.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.df.pojo.po.LogMessage;
import com.df.pojo.po.LogMessageExample;
import com.df.pojo.vo.LogMessageQueryVo;

public interface LogMessageMapper {
    int countByExample(LogMessageExample example);

    int deleteByExample(LogMessageExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(LogMessage record);

    int insertSelective(LogMessage record);

    List<LogMessage> selectByExample(LogMessageExample example);

    LogMessage selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") LogMessage record, @Param("example") LogMessageExample example);

    int updateByExample(@Param("record") LogMessage record, @Param("example") LogMessageExample example);

    int updateByPrimaryKeySelective(LogMessage record);

    int updateByPrimaryKey(LogMessage record);
    
    List<LogMessage> findLogMessageList(LogMessageQueryVo logMessageQueryVo);
    int findLogMessageListCount(LogMessageQueryVo logMessageQueryVo);
}

<?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 namespace="com.df.dao.mapper.LogMessageMapper" >
  <resultMap id="BaseResultMap" type="yycg.base.pojo.po.LogMessage" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="operationUser" property="operationuser" jdbcType="VARCHAR" />
    <result column="path" property="path" jdbcType="VARCHAR" />
    <result column="time" property="time" jdbcType="VARCHAR" />
    <result column="parameter" property="parameter" jdbcType="VARCHAR" />
    <result column="title" property="title" jdbcType="VARCHAR" />
    <result column="action" property="action" jdbcType="VARCHAR" />
    <result column="ip" property="ip" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Example_Where_Clause" >
    <where >
      <foreach collection="oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause" >
    <where >
      <foreach collection="example.oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List" >
    id, operationUser, path, time, parameter, title, action, ip
  </sql>
  <select id="selectByExample" resultMap="BaseResultMap" parameterType="yycg.base.pojo.po.LogMessageExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from log_message
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null" >
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from log_message
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from log_message
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="yycg.base.pojo.po.LogMessageExample" >
    delete from log_message
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="yycg.base.pojo.po.LogMessage" >
    insert into log_message (id, operationUser, path, 
      time, parameter, title, 
      action, ip)
    values (#{id,jdbcType=INTEGER}, #{operationuser,jdbcType=VARCHAR}, #{path,jdbcType=VARCHAR}, 
      #{time,jdbcType=VARCHAR}, #{parameter,jdbcType=VARCHAR}, #{title,jdbcType=VARCHAR}, 
      #{action,jdbcType=VARCHAR}, #{ip,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="yycg.base.pojo.po.LogMessage" >
    insert into log_message
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="operationuser != null" >
        operationUser,
      </if>
      <if test="path != null" >
        path,
      </if>
      <if test="time != null" >
        time,
      </if>
      <if test="parameter != null" >
        parameter,
      </if>
      <if test="title != null" >
        title,
      </if>
      <if test="action != null" >
        action,
      </if>
      <if test="ip != null" >
        ip,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="operationuser != null" >
        #{operationuser,jdbcType=VARCHAR},
      </if>
      <if test="path != null" >
        #{path,jdbcType=VARCHAR},
      </if>
      <if test="time != null" >
        #{time,jdbcType=VARCHAR},
      </if>
      <if test="parameter != null" >
        #{parameter,jdbcType=VARCHAR},
      </if>
      <if test="title != null" >
        #{title,jdbcType=VARCHAR},
      </if>
      <if test="action != null" >
        #{action,jdbcType=VARCHAR},
      </if>
      <if test="ip != null" >
        #{ip,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="yycg.base.pojo.po.LogMessageExample" resultType="java.lang.Integer" >
    select count(*) from log_message
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map" >
    update log_message
    <set >
      <if test="record.id != null" >
        id = #{record.id,jdbcType=INTEGER},
      </if>
      <if test="record.operationuser != null" >
        operationUser = #{record.operationuser,jdbcType=VARCHAR},
      </if>
      <if test="record.path != null" >
        path = #{record.path,jdbcType=VARCHAR},
      </if>
      <if test="record.time != null" >
        time = #{record.time,jdbcType=VARCHAR},
      </if>
      <if test="record.parameter != null" >
        parameter = #{record.parameter,jdbcType=VARCHAR},
      </if>
      <if test="record.title != null" >
        title = #{record.title,jdbcType=VARCHAR},
      </if>
      <if test="record.action != null" >
        action = #{record.action,jdbcType=VARCHAR},
      </if>
      <if test="record.ip != null" >
        ip = #{record.ip,jdbcType=VARCHAR},
      </if>
    </set>
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map" >
    update log_message
    set id = #{record.id,jdbcType=INTEGER},
      operationUser = #{record.operationuser,jdbcType=VARCHAR},
      path = #{record.path,jdbcType=VARCHAR},
      time = #{record.time,jdbcType=VARCHAR},
      parameter = #{record.parameter,jdbcType=VARCHAR},
      title = #{record.title,jdbcType=VARCHAR},
      action = #{record.action,jdbcType=VARCHAR},
      ip = #{record.ip,jdbcType=VARCHAR}
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="yycg.base.pojo.po.LogMessage" >
    update log_message
    <set >
      <if test="operationuser != null" >
        operationUser = #{operationuser,jdbcType=VARCHAR},
      </if>
      <if test="path != null" >
        path = #{path,jdbcType=VARCHAR},
      </if>
      <if test="time != null" >
        time = #{time,jdbcType=VARCHAR},
      </if>
      <if test="parameter != null" >
        parameter = #{parameter,jdbcType=VARCHAR},
      </if>
      <if test="title != null" >
        title = #{title,jdbcType=VARCHAR},
      </if>
      <if test="action != null" >
        action = #{action,jdbcType=VARCHAR},
      </if>
      <if test="ip != null" >
        ip = #{ip,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="yycg.base.pojo.po.LogMessage" >
    update log_message
    set operationUser = #{operationuser,jdbcType=VARCHAR},
      path = #{path,jdbcType=VARCHAR},
      time = #{time,jdbcType=VARCHAR},
      parameter = #{parameter,jdbcType=VARCHAR},
      title = #{title,jdbcType=VARCHAR},
      action = #{action,jdbcType=VARCHAR},
      ip = #{ip,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
  
</mapper>

package com.df.common.log;

import java.lang.annotation.Documented;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;
@Target({ElementType.METHOD})
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface Log {
    /** 方法模塊  操作日志類*/
    String title() default "";
    /** 功能 */
    String action() default "";
}

package com.df.common.log;


import java.lang.reflect.Method;
import java.net.InetAddress;
import java.net.UnknownHostException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.reflect.CodeSignature;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.context.request.RequestAttributes;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

import yycg.base.dao.mapper.LogMessageMapper;
import yycg.base.pojo.po.LogMessage;
import yycg.base.pojo.vo.ActiveUser;
import yycg.util.DateUtils;

/**
 * @author Administrator
 * @Description 日志記錄
 */
public class LogAspect {
    @Autowired
    private LogMessageMapper logMessageMapper;//日志 mapper
     
    private String requestPath = null ; // 請求地址  
    private long startTimeMillis = 0; // 開始時間  
    private long endTimeMillis = 0; // 結束時間  
    private String user = null; // 操作人
    private HttpServletRequest request = null;//請求
   /**
    * @param joinPoint
    * @Description 氣質通知  方法調用前觸發   記錄開始時間,從session中獲取操作人
    */
    public void before(JoinPoint joinPoint){  
        startTimeMillis = System.currentTimeMillis(); 
    } 
    /**
     * @param joinPoint
     * @Description 獲取入參方法參數
     * @return
     */
    public Map<String, Object> getNameAndValue(JoinPoint joinPoint) {
        Map<String, Object> param = new HashMap<>();
        Object[] paramValues = joinPoint.getArgs();
        String[] paramNames = ((CodeSignature)joinPoint.getSignature()).getParameterNames();
        for (int i = 0; i < paramNames.length; i++) {
//            if(paramValues[i] instanceof Integer || paramValues[i] instanceof String) {
//                param.put(paramNames[i], paramValues[i]);
//            }
                param.put(paramNames[i], paramValues[i]);

        }
        return param;
    }
    /**
     * @param joinPoint
     * @Description 后置通知    方法調用后觸發   記錄結束時間 ,操作人 ,入參等
     */
    public void after(JoinPoint joinPoint) {
        request = getHttpServletRequest();
        String targetName = joinPoint.getTarget().getClass().getName();  
        String methodName = joinPoint.getSignature().getName();  
        Object[] arguments = joinPoint.getArgs();  
        Class<?> targetClass = null;
        try {
            targetClass = Class.forName(targetName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Method[] methods = targetClass.getMethods();    //獲取該類下所有方法
        String title;
        String action;
        Class<?>[] clazzs;
        for (Method method : methods) {  
            if (method.getName().equals(methodName)) {  
                clazzs = method.getParameterTypes();      //獲取改方法的參數
                if (clazzs!=null&&clazzs.length == arguments.length
                &&method.getAnnotation(Log.class)!=null) {  
                    request = getHttpServletRequest();
                    requestPath=request.getServletPath();    //請求路徑
                    //user = (String) request.getSession().getAttribute("activeUser");    //用戶登錄時存session的鍵
                    ActiveUser activeUser = (ActiveUser)request.getSession().getAttribute("activeUser");
                    user=activeUser.getUsername();
                    title = method.getAnnotation(Log.class).title();
                    action = method.getAnnotation(Log.class).action();
                    String currnetDayParamMill = DateUtils.getCurrnetDayParamMill(new Date());
                    
                    String ipAddress = request.getHeader("x-forwarded-for");  
                    if(ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {  
                        ipAddress = request.getHeader("Proxy-Client-IP");  
                    }  
                    if(ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {  
                        ipAddress = request.getHeader("WL-Proxy-Client-IP");  
                    }  
                    if(ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {  
                        ipAddress = request.getRemoteAddr();  
                        if(ipAddress.equals("127.0.0.1") || ipAddress.equals("0:0:0:0:0:0:0:1")){  
                            //根據網卡取本機配置的IP  
                            InetAddress inet=null;  
                            try {  
                                inet = InetAddress.getLocalHost();  
                            } catch (UnknownHostException e) {  
                                e.printStackTrace();  
                            }  
                            ipAddress= inet.getHostAddress();  
                        }  
                    }  
                    //對于通過多個代理的情況，第一個IP為客戶端真實IP,多個IP按照','分割  
                    if(ipAddress!=null && ipAddress.length()>15){ //"***.***.***.***".length() = 15  
                        if(ipAddress.indexOf(",")>0){  
                            ipAddress = ipAddress.substring(0,ipAddress.indexOf(","));  
                        }  
                    }  
                                                       
                    LogMessage log=new LogMessage(user, requestPath, currnetDayParamMill, getNameAndValue(joinPoint).toString(), title, action,ipAddress);
                    logMessageMapper.insertSelective(log);
                    break;  
                }  
            }  
        }
    }
    /**
     * @Description: 獲取request  
     */
    public HttpServletRequest getHttpServletRequest(){
        RequestAttributes ra = RequestContextHolder.getRequestAttributes();  
        ServletRequestAttributes sra = (ServletRequestAttributes)ra;  
        HttpServletRequest request = null;
        try {
            request = sra.getRequest();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            //e.printStackTrace();
        }
        return request;
    }
    /**
     * @param joinPoint
     * @return 環繞通知
     * @throws Throwable
     */
    public Object around(ProceedingJoinPoint joinPoint) throws Throwable {  
        return null;  
    }  
    /**
     * @param joinPoint
     * @Description 異常通知
     */
    public void throwing(JoinPoint joinPoint) {
        System.out.println("異常通知");
    }
}

<!-- 操作日志配置 指定掃描aop執行操作的類 -->
<aop:aspectj-autoproxy proxy-target-class="true" />
 <!--將日志類注入到bean中。-->
<bean id="logAspect" class="com.df.common.log.LogAspect"></bean>

 <aop:config>
       <aop:aspect  ref="logAspect">
           <aop:pointcut id="log" expression="execution(* com.*.service.impl.*.*(..))"/>  
           <aop:after pointcut-ref="log" method="after"/> 
       </aop:aspect>
 </aop:config>

@Log(title="增加日志",action="增加用戶信息")
@Override
public void insertSysuser(SysuserCustom sysuserCustom) throws Exception {

}