2021-03-09

1. hello world

答应我，好好学习，天天向上!

2. 2021要做的事

今年中旬完成p6的学习课程，下旬进行考研准备。要记得健身哦。

3. 测试下上传图片

3.1 本地图片

3.2 线上图片

图片地址1
图片地址2

4. 代码段

一段js

//下拉框填充
function fillSelect($el, url, value, text, formFilter, needAllChose, queryParam, defaultVaule, selectedValue, defaultValueText,attrNames,attrObj) {
    if(checkElEmpty(defaultValueText)){
        defaultValueText = "请选择";
    }

    $.get(url, queryParam, function (res) {
        var data = res.rows;
        $el.empty();
        if (needAllChose) {
            if (!checkElEmpty(defaultVaule)) {
                $el.append(createSelectOption(defaultVaule, defaultValueText));
            } else {
                $el.append(createSelectOption("", defaultValueText));
            }
        }
        for (var i = 0; i < data.length; i++) {
            var option;
            if (checkElEmpty(selectedValue)) {
                option = createSelectOption(data[i][value], data[i][text]);
            } else if (selectedValue == data[i][value] || selectedValue.toString().localeCompare(data[i][value]) == 0) {
                option = createSelectOption(data[i][value], data[i][text], true);
            } else {
                option = createSelectOption(data[i][value], data[i][text]);
            }

            for (var j = 0; j < attrNames.length; j++) {
                option['th:' + attrNames[j]] = data[i][attrNames[j]];
            }
            if(!checkElEmpty(attrObj)){
                option["th:obj"] = data[i];
            }

            $el.append(option);
        }
        form.render('select', formFilter);
    });
}

一段java

package com.yjf.note.web.tool;

import cn.hutool.core.io.FileUtil;
import cn.hutool.core.util.CharsetUtil;
import com.common.ajax.EncodingDetect;
import com.yjf.note.web.tool.domain.ExcelThead;
import org.apache.commons.io.FileUtils;
import org.apache.xerces.xs.LSInputList;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartRequest;
import org.springframework.web.multipart.support.StandardMultipartHttpServletRequest;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.util.LinkedList;
import java.util.List;

/**
 * @createTime : 2021/03/04 16:16
 * @autho : hx
 * @describe : null
 */
@RestController
@RequestMapping("/export")
public class ExportController {
    @Autowired
    ExcelService excelService;

    @RequestMapping("/excel/test")
    public void exportExcel(HttpServletResponse httpServletResponse){
    //    String txt = "a=5,c=4,b=3 a=10,b=7,c=9,d=1";
        String txt = "a=5,c=4,b=3 a=10,b=7,c=9,d=1 a=99,d=88,c=33";
        String recordGapSymbol = " ";
        String paramDefineSymbol = "=";
        String paramGapSymbol = ",";
        String recordKeyField = "a";

        List<ExcelThead> list = new LinkedList<>();
        ExcelThead excelThead1 = new ExcelThead(0,"a",ExcelThead.THEAD_TITLE_NUMBER);
        ExcelThead excelThead2 = new ExcelThead(1,"b",ExcelThead.THEAD_TITLE_NUMBER);
        ExcelThead excelThead3 = new ExcelThead(2,"c",ExcelThead.THEAD_TITLE_NUMBER);
        ExcelThead excelThead4 = new ExcelThead(3,"d",ExcelThead.THEAD_TITLE_NUMBER);
        list.add(excelThead1);
        list.add(excelThead2);
        list.add(excelThead3);
        list.add(excelThead4);

    //    excelService.createExcel(httpServletResponse,txt,recordGapSymbol,paramDefineSymbol,paramGapSymbol,list);
        excelService.createExcel(httpServletResponse,txt,recordGapSymbol,paramDefineSymbol,paramGapSymbol,list,recordKeyField);
    }

    @PostMapping("/excel")
    public void exportExcel(HttpServletRequest httpServletRequest,HttpServletResponse httpServletResponse, int txtIn, int transferWay, String[] theadField, String[] dataType, String recordGapSymbol
            , String paramDefineSymbol, String paramGapSymbol, String recordKeyField, String txt, @RequestParam("file")MultipartFile file) throws IOException {
        List<ExcelThead> list = new LinkedList<>();
        for (int i = 0; i < theadField.length; i++) {
            ExcelThead excelThead = new ExcelThead(i,theadField[i],dataType[i]);
            list.add(excelThead);
        }

        String text = null;
        if(txtIn == 0){
            text = txt;
        }else {
            File desc = null;
            if(new File("/root").exists()){
                desc = new File("/root/tempFile/",file.getName());
                desc.mkdirs();
                file.transferTo(desc);
            }else {
                desc = new File("C:\\tempFile\\",file.getName());
                desc.mkdirs();
                file.transferTo(desc);
            }
            String fileEncode = EncodingDetect.getJavaEncode(desc.getAbsolutePath());
            text = FileUtils.readFileToString(desc,fileEncode);
            desc.delete();
        }

        if(transferWay == 0){
            excelService.createExcel(httpServletResponse,text,recordGapSymbol,paramDefineSymbol,paramGapSymbol,list);
        }else {
            excelService.createExcel(httpServletResponse,text,recordGapSymbol,paramDefineSymbol,paramGapSymbol,list,recordKeyField);
        }
    }
}

5. 心想事成，万事如意

The best wishes to myself¹.

---

1. 真是再好不过了 ↩︎