基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

package cn.swiftpass.convert;

import cn.swiftpass.convert.ui.Controller;
import com.alibaba.fastjson.JSON;

import cn.swiftpass.convert.config.Config;
import cn.swiftpass.convert.config.ConfigAosVersion;
import cn.swiftpass.convert.config.SpecialCharacterEntity;
import cn.swiftpass.convert.config.SpecialCharacterEntity.SpeciallistBean;


import javafx.application.Application;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.fxml.FXMLLoader;
import javafx.fxml.JavaFXBuilderFactory;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.DirectoryChooser;
import javafx.stage.FileChooser;
import javafx.stage.Stage;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.net.URL;
import java.util.*;

public class Main extends Application {

    private final static String configPath = "./config_output.json";
    private final static String configAosPath = "./config_aos.json";

    private final static String specialCharacterAosPath = "./SpecialASCIICharacters_aos.txt";
    private static List<String> columnNameList;
    private static List<String> outFileNameList;
    private static Config config;
    private static SpecialCharacterEntity specialCharacterEntity;

    private static ConfigAosVersion configAosVersion;


    private static Map<String, List<String>> resultMap = new LinkedHashMap<>();
    private String numberText = "1";


    @Override
    public void start(Stage primaryStage) throws Exception {


        URL location = getClass().getResource("/layout/main.fxml");
        FXMLLoader fxmlLoader = new FXMLLoader();
        fxmlLoader.setLocation(location);
        fxmlLoader.setBuilderFactory(new JavaFXBuilderFactory());
        Parent root = fxmlLoader.load();

        primaryStage.setTitle("词条自动转换");
        primaryStage.setScene(new Scene(root, 450, 300));
        Controller controller = fxmlLoader.getController();

        controller.btn_select_sheet.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                FileChooser directoryChooser = new FileChooser();
                File file = directoryChooser.showOpenDialog(primaryStage);
                if (file != null) {
                    String sheetPath = file.getPath();
                    config.setConvertFilePath(sheetPath);
                    controller.tv_sheet.setText(sheetPath);
                    writeConfigFile(configPath, JSON.toJSONString(config));
                }

            }
        });
        controller.btn_select_res_path.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                DirectoryChooser directoryChooser = new DirectoryChooser();
                File file = directoryChooser.showDialog(primaryStage);
                if (file != null) {
                    String resPath = file.getPath();
                    configAosVersion.setOutFilePath(resPath);
                    controller.tv_res_path.setText(resPath);
                    writeConfigFile(configAosPath, JSON.toJSONString(configAosVersion));
                }
            }
        });
        if (configAosVersion != null) {
            if (configAosVersion.getOutFilePath() != null && configAosVersion.getOutFilePath().length() > 0) {
                controller.tv_res_path.setText(configAosVersion.getOutFilePath());
            }
        }

        if (config != null) {
            if (config.getConvertFilePath() != null && config.getConvertFilePath().length() > 0) {
                controller.tv_sheet.setText(config.getConvertFilePath());
            }
        }
        controller.btn_confirm.setOnAction(event -> {
            numberText = controller.ed_string_number.getText();
            resultMap.clear();
            readExcellList(readExcel(config.getConvertFilePath()));
            genAosXml();
        });
        primaryStage.show();

    }

    public static void main(String[] args) {
        System.out.println("start......");
        initConfig();
        configAos();

        launch(args);
    }

    private static void initConfig() {

        String configStr = readConfigFile(configPath);
        if (!configStr.isEmpty()) {
            config = JSON.parseObject(configStr, Config.class);
        }
        System.out.println(JSON.toJSON(config));


    }

    private static void configAos() {
        String characterPath = readConfigFile(specialCharacterAosPath);
        if (!characterPath.isEmpty()) {
            generateSpecialList(characterPath);
        }
        String configAosStr = readConfigFile(configAosPath);
        if (!configAosStr.isEmpty()) {
            configAosVersion = JSON.parseObject(configAosStr, ConfigAosVersion.class);
        }
        System.out.println(JSON.toJSON(configAosStr));
        columnNameList = configAosVersion.getColNameList();
        outFileNameList = configAosVersion.getOutFileNameList();
        resultMap.clear();
    }


    private static void generateSpecialList(String characterPath) {
        specialCharacterEntity = new SpecialCharacterEntity();
        List<SpeciallistBean> speciallistBeans = new ArrayList<>();
        String items[] = characterPath.replace("\r\n", "").split("##");
        for (int i = 0; i < items.length; i  ) {
            String totalItemStr = items[i];
            String childItems[] = totalItemStr.split("=");
            SpeciallistBean speciallistBean = new SpeciallistBean();
            speciallistBean.setValue(childItems[0].replace("\r\n", ""));
            speciallistBean.setName(childItems[1].replace("\r\n", ""));
            speciallistBeans.add(speciallistBean);
        }
        specialCharacterEntity.setSpeciallist(speciallistBeans);
    }


    private static String readConfigFile(String filePath) {


        File file = new File(filePath);
        if (!file.exists()) {
            return "";
        }

        BufferedReader reader = null;
        StringBuilder stringBuilder = new StringBuilder();
        try {
            FileInputStream fileInputStream = new FileInputStream(file);
            InputStreamReader inputStreamReader = new InputStreamReader(fileInputStream, "UTF-8");
            reader = new BufferedReader(inputStreamReader);
            char[] buf = new char[1024];
            int len;
            while ((len = reader.read(buf)) != -1) {
                stringBuilder.append(buf, 0, len);
            }
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (reader != null) {
                try {
                    reader.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return stringBuilder.toString();
    }

    private void writeConfigFile(String filePath, String data) {
        File file = new File(filePath);
        if (!file.exists()) {
            return;
        }
        FileOutputStream fileOutputStream = null;
        BufferedOutputStream buf = null;
        try {
            fileOutputStream = new FileOutputStream(file);
            buf = new BufferedOutputStream(fileOutputStream);
            buf.write(data.getBytes());
            buf.flush();
            buf.close();
            fileOutputStream.close();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (fileOutputStream != null) {
                try {
                    fileOutputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            if (buf != null) {
                try {
                    buf.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }

    }

    private void readExcellList(Workbook wb) {
        Sheet sheet = null;
        String cellData = null;
        Row row = null;
        if (wb != null) {

            int sheetNumber = 0;
            Integer number = Integer.valueOf(numberText);
            if (number > 0) {
                sheetNumber = number-1;
            }
            sheet = wb.getSheetAt(sheetNumber);

            row = sheet.getRow(0);


            int rowNum = sheet.getPhysicalNumberOfRows();

            int colnum = row.getPhysicalNumberOfCells();


            List<Integer> columnIndexList = new ArrayList<>();
            for (int i = 0; i < columnNameList.size(); i  ) {
                for (int j = 0; j < colnum; j  ) {
                    cellData = (String) getCellFormatValue(row.getCell(j));
                    if (cellData != null && !cellData.isEmpty() && columnNameList.get(i).equals(cellData)) {
                        columnIndexList.add(j);
                    }
                }
            }
            if (columnIndexList.size() != columnNameList.size()) {
                throw new IllegalStateException(":"   columnNameList);
            }


            for (int i = 1; i < rowNum; i  ) {
                row = sheet.getRow(i);
                if (row == null) {
                    break;
                }

                List<String> temp = null;
                for (int j = 0; j < columnNameList.size(); j  ) {
                    int index = columnIndexList.get(j);
                    cellData = (String) getCellFormatValue(row.getCell(index));
                    if (j == 0) {
                        if (cellData.isEmpty()) {

                            break;
                        }

                        temp = new ArrayList<>();
                        resultMap.put(cellData, temp);
                    } else {
                        temp.add(cellData);
                    }
                }
            }

        }

    }


    private void genAosXml() {
        String topTitle = "<resources>";
        String bottomTitle = "</resources>";
        File itemFile = null;
        for (int i = 0; i < outFileNameList.size(); i  ) {
            try {
                String parentName = configAosVersion.getOutFilePath()  "/" outFileNameList.get(i);
                itemFile = new File(parentName);
                if (!itemFile.exists()) {
                    itemFile.mkdirs();
                }

                itemFile = new File(parentName, "string_p"   numberText   ".xml");
                if (!itemFile.exists()) {
                    itemFile.createNewFile();
                }
                FileOutputStream fos = new FileOutputStream(itemFile);
                BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(fos, "UTF-8"));
                bw.write(topTitle);
                bw.newLine();

                // formatted="false"
                String inputResultFormat = "<string name=\"%s\" formatted=\"false\">%s</string>";
                for (Map.Entry<String, List<String>> entry : resultMap.entrySet()) {
                    String key = entry.getKey();

                    key = key.replace("-", "_");
                    String value = entry.getValue().get(i);
                    System.out.println("value:"   value   " key:"   key);

                    List<SpeciallistBean> speciallistBeans = specialCharacterEntity.getSpeciallist();
                    for (int j = 0; j < speciallistBeans.size(); j  ) {
                        // &#192=?;
                        SpeciallistBean speciallistBean = speciallistBeans.get(j);
                        String specialName = speciallistBean.getName();
                        String changeValue = speciallistBean.getValue();

                        if (value.contains(specialName)) {
                            // <string name="EC01_22">eVoucher No. &amp; Expiry Dates</string>
                            if (specialName.equals("&") && value.contains("&#")) {

                                // <string name="EC05_3_a">Required Points:&#160; </string>
                                break;
                            }
                            value = value.replace(specialName, changeValue);
                        }
                    }

                    if (value.isEmpty()) {
                        throw new Exception(key   "");
                    }

                    String itemLineStr = String.format(inputResultFormat, key, value);
                    bw.write(itemLineStr);
                    bw.newLine();
                }
                bw.write(bottomTitle);
                bw.newLine();
                bw.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }


    public static Workbook readExcel(String filePath) {
        Workbook wb = null;
        if (filePath == null) {
            return null;
        }
        String extString = filePath.substring(filePath.lastIndexOf("."));
        InputStream is = null;
        try {
            is = new FileInputStream(filePath);
            if (".xls".equals(extString)) {
                return wb = new HSSFWorkbook(is);
            } else if (".xlsx".equals(extString)) {
                return wb = new XSSFWorkbook(is);
            } else {
                return wb = null;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return wb;
    }

    public static Object getCellFormatValue(Cell cell) {
        Object cellValue = null;
        if (cell != null) {

            switch (cell.getCellType()) {
                case Cell.CELL_TYPE_STRING: {
                    cellValue = cell.getRichStringCellValue().getString();
                    break;
                }
                default:
                    cellValue = "";
            }
        } else {
            cellValue = "";
        }
        return cellValue;
    }

}