发现新大陆

hai9413hui

于 2012-02-25 14:07:58 发布

阅读量301

点赞数

本文链接：https://blog.youkuaiyun.com/hai9413hui/article/details/7293403

版权

一个很不错的博客空间，让你可以学到很多哦

http://blog.youkuaiyun.com/dyllove98/article/

hai9413hui

博客等级

码龄15年

9
原创

0
点赞

0
收藏

0
粉丝

关注

私信

最新评论

DOM4J解析XML增加节点及内容
hai9413hui: /** * 对导出的报表再做处理，因为报表生成器的局限，需要将报表中的空行去除 * 有个缺点，对EXCEL的颜色支持不够，2007的某些色彩经此处理之后改变了，模板中的绿色变成黄色了 * * @param excelName 报表的文件名 */ public void afterTransformXLS_JXL(String excelName) { // Excel获得文件 jxl.Workbook wb = null; WritableWorkbook wwb = null; try { wb = jxl.Workbook.getWorkbook(new File(excelName)); // 获得Excel文件 wwb = jxl.Workbook.createWorkbook(new File(excelName), wb); for (int sheet_no = 0; sheet_no < wwb.getNumberOfSheets(); sheet_no++){WritableSheet ws = wwb.getSheet(sheet_no); for (int row_no = ws.getRows(); row_no >= 0; row_no--) { if (ws.getCell(0, row_no).getContents() == ""|| ws.getCell(1, row_no).getContents() == null){ws.removeRow(row_no); }}} wwb.write(); } catch (BiffException e){} catch (IOException e){ } finally{try{ wwb.close();} catch (WriteException e) { } catch (IOException e) {} } }
DOM4J解析XML增加节点及内容
hai9413hui: /** * 导出excel的数据 */ private void excelData(Collection<ONTBaseInfoGponDTO> ontInfoCol, String path) { // 将导出信息封装到Map中去 Map<String, Collection<ONTBaseInfoGponDTO>> beans = new HashMap<String, Collection<ONTBaseInfoGponDTO>>(); beans.put("ontInfoCol", ontInfoCol); try { XLSTransformer transformer = new XLSTransformer(); // 生成导出报表 transformer.transformXLS(xlsTemplateFileNameGpon, beans, path); // 对报表做后期处理 afterTransformXLS_JXL(path); } catch (ParsePropertyException e) { LogManager.recordLog(LogType.error, e.toString()); } catch (InvalidFormatException e) { LogManager.recordLog(LogType.error, e.toString()); } catch (IOException e) {} finally { // 清空集合 ontInfoCol.clear(); } }
几个好点的网站
hai9413hui: private DefaultTableModel addTableModleData(Map<String, String> devMap) { // 表格列向量 Vector cell; // 表格行向量 Vector row = new Vector(); // 声明表格模型 DefaultTableModel tableModel = new DefaultTableModel(); // 声明表格头数组 String[] tableHeads = {PropertiesUtil.getInfoMap().get("RESULT"), PropertiesUtil.getInfoMap().get("DEVICE_IP"), PropertiesUtil.getInfoMap().get("ERROR")}; // 将表格头转换过向量类型，以备表格模型使用 Vector tableHeadName = new Vector(); for (int i = 0; i < tableHeads.length; i++) {tableHeadName.add(tableHeads[i]);} Set<String> devSet = devMap.keySet(); for (String ip : devSet) {String content = devMap.get(ip); String[] resList = content.split(";");cell = new Vector();for (int i = 0; i < resList.length; i++){if (i == 0){cell.add(resList[i]); }if (i == 1) {cell.add(ip);} if (i == 2){cell.add(resList[i]);}}row.add(cell);} tableModel.setDataVector(row, tableHeadName); return tableModel;}
几个好点的网站
hai9413hui: /** * 更新进度条的进度 * * @param scale 进度数值 */ public void update(int scale) { if (scale > progressBar.getMaximum()) { // 超出最大值 scale = progressBar.getMaximum(); } if (scale < progressBar.getMinimum()) { // 超出最小值 scale = progressBar.getMinimum(); } if (scale == 100) { label_3.setText(taskMessage); if (devInfo != null) { table_1.setModel(addTableModleData(devInfo)); } } // 显示刻度 progressBar.setValue(scale); }
几个好点的网站
hai9413hui: final JScrollPane scrollPane_1 = new JScrollPane(); scrollPane_1.setBounds(10, 102, 405, 131); jDialog1.getContentPane().add(scrollPane_1); table_1 = new JTable(addTableModleData(devInfo)) { public String getToolTipText(MouseEvent e) { String tip = null; java.awt.Point p = e.getPoint(); int rowIndex = rowAtPoint(p); int colIndex = columnAtPoint(p); int realColumnIndex = convertColumnIndexToModel(colIndex); try { if (realColumnIndex == 2) { tip = getValueAt(rowIndex, colIndex).toString(); } else{tip = super.getToolTipText(e);}} catch (NullPointerException nulle) { nulle.getMessage();} return tip;}}; table_1.setModel(new Table_1TableModel()); scrollPane_1.setViewportView(table_1); table_1.getTopLevelAncestor();}