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 List<TgwEntry> toTgwEntryList(TgwEntity entity, DataTable dataTable) { return toTgwEntryList(entity, (List) dataTable.getDataList()); }
private void addTableHeaders(HSSFSheet sheet, DataTable dataTable) { HSSFRow row = row = addRow(sheet); Iterator headerItr = dataTable.getHeaderIterator(); if (dataTable.isSpreadSheet()) { addCell(row, getHeaderCellStyle(), " "); } while (headerItr.hasNext()) { String systemHeader = (String) headerItr.next(); String displayHeader = (String) dataTable.getDisplayHeaderMap() .get(systemHeader); addCell(row, getHeaderCellStyle(), displayHeader); } }
public static final CategoryDataset createCategoryDataset( DataTable dataTable) { CategoryDataset dataset = null; if (dataTable instanceof SpreadSheet) { int columnSize = dataTable.getColumnSize(); int rowSize = dataTable.getRowSize(); dataset = createCategoryDataset((SpreadSheet) dataTable, rowSize, columnSize); } else { int rowSize = dataTable.getRowSize(); dataset = createCategoryDataset(dataTable, rowSize); } return dataset; }
private String getEmails(String domainName, String entityName, String filterName) { TgwEntity entity = getEntity(domainName, entityName); TgwAttribute emailAttribute = EntityUtils.getEmailAttribute(entity); if (emailAttribute == null) { return null; } StringBuffer buf = new StringBuffer(); DataTable dataTable = null; if (filterName != null && !"".equals(filterName)) { dataTable = (DataTable) getEntityDAO(entity).getMethod(filterName) .evaluate(); } else { dataTable = getEntityDAO(entity).list(); } boolean first = true; while (dataTable.hasNext()) { dataTable.next(); Object obj = dataTable.getRowObject(); if (first) { first = false; } else { buf.append(","); } buf.append(EntityUtils.getProperty(obj, emailAttribute)); } return buf.toString(); }
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); }
private void addTableData(HSSFSheet sheet, DataTable table) { while (table.hasNext()) { HSSFRow row = addRow(sheet); Iterator columnItr = (Iterator) table.next(); if (table.isSpreadSheet()) { String rowHeader = ((SpreadSheet) table).getRowHeader(); addCell(row, getHeaderCellStyle(), rowHeader); } while (columnItr.hasNext()) { Object data = columnItr.next(); if (data != null) { addCell(row, getDataCellStyle(), String.valueOf(data .toString())); } else { addCell(row, getDataCellStyle(), ""); } } } }
public static final JFreeChart createPieChart(DataTable dataTable) { int columnSize = dataTable.getColumnSize(); JFreeChart pieChart = null; if (columnSize == 2) { CategoryDataset cData = createCategoryDataset(dataTable); PieDataset pieData = DatasetUtilities.createPieDatasetForRow(cData, 0); pieChart = ChartFactory.createPieChart(dataTable.getName(), pieData, true, true, true); // PiePlot piePlot = (PiePlot) pieChart.getPlot(); // piePlot.setCircular(false); // piePlot.setExplodePercent(1, 0.5); } return pieChart; }
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 JFreeChart createBarChart(DataTable dataTable) { CategoryDataset cData = createCategoryDataset(dataTable); String dataLabel = getDataLabel(dataTable); String columnLabel = getColumnLabel(dataTable); JFreeChart barChart = ChartFactory.createBarChart(dataTable.getName(), columnLabel, dataLabel, cData, PlotOrientation.VERTICAL, true, true, true); return barChart; }
private Trackback getTrackbackBean(String siteName, String pagename, String url, String title, String blogName, String excerpt) throws PluginException { Trackback trackback = new Trackback(); // already exists or not for given pagename and source URL DataTable dataTable = getTrackbackDAO().getTrackbacks(siteName, pagename, url); if (dataTable.hasNext()) { dataTable.next(); Trackback aTrackback = (Trackback) dataTable.getRowObject(); trackback.setId(aTrackback.getId()); } trackback.setPagename(pagename); trackback.setUrl(url.replaceAll("<", "<").replaceAll(">", ">")); if (title != null && !title.equals("")) trackback.setTitle(ResponseUtils.filter(title)); if (blogName != null && !blogName.equals("")) trackback.setBlogName(ResponseUtils.filter(blogName)); if (excerpt != null && !excerpt.equals("")) trackback.setExcerpt(ResponseUtils.filter(excerpt)); return trackback; }
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; }
public static JFreeChart createLineChart(DataTable dataTable) { CategoryDataset cData = createCategoryDataset(dataTable); String dataLabel = getDataLabel(dataTable); String columnLabel = getColumnLabel(dataTable); JFreeChart chart = ChartFactory.createLineChart(dataTable.getName(), columnLabel, dataLabel, cData, PlotOrientation.VERTICAL, true, true, false); return chart; }
DataTable dataTable = (DataTable) getEntityDAO(entity).list( new EqCriteriaFunction(emailAttr.getName(), emails[i])); if (dataTable.hasNext()) { dataTable.next(); Object obj = dataTable.getRowObject();
TgwEntity tgwRole = domain.findEntityByAnnotaion( TgwEntity.A_BUILTIN, "role"); Collection roleList = dataService.list(tgwRole).getDataList();
public void addDataTable(TgwEntity entity, DataTable dataTable) { // create sheet HSSFSheet sheet = addSheet(dataTable.getName()); setPrintSetup(sheet, entity.getName()); addTableHeaders(sheet, dataTable); addTableData(sheet, dataTable); }
while (dataTable.hasNext() && number > 0) { dataTable.next(); Trackback trackback = (Trackback) dataTable.getRowObject();