Version 8.3.2	SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT

The DBRADIOBUTTON control represents a filter criterion of a database query. Compared to a "normal" RADIOBUTTON control, the only benefit is the convenient way of appending the filter criterion to the SELECT statement.

This document covers the following topics:

• Example

• Properties

Example

The following image shows an example in which the DBRADIOBUTTON is used for the filter criterion "Country":

Have a look at the XML layout definition:

<rowarea name="Filter Criteria">
    <itr>
        <label name="Country" width="80">
        </label>
        <dbradiobutton valueprop="dBRadioButtonSex" querycolumn="COUNTRY" value="DE">
        </dbradiobutton>
        <hdist>
        </hdist>
        <label name="DE" asplaintext="true">
        </label>
        <hdist width="40">
        </hdist>
        <dbradiobutton valueprop="dBRadioButtonSex" querycolumn="COUNTRY" value="UK">
        </dbradiobutton>
        <hdist>
        </hdist>
        <label name="UK" asplaintext="true">
        </label>
        <hdist width="40">
        </hdist>
        <dbradiobutton valueprop="dBRadioButtonSex" querycolumn="COUNTRY" value="US">
        </dbradiobutton>
        <hdist>
        </hdist>
        <label name="US" asplaintext="true">
        </label>
        <hdist>
        </hdist>
        <hdist width="100%">
        </hdist>
        <button name="Execute" method="onExecute">
        </button>
    </itr>
</rowarea>
<vdist>
</vdist>
<rowarea name="Result" height="140">
    <itr height="100%">
        <textgridsss2 griddataprop="result" rowcount="5" width="100%">
            <column name="Title" property="TITLE" width="50">
            </column>
            <column name="Last Name" property="LASTNAME" width="100">
            </column>
            <column name="First Name" property="FIRSTNAME" width="100">
            </column>
            <column name="Country" property="COUNTRY" width="50">
            </column>
            <column name="State" property="STATE" width="100%">
            </column>
        </textgridsss2>
    </itr>
</rowarea>

The corresponding adapter code is:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import com.softwareag.cis.server.Adapter;
import com.softwareag.cis.server.util.DBRADIOBUTTONInfo;
import com.softwareag.cis.server.util.DBTEXTGRIDCollection;
import com.softwareag.cis.server.util.DBUtil;
import com.softwareag.cis.server.util.DelegateError;
import com.softwareag.cis.server.util.IDBCondition;
import com.softwareag.cis.server.util.IDBQUERYConnectionProvider;

// This class is a generated one.

public class DBRadioButton_Adapter
    extends Adapter
    implements IDBQUERYConnectionProvider, IDBDemoAdapter
{
...
    // property >dBRadioButtonSex<
    DBRADIOBUTTONInfo m_dBRadioButtonSex = new DBRADIOBUTTONInfo();
    public DBRADIOBUTTONInfo getDBRadioButtonSex() { return m_dBRadioButtonSex; }

    // property >result<
    DBTEXTGRIDCollection m_result = new DBTEXTGRIDCollection();
    public DBTEXTGRIDCollection getResult() { return m_result; }
    public void setResult(DBTEXTGRIDCollection value) { m_result = value; }
...
    public void onExecute()
    {
        try
        {
            StringBuffer sb = new StringBuffer();
            sb.append("SELECT * FROM BUSINESSPARTNER INNER JOIN ADDRESS ON BUSINESSPARTNER.ID = 
                                ADDRESS.BUSINESSPARTNERID");
            DBUtil.addToQuery(sb, new IDBCondition[] { m_dBRadioButtonSex }, true);
            Class.forName("org.hsqldb.jdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost", "sa", "");
            ResultSet rs = con.createStatement().executeQuery(sb.toString());
            m_result.initWithResultSet(rs);
        }
        catch (Exception exc)
        {
            throw new DelegateError(exc);
        }
    }
...
}

The adapter property dBRadioButtonCountry is of type DBRADIOBUTTONInfo (from the package com.softwareag.cis.server.util). This class has a property value that is manipulated by the DBRADIOBUTTON control. The DBRADIOBUTTONInfo implements (like all DB controls) the interface IDBCondition (com.softwareag.cis.server.util). With class DBUtil (com.softwareag.cis.server.util), there is a convenient way to append the filter value to the SQL query. See the JavaDoc documentation of class DBRADIOBUTTONInfo and DBUtil for details.

For displaying the result, the class DBTEXTGRIDCollection (from the package com.softwareag.cis.server.util) is used. This class extends TEXTGRIDCollection by the ability to initialise the collection with a result set (java.sql.ResultSet). For each line of the result set, it creates an object of class DBTEXTGRIDLine (package com.softwareag.cis.server.util). Class DBTEXTGRIDLine implements the interface IDynamicAccess. With this, "normal" text grid controls can be used to visualize the data of the DBTEXTGRIDCollection.

Properties

www.softwareag.com

Copyright © 2005-2013 Software AG, Darmstadt, Germany.

SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT