FAQ

编译错误问题
- log日志编译错误
运行错误问题
代码生成器问题
Swagger问题
- 不能访问swagger页面
- LocalDateTime日期类使用问题
运维部署问题
- 项目打包后，依赖包丢失
- Could not find artifact junit:junit:jar:4.12
分页问题
根据实体类中的属性名称，获取表对应的列名称
Other问题

编译错误问题

log日志编译错误

log报错

编译提示log.info等日志错误

解决

检查是否安装lombok插件
idea安装lombok
eclipse安装lombok

运行错误问题

MySQL错误

2019-07-31 14:16:52.412 ERROR 14724 --- [           main] com.alibaba.druid.pool.DruidDataSource   : init datasource error, url: jdbc:mysql://localhost:3306/spring_boot_plus?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

不能连接mysql

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

解决

检查MySQL服务是否启动
检查ip地址和端口号

未知数据库

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'spring_boot_plus'

解决

检查是否新建spring_boot_plus数据库
默认的数据库为spring_boot_plus，可在不同环境的配置文件中更改
例如：application-local.yml中的spring.datasource.url中更改数据库名称

Redis错误

org.springframework.data.redis.connection.PoolException: Could not get a resource from the pool; nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379

不能连接redis

Unable to connect to localhost:6379

解决

启动redis服务
redis默认端口号：6379
默认没有设置密码
请根据环境情况，进行配置

端口已被占用

Caused by: java.net.BindException: Address already in use: bind

Caused by: java.net.BindException: Address already in use: bind
	at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_191]
	at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_191]
	at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_191]
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_191]
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_191]

详细错误日志

2019-08-02 23:23:41.350 ERROR 23380 --- [           main] org.apache.catalina.util.LifecycleBase   : Failed to start component [Connector[HTTP/1.1-8888]]

org.apache.catalina.LifecycleException: Protocol handler start failed
	at org.apache.catalina.connector.Connector.startInternal(Connector.java:1008) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.StandardService.addConnector(StandardService.java:227) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.addPreviouslyRemovedConnectors(TomcatWebServer.java:263) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.start(TomcatWebServer.java:195) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.startWebServer(ServletWebServerApplicationContext.java:296) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:162) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) [spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:742) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:389) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:311) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1213) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1202) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at io.geekidea.springbootplus.SpringBootPlusApplication.main(SpringBootPlusApplication.java:51) [classes/:na]
Caused by: java.net.BindException: Address already in use: bind
	at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_191]
	at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_191]
	at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_191]
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_191]
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_191]
	at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:230) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:213) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1124) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.util.net.AbstractEndpoint.start(AbstractEndpoint.java:1210) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.coyote.AbstractProtocol.start(AbstractProtocol.java:585) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.connector.Connector.startInternal(Connector.java:1005) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	... 14 common frames omitted

2019-08-02 23:23:41.356  INFO 23380 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2019-08-02 23:23:41.362  WARN 23380 --- [           main] o.a.c.loader.WebappClassLoaderBase       : The web application [ROOT] appears to have started a thread named [lettuce-eventExecutorLoop-1-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
 java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:467)
 io.netty.util.concurrent.SingleThreadEventExecutor.takeTask(SingleThreadEventExecutor.java:252)
 io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:64)
 io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:906)
 io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
 io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
 java.lang.Thread.run(Thread.java:748)
2019-08-02 23:23:41.363  WARN 23380 --- [           main] o.a.c.loader.WebappClassLoaderBase       : The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Create-1916224178] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
 com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2672)
2019-08-02 23:23:41.364  WARN 23380 --- [           main] o.a.c.loader.WebappClassLoaderBase       : The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Destroy-1916224178] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 java.lang.Thread.sleep(Native Method)
 com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2768)
2019-08-02 23:23:41.377  INFO 23380 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2019-08-02 23:23:41.383 ERROR 23380 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 

***************************
APPLICATION FAILED TO START
***************************

Description:

The Tomcat connector configured to listen on port 8888 failed to start. The port may already be in use or the connector may be misconfigured.

Action:

Verify the connector's configuration, identify and stop any process that's listening on port 8888, or configure this application to listen on another port.

2019-08-02 23:23:41.410  INFO 23380 --- [           main] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
2019-08-02 23:23:41.413  INFO 23380 --- [           main] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService
2019-08-02 23:23:41.414  INFO 23380 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2019-08-02 23:23:41.417  INFO 23380 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...
2019-08-02 23:23:41.421  INFO 23380 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed

Process finished with exit code 1

解决

修改端口： application.local.yml中的port，默认端口8888

或者kill掉对应端口的进程
Mac/linux：kill端口
Windows：找到对应的java程序，结束任务

Spring Boot Admin不能访问问题

你的主机中的软件中止了一个已建立的连接

2019-07-31 16:33:37.205 ERROR 6696 --- [ctor-http-nio-2] o.s.w.s.adapter.HttpWebHandlerAdapter    : [f4aeb71d] Error [java.io.IOException: 你的主机中的软件中止了一个已建立的连接。] for HTTP GET "/applications", but ServerHttpResponse already committed (200 OK)

解决

8888端口：与当前项目端口一致

yaml配置

spring:
  boot:
    admin:
      client:
        url: 'http://localhost:8888'
management:
  endpoints:
    web:
      exposure:
        include: "*"
  endpoint:
    health:
      show-details: ALWAYS

properties配置

spring.boot.admin.client.url=http://localhost:8888
management.endpoints.web.exposure.include=*
management.endpoint.health.show-details=ALWAYS

代码生成器问题

Swagger问题

不能访问swagger页面

{"code":404,"data":null,"msg":"你请求的路径不存在","time":"2019-08-01 12:56:27"}

解决

检查WebMvcConfig.java类中是否排除了swagger静态资源

@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
    registry.addResourceHandler("swagger-ui.html")
            .addResourceLocations("classpath:/META-INF/resources/");
    registry.addResourceHandler("/webjars/**")
            .addResourceLocations("classpath:/META-INF/resources/webjars/");
}

LocalDateTime日期类使用问题

Caused by: java.sql.SQLFeatureNotSupportedException

Caused by: java.sql.SQLFeatureNotSupportedException
	at com.alibaba.druid.pool.DruidPooledResultSet.getObject(DruidPooledResultSet.java:1771)
	at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:38)
	at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:28)
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81)

org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'create_time' from result set.  Cause: java.sql.SQLFeatureNotSupportedException
; null; nested exception is java.sql.SQLFeatureNotSupportedException

	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:96)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy134.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
	at com.sun.proxy.$Proxy139.getSysLogById(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)

问题原因是JDK8的LocalDate、LocalTime、LocalDateTime日期类型，druid数据源尚不支持
druid issues

目前解决办法

1. 更换数据源
1. 在mybatis-plus生成代码中配置，将日期类型生成为DateType.ONLY_DATE，数据库中的日期类型生成为Date

// 全局配置
GlobalConfig gc = new GlobalConfig();
gc.setDateType(DateType.ONLY_DATE); // 设置日期类型为Date

mybatis-plus dateType配置

运维部署问题

项目打包后，依赖包丢失

spring-boot-plus.jar只有100多kb
此时依赖包未打包到主jar中，检查pom.xml配置

spring-boot-plus项目中，pom.xml没有直接继承spring-boot-starter-parent

而是导入spring-boot-dependencies依赖

这样做的好处是，项目可以继承自己的父pom

使用这种方式，进行打包，默认情况下，会导致依赖包丢失，需进行以下配置

<plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
    <configuration>
        <mainClass>io.geekidea.springbootplus.SpringBootPlusApplication</mainClass>
    </configuration>
    <executions>
        <execution>
            <goals>
                <goal>repackage</goal>
            </goals>
        </execution>
    </executions>
</plugin>

mainClass：项目启动类
repackage：重新打包

Could not find artifact junit:junit:jar:4.12

::: dander Could not find artifact junit:junit:jar:4.12

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project spring-boot-plus: Execution default-test of goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test failed: Plugin org.apache.maven.plugins:maven-surefire-plugin:2.22.2 or one of its dependencies could not be resolved: The following artifacts could not be resolved: junit:junit:jar:4.12, org.hamcrest:hamcrest-core:jar:1.3: Could not find artifact junit:junit:jar:4.12 -> [Help 1]

:::

解决

<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
</dependency>

分页问题

keyword字段使用

POST http://127.0.0.1:8888/sysUser/getPageList

请求参数

{
    "keyword": "adm"
}

SysUserQueryParam.java

只使用keyword时，查询参数对象可为空，QueryParam.java父类中有keyword字段

@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = true)
@ApiModel(value = "SysUserQueryParam对象", description = "系统用户查询参数")
public class SysUserQueryParam extends OrderQueryParam {

}

SysUserMapper.xml

xml中使用param获取keyword，需要模糊查询的字段需要自定义

<select id="getSysUserPageList" resultType="io.geekidea.springbootplus.system.vo.SysUserQueryVo">
    select
    <include refid="Base_Column_List"/>
    from sys_user
    where deleted = 0
    <if test="param.keyword != null and param.keyword != ''">
        and (
            username like concat('%', #{param.keyword} ,'%') or
            nickname like concat('%', #{param.keyword} ,'%')
            )
    </if>
</select>

响应结果

{
  "code": 200,
  "msg": "操作成功",
  "success": true,
  "data": {
    "total": "1",
    "records": [
      {
        "id": "1",
        "username": "admin",
        "nickname": "管理员",
        "phone": "15888889900",
        "gender": 1,
        "head": "http://localhost:8888/api/resource/201908201013068.png",
        "remark": "Administrator Account",
        "state": 1,
        "departmentId": "1",
        "roleId": "1",
        "deleted": 0,
        "version": 1,
        "createTime": "2020-02-26 00:00:00",
        "updateTime": "2019-10-27 23:32:29"
      }
    ]
  },
  "time": "2020-03-01 21:39:09"
}

SQL查询语句

==>  Preparing: SELECT COUNT(1) FROM sys_user WHERE deleted = 0 AND (username LIKE concat('%', ?, '%') OR nickname LIKE concat('%', ?, '%')) 
==> Parameters: adm(String), adm(String)
<==    Columns: COUNT(1)
<==        Row: 1
==>  Preparing: SELECT id, username, nickname, phone, gender, head, remark, state, department_id, role_id, deleted, version, create_time, update_time FROM sys_user WHERE deleted = 0 AND (username LIKE concat('%', ?, '%') OR nickname LIKE concat('%', ?, '%')) ORDER BY create_time DESC LIMIT ?,? 
==> Parameters: adm(String), adm(String), 0(Long), 10(Long)
<==    Columns: id, username, nickname, phone, gender, head, remark, state, department_id, role_id, deleted, version, create_time, update_time
<==        Row: 1, admin, 管理员, 15888889900, 1, http://localhost:8888/api/resource/201908201013068.png, Administrator Account, 1, 1, 1, 0, 1, 2020-02-26 00:00:00.0, 2019-10-27 23:32:29.0
<==      Total: 1

重点查询条件语句

where deleted = 0
    and (
        username like concat('%', ? ,'%') or
        nickname like concat('%', ? ,'%')
        )

如何使用自定义查询条件

SysUserQueryParam.java

@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = true)
@ApiModel(value = "SysUserQueryParam对象", description = "系统用户查询参数")
public class SysUserQueryParam extends OrderQueryParam {

    private static final long serialVersionUID = -1115907077988380787L;

    @ApiModelProperty("用户名")
    private String username;

    @ApiModelProperty("昵称")
    private String nickname;

    @ApiModelProperty("状态，0：禁用，1：启用，2：锁定")
    private Integer state;

    @ApiModelProperty("创建时间开始")
    private Date createTimeStart;

    @ApiModelProperty("创建时间结束")
    private Date createTimeEnd;

}

请求参数

{
   "username":  "adm",
   "state":  1,
  "createTimeStart": "2020-02-26",
  "createTimeEnd": "2020-02-27"
}

SysUserMapper.xml

<select id="getSysUserPageList" resultType="io.geekidea.springbootplus.system.vo.SysUserQueryVo">
    select
    <include refid="Base_Column_List"/>
    from sys_user
    where deleted = 0
    <if test="param.keyword != null and param.keyword != ''">
        and (
            username like concat('%', #{param.keyword} ,'%') or
            nickname like concat('%', #{param.keyword} ,'%')
            )
    </if>
    <if test="param.username != null and param.username != ''">
        and username like concat('%', #{param.username} ,'%')
    </if>
    <if test="param.nickname != null and param.nickname != ''">
        and nickname like concat('%', #{param.nickname} ,'%')
    </if>
    <if test="param.state != null">
        and state = #{param.state}
    </if>
    <if test="param.createTimeStart != null">
        and date_format(create_time,'%Y-%m-%d') >= date_format(#{param.createTimeStart},'%Y-%m-%d')
    </if>
    <if test="param.createTimeEnd != null">
        and date_format(create_time,'%Y-%m-%d') &lt;= date_format(#{param.createTimeEnd},'%Y-%m-%d')
    </if>
</select>

响应结果

{
  "code": 200,
  "msg": "操作成功",
  "success": true,
  "data": {
    "total": "1",
    "records": [
      {
        "id": "1",
        "username": "admin",
        "nickname": "管理员",
        "phone": "15888889900",
        "gender": 1,
        "head": "http://localhost:8888/api/resource/201908201013068.png",
        "remark": "Administrator Account",
        "state": 1,
        "departmentId": "1",
        "roleId": "1",
        "deleted": 0,
        "version": 1,
        "createTime": "2020-02-26 00:00:00",
        "updateTime": "2019-10-27 23:32:29"
      }
    ]
  },
  "time": "2020-03-01 21:43:49"
}

SQL语句

==>  Preparing: SELECT COUNT(1) FROM sys_user WHERE deleted = 0 AND username LIKE concat('%', ?, '%') AND state = ? AND date_format(create_time, '%Y-%m-%d') >= date_format(?, '%Y-%m-%d') AND date_format(create_time, '%Y-%m-%d') <= date_format(?, '%Y-%m-%d') 
==> Parameters: adm(String), 1(Integer), 2020-02-26 00:00:00.0(Timestamp), 2020-02-27 00:00:00.0(Timestamp)
<==    Columns: COUNT(1)
<==        Row: 1
==>  Preparing: SELECT id, username, nickname, phone, gender, head, remark, state, department_id, role_id, deleted, version, create_time, update_time FROM sys_user WHERE deleted = 0 AND username LIKE concat('%', ?, '%') AND state = ? AND date_format(create_time, '%Y-%m-%d') >= date_format(?, '%Y-%m-%d') AND date_format(create_time, '%Y-%m-%d') <= date_format(?, '%Y-%m-%d') ORDER BY create_time DESC LIMIT ?,? 
==> Parameters: adm(String), 1(Integer), 2020-02-26 00:00:00.0(Timestamp), 2020-02-27 00:00:00.0(Timestamp), 0(Long), 10(Long)
<==    Columns: id, username, nickname, phone, gender, head, remark, state, department_id, role_id, deleted, version, create_time, update_time
<==        Row: 1, admin, 管理员, 15888889900, 1, http://localhost:8888/api/resource/201908201013068.png, Administrator Account, 1, 1, 1, 0, 1, 2020-02-26 00:00:00.0, 2019-10-27 23:32:29.0
<==      Total: 1

重点查询条件语句

where deleted = 0
    and username like concat('%', ? ,'%')
    and state = ?
    and date_format(create_time,'%Y-%m-%d') >= date_format(?,'%Y-%m-%d')
    and date_format(create_time,'%Y-%m-%d') <= date_format(?,'%Y-%m-%d')

如何使用排序

asc:true 升序，asc:false 降序

column：列名，目前时对应数据库列名称！！！如需要前端传属性名称，后端获取对应的列名称，请看下面的方法！！！

{
  "orders": [
    {
      "asc": true,
      "column": "update_time"
    }
  ]
}

根据实体类中的属性名称，获取表对应的列名称

分页排序可使用这种方法，前端传属性名称，后端获取列名称

BaseServiceImpl.java 增加处理代码

/**
 * @author geekidea
 * @date 2018-11-08
 */
public abstract class BaseServiceImpl<M extends BaseMapper<T>, T> extends ServiceImpl<M, T> implements BaseService<T> {

    private Class<?> entityClass;

    {
        Class<?> clazz = this.getClass();
        Type type = clazz.getGenericSuperclass();
        if (type instanceof ParameterizedType){
            Type[] p = ((ParameterizedType) type).getActualTypeArguments();  //取得所有泛型
            this.entityClass= (Class<T>) p[1];
        }
    }


    protected Page setPageParam(QueryParam queryParam) {
        return setPageParam(queryParam,null);
    }

    protected Page setPageParam(QueryParam queryParam, OrderItem defaultOrder) {
        Page page = new Page();
        // 设置当前页码
        page.setCurrent(queryParam.getCurrent());
        // 设置页大小
        page.setSize(queryParam.getSize());
        /**
         * 如果是queryParam是OrderQueryParam，并且不为空，则使用前端排序
         * 否则使用默认排序
         */
        if (queryParam instanceof OrderQueryParam){
            OrderQueryParam orderQueryParam = (OrderQueryParam) queryParam;
            List<OrderItem> orderItems = orderQueryParam.getOrders();
            if (CollectionUtils.isEmpty(orderItems)){
                page.setOrders(Arrays.asList(defaultOrder));
            }else{
                convertOrderItem(orderItems);
                page.setOrders(orderItems);
            }
        }else{
            page.setOrders(Arrays.asList(defaultOrder));
        }

        return page;
    }

    protected void convertOrderItem(List<OrderItem> orderItems){
        if (CollectionUtils.isEmpty(orderItems)){
            return;
        }
        orderItems.forEach(orderItem -> {
            String column = orderItem.getColumn();
            orderItem.setColumn(PropertyColumnUtil.getColumn(entityClass,column));
        });
    }

}

重点代码

获取实体类泛型类型


    private Class<?> entityClass;

    {
        Class<?> clazz = this.getClass();
        Type type = clazz.getGenericSuperclass();
        if (type instanceof ParameterizedType){
            Type[] p = ((ParameterizedType) type).getActualTypeArguments();  //取得所有泛型
            this.entityClass= (Class<T>) p[1];
        }
    }

将属性名称转换成列名称

    protected void convertOrderItem(List<OrderItem> orderItems){
        if (CollectionUtils.isEmpty(orderItems)){
            return;
        }
        orderItems.forEach(orderItem -> {
            String column = orderItem.getColumn();
            orderItem.setColumn(PropertyColumnUtil.getColumn(entityClass,column));
        });
    }

新增属性列名获取工具类


package io.geekidea.springbootplus.util;

import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.collections4.MapUtils;
import org.apache.commons.lang3.StringUtils;

import java.util.List;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;
import java.util.stream.Collectors;

/**
 * @author geekidea
 * @date 2020/3/2
 **/
public class PropertyColumnUtil {

    private static Map<Class<?>, Map<String, String>> cacheMap = new ConcurrentHashMap<>();

    public static Map<Class<?>, Map<String, String>> getMap() {
        return cacheMap;
    }

    /**
     * 根据实体class，从mybatisplus中获取对应Table的属性列名Map
     *
     * @param clazz
     * @return
     */
    private static Map<String, String> getTableFieldMap(Class<?> clazz) {
        TableInfo tableInfo = TableInfoHelper.getTableInfo(clazz);
        if (tableInfo == null) {
            return null;
        }
        List<TableFieldInfo> tableFieldInfos = tableInfo.getFieldList();
        if (CollectionUtils.isEmpty(tableFieldInfos)) {
            return null;
        }
        Map<String, String> cacheMap = tableFieldInfos.stream().collect(Collectors.toMap(TableFieldInfo::getProperty, TableFieldInfo::getColumn));
        return cacheMap;
    }

    /**
     * 从本地缓存中获取属性列名map
     *
     * @param clazz
     * @return
     */
    public static Map<String, String> getPropertyColumnMap(Class<?> clazz) {
        Map<String, String> propertyColumnMap = cacheMap.get(clazz);
        if (MapUtils.isEmpty(propertyColumnMap)) {
            // 从TableInfo中获取，并缓存到内存map中
            Map<String, String> fieldMap = getTableFieldMap(clazz);
            if (MapUtils.isEmpty(fieldMap)) {
                return null;
            } else {
                cacheMap.put(clazz, fieldMap);
                return fieldMap;
            }
        } else {
            return propertyColumnMap;
        }
    }

    /**
     * 通过实体class类型和属性名称，从缓存中获取对应的列名
     *
     * @param clazz
     * @param property
     * @return
     */
    public static String getColumn(Class<?> clazz, String property) {
        Map<String, String> propertyColumnMap = getPropertyColumnMap(clazz);
        if (MapUtils.isEmpty(propertyColumnMap)) {
            throw new IllegalArgumentException("没有找到对应的实体映射对象");
        }
        String column = propertyColumnMap.get(property);
        if (StringUtils.isEmpty(column)) {
            throw new IllegalArgumentException("没有找到对应的列");
        }
        return column;
    }

}

前端排序参数

{
  "orders": [
    {
      "asc": true,
      "column": "updateTime"
    }
  ]
}

后台转换后

OrderItem(column=update_time, asc=true)

ORDER BY update_time LIMIT ?,?

Other问题

← XSS跨站脚本攻击处理 IDEA导入spring-boot-plus→

# FAQ

# 编译错误问题

# log日志编译错误

# 运行错误问题

# MySQL错误

# Redis错误

# 端口已被占用

# Spring Boot Admin不能访问问题

# 代码生成器问题

# Swagger问题

# 不能访问swagger页面

# LocalDateTime日期类使用问题

# 运维部署问题

# 项目打包后，依赖包丢失

# Could not find artifact junit:junit:jar:4.12

# 分页问题

# keyword字段使用

# 如何使用自定义查询条件

# 如何使用排序

# 根据实体类中的属性名称，获取表对应的列名称

# BaseServiceImpl.java 增加处理代码

# 新增属性列名获取工具类

# 前端排序参数

# 后台转换后

# Other问题

FAQ