数据库部分
主表:
从表:
导出:
导入:
pom.xml
。
<!-- poi依赖 -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
entity
。
package com.ysd.demo1.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.ysd.demo1.util.ExcelDesc;
import java.io.Serializable;
/**
* <p>
*
* </p>
*
* @author jmf
* @since 2020-03-31
*/
public class Student implements Serializable {
private static final long serialVersionUID = 1L;
/**
* 学生ID
*/
@TableId(value = "student_id", type = IdType.AUTO)
private Integer studentId;
/**
* 卡号
*/
@ExcelDesc("卡号")
private Integer cardNo;
/**
* 姓名
*/
@ExcelDesc("学生姓名")
private String studentName;
/**
* 性别
*/
@ExcelDesc("性别")
private String studentSex;
/**
* 年龄
*/
@ExcelDesc("年龄")
private String studentAge;
/**
* 需要:专业,系名称
*/
private Integer professionalId;
/**
* 备注
*/
@ExcelDesc("备注")
private String studentNote;
/**
* 逻辑删除
*/
@TableLogic
private Integer del;
public Integer getStudentId() {
return studentId;
}
public void setStudentId(Integer studentId) {
this.studentId = studentId;
}
public Integer getCardNo() {
return cardNo;
}
public void setCardNo(Integer cardNo) {
this.cardNo = cardNo;
}
public String getStudentName() {
return studentName;
}
public void setStudentName(String studentName) {
this.studentName = studentName;
}
public String getStudentSex() {
return studentSex;
}
public void setStudentSex(String studentSex) {
this.studentSex = studentSex;
}
public String getStudentAge() {
return studentAge;
}
public void setStudentAge(String studentAge) {
this.studentAge = studentAge;
}
public Integer getProfessionalId() {
return professionalId;
}
public void setProfessionalId(Integer professionalId) {
this.professionalId = professionalId;
}
public String getStudentNote() {
return studentNote;
}