方法一 easypoi注解+hibernate验证:
导入实体类:
package com.ssish.saas.ln.constant.db.excle;
import cn.afterturn.easypoi.excel.annotation.Excel;
import com.ssish.saas.ln.constant.common.BaseObject;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Pattern;
public class FileAppointmentAccount extends BaseObject {
@Excel(name = "账号")
@NotBlank(message = "账号不能为空")
private String appointmentAccount;
@Excel(name = "密码")
@NotBlank(message = "密码不能为空")
@Pattern(regexp = "^[+-]?\\d+(\\.\\d+)?$",message = "金额格式不对")
private String appointmentPassword;
private Integer servicecententSupplierId;
private Long batchId;
@Excel(name = "错误原因")
private String message;
public String getAppointmentAccount() {
return appointmentA