java字符串，excel数据轻松解决

举例有这些数据要写数据库脚本

java代码如下：

public static void main(String[] args) {
        String a = "110118\t密云区\n" +
                "110119\t延庆区\n" +
                "120117\t宁河区\n" +
                "120118\t静海区\n" +
                "120119\t蓟州区\n" +
                "130109\t藁城区\n" +
                "130110\t鹿泉区\n" +
                "130111\t栾城区\n" +
                "130209\t曹妃甸区\n" +
                "130306\t抚宁区\n" +
                "130407\t肥乡区\n" +
                "130408\t永年区\n" +
                "130606\t莲池区\n" +
                "130607\t满城区\n" +
                "130608\t清苑区\n" +
                "130609\t徐水区\n" +
                "130708\t万全区\n" +
                "130709\t崇礼区\n" +
                "130881\t平泉市\n" +
                "131103\t冀州区\n" +
                "140213\t平城区\n" +
                "140214\t云冈区\n" +
                "140215\t云州区\n" +
                "140681\t怀仁市\n" +
                "150603\t康巴什区\n" +
                "150703\t扎赉诺尔区\n" +
                "210115\t辽中区\n";
        String[] split = a.split("\n");
        int dd = 4819;
        for (int i = 0; i < split.length; i++) {
            dd++;
            String[] split1 = split[i].split("\t");
            for (int j = 0; j < split1.length - 1; j++) {
                String tr = "INSERT INTO CHANNEL_DICTIONARIES " +
                        "(\"ID\", \"CHANNEL_CODE\", \"EXTERNAL_CODE\", \"EXTERNAL_NAME\", \"EXTERNAL_CODE_PARENT\", \"HEXIN_CODE\"," +
                        " \"HEXIN_NAME\", \"HEXIN_CODE_PARENT\", \"SORT\", \"TYPE_CODE\", \"TYPE_NAME\") VALUES " +
                        "('" + dd + "', 'gdrs','" + split1[0] + "', '" + split1[1] + "', NULL, '" + split1[0] + "', '" + split1[1] + "', NULL, NULL, '1005', '省市区');";
                System.out.println(tr);
            }

        }
    }

结果如下

总结

根绝excel的/n 和 /t 可以任意组合，对于一些长期根据需求不能整体导入excel的小同学，本人认为挺好玩的，亲身用过好用不麻烦，存在的问题是数据量太大不行，string有大小的限制