| Package | Description | 
|---|---|
| com.irisel.oms.dbh | |
| com.irisel.oms.ejb.browser | |
| com.irisel.oms.ejb.interfaces | |
| com.irisel.oms.guiom.interfaces | |
| com.irisel.oms.olapi | |
| com.irisel.oms.olapi.internal | |
| com.irisel.oms.sql | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | Dbh. execute(Query q)Executes the given query over existing db connection. | 
| boolean | DBHandler. execute(Query q) | 
| java.lang.Object | Dbh. executeQuery(Query q,
            boolean valuesFormatted,
            ResultsHandler processor) | 
| java.lang.Object | DBHandler. executeQuery(Query q,
            boolean formattedValues,
            ResultsHandler processor) | 
| java.lang.Object | Dbh. executeQuery(Query q,
            ResultsHandler p)Executes the given query over existing db connection. | 
| java.lang.Object | DBHandler. executeQuery(Query q,
            ResultsHandler processor) | 
| int | Dbh. executeUpdate(Query q) | 
| int | DBHandler. executeUpdate(Query q) | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | OMBrowserBean. execute(Query q)Business method | 
| int | OMBrowserBean. executeUpdate(Query q)Business method | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | OMBrowserEJB. execute(Query q)Business method | 
| int | OMBrowserEJB. executeUpdate(Query q)Business method | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | Browser. execute(Query q) | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | SSBrowser. execute(Query q) | 
| int | SSBrowser. executeUpdate(Query q) | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | OMSBrowser. execute(Query q) | 
| boolean | Browser. execute(Query q)Deprecated.  | 
| int | OMSBrowser. executeUpdate(Query q) | 
| int | Browser. executeUpdate(Query q)Deprecated.  | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AlterTableQueryThis class is used to generate, store and analyze SQL statements. | 
| class  | CreateTableQueryThis class is used to generate, store and analyze Create-Table SQL statements. | 
| class  | DeleteQueryThis class is used to generate, store and analyze SQL statements. | 
| class  | DropTableQueryThis class is used to generate, store and analyze SQL statements. | 
| class  | InsertQueryThis class is used to generate, store and analyze SQL statements. | 
| class  | SelectQueryThis class is used to generate, store and analyze SQL statements. | 
| class  | UpdateQueryThis class is used to generate, store and analyze SQL statements. | 
| Modifier and Type | Method and Description | 
|---|---|
| Query[] | Query. getChilds()Returns array of 1st-level child Querys. | 
| Query[] | Query. getChildsDeep()Returns array of child Querys (recursively). | 
| Query | Filter. getQuery2()Returns the (query) right-hand value of this filter. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | Filter. setQuery2(Query newQuery2)Sets the right-hand query for this filter. | 
| Constructor and Description | 
|---|
| Filter(Field f1,
      int op,
      Query q2)Constructor for filters of the form: tableA.field1 IN ( select field1 from tableB where ...) |