package com.metaqianfeng;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.FileInputStream;import java.io.IOException;import java.math.BigDecimal;import java.sql.*;import java.text.SimpleDateFormat;import java.time.LocalDateTime;import java.util.Date;import java.util.HashMap;import java.util.Map;public class ExcelToDatabase {// 定义变量主要是为了后续写入group_idprivate static HashMap nameToGroupIdMap = new HashMap() {{put("考核1组", "037b3fecf80047c29769abf264f86a14");put("考核13组", "2364775b5cf148c5849bf6ba269905a0");put("考核2组", "2a69dddc52f344e0bb6eace6a327cd8d");put("考核3组", "382ad90e0c8d4f33b833d7e697a9cf28");put("考核12组", "5de7c1b46d5540cb85e5a69fc08ec63d");put("考核7组", "6045f93b4c5a44268a6c343064c4195d");put("考核5组", "6c5bb3cd3cd94e6fbfefded112c1d9c6");put("考核6组", "738d9c5198fd48d998e83103f4d21efa");put("考核14组", "99b5c9bf3814426c81a5eba20746fc2d");put("考核10组", "af7ed97b2f9b4e9c9b988256062307ee");put("考核4组", "b2a2cecc45ac449bb4067a6813f909c4");put("考核9组", "dbfa1bcbf3744bb09aad29c8f25ccb1e");put("考核11组", "f2c57761643646998cf8fe226a8818d3");put("考核15组", "f480c4175f69403da7ed200d17998146");put("考核8组", "fc3a52b5ee4f4ba38181e0c55975126d");}};//主要是为了kind的id和name的对应关系,一级菜单只有一种private static HashMap nameToKindMap = new HashMap() {{put("舰载飞行潜质专家评定表", "JZ");put("军事飞行潜质专家评定表", "JS");put("行为观察", "XWGC");put("情境考查", "QJKC");put("潜质检测", "QZJC");}};// 主要是为了区分 3-军事飞行潜质评定表和 4-舰载飞行潜质评定表,军事飞行潜质评定表的意志品质和舰载飞行潜质评定表的意志品质不一样private static HashMap nameToAbilityIdMap3 = new HashMap() {{put("记忆能力", "0152d549fcb74b8fb7ba09ea8c42eb03");put("创造能力", "2105681a308145348ef844089453c115");put("思维能力", "3a6b3b7881e0424f8e3c46e0ba0e3820");put("应变反应", "44aca75028a14195980c5bb7ce6c19f7");put("成就动机", "4536b9ec0e9846fc926fff3098d17e15");//有歧义到底是字母还是uuid// todoput("领导能力", "4f79cd4c2542456f8b52c7d85ec1f4ee");put("压力应对", "4fb5e3e4930e4c02801800f43b7a53dd");put("情绪特点", "5464211d509e44e19fbb7df60ad99ffe");put("注意集散", "555aa0c2913d4d7cb97453891583d8c3");put("操控能力", "59c69d184bcb4279a0d92f3983ebc662");put("性格特征", "5b6cccc21dcb4664b559d8ee6ce80439");put("空间定向", "77ce3eaa5b6640c5ac34e255a9e14a97");put("感知能力", "7d876306328c4e34bafda2064a1e3b17");put("意志品质", "84e1de9c001d4b9cae3b48da11ec0a2c");//3-军事飞行潜质评定表put("思想意识", "88637fd449544cebb6f3123909d55ef4");put("适应能力", "8a414c69441f44e69d745c98f4f461b6");put("精确操控", "8a6c762b69b449b88dbc1bb669a78851");put("飞行动机", "9a7656c93c124dd393f8880c57ac5748");put("环境适应", "9cb818e0b57641a1b94d68315bff1266");put("注意能力", "c290720486ec4958b47efe75788109bd");put("判断决策", "e1f06aa6fa444d0aa3bfaeb7043aaf20");put("自控能力", "e4f8cc561a044a6e875368ad2b3136db");put("情绪调控", "ec7d3cf4a8ba4c708f5d7fb87cd31e61");put("反应能力", "fa684d72c8da493cbc918af1a0057457");put("综合评定", "FINAL");put("意志品质", "YZPZ");put("情绪特点", "QXTD");put("性格特征", "XGTZ");put("飞行动机", "FXDJ");put("思想意识", "SXYS");}};pri