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 Da...
摘要由CSDN通过智能技术生成

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
  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,我来为你具体介绍下springboot+vue实现el-table显示数据的逻辑。 1. 后端逻辑 在后端,我们需要使用Spring Boot框架来实现数据的处理和接口的实现。具体逻辑如下: (1) 定义实体类 首先,我们需要定义实体类来映射数据库表中的数据。例如,我们定义一个User实体类来映射数据库表中的用户数据: ```java public class User { private Long id; private String name; private Integer age; private String address; // getter和setter方法省略 } ``` (2) 定义数据访问接口 接下来,我们需要定义一个数据访问接口来访问数据库中的用户数据。可以使用MyBatis或者Hibernate等ORM框架来实现。例如,在使用MyBatis的情况下,我们可以在Mapper接口中定义一个查询所有用户数据的方法: ```java public interface UserMapper { List<User> getAllUsers(); } ``` (3) 实现数据访问接口 然后,我们需要实现数据访问接口来访问数据库中的用户数据。例如,在使用MyBatis的情况下,我们可以使用Mapper XML文件来实现查询所有用户数据的方法: ```xml <select id="getAllUsers" resultType="User"> SELECT id, name, age, address FROM user </select> ``` (4) 定义控制器 最后,我们需要定义一个控制器来处理前端的数据请求。例如,我们可以定义一个UserController类来处理前端请求获取所有用户数据的方法: ```java @RestController @RequestMapping("/api") public class UserController { @Autowired private UserMapper userMapper; @GetMapping("/users") public List<User> getAllUsers() { return userMapper.getAllUsers(); } } ``` 2. 前端逻辑 在前端,我们需要使用Vue框架来实现页面的渲染和数据的展示。具体逻辑如下: (1) 安装element-ui组件库 我们可以使用npm命令来安装element-ui组件库: ``` npm install element-ui --save ``` (2) 引入el-table组件 在Vue组件中引入el-table组件,并使用axios库从后端接口获取数据。例如: ```vue <template> <div> <el-table :data="users"> <el-table-column prop="id" label="ID"></el-table-column> <el-table-column prop="name" label="Name"></el-table-column> <el-table-column prop="age" label="Age"></el-table-column> <el-table-column prop="address" label="Address"></el-table-column> </el-table> </div> </template> <script> import axios from 'axios'; export default { data() { return { users: [] } }, mounted() { axios.get('/api/users').then(response => { this.users = response.data; }); } } </script> ``` 其中,`:data="users"`绑定了数据源,`el-table-column`定义了要展示的列。在`mounted()`方法中使用axios库从后端接口获取数据,并将数据赋值给`users`变量。 至此,我们就完成了基于Spring Boot和Vue的el-table数据展示功能的实现
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值