基于Java的dsts模拟考试系统设计源码

package cn.jit.util; import cn.jit.handler.ExcelHeader; import cn.jit.handler.ExcelTemplate; import cn.jit.util.Utils; import org.apache.commons.beanutils.BeanUtils; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.lang.reflect.Array; import java.util.ArrayList; import java.util.Collection; import java.util.List; import java.util.Map; public class ExcelUtils { static private ExcelUtils excelUtils = new ExcelUtils(); private ExcelUtils() { } public static ExcelUtils getInstance() { return excelUtils; } /*----------------------------------------读取Excel操作基于注解映射---------------------------------------------*/ /* 一. 操作流程 ： */ /* 1) 读取表头信息,与给出的Class类注解匹配 */ /* 2) 读取表头下面的数据内容, 按行读取, 并映射至java对象 */ /* 二. 参数说明 */ /* *) excelPath => 目标Excel路径 */ /* *) InputStream => 目标Excel文件流 */ /* *) clazz => java映射对象 */ /* *) offsetLine => 开始读取行坐标(默认0) */ /* *) limitLine => 最大读取行数(默认表尾) */ /* *) sheetIndex => Sheet索引(默认0) */ public <T> List<T> readExcel2Objects(String excelPath, Class<T> clazz, int offsetLine, int limitLine, int sheetIndex) throws Exception { Workbook workbook = WorkbookFactory.create(new File(excelPath)); return readExcel2ObjectsHandler(workbook, clazz, offsetLine, limitLine, sheetIndex); } public <T> List<T> readExcel2Objects(InputStream is, Class<T> clazz, int offsetLine, int limitLine, int sheetIndex) throws Exception { Workbook workbook = WorkbookFactory.create(is); return readExcel2ObjectsHandler(workbook, clazz, offsetLine, limitLine, sheetIndex); } public <T> List<T> readExcel2Objects(String excelPath, Class<T> clazz, int sheetIndex) throws Exception { return readExcel2Objects(excelPath, clazz, 0, Integer.MAX_VALUE, sheetIndex); } public <T> List<T> readExcel2Objects(String excelPath, Class<T> clazz) throws Exception { return readExcel2Objects(excelPath, clazz, 0, Integer.MAX_VALUE, 0); } public <T> List<T> readExcel2Objects(InputStream is, Class<T> clazz, int sheetIndex) throws Exception { return readExcel2Objects(is, clazz, 0, Integer.MAX_VALUE, sheetIndex); } public <T> List<T> readExcel2Objects(InputStream is, Class<T> clazz) throws Exception { return readExcel2Objects(is, clazz, 0, Integer.MAX_VALUE, 0); } private <T> List<T> readExcel2ObjectsHandler(Workbook workbook, Class<T> clazz, int offsetLine, int limitLine, int sheetIndex) throws Exception { Sheet sheet = workbook.getSheetAt(sheetIndex); Row row = sheet.getRow(offsetLine); List<T> list = new ArrayList<>(); Map<Integer, ExcelHeader> maps = Utils.getHeaderMap(row, clazz); if (maps == null || maps.size() <= 0) throw new RuntimeException("要读取的Excel的格式不正确，检查是否设定了合适的行"); int maxLine = sheet.getLastRowNum() > (offsetLine + limitLine) ? (offsetLine + limitLine) : sheet .getLastRowNum(); for (int i = offsetLine + 1; i <= maxLine; i++) { row = sheet.getRow(i); T obj = clazz.newInstance(); for (Cell cell : row) { int ci = cell.getColumnIndex(); ExcelHeader header = maps.get(ci); if (null == header) continue; String filed = header.getFiled(); String val = Utils.getCellValue(cell); Object value = Utils.str2TargetClass(val, header.getFiledClazz()); BeanUtils.copyProperty(obj, filed, value); } list.add(obj); } return list; } /*----------------------------------------读取Excel操作无映射--------------------------------------------------*/ /* 一. 操作流程 ： */ /* *) 按行读取Excel文件,存储形式为 Cell->String => Row->List<Cell> => Excel->List<Row> */ /* 二. 参数说明 */ /* *) excelPath => 目标Excel路径 */ /* *) InputStream => 目标Excel文件流 */ /* *) offsetLine => 开始读取行坐标(默认0) */ /* *) limitLine => 最大读取行数(默认表尾) */ /* *) sheetIndex => Sheet索引(默认0) */ public List<List<String>> readExcel2List(String excelPath, int offsetLine, int limitLine, int sheetIndex) throws Exception { Workbook workbook = WorkbookFactory.create(new File(excelPath)); return readExcel2ObjectsHandler(workbook, offsetLine, limitLine, sheetIndex); } public List<List<String>> readExcel2List(InputStream is, int offsetLine, int limitLine, int sheetIndex) throws Exception { Workbook workbook = WorkbookFactory.create(is); return readExcel2ObjectsHandler(workbook, offsetLine, limitLine, sheetIndex); } public List<List<String>> readExcel2List(String excelPath, int offsetLine) throws Exception { Workbook workbook = WorkbookFactory.create(new File(excelPath)); return readExcel2ObjectsHandler(workbook, offsetLine, Integer.MAX_VALUE, 0); } public List<List<String>> readExcel2List(InputStream is, int offsetLine) throws Exception { Workbook workbook = WorkbookFactory.create(is); return readExcel2ObjectsHandler(workbook, offsetLine, Integer.MAX_VALUE, 0); } public List<List<String>> readExcel2List(String excelPath) throws Exception { Workbook workbook = WorkbookFactory.create(new File(excelPath)); return readExcel2ObjectsHandler(workbook, 0, Integer.MAX_VALUE, 0); } public List<List<String>> readExcel2List(InputStream is) throws Exception { Workbook workbook = WorkbookFactory.create(is); return readExcel2ObjectsHandler(workbook, 0, Integer.MAX_VALUE, 0); } private List<List<String>> readExcel2ObjectsHandler(Workbook workbook, int offsetLine, int limitLine, int sheetIndex) throws Exception { List<List<String>> list = new ArrayList<>(); Sheet sheet = workbook.getSheetAt(sheetIndex); int maxLine = sheet.g