|  | 
 
| @excel注解,数据库存储的是字典的值,导入导出时显示字典的文本。 
 实体类的对应的属性:
 @Excel(name = "支付方式", width = 15, dicCode = "distribute_payment")
 @ApiModelProperty(value = "支付方式")
 private java.lang.Integer payment;
 代码报错的位置:
 java.sql.SQLException: Incorrect integer value: '单位转账' for column 'payment' at row 1
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
 at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)
 at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
 at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
 
 
 | 
 
  
  |