[Java] 解决MyBatis中Enum字段参数解析问题

• 基础Class和TypeHandler
  
• 请求参数解析问题
  
• 问题解决
  

@Data
@Alias(value = "user")
public class User implements Serializable {
  private static final long serialVersionUID = -4947062488310146862L;
 
  private Long id;
 
  @NotNull(message = "用户名不能为空")
  private String userName;
 
  @NotNull(message = "备注不能为空")
  private String note;
 
  @NotNull(message = "性别不能为空")
  private SexEnum sex;
}

@MappedJdbcTypes(JdbcType.INTEGER)
@MappedTypes(value = SexEnum.class)
public class SexTypeHandler extends BaseTypeHandler<SexEnum> {
  /**
   * 设置非空性别参数
   */
  @Override
  public void setNonNullParameter(PreparedStatement preparedStatement, int i, SexEnum sexEnum, JdbcType jdbcType) throws SQLException {
    preparedStatement.setInt(i, sexEnum.getId());
  }
 
  /**
   * 通过列名读取性别
   */
  @Override
  public SexEnum getNullableResult(ResultSet resultSet, String s) throws SQLException {
    int sex = resultSet.getInt(s);
    if (sex != 1 && sex != 2) {
      return null;
    }
    return SexEnum.getEnumById(sex);
  }
 
  /**
   * 通过下标读取性别
   */
  @Override
  public SexEnum getNullableResult(ResultSet resultSet, int i) throws SQLException {
    int sex = resultSet.getInt(i);
    if (sex != 1 && sex != 2) {
      return null;
    }
    return SexEnum.getEnumById(sex);
  }
 
  /**
   * 通过存储过程读取性别
   */
  @Override
  public SexEnum getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
    int sex = callableStatement.getInt(i);
    if (sex != 1 && sex != 2) {
      return null;
    }
    return SexEnum.getEnumById(sex);
  }
}

{
    id: id,
    userName: username,
    sex: sex === 'MALE' ? 1 : 2, // 1: 男，2: 女
    note: note
}

1： MALE
2： FAMALE

2020-03-02 22:59:50.722  WARN 10864 --- [nio-8080-exec-2] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deserialize value of type `cn.zyt.springbootlearning.domain.SexEnum` from number 2: index value outside legal index range [0..1]; nested exception is com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type `cn.zyt.springbootlearning.domain.SexEnum` from number 2: index value outside legal index range [0..1]
 at [Source: (PushbackInputStream); line: 1, column: 40] (through reference chain: cn.zyt.springbootlearning.domain.User["sex"])]

{
    id: id,
    userName: username,
    sex: sex,
    note: note
}

<tr>
  <td>sex:</td>
  <td><select name="sex" value={sex} onChange={this.handleChange}>
  <option value="MALE">MALE</option>
  <option value="FEMALE">FEMALE</option>
  </select></td>
</tr>