public List getAllResourcesWhere(String field, String value) { // read all users from the db String sql = singleStorageSql.getXmlSql(field, m_resourceTableName); Object[] fields = new Object[1]; fields[0] = value; // %%% + "order by " + m_resourceTableOrderField + " asc"; return loadResources(sql, fields); }
public List getAllResourcesWhere(String field, String value) { // read all users from the db String sql = singleStorageSql.getXmlSql(field, m_resourceTableName); Object[] fields = new Object[1]; fields[0] = value; // %%% + "order by " + m_resourceTableOrderField + " asc"; return loadResources(sql, fields); }
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 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 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; }