屏蔽字工具类 Java读取Excel工具类 读取到内存中

MaskWordTable: 屏蔽字工具类

import java.util.Collections;import java.util.Comparator;import java.util.LinkedList;import java.util.List;import Common.FunctionHelper;import Common.Container.CCMap;public class MaskWordTable{private final static String FILENAME = "MaskWord.xls";private final static String PATH = Thread.currentThread().getContextClassLoader().getResource(FILENAME).getPath();private CCMap<String, List<String>> mMaskWordTable = new CCMap<String, List<String>>();private MaskWordTable(){}private static class LazyHolder{private final static MaskWordTable INSTANCE = new MaskWordTable();}public final static MaskWordTable getMaskWordTable(){return LazyHolder.INSTANCE;}/** * @see read excel */private boolean ReadExcel(){try{List<String> table = ExcelUtil.exportListFromExcel(PATH, FILENAME);for(String row : table){AddRow(row);}Sort();return true;}catch(Exception e){e.printStackTrace();}return false;}/** * @see 是否包含屏蔽字 */public boolean IsHave(String text){if(0 == mMaskWordTable.Size()){ReadExcel();}if(FunctionHelper.StringIsNullOrEmpty(text)){return false;}for(int i = 0; i < text.length(); ++i){String key = text.substring(i, i + 1);String content = text.substring(i);List<String> value = mMaskWordTable.GetValue(key);if(null == value){continue;}for(String word : value){if(content.indexOf(word) >= 0){return true;}}}return false;}/** * @see 屏蔽字转换 */public String ConvertTo(String text){if(0 == mMaskWordTable.Size()){ReadExcel();}if(FunctionHelper.StringIsNullOrEmpty(text)){return "";}List<String> sensitiveWords = new LinkedList<String>();for(int i = 0; i < text.length(); ++i){String key = text.substring(i, i + 1);String content = text.substring(i);List<String> value = mMaskWordTable.GetValue(key);if(null == value){continue;}for(String word : value){if(content.indexOf(word) >= 0){i += word.length() - 1;sensitiveWords.add(word);}}}for(String sensitiveWord : sensitiveWords){text = text.replaceFirst(sensitiveWord, StarGenerator(sensitiveWord.length()));}return text;}private String StarGenerator(int length){String stars = "";for(int i = 0; i < length; ++i){stars += "*";}return stars;}private class LengthComparator implements Comparator<String>{@Overridepublic int compare(String o1, String o2){return o2.length() - o1.length();}}private void Sort(){List<List<String>> values = mMaskWordTable.GetValues();for(List<String> value : values){Collections.sort(value, new LengthComparator());}}private void AddRow(String row){if(FunctionHelper.StringIsNullOrEmpty(row)){return;}String key = row.substring(0, 1);List<String> value = mMaskWordTable.GetValue(key);if(null != value){value.add(row);}else{value = new LinkedList<String>();value.add(row);mMaskWordTable.Put(key, value);}}}

ExcelUtil: Java读取Excel工具类

import java.io.File;import java.io.FileInputStream;import java.io.InputStream;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellValue;import org.apache.poi.ss.usermodel.FormulaEvaluator;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;public class ExcelUtil {private final static String XLS = "xls";//Excel 2003private final static String XLSX = "xlsx";//Excel 2007/** * Excel文件的Sheet导出至List *  * @param file * @param sheetNum * @return */public static List<String> parseListExcel(String path, String fileName) {List<String> list = new ArrayList<String>();try {FileInputStream in = new FileInputStream(new File(path));Workbook workbook = null;try {workbook = getWorkbook(in, fileName);} catch (Exception e) {e.printStackTrace();System.out.println("文件后缀解析失败");}Sheet sheet = workbook.getSheetAt(0);//读取第一个工作表// 解析公式结果FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();int minRowIx = sheet.getFirstRowNum();int maxRowIx = sheet.getLastRowNum();for (int rowIx = minRowIx; rowIx <= maxRowIx; rowIx++) {Row row = sheet.getRow(rowIx);StringBuilder sb = new StringBuilder();short minColIx = row.getFirstCellNum();short maxColIx = row.getLastCellNum();for (short colIx = minColIx; colIx <= maxColIx; colIx++) {Cell cell = row.getCell(new Integer(colIx));CellValue cellValue = evaluator.evaluate(cell);if (cellValue == null) {continue;}sb.append(getCellValue(cell));}list.add(sb.toString());}} catch (Exception e) {e.printStackTrace();}return list;}/** *  Excel文件的Sheet导出至List<Map> *   * @param path 文件路径 * @param fileName 文件名 * @param mapping * @return */public static List<Map<String, Object>> parseMapExcel(String path, String fileName, Map<String, String> mapping){// 返回数据List<Map<String, Object>> ls = new ArrayList<Map<String, Object>>();try {// 根据文件名来创建Excel工作薄FileInputStream in = new FileInputStream(new File(path));Workbook work = getWorkbook(in, fileName);if (null == work) {throw new Exception("创建Excel工作薄为空！");}Sheet sheet = null;Row row = null;Cell cell = null;// 遍历Excel中所有的sheetfor (int i = 0; i < work.getNumberOfSheets(); i++) {sheet = work.getSheetAt(i);if (sheet == null)continue;// 取第一行标题row = sheet.getRow(0);String title[] = null;if (row != null) {title = new String[row.getLastCellNum()];for (int y = row.getFirstCellNum(); y < row.getLastCellNum(); y++) {cell = row.getCell(y);title[y] = (String) getCellValue(cell);}} elsecontinue;// 遍历当前sheet中的所有行for (int j = 1; j < sheet.getLastRowNum() + 1; j++) {row = sheet.getRow(j);Map<String, Object> m = new HashMap<String, Object>();// 遍历所有的列for (int y = row.getFirstCellNum(); y < row.getLastCellNum(); y++) {cell = row.getCell(y);String key = title[y];m.put(mapping.get(key), getCellValue(cell));}ls.add(m);}}work.close();} catch (Exception e) {e.printStackTrace();}return ls;}/** * @see 根据文件后缀，自适应上传文件的版本 */private static Workbook getWorkbook(InputStream in, String fileName) throws Exception {Workbook wb = null;        String fileType = fileName.substring(fileName.lastIndexOf(".")+1);        if (XLS.equals(fileType)) {            wb = new HSSFWorkbook(in); // 2003-        } else if (XLSX.equals(fileType)) {            wb = new XSSFWorkbook(in); // 2007+        } else {            throw new Exception("解析的文件格式有误！");        }        return wb;}/** * @see 对表格中数值进行格式化 */private static Object getCellValue(Cell cell) {Object value = "";if(cell == null){return value;}switch (cell.getCellType()) {case Cell.CELL_TYPE_STRING:value = cell.getStringCellValue();break;case Cell.CELL_TYPE_NUMERIC:case Cell.CELL_TYPE_BOOLEAN:case Cell.CELL_TYPE_FORMULA:case Cell.CELL_TYPE_BLANK:cell.setCellType(Cell.CELL_TYPE_STRING);value = cell.getStringCellValue();break ;default:break;}return value;}}

Test: 测试

public class Test {public static void main(String[] args) {String str = "xxxxx";String result = MaskWordTable.getMaskWordTable().IsHave(str) ? MaskWordTable.getMaskWordTable().ConvertTo(str) : str;System.out.println(result);}}