package com.test.server.utils;

import com.linuxense.javadbf.DBFReader;
import lombok.extern.slf4j.Slf4j;

import java.io.ByteArrayInputStream;
import java.io.FileInputStream;
import java.nio.charset.StandardCharsets;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @description: dbf工具类
 */
@Slf4j
public class DBFUtils {

    public static List

前端的columnDto参数:
[
 {
                        title: item.libraryTableName,
                        dataIndex: item.libraryTableName,
                        key: item.fileFieldCode  
                    }
]



resource接口


    @RequestMapping(value = "/exportExcelTemplate", method=RequestMethod.POST)
    void exportExcelTemplate(@ApiParam(value = "传输对象", required = true) ExportDto, NewStudentImportSettingVo> exportDto);


    @RequestMapping(value = "/exportDbfTemplate", method=RequestMethod.POST)
    void exportDbfTemplate(@ApiParam(value = "传输对象", required = true) ExportDto, NewStudentImportSettingVo> exportDto);




工具类 exportDto.java 

package com.test.dto;

import java.io.Serializable;
import java.util.List;

public class ExportDto implements Serializable {
    private static final long serialVersionUID = -9003609292510835997L;
    private T pageQueryParam;
    private List columns;
    private List rowKeys;
    private List rows;

    public ExportDto() {
    }

    public T getPageQueryParam() {
        return this.pageQueryParam;
    }

    public List getColumns() {
        return this.columns;
    }

    public List getRowKeys() {
        return this.rowKeys;
    }

    public List getRows() {
        return this.rows;
    }

    public void setPageQueryParam(T pageQueryParam) {
        this.pageQueryParam = pageQueryParam;
    }

    public void setColumns(List columns) {
        this.columns = columns;
    }

    public void setRowKeys(List rowKeys) {
        this.rowKeys = rowKeys;
    }

    public void setRows(List rows) {
        this.rows = rows;
    }
}

 
 ColumnsDto.java类

package com.test.dto;

import java.io.Serializable;

public class ColumnsDto implements Serializable {
    private static final long serialVersionUID = -9003609292510835997L;
    private String title;
    private String dataIndex;
    private String key;
    private String align;
    private String width;

    public ColumnsDto() {
    }

    public String getTitle() {
        return this.title;
    }

    public String getDataIndex() {
        return this.dataIndex;
    }

    public String getKey() {
        return this.key;
    }

    public String getAlign() {
        return this.align;
    }

    public String getWidth() {
        return this.width;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public void setDataIndex(String dataIndex) {
        this.dataIndex = dataIndex;
    }

    public void setKey(String key) {
        this.key = key;
    }

    public void setAlign(String align) {
        this.align = align;
    }

    public void setWidth(String width) {
        this.width = width;
    }

    public boolean equals(Object o) {
        if (o == this) {
            return true;
        } else if (!(o instanceof ColumnsDto)) {
            return false;
        } else {
            ColumnsDto other = (ColumnsDto)o;
            if (!other.canEqual(this)) {
                return false;
            } else {
                label71: {
                    Object this$title = this.getTitle();
                    Object other$title = other.getTitle();
                    if (this$title == null) {
                        if (other$title == null) {
                            break label71;
                        }
                    } else if (this$title.equals(other$title)) {
                        break label71;
                    }

                    return false;
                }

                Object this$dataIndex = this.getDataIndex();
                Object other$dataIndex = other.getDataIndex();
                if (this$dataIndex == null) {
                    if (other$dataIndex != null) {
                        return false;
                    }
                } else if (!this$dataIndex.equals(other$dataIndex)) {
                    return false;
                }

                label57: {
                    Object this$key = this.getKey();
                    Object other$key = other.getKey();
                    if (this$key == null) {
                        if (other$key == null) {
                            break label57;
                        }
                    } else if (this$key.equals(other$key)) {
                        break label57;
                    }

                    return false;
                }

                Object this$align = this.getAlign();
                Object other$align = other.getAlign();
                if (this$align == null) {
                    if (other$align != null) {
                        return false;
                    }
                } else if (!this$align.equals(other$align)) {
                    return false;
                }

                Object this$width = this.getWidth();
                Object other$width = other.getWidth();
                if (this$width == null) {
                    if (other$width == null) {
                        return true;
                    }
                } else if (this$width.equals(other$width)) {
                    return true;
                }

                return false;
            }
        }
    }

    protected boolean canEqual(Object other) {
        return other instanceof ColumnsDto;
    }

    public int hashCode() {
        int PRIME = true;
        int result = 1;
        Object $title = this.getTitle();
        int result = result * 59 + ($title == null ? 43 : $title.hashCode());
        Object $dataIndex = this.getDataIndex();
        result = result * 59 + ($dataIndex == null ? 43 : $dataIndex.hashCode());
        Object $key = this.getKey();
        result = result * 59 + ($key == null ? 43 : $key.hashCode());
        Object $align = this.getAlign();
        result = result * 59 + ($align == null ? 43 : $align.hashCode());
        Object $width = this.getWidth();
        result = result * 59 + ($width == null ? 43 : $width.hashCode());
        return result;
    }

    public String toString() {
        return "ColumnsDto(title=" + this.getTitle() + ", dataIndex=" + this.getDataIndex() + ", key=" + this.getKey() + ", align=" + this.getAlign() + ", width=" + this.getWidth() + ")";
    }
}



controller.java类


import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import com.ly.spring.boot.uuid.UUIDStringGenerator;



    @Autowired
    private HttpServletRequest request;

    @Autowired
    private HttpServletResponse response;

    @Autowired
    private UUIDStringGenerator uuidStringGenerator;
	
    @Override
    public void exportExcelTemplate(@RequestBody ExportDto, NewStudentImportSettingVo> exportDto) {

        String studentType = exportDto.getPageQueryParam().getParam().getStudentType();
        String fileName = "bs".equals(studentType)?"博士":"ss".equals(studentType)?"硕士":"tdxl".equals(studentType)?"同等学力":"";
        try {
            String characterEncoding = request.getCharacterEncoding();
            response.setHeader("content-type", "application/octet-stream");
            response.setHeader("content-disposition",
                    "attachment;fileName=" + URLEncoder.encode(fileName+"新生信息模板导出"+ DatetimeUtils.getCurrentDateFromFormat("`yyyyMMddhhmm`") +".xls", characterEncoding));
            response.setContentType( "application/msexcel" );
            ExcelTool excelTool = new ExcelTool(fileName+"新生信息模板");
            List