public Object readSqlResultRecord(ResultSet result) { try { // create the Resource from the db xml String xml = result.getString(1); Entity entry = readResource(xml); return entry; } catch (SQLException ignore) { return null; } } });
public Object readSqlResultRecord(ResultSet result) { try { // create the Resource from the db xml String xml = result.getString(1); Entity entry = readResource(xml); return entry; } catch (SQLException ignore) { return null; } } });
public List getSelectedResourcesWhere(String sqlWhere) { List all = new Vector(); // read all users from the db String sql = singleStorageSql.getXmlWhereSql(m_resourceTableName, sqlWhere); // %%% + "order by " + m_resourceTableOrderField + " asc"; List xml = m_sql.dbRead(sql); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry); } } return all; }
public List getAllResources() { List all = new Vector(); // read all users from the db String sql = singleStorageSql.getXmlSql(m_resourceTableName); // %%% + "order by " + m_resourceTableOrderField + " asc"; List xml = m_sql.dbRead(sql); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry); } } return all; }
public List getAllResources() { List all = new Vector(); // read all users from the db String sql = singleStorageSql.getXmlSql(m_resourceTableName); // %%% + "order by " + m_resourceTableOrderField + " asc"; List xml = m_sql.dbRead(sql); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry); } } return all; }
public List getSelectedResourcesWhere(String sqlWhere) { List all = new Vector(); // read all users from the db String sql = singleStorageSql.getXmlWhereSql(m_resourceTableName, sqlWhere); // %%% + "order by " + m_resourceTableOrderField + " asc"; List xml = m_sql.dbRead(sql); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry); } } return all; }
public List getAllResources(int first, int last) { String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName, first, last); Object[] fields = singleStorageSql.getXmlFields(first, last); List xml = m_sql.dbRead(sql, fields, null); List rv = new Vector(); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) rv.add(entry); } } return rv; }
public List getAllResources(int first, int last) { String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName, first, last); Object[] fields = singleStorageSql.getXmlFields(first, last); List xml = m_sql.dbRead(sql, fields, null); List rv = new Vector(); // process all result xml into user objects if (!xml.isEmpty()) { for (int i = 0; i < xml.size(); i++) { Entity entry = readResource((String) xml.get(i)); if (entry != null) rv.add(entry); } } return rv; }
public Object readSqlResultRecord(ResultSet result) { try { if (storage instanceof BaseDbBinarySingleStorage) { return ((BaseDbBinarySingleStorage) storage).readResource(result .getBytes(1)); } else if (storage instanceof BaseDbDualSingleStorage) { return ((BaseDbDualSingleStorage) storage).readResource(result .getString(1), result.getBytes(2)); } else { return ((BaseDbSingleStorage) storage).readResource(result.getString(1)); } } catch (Exception ex) { log.error("Failed to read entity Record "); } return null; } }
public Object readSqlResultRecord(ResultSet result) { try { if (storage instanceof BaseDbBinarySingleStorage) { return ((BaseDbBinarySingleStorage) storage).readResource(result .getBytes(1)); } else if (storage instanceof BaseDbDualSingleStorage) { return ((BaseDbDualSingleStorage) storage).readResource(result .getString(1), result.getBytes(2)); } else { return ((BaseDbSingleStorage) storage).readResource(result.getString(1)); } } catch (Exception ex) { log.error("Failed to read entity Record "); } return null; } }
Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry);
public Entity getResource(String id) { Entity entry = null; // get the user from the db String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); List xml = m_sql.dbRead(sql, fields, null); if (!xml.isEmpty()) { // create the Resource from the db xml entry = readResource((String) xml.get(0)); } return entry; }
public Entity getResource(String id) { Entity entry = null; // get the user from the db String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); List xml = m_sql.dbRead(sql, fields, null); if (!xml.isEmpty()) { // create the Resource from the db xml entry = readResource((String) xml.get(0)); } return entry; }
Entity entry = readResource((String) xml.get(i)); if (entry != null) all.add(entry);
Entity entry = readResource(result.toString()); edit = m_user.newResourceEdit(null, entry);
Entity entry = readResource(result.toString()); edit = m_user.newResourceEdit(null, entry);