Example usage for com.google.gwt.gears.client.database Database execute

Introduction

In this page you can find the example usage for com.google.gwt.gears.client.database Database execute.

Prototype

private native ResultSet execute(String sqlStatement, JavaScriptObject args) ;

Source Link

Usage

From source file:org.sigmah.client.offline.sigmah.dao.OrganizationDAO.java

License:Open Source License

/**
 * Read an organization from the local database.
 * @param organizationId Identifier of the organization to read.
 * @param database Google Gears database, must have already been opened.
 * @return An OrganizationDTO or <code>null</code> if the given identifier isn't present in the local database.
 * @throws DatabaseException/* w ww  .java 2 s  . c  o m*/
 */
public static OrganizationDTO selectOrganization(int organizationId, final Database database)
        throws DatabaseException {
    final ResultSet resultSet = database.execute("SELECT * FROM organization " + "WHERE id = ?",
            Integer.toString(organizationId));

    final OrganizationDTO organizationDTO = asOrganizationDTO(resultSet);
    if (organizationDTO != null) {
        final OrgUnitDTO rootOrgUnit = iterateSelectOnOrgUnit(organizationDTO.getRoot().getId(), database);
        organizationDTO.setRoot(rootOrgUnit);
    }

    return organizationDTO;
}

---

From source file:org.sigmah.client.offline.sigmah.dao.OrganizationDAO.java

License:Open Source License

private static OrgUnitDTO iterateSelectOnOrgUnit(int orgUnitId, Database database) throws DatabaseException {
    final ResultSet resultSet = database.execute("SELECT * FROM orgUnit " + "WHERE id = ?",
            Integer.toString(orgUnitId));

    final OrgUnitDTO orgUnitDTO = asOrgUnitDTO(resultSet);
    if (orgUnitDTO != null)
        orgUnitDTO.setChildren(findSubOrgUnits(orgUnitDTO.getId(), database));

    return orgUnitDTO;
}

---

From source file:org.sigmah.client.offline.sigmah.dao.OrganizationDAO.java

License:Open Source License

private static Set<OrgUnitDTO> findSubOrgUnits(int parentOrgUnitId, Database database)
        throws DatabaseException {
    final ResultSet resultSet = database.execute("SELECT * FROM orgUnit " + "WHERE parent = ?",
            Integer.toString(parentOrgUnitId));

    final LinkedHashSet<OrgUnitDTO> children = new LinkedHashSet<OrgUnitDTO>();

    while (resultSet.isValidRow()) {

        final OrgUnitDTO orgUnitDTO = asOrgUnitDTO(resultSet);
        Log.debug("OrgUnit, parent : " + parentOrgUnitId + ", child : " + orgUnitDTO.getId());

        if (orgUnitDTO != null)
            orgUnitDTO.setChildren(findSubOrgUnits(orgUnitDTO.getId(), database));

        children.add(orgUnitDTO);//from  www . j  a v  a 2 s  . co m
        resultSet.next();
    }

    return children;
}

---

From source file:org.sigmah.client.offline.sigmah.Query.java

License:Open Source License

public ResultSet execute() throws DatabaseException {
    final Factory factory = Factory.getInstance();
    final Database database = factory.createDatabase();

    database.open(OnlineMode.LOCAL_DATABASE_NAME);

    final ResultSet resultSet = database.execute(statement, arguments);

    database.close();//from w  w  w . j  a v a  2s .c  o m

    return resultSet;
}

---

From source file:org.sigmah.client.offline.sigmah.Query.java

License:Open Source License

public ResultSet execute(final Database database) throws DatabaseException {
    return database.execute(statement, arguments);
}

---