public static class STHTables.DRIVERS
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DRV_ID |
static java.lang.String |
PROV_NAME |
static java.lang.String |
SYS_NAME |
static java.lang.String |
TABLE_NAME |
Constructor and Description |
---|
DRIVERS() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
queryAllProviders()
SELECT id, gwname, provider from drivers ORDER BY provider
|
static java.lang.String |
queryDRVIDForName()
SELECT id FROM drivers WHERE name=? *
|
static java.lang.String |
queryInsert()
INSERT INTO drivers(name, provider) values(?,?) *
|
static java.lang.String |
queryProviders_v1()
SELECT id, name FROM drivers ORDER BY name ASC
|
static java.lang.String |
queryProviders_v2()
SELECT id, name, provider FROM drivers ORDER BY name ASC
|
static java.lang.String |
queryProvidersForSystem_v1() |
static java.lang.String |
queryProvidersForSystem_v2()
SELECT id, name, provider from drivers WHERE name=? ORDER BY provider *
|
static java.lang.String |
queryUpdate()
UPDATE drivers SET name=? WHERE name=? *
|
public static final java.lang.String TABLE_NAME
public static final java.lang.String DRV_ID
public static final java.lang.String SYS_NAME
public static final java.lang.String PROV_NAME
public static java.lang.String queryDRVIDForName()
public static java.lang.String queryProviders_v2()
public static java.lang.String queryProviders_v1()
public static java.lang.String queryProvidersForSystem_v2()
public static java.lang.String queryAllProviders()
public static java.lang.String queryProvidersForSystem_v1()
public static java.lang.String queryInsert()
public static java.lang.String queryUpdate()