springboot+vue实现excel导入-------去重

springboot后台:

数据库:

bean:
 

package com.heeexy.example.bean;

import java.util.Date;

//客户列表
public class KH {
	
	private int id;	
	
	private int userId;
	
	private Date update_time;
	
	private Date create_time;
	
	private int dr=0;
	//客户类型
	private String khlx;
	//客户状态
	private String khzt;
	//所属部门
	private String ssbm;
	//客户名称
	private String khmc;
	//电话
	private double dianhua;
	//手机
	private double shouji;
	//地址
	private String dizhi;
	//最新跟进记录
	private String zuixingenjinjilu;
	//前负责人
	private String qianfzr; 
	//计划状态
	private int status;
	//跟进日期
	private Date genjinriqi;
	//跟进内容
	private String genjinneirong;
	//发起日期
	private Date faqiriqi;
	//公司名称
	private String gongsimingcheng;
	//公司地址
	private String gongsidizhi;
	//负责人
	private String fuzeren;
    //区分是我的客户0还是下属客户1
	private int qfkh;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getUserId() {
		return userId;
	}
	public void setUserId(int userId) {
		this.userId = userId;
	}
	public Date getUpdate_time() {
		return update_time;
	}
	public void setUpdate_time(Date update_time) {
		this.update_time = update_time;
	}
	public Date getCreate_time() {
		return create_time;
	}
	public void setCreate_time(Date create_time) {
		this.create_time = create_time;
	}
	
	public String getKhlx() {
		return khlx;
	}
	public void setKhlx(String khlx) {
		this.khlx = khlx;
	}
	public String getKhzt() {
		return khzt;
	}
	public void setKhzt(String khzt) {
		this.khzt = khzt;
	}
	public String getSsbm() {
		return ssbm;
	}
	public void setSsbm(String ssbm) {
		this.ssbm = ssbm;
	}
	
	public String getKhmc() {
		return khmc;
	}
	public void setKhmc(String khmc) {
		this.khmc = khmc;
	}
	
	public String getDizhi() {
		return dizhi;
	}
	public void setDizhi(String dizhi) {
		this.dizhi = dizhi;
	}
	public String getZuixingenjinjilu() {
		return zuixingenjinjilu;
	}
	public void setZuixingenjinjilu(String zuixingenjinjilu) {
		this.zuixingenjinjilu = zuixingenjinjilu;
	}
	public String getQianfzr() {
		return qianfzr;
	}
	public void setQianfzr(String qianfzr) {
		this.qianfzr = qianfzr;
	}

	public int getStatus() {
		return status;
	}
	public void setStatus(int status) {
		this.status = status;
	}

	public double getDianhua() {
		return dianhua;
	}
	public void setDianhua(double dianhua) {
		this.dianhua = dianhua;
	}
	public double getShouji() {
		return shouji;
	}
	public void setShouji(double shouji) {
		this.shouji = shouji;
	}
	public Date getGenjinriqi() {
		return genjinriqi;
	}
	public void setGenjinriqi(Date genjinriqi) {
		this.genjinriqi = genjinriqi;
	}
	public String getGenjinneirong() {
		return genjinneirong;
	}
	public void setGenjinneirong(String genjinneirong) {
		this.genjinneirong = genjinneirong;
	}
	public Date getFaqiriqi() {
		return faqiriqi;
	}
	public void setFaqiriqi(Date faqiriqi) {
		this.faqiriqi = faqiriqi;
	}
	public String getGongsimingcheng() {
		return gongsimingcheng;
	}
	public void setGongsimingcheng(String gongsimingcheng) {
		this.gongsimingcheng = gongsimingcheng;
	}
	public String getGongsidizhi() {
		return gongsidizhi;
	}
	public void setGongsidizhi(String gongsidizhi) {
		this.gongsidizhi = gongsidizhi;
	}
	public String getFuzeren() {
		return fuzeren;
	}
	public void setFuzeren(String fuzeren) {
		this.fuzeren = fuzeren;
	}
	public int getDr() {
		return dr;
	}
	public void setDr(int dr) {
		this.dr = dr;
	}
	public int getQfkh() {
		return qfkh;
	}
	public void setQfkh(int qfkh) {
		this.qfkh = qfkh;
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((create_time == null) ? 0 : create_time.hashCode());
		long temp;
		temp = Double.doubleToLongBits(dianhua);
		result = prime * result + (int) (temp ^ (temp >>> 32));
		result = prime * result + ((dizhi == null) ? 0 : dizhi.hashCode());
		result = prime * result + dr;
		result = prime * result + ((faqiriqi == null) ? 0 : faqiriqi.hashCode());
		result = prime * result + ((fuzeren == null) ? 0 : fuzeren.hashCode());
		result = prime * result + ((genjinneirong == null) ? 0 : genjinneirong.hashCode());
		result = prime * result + ((genjinriqi == null) ? 0 : genjinriqi.hashCode());
		result = prime * result + ((gongsidizhi == null) ? 0 : gongsidizhi.hashCode());
		result = prime * result + ((gongsimingcheng == null) ? 0 : gongsimingcheng.hashCode());
		result = prime * result + id;
		result = prime * result + ((khlx == null) ? 0 : khlx.hashCode());
		result = prime * result + ((khmc == null) ? 0 : khmc.hashCode());
		result = prime * result + ((khzt == null) ? 0 : khzt.hashCode());
		result = prime * result + qfkh;
		result = prime * result + ((qianfzr == null) ? 0 : qianfzr.hashCode());
		temp = Double.doubleToLongBits(shouji);
		result = prime * result + (int) (temp ^ (temp >>> 32));
		result = prime * result + ((ssbm == null) ? 0 : ssbm.hashCode());
		result = prime * result + status;
		result = prime * result + ((update_time == null) ? 0 : update_time.hashCode());
		result = prime * result + userId;
		result = prime * result + ((zuixingenjinjilu == null) ? 0 : zuixingenjinjilu.hashCode());
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		KH other = (KH) obj;
		if (create_time == null) {
			if (other.create_time != null)
				return false;
		} else if (!create_time.equals(other.create_time))
			return false;
		if (Double.doubleToLongBits(dianhua) != Double.doubleToLongBits(other.dianhua))
			return false;
		if (dizhi == null) {
			if (other.dizhi != null)
				return false;
		} else if (!dizhi.equals(other.dizhi))
			return false;
		if (dr != other.dr)
			return false;
		if (faqiriqi == null) {
			if (other.faqiriqi != null)
				return false;
		} else if (!faqiriqi.equals(other.faqiriqi))
			return false;
		if (fuzeren == null) {
			if (other.fuzeren != null)
				return false;
		} else if (!fuzeren.equals(other.fuzeren))
			return false;
		if (genjinneirong == null) {
			if (other.genjinneirong != null)
				return false;
		} else if (!genjinneirong.equals(other.genjinneirong))
			return false;
		if (genjinriqi == null) {
			if (other.genjinriqi != null)
				return false;
		} else if (!genjinriqi.equals(other.genjinriqi))
			return false;
		if (gongsidizhi == null) {
			if (other.gongsidizhi != null)
				return false;
		} else if (!gongsidizhi.equals(other.gongsidizhi))
			return false;
		if (gongsimingcheng == null) {
			if (other.gongsimingcheng != null)
				return false;
		} else if (!gongsimingcheng.equals(other.go