@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> {
    /**
     * 設(shè)置非空性別參數(shù)
     */
    @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);
    }
 
    /**
     * 通過下標(biāo)讀取性別
     */
    @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
}

{
      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>