private TableData[][] toTableDataSet(DataTable dataTable) { TableData[][] data = new TableData[dataTable.getRowSize()][dataTable .getColumnSize()]; for (int i = 0; dataTable.hasNext(); i++) { DataRow row = dataTable.nextRow(); for (int j = 0; row.hasNext(); j++) { String name = (String) dataTable.getHeaders().get(j); Object value = row.next(); data[i][j] = new TableData(name, String.valueOf(value)); } } return data; } }
public static final CategoryDataset createCategoryDataset( DataTable dataTable, int rowSize) { double[][] data = new double[1][rowSize]; Comparable[] rowKeys = new Comparable[1]; Comparable[] columnKeys = new Comparable[rowSize]; rowKeys[0] = (String)dataTable.getHeaders().get(1); for (int i = 0; dataTable.hasNextRow(); i++) { DataRow dataRow = dataTable.nextRow(); Comparable columnKey = (Comparable) dataRow.getCell(0); if(columnKey == null){ columnKey = TgwResource.getMessage("msg.nodata"); } columnKeys[i] = columnKey; Object obj = dataRow.getCell(1); if (obj != null) { data[0][i] = Double.parseDouble(String.valueOf(obj)); } else { data[0][i] = 0.0; } } return DatasetUtilities .createCategoryDataset(rowKeys, columnKeys, data); }
public List toEditableHtml(int lineNumber, DataRow dataRow) { Object obj = null; if (dataRow != null) { obj = dataRow.getDataObject(); } return tableForm.toRowElements(lineNumber, obj, dataTable.getHeaders()); }
public static final CategoryDataset createCategoryDataset( SpreadSheet sheet, int rowSize, int columnSize) { double[][] data = new double[rowSize][columnSize]; Comparable[] rowKeys = new Comparable[rowSize]; Comparable[] columnKeys = new Comparable[columnSize]; List rowHeaders = sheet.getRowHeaders(); List columnHeaders = sheet.getColumnHeaders(); for (int row = 0; row < rowSize; row++) { rowKeys[row] = (Comparable) rowHeaders.get(row); DataRow dataRow = sheet.nextRow(); for (int column = 0; column < columnSize; column++) { if (row == 0) { columnKeys[column] = (Comparable) columnHeaders.get(column); } Object obj = dataRow.next(); if (obj != null) { data[row][column] = Double.parseDouble(String.valueOf(obj)); } else { data[row][column] = 0.0; } } } return DatasetUtilities .createCategoryDataset(rowKeys, columnKeys, data); }
public Counter getCounter(CriteriaFunction criteria) { DataTable dataTable = getCounterDataTable(criteria); if (dataTable.hasNext()) { DataRow dataRow = (DataRow) dataTable.next(); return (Counter) dataRow.getDataObject(); } return null; }
public Counter getTotalCounter(String pagePath) { EqCriteriaFunction criteria = new EqCriteriaFunction(PAGE_NAME, pagePath); DataTable dataTable = getCounterDataTable(criteria); Counter counter = (Counter) entity.newInstance(); int total = 0; while (dataTable.hasNext()) { DataRow row = (DataRow) dataTable.next(); Counter rowCounter = (Counter) row.getDataObject(); int count = rowCounter.getAccessCount().intValue(); total += count; } counter.setPageName(pagePath); counter.setAccessCount(new Integer(total)); // counter.setAccessDate(new Date()); return counter; }