当前使用版本(必填,否则不予处理)
<mybatis-plus.version>3.4.2</mybatis-plus.version>
该问题是如何引起的?(确定最新版也有问题再提!!!)
分页查询时出现:
实体字段时editTime,数据库是edit_time,分页时如何将实体字段转换为数据库字段?
重现步骤(如果有就写完整)
if (CollectionUtils.isNotEmpty(page.getOrders())) {
OrderItem orderItem = (OrderItem) page.getOrders().get(0);
if("name".equals(orderItem.getColumn())){
queryWrapper.orderBy(true, orderItem.isAsc(),LockerEntity::getName);
}
if("editTime".equals(orderItem.getColumn())){
queryWrapper.orderBy(true, orderItem.isAsc(),LockerEntity::getEditTime);
}
}
报错信息
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'editTime' in 'order clause'
### The error may exist in com/xiaoi/rpa/infrastructure/persistence/mapper/LockerMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id, name, description, creator, create_time, editor, edit_time, is_deleted FROM locker WHERE is_deleted = 0 AND (id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY editTime DESC LIMIT ?
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'editTime' in 'order clause'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'editTime' in 'order clause'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy103.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)