<?xml version="1.0" encoding="UTF-8"?>
<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/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>wonder</groupId>
    <artifactId>skyRainbow</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.9.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <dependencies>

        <!--spring boot 的依赖 START-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--spring boot 的依赖 END-->

        <!--mybatis 的依赖 START-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!--mybatis 的依赖 END-->

        <!--mysql 的依赖 START-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--mysql 的依赖 END-->

        <!--jsp 的依赖 START-->
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
        </dependency>
        <!--jsp 的依赖 END-->

        <!--swagger 的依赖 START-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
            <version>2.2.2</version>
        </dependency>
        <!--swagger 的依赖 END-->

    </dependencies>

    <build>
        <!--配置文件读取路径-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>

　　　　　　　　　　　　<include>**/*.properties</include>

</includes>
            </resource>
        </resources>

        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

package lf;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.PropertySource;


@SpringBootApplication
@MapperScan("lf.mapper") // mapper层的路径
@PropertySource({"classpath:mybatis.properties",
                 "classpath:datasource.properties"})// 读取.properties 文件路径
public class SkyRainbowApplication {

    public static void main(String[] args) {
        /**
         * Spring boot 程序入口
         */
        SpringApplication.run(SkyRainbowApplication.class,args);
   }
}

package lf.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.context.request.async.DeferredResult;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

import static com.google.common.base.Predicates.or;
import static springfox.documentation.builders.PathSelectors.regex;

@Configuration
@EnableSwagger2
public class SwaggerConfig {

    @Bean
    public Docket api_lf(){
        return  new Docket(DocumentationType.SWAGGER_2)
                .groupName("api_lf")
                .genericModelSubstitutes(DeferredResult.class)
                .useDefaultResponseMessages(false)
                .forCodeGeneration(false)
                .pathMapping("/")
                .select()
                .paths(or(regex("/lf/.*")))
                .build()
                .apiInfo(apiInfo());

    }

    /**
     *  构建api文档详细信息
     */
    private ApiInfo apiInfo() {
        ApiInfo apiInfo = new ApiInfo(
                "甘雨路 API",// 标题
                "API 描述说明",//描述
                "1.0",//版本
                "NO terms of service",
                "lf@qq.com",// 创建人
                "The Apache License, Version 2.0",
                "http://www.apache.org/licenses/LICENSE-2.0.html"
        );
        return apiInfo;
    }



}

package lf.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiParam;
import lf.entity.BsdUser;
import lf.service.BsdUserSerive;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import javax.annotation.Resource;
import java.util.Date;

@Controller
@RequestMapping(value="${modulePath}/page")
@Api(description = "页面跳转控制器")
public class PageController {
    @Resource
    private BsdUserSerive userSerive;
    /**
     * 进入公司主页
     */
    @RequestMapping(value = "/company",method = RequestMethod.GET)
    public String gotoCompanyPage(Model model,@RequestParam @ApiParam("用户id") Long id){
        BsdUser user = userSerive.getUserById(id);
        model.addAttribute("time",new Date());
        model.addAttribute("loginName",user.getName());
        return "main";
    }

}

package lf.controller;

import io.swagger.annotations.*;
import lf.entity.BsdUser;
import lf.entity.utils.CommonDTO;
import lf.service.BsdUserSerive;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;

@Api(description = "用户控制器")//swagger注解用于类
@Controller // 控制器注解
@RequestMapping(value="${modulePath}/user")
public class UserController {

    @Resource
    private BsdUserSerive userSerive;

    @ResponseBody
    @RequestMapping(value = "/info",method = RequestMethod.GET)
    public CommonDTO<BsdUser> getUserbyId(@RequestParam @ApiParam("用户id") Long id){
        CommonDTO<BsdUser> detailDTO = new CommonDTO<>(0,1);
        try {
            BsdUser user = userSerive.getUserById(id);
            detailDTO.setData(user);
        } catch (Exception e) {
            e.printStackTrace();
            detailDTO.setStatus(1);
            detailDTO.setCode(400);
            detailDTO.setMsg("获取用户信息异常："+e.getMessage());

        }

        return detailDTO;
    }


}

package lf.entity.utils;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.util.Map;


@ApiModel(description = "详情DTO")
public class CommonDTO<T>{

    @ApiModelProperty(value = "提示信息")
    private String msg;

    @ApiModelProperty(value = "0 代表无错误 1代表有错误")
    private Integer status;

    @ApiModelProperty(value = "总记录")
    private Integer total;

    @ApiModelProperty(value = "业务数据")
    private T data;

    @ApiModelProperty(value = "200 代表无错误 400代表有错误--->加入这个字段是原生需求")
    private Integer code;


    @ApiModelProperty(value = "当前页码")
    private Integer pageNo = 1;

    @ApiModelProperty(value = "当前页码，默认：10")
    private Integer pageSize = Integer.valueOf(10); // 页面大小，设置为“-1”表示不进行分页（分页无效）

    @ApiModelProperty(value = "总记录数")
    private long totalSize;// 总记录数，设置为“-1”表示不查询总数



    private Map<String,Object> DataMap;

    public CommonDTO(Integer status) {
        if (status == 0){
            this.status = status;
            this.code = 200;
            this.msg = "操作成功";
        }
        this.data = null;
    }




    public CommonDTO(Integer status, Integer total) {
        if (status == 0){
            this.status = status;
            this.code = 200;
            this.msg = "操作成功";
        }
        this.data = null;
        this.total = total;
    }

    public Map<String, Object> getDataMap() {
        return DataMap;
    }

    public void setDataMap(Map<String, Object> dataMap) {
        DataMap = dataMap;
    }

    public Integer getCode() {return code;}

    public void setCode(Integer code) {this.code = code;}

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }

    public Integer getTotal() {
        return total;
    }

    public void setTotal(Integer total) {
        this.total = total;
    }

    public T getData() {
        return data;
    }

    public void setData(T data) {
        this.data = data;
    }


    public Integer getPageNo() {
        return (pageNo!=null&&pageNo>0)?pageNo:-1;
    }

    public void setPageNo(Integer pageNo) {
        this.pageNo = pageNo;
    }

    public Integer getPageSize() {
        return (pageSize!=null&&pageSize>0)?pageSize:10;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }


    /**
     * 获取设置总数
     * @return
     */
    public long getTotalSize() {
        return totalSize;
    }

    /**
     * 设置数据总数
     * @param count
     */
    public void setTotalSize(long totalSize) {
        this.totalSize = totalSize;
        if (pageSize >= totalSize){
            pageNo = 1;
        }
    }


    @Override
    public String toString() {
        return "CommonDTO{" +
                "msg=''" + msg + ''\'''' +
                ", status=" + status +
                ", total=" + total +
                ", data=" + data +
                ''}'';
    }
}

package lf.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

@ApiModel(description = "用户实体")
public class BsdUser implements Serializable {
    @ApiModelProperty("主键")
    private Long id;
    @ApiModelProperty("组织id")
    private Long orgId;
    @ApiModelProperty("用户类型(0,品牌商1，服务商2，零售商，3客服)")
    private Integer userType;
    @ApiModelProperty("登录名")
    private String loginName;
    @ApiModelProperty("电话")
    private String phone;
    @ApiModelProperty("姓名")
    private String name;
    @ApiModelProperty("简称")
    private String shortName;
    @ApiModelProperty("密码")
    private String password;
    @ApiModelProperty("联系人")
    private String contactUserName;
    @ApiModelProperty("地址")
    private String address;
    @ApiModelProperty("经度")
    private BigDecimal longitude;
    @ApiModelProperty("纬度")
    private BigDecimal latitude;
    @ApiModelProperty("级别(0,普通会员,1,一级会员，2，二级会员，3三级会员，4，四级会员,5,五级会员)")
    private Integer level;
    @ApiModelProperty("状态(0,无效，1有效,2未审核,3审核未通过)")
    private Integer state;
    @ApiModelProperty("银行卡")
    private String bankCard;
    @ApiModelProperty("总积分")
    private Long totalPoints;
    @ApiModelProperty("上级组织id")
    private Long superiorId;
    @ApiModelProperty("创建人id")
    private Long createdBy;
    @ApiModelProperty("最后更新人")
    private Long lastUpdatedBy;
    @ApiModelProperty("创建日期")
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    private Date createdDate;
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @ApiModelProperty("最后更新日期")
    private Date lastUpdatedDate;
    @ApiModelProperty("软删除标志")
    private Integer removeFlag;
    @ApiModelProperty("图片地址")
    private String imgUrl;
    @ApiModelProperty("消费总金额")
    private BigDecimal totalPaymentAmount;
    @ApiModelProperty("佣金")
    private BigDecimal commission;
    @ApiModelProperty("运费")
    private BigDecimal freight;
    @ApiModelProperty("编号")
    private String code;
    @ApiModelProperty("已经支付定金")
    private Long depositPaid;
    @ApiModelProperty("注册信息附件信息传")
    private String registerAttachmentUrl;
    @ApiModelProperty("支付密码")
    private String payPassWord;
    @ApiModelProperty("钱包余额")
    private BigDecimal balance;
    @ApiModelProperty("现金卷余额")
    private BigDecimal cashRoll;

    private static final long serialVersionUID = 1L;

    public Long getId() {
        return id;
    }

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

    public Long getOrgId() {
        return orgId;
    }

    public void setOrgId(Long orgId) {
        this.orgId = orgId;
    }

    public Integer getUserType() {
        return userType;
    }

    public void setUserType(Integer userType) {
        this.userType = userType;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code == null ? null : code.trim();
    }

    public String getLoginName() {
        return loginName;
    }

    public void setLoginName(String loginName) {
        this.loginName = loginName == null ? null : loginName.trim();
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone == null ? null : phone.trim();
    }

    public String getShortName() {
        return shortName;
    }

    public void setShortName(String shortName) {
        this.shortName = shortName == null ? null : shortName.trim();
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password == null ? null : password.trim();
    }

    public String getContactUserName() {
        return contactUserName;
    }

    public void setContactUserName(String contactUserName) {
        this.contactUserName = contactUserName == null ? null : contactUserName.trim();
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address == null ? null : address.trim();
    }

    public BigDecimal getLongitude() {
        return longitude;
    }

    public void setLongitude(BigDecimal longitude) {
        this.longitude = longitude;
    }

    public String getRegisterAttachmentUrl() {
        return registerAttachmentUrl;
    }

    public void setRegisterAttachmentUrl(String registerAttachmentUrl) {
        this.registerAttachmentUrl = registerAttachmentUrl == null ? null : registerAttachmentUrl.trim();
    }

    public BigDecimal getLatitude() {
        return latitude;
    }

    public void setLatitude(BigDecimal latitude) {
        this.latitude = latitude;
    }

    public Integer getLevel() {
        return level;
    }

    public void setLevel(Integer level) {
        this.level = level;
    }

    public String getImgUrl() {
        return imgUrl;
    }

    public void setImgUrl(String imgUrl) {
        this.imgUrl = imgUrl == null ? null : imgUrl.trim();
    }

    public Integer getState() {
        return state;
    }

    public void setState(Integer state) {
        this.state = state;
    }

    public String getBankCard() {
        return bankCard;
    }

    public void setBankCard(String bankCard) {
        this.bankCard = bankCard == null ? null : bankCard.trim();
    }

    public BigDecimal getTotalPaymentAmount() {
        return totalPaymentAmount;
    }

    public void setTotalPaymentAmount(BigDecimal totalPaymentAmount) {
        this.totalPaymentAmount = totalPaymentAmount;
    }

    public Long getTotalPoints() {
        return totalPoints;
    }

    public void setTotalPoints(Long totalPoints) {
        this.totalPoints = totalPoints;
    }

    public Long getSuperiorId() {
        return superiorId;
    }

    public void setSuperiorId(Long superiorId) {
        this.superiorId = superiorId;
    }

    public BigDecimal getCommission() {
        return commission;
    }

    public void setCommission(BigDecimal commission) {
        this.commission = commission;
    }

    public BigDecimal getFreight() {
        return freight;
    }

    public void setFreight(BigDecimal freight) {
        this.freight = freight;
    }

    public Long getDepositPaid() {
        return depositPaid;
    }

    public void setDepositPaid(Long depositPaid) {
        this.depositPaid = depositPaid;
    }

    public String getPayPassWord() {
        return payPassWord;
    }

    public void setPayPassWord(String payPassWord) {
        this.payPassWord = payPassWord == null ? null : payPassWord.trim();
    }

    public BigDecimal getBalance() {
        return balance;
    }

    public void setBalance(BigDecimal balance) {
        this.balance = balance;
    }

    public BigDecimal getCashRoll() {
        return cashRoll;
    }

    public void setCashRoll(BigDecimal cashRoll) {
        this.cashRoll = cashRoll;
    }

    public Long getCreatedBy() {
        return createdBy;
    }

    public void setCreatedBy(Long createdBy) {
        this.createdBy = createdBy;
    }

    public Date getCreatedDate() {
        return createdDate;
    }

    public void setCreatedDate(Date createdDate) {
        this.createdDate = createdDate;
    }

    public Long getLastUpdatedBy() {
        return lastUpdatedBy;
    }

    public void setLastUpdatedBy(Long lastUpdatedBy) {
        this.lastUpdatedBy = lastUpdatedBy;
    }

    public Date getLastUpdatedDate() {
        return lastUpdatedDate;
    }

    public void setLastUpdatedDate(Date lastUpdatedDate) {
        this.lastUpdatedDate = lastUpdatedDate;
    }

    public Integer getRemoveFlag() {
        return removeFlag;
    }

    public void setRemoveFlag(Integer removeFlag) {
        this.removeFlag = removeFlag;
    }
}

package lf.service;

import lf.entity.BsdUser;


public interface BsdUserSerive {
    /**
     * 根据用户id获取用户
     * @param id
     * @return
     */
    public BsdUser getUserById(Long id);
}

package lf.service.impl;

import lf.entity.BsdUser;
import lf.mapper.BsdUserMapper;
import lf.service.BsdUserSerive;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;


@Service
public class BsdUserSeriveImpl implements BsdUserSerive{

    @Autowired
    private BsdUserMapper userMapper;
    /**
     * 根据用户id获取用户信息
     * @param id
     * @return
     */
    @Override
    public BsdUser getUserById(Long id) {
        return userMapper.getUserById(id);
    }
}

package lf.mapper;

import lf.entity.BsdUser;
import org.mapstruct.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

public interface BsdUserMapper{

    /**
     * 根据用户id获取用户信息
     * @param id
     * @return
     */
    public BsdUser getUserById(Long 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="lf.mapper.BsdUserMapper">
  <resultMap id="BsdUserResultMap" type="lf.entity.BsdUser">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="org_id" jdbcType="BIGINT" property="orgId" />
    <result column="user_type" jdbcType="INTEGER" property="userType" />
    <result column="code" jdbcType="VARCHAR" property="code" />
    <result column="login_name" jdbcType="VARCHAR" property="loginName" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="name" jdbcType="VARCHAR" property="name" />
    <result column="short_name" property="shortName" jdbcType="VARCHAR" />
    <result column="register_attachment_url" property="registerAttachmentUrl" jdbcType="VARCHAR" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="contact_user_name" jdbcType="VARCHAR" property="contactUserName" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="longitude" jdbcType="DECIMAL" property="longitude" />
    <result column="latitude" jdbcType="DECIMAL" property="latitude" />
    <result column="level" jdbcType="INTEGER" property="level" />
    <result column="img_url" jdbcType="VARCHAR" property="imgUrl" />
    <result column="state" jdbcType="INTEGER" property="state" />
    <result column="bank_card" jdbcType="VARCHAR" property="bankCard" />
    <result column="total_payment_amount" jdbcType="DECIMAL" property="totalPaymentAmount" />
    <result column="commission" jdbcType="DECIMAL" property="commission" />
    <result column="freight" jdbcType="DECIMAL" property="freight" />
    <result column="total_points" jdbcType="BIGINT" property="totalPoints" />
    <result column="superior_id" jdbcType="BIGINT" property="superiorId" />
    <result column="created_by" jdbcType="BIGINT" property="createdBy" />
    <result column="created_date" jdbcType="TIMESTAMP" property="createdDate" />
    <result column="last_updated_by" jdbcType="BIGINT" property="lastUpdatedBy" />
    <result column="last_updated_date" jdbcType="TIMESTAMP" property="lastUpdatedDate" />
    <result column="remove_flag" jdbcType="INTEGER" property="removeFlag" />
    <result column="deposit_paid" jdbcType="DECIMAL" property="depositPaid" />
    <result column="pay_pass_word" jdbcType="VARCHAR" property="payPassWord" />
    <result column="balance" jdbcType="DECIMAL" property="balance" />
    <result column="cash_roll" jdbcType="DECIMAL" property="cashRoll" />
  </resultMap>
  <sql id="BsdUser_Column_List">
    id, org_id, user_type, code, login_name, phone, name,short_name,register_attachment_url,password, contact_user_name,
    address, longitude, latitude, level, img_url, state, bank_card, total_payment_amount,commission,freight,
    total_points, superior_id, created_by, created_date, last_updated_by, last_updated_date, 
    remove_flag, deposit_paid, pay_pass_word, balance, cash_roll
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BsdUserResultMap">
    select
    <include refid="BsdUser_Column_List" />
    from bsd_user
    where id = #{id}
  </select>

  <select id="getUserById" parameterType="java.lang.Long" resultMap="BsdUserResultMap">
    select
    <include refid="BsdUser_Column_List" />
    from bsd_user
    where id = #{id}
  </select>



</mapper>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>主页</title>
</head>
<body>

    <h1>欢迎登陆甘雨路主页</h1>
    <div>登陆时间：${time}</div>
    <div>登陆人：${loginName}</div>


</body>
</html>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <typeAlias alias="Integer" type="java.lang.Integer" />
        <typeAlias alias="Long" type="java.lang.Long" />
        <typeAlias alias="HashMap" type="java.util.HashMap" />
        <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />
        <typeAlias alias="ArrayList" type="java.util.ArrayList" />
        <typeAlias alias="LinkedList" type="java.util.LinkedList" />
    </typeAliases>
</configuration>

# 页面默认前缀目录
spring.mvc.view.prefix=/WEB-INF/jsp/
# 响应页面默认后缀
spring.mvc.view.suffix=.jsp

#swagger
modulePath=/lf

#数据源配置
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/bsdmxm?useUnicode=true&characterEncoding=utf8
spring.datasource.username = bs
spring.datasource.password = bs7

#mybatis 配置
mybatis.config-locations=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:lf/mapper/xml/*.xml
mybatis.type-aliases-package=lf.entity

<!-- mybatis-plus begin -->
<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatisplus-spring-boot-starter</artifactId>
  <version>1.0.4</version>
</dependency>
<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus</artifactId>
  <version>2.1.2</version>
</dependency>
<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mybatis-plus end -->

<!-- druid阿里巴巴数据库连接池 -->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.1.3</version>
</dependency>
<!--MysqL-->
<dependency>
  <groupId>MysqL</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
</dependency>
<dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>1.3.1</version>
</dependency>

server:
  port: 8080

#spring
spring:
 devtools:
  restart:
   enabled: true   #这里是为了热部署的，与mybatis是无关的

 #DATABASE CONfig
 datasource:
  driver-class-name: com.MysqL.jdbc.Driver
  username: root
  password: root
  url: jdbc:MysqL://MysqLdb:3306/tdx_shop?useUnicode=true&characterEncoding=utf-8
  type: com.alibaba.druid.pool.DruidDataSource  #这里是配置druid连接池，以下都是druid的配置信息
  filters: stat,wall,log4j
  maxActive: 20
  initialSize: 1
  maxWait: 60000
  minIdle: 1
  timeBetweenevictionRunsMillis: 60000
  minevictableIdleTimeMillis: 300000
  validationQuery: select 'x'
  testWhileIdle: true
  testOnBorrow: false
  testOnReturn: false
  poolPreparedStatements: true
  maxOpenPreparedStatements: 20
  connection-properties: druid.stat.merggsql=ture;druid.stat.slowsqlMillis=5000

#mybatis
mybatis:
 mapper-locations: classpath*:/mapper/**Mapper.xml  #把xml文件放在com.XX.mapper.*中可能会出现找到的问题，这里把他放在resource下的mapper中
 #实体扫描，多个package用逗号或者分号分隔
 typeAliasesPackage: com.tdx.account_service.entity #这里是实体类的位置
 configuration:
  map-underscore-to-camel-case: true
  cache-enabled: false
#logging
logging:
 level: warn

package com.tdx.account_service.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import com.baomidou.mybatisplus.MybatisConfiguration;
import com.baomidou.mybatisplus.MybatisXMLLanguageDriver;
import com.baomidou.mybatisplus.entity.GlobalConfiguration;
import com.baomidou.mybatisplus.enums.DBType;
import com.baomidou.mybatisplus.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.plugins.PerformanceInterceptor;
import com.baomidou.mybatisplus.plugins.parser.IsqlParser;
import com.baomidou.mybatisplus.plugins.parser.IsqlParserFilter;
import com.baomidou.mybatisplus.plugins.parser.tenant.TenantHandler;
import com.baomidou.mybatisplus.plugins.parser.tenant.TenantsqlParser;
import com.baomidou.mybatisplus.spring.MybatissqlSessionfactorybean;
import com.baomidou.mybatisplus.spring.boot.starter.SpringBootVFS;
import com.baomidou.mybatisplus.toolkit.PluginUtils;
import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.expression.LongValue;
import org.apache.ibatis.mapping.DatabaseIdProvider;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.reflection.MetaObject;
import org.mybatis.spring.annotation.MapperScan;
import org.mybatis.spring.boot.autoconfigure.MybatisProperties;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.bind.RelaxedPropertyResolver;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.core.io.DefaultResourceLoader;
import org.springframework.core.io.ResourceLoader;
import org.springframework.util.ObjectUtils;
import org.springframework.util.StringUtils;
import javax.sql.DataSource;
import java.sql.sqlException;
import java.util.ArrayList;
import java.util.List;
/**
 * code is far away from bug with the animal protecting
 * ┏┓　　　┏┓
 * ┏┛┻━━━┛┻┓
 * ┃　　　　　　　┃
 * ┃　　　━　　　┃
 * ┃　┳┛　┗┳　┃
 * ┃　　　　　　　┃
 * ┃　　　┻　　　┃
 * ┃　　　　　　　┃
 * ┗━┓　　　┏━┛
 * 　　┃　　　┃神兽保佑
 * 　　┃　　　┃代码无BUG！
 * 　　┃　　　┗━━━┓
 * 　　┃　　　　　　　┣┓
 * 　　┃　　　　　　　┏┛
 * 　　┗┓┓┏━┳┓┏┛
 * 　　　┃┫┫　┃┫┫
 * 　　　┗┻┛　┗┻┛
 *
 *
 * @Description : MybatisPlus配置
 * ---------------------------------
 * @Author : Liang.Guangqing
 * @Date : Create in 2017/9/19 13:54
 */
@Configuration
@EnableConfigurationProperties(MybatisProperties.class)
public class MybatisPlusConfig {
  @Autowired
  private Environment environment;
  private RelaxedPropertyResolver propertyResolver;
  @Autowired
  private DataSource dataSource;
  @Autowired
  private MybatisProperties properties;
  @Autowired
  private ResourceLoader resourceLoader = new DefaultResourceLoader();
  @Autowired(required = false)
  private Interceptor[] interceptors;
  @Autowired(required = false)
  private DatabaseIdProvider databaseIdProvider;

  /**
   * @Description : mybatis-plus sql执行效率插件【生产环境可以关闭】
   * ---------------------------------
   * @Author : Liang.Guangqing
   * @Date : Create in 2017/9/19 13:57
   */
  @Bean
  public PerformanceInterceptor performanceInterceptor() {
    return new PerformanceInterceptor();
  }

  /**
   * 配置DataSource
   * @return
   * @throws sqlException
   */
  @Bean
  public DataSource druidDataSource() throws sqlException {
    this.propertyResolver = new RelaxedPropertyResolver(environment,"spring.datasource.");

    System.out.println("====================注入druid!====================");
    DruidDataSource datasource = new DruidDataSource();
    datasource.setUrl(propertyResolver.getProperty("url"));
    datasource.setDriverClassName(propertyResolver.getProperty("driver-class-name"));
    datasource.setUsername(propertyResolver.getProperty("username"));
    datasource.setPassword(propertyResolver.getProperty("password"));
    datasource.setinitialSize(Integer.valueOf(propertyResolver.getProperty("initial-size")));
    datasource.setMinIdle(Integer.valueOf(propertyResolver.getProperty("min-idle")));
    datasource.setMaxWait(Long.valueOf(propertyResolver.getProperty("max-wait")));
    datasource.setMaxActive(Integer.valueOf(propertyResolver.getProperty("max-active")));
    datasource.setMinevictableIdleTimeMillis(Long.valueOf(propertyResolver.getProperty("min-evictable-idle-time-millis")));
    try {
      datasource.setFilters(propertyResolver.getProperty("filters"));
    } catch (sqlException e) {
      e.printstacktrace();
    }
    return datasource;
  }

  /**
   * @Description : mybatis-plus分页插件
   * ---------------------------------
   * @Author : Liang.Guangqing
   * @Date : Create in 2017/9/19 13:59
   */
  @Bean
  public PaginationInterceptor paginationInterceptor() {
    PaginationInterceptor page = new PaginationInterceptor();
    page.setDialectType("MysqL");
    return page;
  }

  /**
   * 这里全部使用mybatis-autoconfigure 已经自动加载的资源。不手动指定
   * 配置文件和mybatis-boot的配置文件同步
   * @return
   */
  @Bean
  public MybatissqlSessionfactorybean mybatissqlSessionfactorybean() {
    MybatissqlSessionfactorybean mybatisPlus = new MybatissqlSessionfactorybean();
    mybatisPlus.setDataSource(dataSource);
    mybatisPlus.setVfs(SpringBootVFS.class);
    if (StringUtils.hasText(this.properties.getConfigLocation())) {
      mybatisPlus.setConfigLocation(this.resourceLoader.getResource(this.properties.getConfigLocation()));
    }
    mybatisPlus.setConfiguration(properties.getConfiguration());
    if (!ObjectUtils.isEmpty(this.interceptors)) {
      mybatisPlus.setPlugins(this.interceptors);
    }
    // MP 全局配置，更多内容进入类看注释
    GlobalConfiguration globalConfig = new GlobalConfiguration();
    globalConfig.setDbType(DBType.MysqL.name());
    // ID 策略 AUTO->`0`("数据库ID自增") INPUT->`1`(用户输入ID") ID_WORKER->`2`("全局唯一ID") UUID->`3`("全局唯一ID")
    globalConfig.setIdType(2);
    mybatisPlus.setGlobalConfig(globalConfig);
    MybatisConfiguration mc = new MybatisConfiguration();
    mc.setDefaultScriptingLanguage(MybatisXMLLanguageDriver.class);
    mybatisPlus.setConfiguration(mc);
    if (this.databaseIdProvider != null) {
      mybatisPlus.setDatabaseIdProvider(this.databaseIdProvider);
    }
    if (StringUtils.hasLength(this.properties.getTypeAliasesPackage())) {
      mybatisPlus.setTypeAliasesPackage(this.properties.getTypeAliasesPackage());
    }
    if (StringUtils.hasLength(this.properties.getTypeHandlersPackage())) {
      mybatisPlus.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());
    }
    if (!ObjectUtils.isEmpty(this.properties.resolveMapperLocations())) {
      mybatisPlus.setMapperLocations(this.properties.resolveMapperLocations());
    }
    return mybatisPlus;
  }

  /**
   * 注册一个StatViewServlet
   * @return
   */
  @Bean
  public ServletRegistrationBean DruidStatViewServle(){
    //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.
    ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
    //添加初始化参数：initParams
    //白名单：
    // servletRegistrationBean.addInitParameter("allow","127.0.0.1");
    //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry,you are not permitted to view this page.
    // servletRegistrationBean.addInitParameter("deny","192.168.1.73");
    //登录查看信息的账号密码.
    servletRegistrationBean.addInitParameter("loginUsername","root");
    servletRegistrationBean.addInitParameter("loginPassword","root");
    //是否能够重置数据.
    servletRegistrationBean.addInitParameter("resetEnable","false");
    return servletRegistrationBean;
  }

  /**
   * 注册一个：filterRegistrationBean
   *
   * @return
   */
  @Bean
  public FilterRegistrationBean druidStatFilter(){
    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
    //添加过滤规则.
    filterRegistrationBean.addUrlPatterns("/*");
    //添加不需要忽略的格式信息.
    filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
    return filterRegistrationBean;
  }



}

<dependency>
  <groupId>org.apache.veLocity</groupId>
  <artifactId>veLocity-engine-core</artifactId>
  <version>2.0</version>
</dependency>

/**
 * copyright (c) 2011-2016,hubin (jobob@qq.com).
 * <p>
 * Licensed under the Apache License,Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing,software
 * distributed under the License is distributed on an "AS IS" BASIS,WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND,either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
package com.tdx.account_service.generator;
import java.io.File;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.enums.FieldFill;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.FileOutConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.TemplateConfig;
import com.baomidou.mybatisplus.generator.config.converts.MysqLTypeConvert;
import com.baomidou.mybatisplus.generator.config.po.TableFill;
import com.baomidou.mybatisplus.generator.config.po.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.DbColumnType;
import com.baomidou.mybatisplus.generator.config.rules.DbType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;

/**
 *code is far away from bug with the animal protecting
 * ┏┓　　　┏┓
 *┏┛┻━━━┛┻┓
 *┃　　　　　　　┃ 　
 *┃　　　━　　　┃
 *┃　┳┛　┗┳　┃
 *┃　　　　　　　┃
 *┃　　　┻　　　┃
 *┃　　　　　　　┃
 *┗━┓　　　┏━┛
 *　　┃　　　┃神兽保佑
 *　　┃　　　┃代码无BUG！
 *　　┃　　　┗━━━┓
 *　　┃　　　　　　　┣┓
 *　　┃　　　　　　　┏┛
 *　　┗┓┓┏━┳┓┏┛
 *　　　┃┫┫　┃┫┫
 *　　　┗┻┛　┗┻┛
 *　　
 *  @Description : MybatisPlus代码生成器
 *  ---------------------------------
 *  @Author : Liang.Guangqing
 *  @Date : Create in 2017/9/19 14:48　
 */
public class MysqLGenerator {
  private static String packageName="account_service";  //文件路径
  private static String authorName="Liang.Guangqing";   //作者
  private static String table="sc_user";         //table名字
  private static String prefix="sc_";           //table前缀
  private static File file = new File(packageName);
  private static String path = file.getAbsolutePath();
  public static void main(String[] args) {
    // 自定义需要填充的字段
    List<TableFill> tableFillList = new ArrayList<>();
    tableFillList.add(new TableFill("ASDD_SS",FieldFill.INSERT_UPDATE));
    // 代码生成器
    AutoGenerator mpg = new AutoGenerator().setGlobalConfig(
        // 全局配置
        new GlobalConfig()
            .setoutputDir(path+"/src/main/java")//输出目录
            .setFileOverride(true)// 是否覆盖文件
            .setActiveRecord(true)// 开启 activeRecord 模式
            .setEnableCache(false)// XML 二级缓存
            .setBaseResultMap(true)// XML ResultMap
            .setBaseColumnList(true)// XML columList
            .setopen(false)//生成后打开文件夹
            .setAuthor(authorName)
        // 自定义文件命名，注意 %s 会自动填充表实体属性！
         .setMapperName("%sMapper")
         .setXmlName("%sMapper")
         .setServiceName("%sService")
         .setServiceImplName("%sServiceImpl")
         .setControllerName("%sController")
    ).setDataSource(
        // 数据源配置
        new DataSourceConfig()
            .setDbType(DbType.MysqL)// 数据库类型
            .setTypeConvert(new MysqLTypeConvert() {
              // 自定义数据库表字段类型转换【可选】
              @Override
              public DbColumnType processtypeConvert(String fieldType) {
                System.out.println("转换类型：" + fieldType);
                // if ( fieldType.toLowerCase().contains( "tinyint" ) ) {
                //  return DbColumnType.BOOLEAN;
                // }
                return super.processtypeConvert(fieldType);
              }
            })
            .setDriverName("com.MysqL.jdbc.Driver")
            .setUsername("root")
            .setPassword("root")
            .setUrl("jdbc:MysqL://127.0.0.1:3306/tdx_shop?characterEncoding=utf8")
    ).setStrategy(
        // 策略配置
        new StrategyConfig()
            // .setCapitalMode(true)// 全局大写命名
            //.setDbColumnUnderline(true)//全局下划线命名
            .setTablePrefix(new String[]{prefix})// 此处可以修改为您的表前缀
            .setNaming(NamingStrategy.underline_to_camel)// 表名生成策略
            .setInclude(new String[] { table }) // 需要生成的表
            .setRestControllerStyle(true)
            //.setExclude(new String[]{"test"}) // 排除生成的表
            // 自定义实体父类
            // .setSuperEntityClass("com.baomidou.demo.TestEntity")
            // 自定义实体，公共字段
            //.setSuperEntityColumns(new String[]{"test_id"})
            .setTableFillList(tableFillList)
        // 自定义 mapper 父类
        // .setSuperMapperClass("com.baomidou.demo.TestMapper")
        // 自定义 service 父类
        // .setSuperServiceClass("com.baomidou.demo.TestService")
        // 自定义 service 实现类父类
        // .setSuperServiceImplClass("com.baomidou.demo.TestServiceImpl")
        // 自定义 controller 父类
        .setSuperControllerClass("com.tdx."+packageName+".controller.AbstractController")
        // 【实体】是否生成字段常量（默认 false）
        // public static final String ID = "test_id";
        // .setEntityColumnConstant(true)
        // 【实体】是否为构建者模型（默认 false）
        // public User setName(String name) {this.name = name; return this;}
        // .setEntityBuilderModel(true)
        // 【实体】是否为lombok模型（默认 false）<a href="https://projectlombok.org/" rel="external nofollow" >document</a>
        // .setEntityLombokModel(true)
        // Boolean类型字段是否移除is前缀处理
        // .setEntityBooleanColumnRemoveIsPrefix(true)
        // .setRestControllerStyle(true)
        // .setControllerMappingHyphenStyle(true)
    ).setPackageInfo(
        // 包配置
        new PackageConfig()
            //.setModuleName("User")
            .setParent("com.tdx."+packageName)// 自定义包路径
            .setController("controller")// 这里是控制器包名，默认 web
            .setEntity("entity")
            .setMapper("dao")
            .setService("service")
            .setServiceImpl("service.impl")
            //.setXml("mapper")
    ).setCfg(
        // 注入自定义配置，可以在 VM 中使用 cfg.abc 设置的值
        new InjectionConfig() {
          @Override
          public void initMap() {
            Map<String,Object> map = new HashMap<>();
            map.put("abc",this.getConfig().getGlobalConfig().getAuthor() + "-mp");
            this.setMap(map);
          }
        }.setFileOutConfigList(Collections.<FileOutConfig>singletonList(new FileOutConfig("/templates/mapper.xml.vm") {
          // 自定义输出文件目录
          @Override
          public String outputFile(TableInfo tableInfo) {
            return path+"/src/main/resources/mapper/" + tableInfo.getEntityName() + "Mapper.xml";
          }
        }))
    ).setTemplate(
        // 关闭默认 xml 生成，调整生成 至 根目录
        new TemplateConfig().setXml(null)
        // 自定义模板配置，模板可以参考源码 /mybatis-plus/src/main/resources/template 使用 copy
        // 至您项目 src/main/resources/template 目录下，模板名称也可自定义如下配置：
        // .setController("...");
        // .setEntity("...");
        // .setMapper("...");
        // .setXml("...");
        // .setService("...");
        // .setServiceImpl("...");
    );

    // 执行生成
    mpg.execute();

    // 打印注入设置，这里演示模板里面怎么获取注入内容【可无】
    System.err.println(mpg.getCfg().getMap().get("abc"));
  }
}

package ${package.Controller};
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
#if(${restControllerStyle})
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
#else
import org.springframework.stereotype.Controller;
#end
#if(${superControllerClasspackage})
import ${superControllerClasspackage};
#end
import org.springframework.beans.factory.annotation.Autowired;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import ${package.Service}.${table.serviceName};
import ${package.Entity}.common.DatatablesJSON;
import ${package.Entity}.common.JSONResult;
import ${package.Entity}.${entity};
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
 *code is far away from bug with the animal protecting
 * ┏┓　　　┏┓
 *┏┛┻━━━┛┻┓
 *┃　　　　　　　┃ 　
 *┃　　　━　　　┃
 *┃　┳┛　┗┳　┃
 *┃　　　　　　　┃
 *┃　　　┻　　　┃
 *┃　　　　　　　┃
 *┗━┓　　　┏━┛
 *　　┃　　　┃神兽保佑
 *　　┃　　　┃代码无BUG！
 *　　┃　　　┗━━━┓
 *　　┃　　　　　　　┣┓
 *　　┃　　　　　　　┏┛
 *　　┗┓┓┏━┳┓┏┛
 *　　　┃┫┫　┃┫┫
 *　　　┗┻┛　┗┻┛
 *　　
 *  @description : ${entity} 控制器
 *  ---------------------------------
 *   @author ${author}
 *  @since ${date}
 */
#if(${restControllerStyle})
@RestController
#else
@Controller
#end
@RequestMapping("#if(${package.ModuleName})/${package.ModuleName}#end/#if(${controllerMappingHyphenStyle})${controllerMappingHyphen}#else${table.entityPath}#end")
#if(${superControllerClass})
public class ${table.controllerName} extends ${superControllerClass} {
#else
public class ${table.controllerName} {
#end
  private final Logger logger = LoggerFactory.getLogger(${table.controllerName}.class);
  @Autowired
  public ${table.serviceName} ${table.entityPath}Service;

  /**
   * @description : 获取分页列表
   * ---------------------------------
   * @author : ${author}
   * @since : Create in ${date}
   */
  @RequestMapping(value = "/get${entity}List",method = RequestMethod.POST)
  public Object get${entity}List(${entity} param,@RequestParam(value = "draw",defaultValue = "0") Integer draw,@RequestParam(value = "length") Integer length,@RequestParam(value = "start") Integer start) {
      DatatablesJSON<${entity}> resJson=new DatatablesJSON<>();
      try {
        Integer pageNo=getPageNo(start,length);
        Page<${entity}> page=new Page<${entity}>(pageNo,length);
        ${table.entityPath}Service.selectPage(page,new EntityWrapper<${entity}>(param));
        resJson.setDraw(draw++);
        resJson.setRecordsTotal(page.getTotal());
        resJson.setRecordsFiltered(page.getTotal());
        resJson.setData(page.getRecords());
        resJson.setSuccess(true);
      }catch (Exception e){
        resJson.setSuccess(false);
        resJson.setError("异常信息:{"+e.getClass().getName()+"}");
        logger.info("异常信息:{}"+e.getMessage());
      }
      return resJson;
  }

  /**
   * @description : 通过id获取${entity}
   * ---------------------------------
   * @author : ${author}
   * @since : Create in ${date}
   */
  @RequestMapping(value = "/get${entity}ById",method = RequestMethod.GET)
  public Object get${entity}ById(String id) {
      JSONResult<${entity}> resJson = new JSONResult<>();
      try {
        ${entity} param= ${table.entityPath}Service.selectById(id);
        resJson.setData(param);
        resJson.setSuccess(true);
      }catch (Exception e) {
        resJson.setSuccess(false);
        resJson.setMessage("异常信息:{"+e.getClass().getName()+"}");
        logger.info("异常信息:{}"+e.getMessage());
      }
      return resJson;
  }

  /**
   * @description : 通过id删除${entity}
   * ---------------------------------
   * @author : ${author}
   * @since : Create in ${date}
   */
  @RequestMapping(value = "/delete${entity}ById",method = RequestMethod.GET)
  public Object delete${entity}ById(String id) {
      JSONResult<${entity}> resJson = new JSONResult<>();
      try{
        resJson.setSuccess(${table.entityPath}Service.deleteById(id));
      }catch (Exception e) {
        resJson.setSuccess(false);
        resJson.setMessage("异常信息:{"+e.getClass().getName()+"}");
        logger.info("异常信息:{}"+e.getMessage());
      }
      return resJson;
  }

  /**
   * @description : 通过id更新${entity}
   * ---------------------------------
   * @author : ${author}
   * @since : Create in ${date}
   */
  @RequestMapping(value = "/update${entity}ById",method = RequestMethod.POST)
  public Object update${entity}ById(${entity} param) {
      JSONResult<${entity}> resJson = new JSONResult<>();
      try{
        resJson.setSuccess(${table.entityPath}Service.updateById(param));
      }catch (Exception e) {
        resJson.setSuccess(false);
        resJson.setMessage("异常信息:{"+e.getClass().getName()+"}");
        logger.info("异常信息:{}"+e.getMessage());
      }
      return resJson;
  }

  /**
   * @description : 添加${entity}
   * ---------------------------------
   * @author : ${author}
   * @since : Create in ${date}
   */
  @RequestMapping(value = "/add${entity}",method = RequestMethod.POST)
  public Object add${entity}(${entity} param) {
      JSONResult<${entity}> resJson = new JSONResult<>();
      try{
        resJson.setSuccess(${table.entityPath}Service.insert(param));
      }catch (Exception e) {
        resJson.setSuccess(false);
        resJson.setMessage("异常信息:{"+e.getClass().getName()+"}");
        logger.info("异常信息:{}"+e.getMessage());
      }
      return resJson;
  }
}

  /**
   * 分页 PAGE
   */
  @GetMapping("/test")
  public Page<User> test() {
    return userService.selectPage(new Page<User>(0,12));
  }

  /**
   * AR 部分测试
   */
  @GetMapping("/test1")
  public Page<User> test1() {
    User user = new User();
    System.err.println("删除所有：" + user.delete(null));
    //user.setId(2017091801L);
    user.setAccout("test"+num++);
    user.setType("test");
    user.setCreateTime(new Date());
    user.setPhone("13111110000");
    user.setPassword("123456");
    user.setNickname("guangqing"+2*num++);
    user.insert();
    System.err.println("查询插入结果：" + user.selectById().toString());
    //user.setNickname("mybatis-plus-ar");
    System.err.println("更新：" + user.updateById());
    return user.selectPage(new Page<User>(0,12),null);
  }

  /**
   * 增删改查 CRUD
   */
  @GetMapping("/test2")
  public User test2() {
    User user = new User();
    user.setId(123456L);
    user.setAccout("test");
    user.setType("test");
    user.setCreateTime(new Date());
    user.setPhone("13111110000");
    user.setPassword("123456");
    user.setNickname("guangqing");
    System.err.println("删除一条数据：" + userService.deleteById(1L));
    System.err.println("插入一条数据：" + userService.insert(user));
    User user2 = new User();
    user.setId(223456L);
    user.setAccout("test2");
    user.setType("test");
    user.setCreateTime(new Date());
    user.setPhone("13111110000");
    user.setPassword("123456");
    user.setNickname("guangqing");
    boolean result = userService.insert(user);
    // 自动回写的ID
    Long id = user.getId();
    System.err.println("插入一条数据：" + result + ",插入信息：" + user.toString());
    System.err.println("查询：" + userService.selectById(id).toString());
    Page<User> userListPage = userService.selectPage(new Page<User>(1,5),new EntityWrapper<>(new User()));
    System.err.println("total=" + userListPage.getTotal() + ",current list size=" + userListPage.getRecords().size());
    return userService.selectById(1L);
  }

  @GetMapping("testSelect")
  public Object testSelect() {
    Integer start = 0;
    Integer length =10;
    User param = new User();
    //param.setNickname("guangqing2");
    Integer pageNo=getPageNo(start,length);
    Page<User> page =new Page<User>(pageNo,length);
    EntityWrapper<User> ew = new EntityWrapper<User>();
    ew.setEntity(param);
    ew.where("password={0}","123456")
        .like("nickname","guangqing")
        .ge("create_time","2017-09-21 15:50:00");
    userService.selectPage(page,ew);
    DatatablesJSON<User> resJson= new DatatablesJSON<>();
    //resJson.setDraw(draw++);
    resJson.setRecordsTotal(page.getTotal());
    resJson.setRecordsFiltered(page.getTotal());
    resJson.setData(page.getRecords());
    return resJson;
  }


  @GetMapping("/selectsql")
  public Object getUserBysql() {
    JSONObject result = new JSONObject();
    result.put("records",userService.selectListBysql());
    return result;
  }

  /**
   * 7、分页 size 一页显示数量 current 当前页码
   * 方式一：http://localhost:8080/user/page?size=1¤t=1<br>
   * 方式二：http://localhost:8080/user/pageHelper?size=1¤t=1<br>
   */

  // 参数模式分页
  @GetMapping("/page")
  public Object page(Page page) {
    return userService.selectPage(page);
  }

  // ThreadLocal 模式分页
  @GetMapping("/pageHelper")
  public Object pageHelper(Page page) {
    pageHelper.setPagination(page);
    page.setRecords(userService.selectList(null));
    page.setTotal(pageHelper.freetotal());//获取总数并释放资源 也可以 pageHelper.getTotal()
    return page;
  }


  /**
   * 测试事物
   * http://localhost:8080/user/test_transactional<br>
   * 访问如下并未发现插入数据说明事物可靠！！<br>
   * http://localhost:8080/user/test<br>
   * <br>
   * 启动 Application 加上 @EnableTransactionManagement 注解其实可无默认貌似就开启了<br>
   * 需要事物的方法加上 @Transactional 必须的哦！！
   */
  @Transactional
  @GetMapping("/test_transactional")
  public void testTransactional() {
    //userService.insert(new User(1000L,"测试事物",16,3));
    System.out.println(" 这里手动抛出异常，自动回滚数据");
    throw new RuntimeException();
  }

您可能感兴趣的文章:

• 详解Spring boot上配置与使用mybatis plus
• SpringBoot Mybatis Plus公共字段自动填充功能