Examples of com.vaadin.data.util.QueryContainer

com.vaadin.data.util.QueryContainer

The QueryContainer is the specialized form of Container which is Ordered and Indexed. This is used to represent the contents of relational database tables accessed through the JDBC Connection in the Vaadin Table. This creates Items based on the queryStatement provided to the container.

The QueryContainer can be visualized as a representation of a relational database table.Each Item in the container represents the row fetched by the query.All cells in a column have same data type and the data type information is retrieved from the metadata of the resultset.

Note : If data in the tables gets modified, Container will not get reflected with the updates, we have to explicity invoke QueryContainer.refresh method. {@link com.vaadin.data.util.QueryContainer#refresh() refresh()}
@see com.vaadin.data.Container @author IT Mill Ltd. @version @since 4.0 @deprecated will be removed in the future, use the SQLContainer add-on

    // TODO where deleted=?
    final String q = "SELECT DISTINCT(" + Resource.PROPERTY_ID_CATEGORY
        + ") FROM " + Resource.TABLE + " ORDER BY "
        + Resource.PROPERTY_ID_CATEGORY;
    try {
      return new QueryContainer(q, connection,
          ResultSet.TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_READ_ONLY);
    } catch (final SQLException e) {
      throw new RuntimeException(e);
    }

View Full Code Here

          + "'"; // FIXME ->
      // PreparedStatement!
    }


    try {
      return new QueryContainer(q, connection,
          ResultSet.TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_READ_ONLY);
    } catch (final SQLException e) {
      throw new RuntimeException(e);
    }

View Full Code Here

      q += " HAVING " + Reservation.PROPERTY_ID_RESOURCE_ID + " IN (" + s
          + ")";
    }
    q += " ORDER BY " + Reservation.PROPERTY_ID_RESERVED_FROM;
    try {
      final QueryContainer qc = new QueryContainer(q, connection,
          ResultSet.TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_READ_ONLY);
      if (qc.size() < 1) {
        return null;
      } else {
        return qc;
      }
    } catch (final SQLException e) {

View Full Code Here

  public Container getUsers() {
    // TODO where deleted=?
    final String q = "SELECT * FROM " + User.TABLE + " ORDER BY "
        + User.PROPERTY_ID_FULLNAME;
    try {
      final QueryContainer qc = new QueryContainer(q, connection,
          ResultSet.TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_READ_ONLY);
      return qc;
    } catch (final SQLException e) {
      throw new RuntimeException(e);

View Full Code Here

  /**
   * Populates table component with all rows from calendar table.
   */
  private void initCalendars() {
    try {
      final QueryContainer qc = new QueryContainer("SELECT * FROM "
          + CalendarDB.DB_TABLE_NAME, sampleDatabase
          .getConnection());
      from.setContainerDataSource(qc);
      to.setContainerDataSource(qc);
    } catch (final SQLException e) {

View Full Code Here

TOP

Related Classes of com.vaadin.data.util.QueryContainer

com.vaadin.data.Property

net.sf.czarrental.dl.ReservationsDB

net.sf.czarrental.pl.CalendarDemo

java.util.Collection

java.util.ArrayList

java.sql.ResultSetMetaData

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.