/** * Constructor from database row * * @param connectionInfo Database row */ public DatabaseConnectionInfo(Map<String, CellData> connectionInfo) { super(); alias = connectionInfo.get("alias").getStringValue(); description = connectionInfo.get("description").getStringValue(); connectionType = connectionInfo.get("connectionType").getStringValue(); databaseType = connectionInfo.get("databaseType").getStringValue(); environment = connectionInfo.get("environment").getStringValue(); url = connectionInfo.get("url").getStringValue(); user = connectionInfo.get("user").getStringValue(); password = connectionInfo.get("password").getStringValue(); driver = connectionInfo.get("driver").getStringValue(); jndi = "D".equalsIgnoreCase(connectionType) ? "java:comp/env/" + url : null; }
/** * Returns the datalist as a string array * * @param dataList Datalist * @param columnList Column order * @return DataList as a string array */ public static String[] getDataAsArray(DataList dataList, List<String> columnList) { List<String> list = new ArrayList<>(); for (Map<String, CellData> row : dataList.getRows()) { for (String val : columnList) { CellData cell = row.get(val); list.add(cell != null ? cell.getStringValue() : ""); } } String[] dataArray = new String[list.size()]; return list.toArray(dataArray); }
/** * Returns the value data by (rowNumber, hashKey) * * @param list DataList * @param rowNumber Row number * @param key Column name * @return Single Value Data */ public static String getData(DataList list, Integer rowNumber, String key) { // Variable definition Map<String, CellData> row; String cellString = ""; row = getRow(list, rowNumber); CellData cell = row.get(key); if (cell != null) { cellString = cell.getStringValue(); } return cellString; }
/** * Remove the rows whose column value is distinct to the value * * @param list DataList to filter * @param column column to check * @param value value to check */ public static void filter(DataList list, String column, String value) { List<Map<String, CellData>> newRows = new ArrayList<>(); for (Map<String, CellData> row : list.getRows()) { if (row.containsKey(column)) { CellData cell = row.get(column); if (cell.getStringValue().equalsIgnoreCase(value)) { newRows.add(row); } } } // Set the new list list.setRows(newRows); }
/** * Store the service response from one row of Datalist * * @param dataList DataList to store * @param rowNum Row index of DataList to store * @return this */ public ServiceData setData(DataList dataList, Integer rowNum) { if (rowNum != null) { List<String> result = new ArrayList<>(DataListUtil.getColumnList(dataList).size()); // Get row data Map<String, CellData> rowData = DataListUtil.getRow(dataList, rowNum); // Build list with data of row for (Map.Entry<String, CellData> entry : rowData.entrySet()) { result.add(entry.getValue().getStringValue()); } this.data = result.toArray(); } return this; }
public Object getValue() { if (sendStringValue) { return this.getStringValue(); } else { switch (this.getType()) { case STRING: default: return this.getStringValue();
/** * Set celldata value * * @param value Long value * @return this */ @JsonIgnore public CellData setValue(CellData value) { setValue(value.getStringValue(), value.getObjectValue(), value.getType()); return this; }
/** * Returns the value casted as date * * @return CellData value as Date */ @JsonIgnore public Date getDateValue() { Date dateValue = null; switch (this.getType()) { // Get value as date case DATE: dateValue = (Date) this.getObjectValue(); break; // Get value as date case STRING: default: dateValue = stringToDate(getStringValue()); break; } return dateValue; }
String string1 = this.getStringValue(); String string2 = cell2.getStringValue(); equals = string1.equals(string2); break;
String string1 = this.getStringValue(); String string2 = cell2.getStringValue(); comparison = string1.compareTo(string2); break;