【logHelper】

最新推荐文章于 2024-04-15 22:48:03 发布
最新推荐文章于 2024-04-15 22:48:03 发布
阅读量572 收藏
点赞数
文章标签： spring boot mysql java maven
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_44559317/article/details/123719615
版权

文章目录

前言

实现 日志管理
基于 MBG 生成 entity,dao,service,serviceImpl,Controller及其xml文件

一、日志表

示例：pandas 是基于NumPy 的一种工具，该工具是为了解决数据分析任务而创建的。

二、实现步骤

1.创建类 LogHelper，注入 logService

代码如下：


	package org.honey.nongle.web.service;
	
	import org.apache.shiro.SecurityUtils;
	import org.apache.shiro.subject.Subject;
	import org.honey.nongle.core.util.IpUtil;
	import org.honey.nongle.db.domain.LitemallAdmin;
	import org.honey.nongle.db.domain.NongleLog;
	import org.honey.nongle.db.service.NongleLogService;
	import org.springframework.beans.factory.annotation.Autowired;
	import org.springframework.stereotype.Component;
	import org.springframework.web.context.request.RequestContextHolder;
	import org.springframework.web.context.request.ServletRequestAttributes;
	
	import javax.servlet.http.HttpServletRequest;
	
	/**
	 * 这里的日志类型设计成四种（当然开发者需要可以自己扩展）
	 * 一般日志：用户觉得需要查看的一般操作日志，建议是默认的日志级别
	 * 安全日志：用户安全相关的操作日志，例如登录、删除管理员
	 * 订单日志：用户交易相关的操作日志，例如订单发货、退款
	 * 其他日志：如果以上三种不合适，可以选择其他日志，建议是优先级最低的日志级别
	 * <p>
	 * 当然可能很多操作是不需要记录到数据库的，例如编辑商品、编辑广告品之类。
	 */
	@Component
	public class LogHelper {
	    public static final  Integer LOG_TYPE_GENERAL = 0;
	    public static final  Integer LOG_TYPE_AUTH = 1;
	    public static final  Integer LOG_TYPE_ORDER = 2;
	    public static final  Integer LOG_TYPE_OTHER = 3;
	
	    @Autowired
	    private NongleLogService logService;
	
	    public void logGeneralSucceed(String action) {
	        logAdmin(LOG_TYPE_GENERAL, action, true, "", "");
	    }
	
	    public void logGeneralSucceed(String action, String result) {
	        logAdmin(LOG_TYPE_GENERAL, action, true, result, "");
	    }
	
	    public void logGeneralFail(String action, String error) {
	        logAdmin(LOG_TYPE_GENERAL, action, false, error, "");
	    }
	
	    public void logAuthSucceed(String action) {
	        logAdmin(LOG_TYPE_AUTH, action, true, "", "");
	    }
	
	    public void logAuthSucceed(String action, String result) {
	        logAdmin(LOG_TYPE_AUTH, action, true, result, "");
	    }
	
	    public void logAuthFail(String action, String error) {
	        logAdmin(LOG_TYPE_AUTH, action, false, error, "");
	    }
	
	    public void logOrderSucceed(String action) {
	        logAdmin(LOG_TYPE_ORDER, action, true, "", "");
	    }
	
	    public void logOrderSucceed(String action, String result) {
	        logAdmin(LOG_TYPE_ORDER, action, true, result, "");
	    }
	
	    public void logOrderFail(String action, String error) {
	        logAdmin(LOG_TYPE_ORDER, action, false, error, "");
	    }
	
	    public void logOtherSucceed(String action) {
	        logAdmin(LOG_TYPE_OTHER, action, true, "", "");
	    }
	
	    public void logOtherSucceed(String action, String result) {
	        logAdmin(LOG_TYPE_OTHER, action, true, result, "");
	    }
	
	    public void logOtherFail(String action, String error) {
	        logAdmin(LOG_TYPE_OTHER, action, false, error, "");
	    }
	
	    public void logAdmin(Integer type, String action, Boolean succeed, String result, String comment) {
	        NongleLog log = new NongleLog();
	
	        Subject currentUser = SecurityUtils.getSubject();
	        if (currentUser != null) {
	            LitemallAdmin admin = (LitemallAdmin) currentUser.getPrincipal();
	            if (admin != null) {
	                log.setAdmin(admin.getUsername());
	            } else {
	                log.setAdmin("游客");
	            }
	        } else {
	            log.setAdmin("游客");
	        }
	
	        HttpServletRequest request =
	                ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
	        if (request != null) {
	            log.setIp(IpUtil.getIpAddr(request));
	        }
	
	        log.setType(type);
	        log.setAction(action);
	        log.setStatus(succeed);
	        log.setResult(result);
	        log.setComment(comment);
	        logService.add(log);
	    }
	}

2.创建 logService，注入 logMapper

代码如下：

	package org.honey.nongle.db.service;

	import com.github.pagehelper.PageHelper;
	import org.honey.nongle.db.dao.NongleLogMapper;
	import org.honey.nongle.db.domain.NongleLog;
	import org.honey.nongle.db.domain.NongleLogExample;
	import org.springframework.stereotype.Service;
	import org.springframework.util.StringUtils;
	
	import javax.annotation.Resource;
	import java.time.LocalDateTime;
	import java.util.List;
	
	@Service
	public class NongleLogService {
	    @Resource
	    private NongleLogMapper logMapper;
	
	    public void deleteById(Integer id) {
	        logMapper.logicalDeleteByPrimaryKey(id);
	    }
	
	    public void add(NongleLog log) {
	        log.setAddTime(LocalDateTime.now());
	        log.setUpdateTime(LocalDateTime.now());
	        logMapper.insertSelective(log);
	    }
	
	    public List<NongleLog> querySelective(String name, Integer page, Integer size, String sort, String order) {
	        NongleLogExample example = new NongleLogExample();
	        NongleLogExample.Criteria criteria = example.createCriteria();
	
	        if (!StringUtils.isEmpty(name)) {
	            criteria.andAdminLike("%" + name + "%");
	        }
	        criteria.andDeletedEqualTo(false);
	
	        if (!StringUtils.isEmpty(sort) && !StringUtils.isEmpty(order)) {
	            example.setOrderByClause(sort + " " + order);
	        }
	
	        PageHelper.startPage(page, size);
	        return logMapper.selectByExample(example);
	    }
	}

3.MBG 生成创建 logMapper.java 接口 及 logMapper.xml

代码如下：


	package org.honey.nongle.db.dao;
	
	import java.util.List;
	import org.apache.ibatis.annotations.Param;
	import org.honey.nongle.db.domain.NongleLog;
	import org.honey.nongle.db.domain.NongleLogExample;
	
	public interface NongleLogMapper {
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    long countByExample(NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int deleteByExample(NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int deleteByPrimaryKey(Integer id);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int insert(NongleLog record);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int insertSelective(NongleLog record);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    NongleLog selectOneByExample(NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    NongleLog selectOneByExampleSelective(@Param("example") NongleLogExample example, @Param("selective") NongleLog.Column ... selective);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    List<NongleLog> selectByExampleSelective(@Param("example") NongleLogExample example, @Param("selective") NongleLog.Column ... selective);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    List<NongleLog> selectByExample(NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    NongleLog selectByPrimaryKeySelective(@Param("id") Integer id, @Param("selective") NongleLog.Column ... selective);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    NongleLog selectByPrimaryKey(Integer id);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    NongleLog selectByPrimaryKeyWithLogicalDelete(@Param("id") Integer id, @Param("andLogicalDeleted") boolean andLogicalDeleted);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int updateByExampleSelective(@Param("record") NongleLog record, @Param("example") NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int updateByExample(@Param("record") NongleLog record, @Param("example") NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int updateByPrimaryKeySelective(NongleLog record);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int updateByPrimaryKey(NongleLog record);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int logicalDeleteByExample(@Param("example") NongleLogExample example);
	
	    /**
	     * This method was generated by MyBatis Generator.
	     * This method corresponds to the database table nongle_log
	     *
	     * @mbg.generated
	     */
	    int logicalDeleteByPrimaryKey(Integer id);
	}

	<?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="org.honey.nongle.db.dao.NongleLogMapper">
  <resultMap id="BaseResultMap" type="org.honey.nongle.db.domain.NongleLog">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="admin" jdbcType="VARCHAR" property="admin" />
    <result column="ip" jdbcType="VARCHAR" property="ip" />
    <result column="type" jdbcType="INTEGER" property="type" />
    <result column="action" jdbcType="VARCHAR" property="action" />
    <result column="status" jdbcType="BIT" property="status" />
    <result column="result" jdbcType="VARCHAR" property="result" />
    <result column="comment" jdbcType="VARCHAR" property="comment" />
    <result column="add_time" jdbcType="TIMESTAMP" property="addTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
    <result column="deleted" jdbcType="BIT" property="deleted" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <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 close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <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 close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    id, `admin`, ip, `type`, `action`, `status`, `result`, `comment`, add_time, update_time, 
    deleted
  </sql>
  <select id="selectByExample" parameterType="org.honey.nongle.db.domain.NongleLogExample" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from nongle_log
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByExampleSelective" parameterType="map" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="example.distinct">
      distinct
    </if>
    <choose>
      <when test="selective != null and selective.length &gt; 0">
        <foreach collection="selective" item="column" separator=",">
          ${column.aliasedEscapedColumnName}
        </foreach>
      </when>
      <otherwise>
        <include refid="Base_Column_List" />
      </otherwise>
    </choose>
    from nongle_log
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
    <if test="example.orderByClause != null">
      order by ${example.orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from nongle_log
    where id = #{id,jdbcType=INTEGER}
  </select>
  <select id="selectByPrimaryKeyWithLogicalDelete" parameterType="map" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from nongle_log
    where id = #{id,jdbcType=INTEGER}
      and deleted = 
    <choose>
      <when test="andLogicalDeleted">
        1
      </when>
      <otherwise>
        0
      </otherwise>
    </choose>
  </select>
  <select id="selectByPrimaryKeySelective" parameterType="map" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <choose>
      <when test="selective != null and selective.length &gt; 0">
        <foreach collection="selective" item="column" separator=",">
          ${column.aliasedEscapedColumnName}
        </foreach>
      </when>
      <otherwise>
        <include refid="Base_Column_List" />
      </otherwise>
    </choose>
    from nongle_log
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from nongle_log
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="org.honey.nongle.db.domain.NongleLogExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from nongle_log
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="org.honey.nongle.db.domain.NongleLog">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
      SELECT LAST_INSERT_ID()
    </selectKey>
    insert into nongle_log (`admin`, ip, `type`,
      `action`, `status`, `result`, 
      `comment`, add_time, update_time, 
      deleted)
    values (#{admin,jdbcType=VARCHAR}, #{ip,jdbcType=VARCHAR}, #{type,jdbcType=INTEGER}, 
      #{action,jdbcType=VARCHAR}, #{status,jdbcType=BIT}, #{result,jdbcType=VARCHAR}, 
      #{comment,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, 
      #{deleted,jdbcType=BIT})
  </insert>
  <insert id="insertSelective" parameterType="org.honey.nongle.db.domain.NongleLog">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
      SELECT LAST_INSERT_ID()
    </selectKey>
    insert into nongle_log
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="admin != null">
        `admin`,
      </if>
      <if test="ip != null">
        ip,
      </if>
      <if test="type != null">
        `type`,
      </if>
      <if test="action != null">
        `action`,
      </if>
      <if test="status != null">
        `status`,
      </if>
      <if test="result != null">
        `result`,
      </if>
      <if test="comment != null">
        `comment`,
      </if>
      <if test="addTime != null">
        add_time,
      </if>
      <if test="updateTime != null">
        update_time,
      </if>
      <if test="deleted != null">
        deleted,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="admin != null">
        #{admin,jdbcType=VARCHAR},
      </if>
      <if test="ip != null">
        #{ip,jdbcType=VARCHAR},
      </if>
      <if test="type != null">
        #{type,jdbcType=INTEGER},
      </if>
      <if test="action != null">
        #{action,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        #{status,jdbcType=BIT},
      </if>
      <if test="result != null">
        #{result,jdbcType=VARCHAR},
      </if>
      <if test="comment != null">
        #{comment,jdbcType=VARCHAR},
      </if>
      <if test="addTime != null">
        #{addTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updateTime != null">
        #{updateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="deleted != null">
        #{deleted,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="org.honey.nongle.db.domain.NongleLogExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from nongle_log
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log
    <set>
      <if test="record.id != null">
        id = #{record.id,jdbcType=INTEGER},
      </if>
      <if test="record.admin != null">
        `admin` = #{record.admin,jdbcType=VARCHAR},
      </if>
      <if test="record.ip != null">
        ip = #{record.ip,jdbcType=VARCHAR},
      </if>
      <if test="record.type != null">
        `type` = #{record.type,jdbcType=INTEGER},
      </if>
      <if test="record.action != null">
        `action` = #{record.action,jdbcType=VARCHAR},
      </if>
      <if test="record.status != null">
        `status` = #{record.status,jdbcType=BIT},
      </if>
      <if test="record.result != null">
        `result` = #{record.result,jdbcType=VARCHAR},
      </if>
      <if test="record.comment != null">
        `comment` = #{record.comment,jdbcType=VARCHAR},
      </if>
      <if test="record.addTime != null">
        add_time = #{record.addTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.updateTime != null">
        update_time = #{record.updateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.deleted != null">
        deleted = #{record.deleted,jdbcType=BIT},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log
    set id = #{record.id,jdbcType=INTEGER},
      `admin` = #{record.admin,jdbcType=VARCHAR},
      ip = #{record.ip,jdbcType=VARCHAR},
      `type` = #{record.type,jdbcType=INTEGER},
      `action` = #{record.action,jdbcType=VARCHAR},
      `status` = #{record.status,jdbcType=BIT},
      `result` = #{record.result,jdbcType=VARCHAR},
      `comment` = #{record.comment,jdbcType=VARCHAR},
      add_time = #{record.addTime,jdbcType=TIMESTAMP},
      update_time = #{record.updateTime,jdbcType=TIMESTAMP},
      deleted = #{record.deleted,jdbcType=BIT}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="org.honey.nongle.db.domain.NongleLog">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log
    <set>
      <if test="admin != null">
        `admin` = #{admin,jdbcType=VARCHAR},
      </if>
      <if test="ip != null">
        ip = #{ip,jdbcType=VARCHAR},
      </if>
      <if test="type != null">
        `type` = #{type,jdbcType=INTEGER},
      </if>
      <if test="action != null">
        `action` = #{action,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        `status` = #{status,jdbcType=BIT},
      </if>
      <if test="result != null">
        `result` = #{result,jdbcType=VARCHAR},
      </if>
      <if test="comment != null">
        `comment` = #{comment,jdbcType=VARCHAR},
      </if>
      <if test="addTime != null">
        add_time = #{addTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updateTime != null">
        update_time = #{updateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="deleted != null">
        deleted = #{deleted,jdbcType=BIT},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="org.honey.nongle.db.domain.NongleLog">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log
    set `admin` = #{admin,jdbcType=VARCHAR},
      ip = #{ip,jdbcType=VARCHAR},
      `type` = #{type,jdbcType=INTEGER},
      `action` = #{action,jdbcType=VARCHAR},
      `status` = #{status,jdbcType=BIT},
      `result` = #{result,jdbcType=VARCHAR},
      `comment` = #{comment,jdbcType=VARCHAR},
      add_time = #{addTime,jdbcType=TIMESTAMP},
      update_time = #{updateTime,jdbcType=TIMESTAMP},
      deleted = #{deleted,jdbcType=BIT}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <select id="selectOneByExample" parameterType="org.honey.nongle.db.domain.NongleLogExample" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <include refid="Base_Column_List" />
    from nongle_log
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
  <select id="selectOneByExampleSelective" parameterType="map" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <choose>
      <when test="selective != null and selective.length &gt; 0">
        <foreach collection="selective" item="column" separator=",">
          ${column.aliasedEscapedColumnName}
        </foreach>
      </when>
      <otherwise>
        <include refid="Base_Column_List" />
      </otherwise>
    </choose>
    from nongle_log
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
    <if test="example.orderByClause != null">
      order by ${example.orderByClause}
    </if>
    limit 1
  </select>
  <update id="logicalDeleteByExample" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log set deleted = 1
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="logicalDeleteByPrimaryKey" parameterType="java.lang.Integer">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update nongle_log set deleted = 1
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>

三、MBG 生成 entity,dao,service,serviceImpl,Controller及其xml文件

1. pom 配置文件

	<project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <artifactId>nongle-db</artifactId>
    <packaging>jar</packaging>

    <parent>
        <groupId>org.honey</groupId>
        <artifactId>nongle</artifactId>
        <version>0.1.0</version>
    </parent>

    <dependencies>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-json</artifactId>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
        </dependency>

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

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
        </dependency>

    </dependencies>

	// Here
    <build>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.7</version>
                <configuration>
                    <configurationFile>
                        mybatis-generator/generatorConfig.xml
                    </configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.16</version>
                    </dependency>
                    <dependency>
                        <groupId>com.itfsw</groupId>
                        <artifactId>mybatis-generator-plugin</artifactId>
                        <version>1.3.2</version>
                    </dependency>
                </dependencies>
            </plugin>

        </plugins>

    </build>

</project>

2. MBG 配置文件

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE generatorConfiguration
	        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
	        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
	
	<generatorConfiguration>
	
	    <context id="mysqlgenerator" targetRuntime="MyBatis3">
	        <property name="autoDelimitKeywords" value="true"/>
	        <!--可以使用``包括字段名，避免字段名与sql保留字冲突报错-->
	        <property name="beginningDelimiter" value="`"/>
	        <property name="endingDelimiter" value="`"/>
	
	        <!-- 自动生成toString方法 -->
	        <plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
	        <!-- 自动生成equals方法和hashcode方法 -->
	        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"/>
	
	        <!-- 非官方插件 https://github.com/itfsw/mybatis-generator-plugin -->
	        <!-- 查询单条数据插件 -->
	        <plugin type="com.itfsw.mybatis.generator.plugins.SelectOneByExamplePlugin"/>
	        <!-- 查询结果选择性返回插件 -->
	        <plugin type="com.itfsw.mybatis.generator.plugins.SelectSelectivePlugin"/>
	        <!-- Example Criteria 增强插件 -->
	        <plugin type="com.itfsw.mybatis.generator.plugins.ExampleEnhancedPlugin"/>
	        <!-- 数据Model属性对应Column获取插件 -->
	        <plugin type="com.itfsw.mybatis.generator.plugins.ModelColumnPlugin"/>
	        <!-- 逻辑删除插件 -->
	        <plugin type="com.itfsw.mybatis.generator.plugins.LogicalDeletePlugin">
	            <!-- 这里配置的是全局逻辑删除列和逻辑删除值，当然在table中配置的值会覆盖该全局配置 -->
	            <!-- 逻辑删除列类型只能为数字、字符串或者布尔类型 -->
	            <property name="logicalDeleteColumn" value="deleted"/>
	            <!-- 逻辑删除-已删除值 -->
	            <property name="logicalDeleteValue" value="1"/>
	            <!-- 逻辑删除-未删除值 -->
	            <property name="logicalUnDeleteValue" value="0"/>
	        </plugin>
	
	        <commentGenerator>
	            <property name="suppressDate" value="true"/>
	            <!--<property name="suppressAllComments" value="true"/>-->
	        </commentGenerator>
	
	        <!--数据库连接信息-->
	        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
	                        connectionURL="jdbc:mysql://127.0.0.1:3306/nongle?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC&amp;verifyServerCertificate=false&amp;useSSL=false&amp;nullCatalogMeansCurrent=true"
	                        userId="nongle"
	                        password="nongle123456"/>
	
	        <javaTypeResolver>
	            <property name="useJSR310Types" value="true"/>
	        </javaTypeResolver>
	
	        <javaModelGenerator targetPackage="org.honey.nongle.db.domain" targetProject="src/main/java"/>
	        <sqlMapGenerator targetPackage="org.honey.nongle.db.dao" targetProject="src/main/resources"/>
	        <javaClientGenerator type="XMLMAPPER" targetPackage="org.honey.nongle.db.dao"
	                             targetProject="src/main/java"/>
	        <!--表名-->
	        <table tableName="nongle_ad">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_address">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_admin">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="role_ids" javaType="java.lang.Integer[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonIntegerArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_brand">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_cart">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="specifications" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_category">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_collect">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_comment">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="pic_urls" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	
	        <table tableName="nongle_feedback">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="pic_urls" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	
	        <table tableName="nongle_footprint">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_goods">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="gallery" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_goods_attribute">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_goods_specification">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_goods_product">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="specifications" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_issue">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_keyword">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_order">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_order_goods">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="specifications" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	            <columnOverride column="comments" javaType="java.lang.Integer[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonIntegerArrayTypeHandler"/>
	
	        </table>
	        <table tableName="nongle_region">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_search_history">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_storage">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_topic">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="goods" javaType="java.lang.Integer[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonIntegerArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_user">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_system">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	
	        <table tableName="nongle_groupon_rules">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_groupon">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_coupon">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="goods_value" javaType="java.lang.Integer[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonIntegerArrayTypeHandler"/>
	        </table>
	        <table tableName="nongle_coupon_user">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_role">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_permission">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_log">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_notice">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_notice_admin">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	        </table>
	        <table tableName="nongle_aftersale">
	            <generatedKey column="id" sqlStatement="MySql" identity="true"/>
	            <columnOverride column="pictures" javaType="java.lang.String[]"
	                            typeHandler="org.honey.nongle.db.mybatis.JsonStringArrayTypeHandler"/>
	        </table>
	    </context>
	</generatorConfiguration>

3. 运行插件

IntelliJ IDEA，可以在Maven 面板双击mybatis-generator:gennerate，就会自动生成mybatis相关文件。

Mybatis generator(MBG)自动生成mybatis代码

HoneyProMax
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
LogHelper 日志记录帮助类
软件研发实战应用技术分享
10-23 8712
1、LogHelper 日志记录帮助类 2
Android小技巧(三)：调试程序执行流程的小技巧
lzc的专栏
09-27 6728
介绍：在开发的过程中我们经常需要调试程序的执行路径，如我们想知道一个Activity的生命周期方法的调用顺序，我们可能会写如下代码： ..... public void onResume() { super.onResume(); Log.d("Tag","
mybatis插件generatorConfiguration.xml配置中http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd报红
最新发布
m0_62943214的博客
04-15 328
是不是感觉很麻烦，其实还有实现方案1的另一种快捷方式，鼠标点击红色部分，然后IDEA出现小红灯，选择Ignore external resource即可解决。file --> settings- -> languages & frameworks -->Schemas and DTDs 点击下方的 “+” 加号添加刚刚红色的url 即可。将这个标识符手动添加到IDEA中，首先复制报红色的那串代码（只要红色的部分），然后按照步骤添加就行。返回配置文件，可以看到红色提示消失，控制台报错消失。
日志帮助文件 LogHelper
weixin_33895516的博客
02-07 176
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace AIMS.RedisMng { using System.Collections.Generic; us...
LogHelper.zip
08-10
自定义文本日志，支持头部插入，倒序读取
解决 http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd 报错
忆往昔的博客
12-29 7267
方法一：一般来讲只需要 alt+enter 选择（点击红色小灯泡，选择Fetch external resource即可解决） 方法二 ：依旧不行就缺少mybatis-generator-core.jar 解决办法：Pom.xml添加依赖 <!-- mybatis-generator-core 反向生成java代码--> <dependency> <groupId>org.mybatis.generator</groupId>
LogHelper C#日志记录
12-09
C#实现的多文件，按日期、时间记录日志
.net Loghelper小组件
06-25
.net Loghelper小组件
LogHelper.cs
05-25
C# loghelper.cs可以直接添加到公共类当中，需要保存日志的时候直接调用就可以，比较方便
Log
ZhuangLiang
05-28 733
using System; using System.Text; using Microsoft.Practices.EnterpriseLibrary.Logging; namespace Utility { public static class LogHelper { private static LogWriter _logWriter; ...
LogHelper
qq_40923160的博客
01-27 219
#pragma once #include "spdlog/spdlog.h" #include "spdlog/logger.h" #include "spdlog/sinks/rotating_file_sink.h" #include "spdlog/async.h" typedef enum class log_level { LOG_ERROR = 1, LOG_INFO, LOG_WARN, LOG_EVENT, LOG_STATUS, LOG_...
解决Mybatis逆向工程 http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd报红问题
a1079062541的博客
12-04 1667
解决Mybatis逆向工程 http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd报红问题 在使用mybatis逆向工程的时候经常会出现头部标签报红的情况！这是外部资源没有导入进来的结果。 解决方案1： 点击报红的头部标签之后会出现一个红色的小灯泡，点击它选择 Fetch external resource获取外部资源。 解决方案2： 如果方案1没能解决，采用方案2 先把 http://mybatis.org/dtd/mybatis-genera
http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd 报红
热门推荐
王坦的博客
11-28 4万+
现象 在 idea 中使用 mybatis-generator，配置文件头部 文档类型定义报红 解决方法 点开 Settings —— Languages & Frameworks —— Schemas and DTDs，如下图 添加一个外部资源映射 Map External Resource，如下图 3. 具体配置，File 指定你的 jar 包中的 dtd 文档即可 ...
Mybatis Generator最完整配置详解
信
01-16 5491
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">     resource：配置资源加载地址，使用resource，MBG从classpath开始找，比如com/myprojec
MyBatis逆向生成配置XML及详解
上善若泪
01-24 3250
配置XML示例： &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd...
MyBatisGenerator数据层代码生成器使用教程
liubaojun的博客
12-02 1732
MyBatis Generator数据层代码生成MyBatis Generator简介MBG的使用流程1、pom.xml中添加依赖 MyBatis Generator简介 MyBatis Generator（MBG）是一个代码生成器，能够基于数据库表（一或多张表）生成用于访问表的构件，例如：实体类、mapper接口、mapper.xml等。 MBG的使用流程 1、pom.xml中添加依赖 <!-- MyBatis 生成器 --> <dependency> <g
LOG Helper
小完能的专栏
03-05 1759
在终端打印LOG是最基础、最易用、某种程度上也是最经济的Debug方式。但是Base的规模大了，管理LOG也不是一件轻松的事情。 最近项目组在Linux内核里写一个新的mach，和该mach专用的驱动。面对一坨一坨的日益增加的代码，Debug时想要从LOG上一眼找出问题点，以及
LogcatHelperDemo【应用log信息保存成本地文件】
weixin_33950035的博客
08-19 506
版权声明：本文为HaiyuKing原创文章，转载请注明出处！ 前言 简单记录下LogcatHelper的使用，并对原有代码进行了修改【因为保存到应用内的目录中不需要申请权限，所以去掉保存到SD的功能--个人觉得这个类主要用于开发者自己调试用】： /**初始化目录 "包名+logcat" * */ public void init(Context contex...
java Log日志分析辅助工具类
明亮的技术博客
02-13 2435
在分析有一些比较复杂的问题时，比如我只想从海量的日志中分析某个接口功能或者某台机器发起的请求和响应，这时候只用肉眼是不行的，必须对日志进行分析，把自己需要的日志都复制到另外的文本文件中才可以进行一目了然的分析，此外涉及到利用依据数学统计运算的一些功能写程序来实现要比靠肉眼靠谱多了。 一个小小的例子，粘出来，一来自己做个标记，二来送给需要的人。 实现了部分日志分析的工具类源码 package
C#,LogHelper
09-07
C#中的LogHelper是一个记录系统日志的辅助类。它包含一个名为RecordLog的静态方法，用于将错误信息写入日志文件。这个方法接受两个参数，分别是文件名和错误信息。 在RecordLog方法中，它首先会获取当前程序执行所在...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值