ManagedFileDirectoryUtilitySQLResource

java.lang.Object
- com.ibm.commerce.context.content.resources.file.ManagedFileDirectoryUtilitySQLResource

```
public abstract class ManagedFileDirectoryUtilitySQLResource
extends java.lang.Object
```
This class holds all the constants that define SQL statements as well as utilities to retrieve their values.

Field Summary

Fields
Modifier and Type	Field and Description
`protected static java.lang.String`	`CMFILEDIR_COLUMN_CMFILEDIR_ID` This is a constant to represent the key used to retrieve the database table column names from the property file.
`protected static java.lang.String`	`CMFILEDIR_COLUMN_CMFILEDIR_PARENT` This is a constant to represent the key used to retrieve the database table column names from the property file.
`protected static java.lang.String`	`CMFILEDIR_COLUMN_DISPLAYNAME` This is a constant to represent the key used to retrieve the database table column names from the property file.
`protected static java.lang.String`	`CMFILEDIR_COLUMN_IDENTIFIER` This is a constant to represent the key used to retrieve the database table column names from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_DELETE_BY_CMFILEDIR_ID` This is a constant to represent the key used to delete a record in table `CMFILEDIR` from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_INSERT_GENERIC` This is a constant to represent the key used to retrieve the `SQL` statements from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT` This is a constant to represent the key used to retrieve the `SQL` statements from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT_IS_NULL` This is a constant to represent the key used to retrieve the `SQL` statements from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_AND_IDENTIFIER` This is a constant to represent the key used to retrieve the `SQL` statements from the property file.
`protected static java.lang.String`	`CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_IS_NULL_AND_IDENTIFIER` This is a constant to represent the key used to retrieve the `SQL` statements from the property file.
`protected static java.lang.String`	`CMFILEDIR_TABLE` This is a constant to represent the key used to retrieve the database table names from the property file.
`static java.lang.String`	`COPYRIGHT` IBM Copyright notice field.
`static java.lang.String`	`PROPERTY_FILE_KEY_PREFIX` This is a constant to represent the prefix of the key used to retrieve the database related constant.
`protected static java.lang.String`	`RESOURCE_BUNDLE` This is the resource bundle used to get the `SQL` statements.

Constructor Summary

Constructors
Constructor and Description

ManagedFileDirectoryUtilitySQLResource()

Constructors
Constructor and Description
`ManagedFileDirectoryUtilitySQLResource()`

Method Summary

Methods
Modifier and Type Method and Description

static java.lang.String get(java.lang.String key)
This method returns the value associated with the specified key.
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods
Modifier and Type	Method and Description
`static java.lang.String`	`get(java.lang.String key)` This method returns the value associated with the specified key.

- Field Detail
  - COPYRIGHT
```
public static final java.lang.String COPYRIGHT
```
    IBM Copyright notice field.
    
    See Also:
    
    Constant Field Values
  - RESOURCE_BUNDLE
```
protected static final java.lang.String RESOURCE_BUNDLE
```
    This is the resource bundle used to get the SQL statements.
  - CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_AND_IDENTIFIER
```
protected static final java.lang.String CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_AND_IDENTIFIER
```
    This is a constant to represent the key used to retrieve the SQL statements from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_IS_NULL_AND_IDENTIFIER
```
protected static final java.lang.String CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_IS_NULL_AND_IDENTIFIER
```
    This is a constant to represent the key used to retrieve the SQL statements from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT
```
protected static final java.lang.String CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT
```
    This is a constant to represent the key used to retrieve the SQL statements from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT_IS_NULL
```
protected static final java.lang.String CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT_IS_NULL
```
    This is a constant to represent the key used to retrieve the SQL statements from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_SQL_INSERT_GENERIC
```
protected static final java.lang.String CMFILEDIR_SQL_INSERT_GENERIC
```
    This is a constant to represent the key used to retrieve the SQL statements from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_COLUMN_CMFILEDIR_ID
```
protected static final java.lang.String CMFILEDIR_COLUMN_CMFILEDIR_ID
```
    This is a constant to represent the key used to retrieve the database table column names from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_COLUMN_CMFILEDIR_PARENT
```
protected static final java.lang.String CMFILEDIR_COLUMN_CMFILEDIR_PARENT
```
    This is a constant to represent the key used to retrieve the database table column names from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_COLUMN_IDENTIFIER
```
protected static final java.lang.String CMFILEDIR_COLUMN_IDENTIFIER
```
    This is a constant to represent the key used to retrieve the database table column names from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_COLUMN_DISPLAYNAME
```
protected static final java.lang.String CMFILEDIR_COLUMN_DISPLAYNAME
```
    This is a constant to represent the key used to retrieve the database table column names from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_TABLE
```
protected static final java.lang.String CMFILEDIR_TABLE
```
    This is a constant to represent the key used to retrieve the database table names from the property file.
    
    See Also:
    
    Constant Field Values
  - CMFILEDIR_SQL_DELETE_BY_CMFILEDIR_ID
```
protected static final java.lang.String CMFILEDIR_SQL_DELETE_BY_CMFILEDIR_ID
```
    This is a constant to represent the key used to delete a record in table CMFILEDIR from the property file.
    
    See Also:
    
    Constant Field Values
  - PROPERTY_FILE_KEY_PREFIX
```
public static java.lang.String PROPERTY_FILE_KEY_PREFIX
```
    This is a constant to represent the prefix of the key used to retrieve the database related constant.
- Constructor Detail
  - ManagedFileDirectoryUtilitySQLResource
```
public ManagedFileDirectoryUtilitySQLResource()
```
- Method Detail
  - get
```
public static java.lang.String get(java.lang.String key)
```
    This method returns the value associated with the specified key.
    
    Parameters:
    
    key - The key.
    
    Returns:
    
    The value associated with the key.

Class ManagedFileDirectoryUtilitySQLResource

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

COPYRIGHT

RESOURCE_BUNDLE

CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_AND_IDENTIFIER

CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_FOR_PARENT_IS_NULL_AND_IDENTIFIER

CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT

CMFILEDIR_SQL_SELECT_CMFILEDIR_ID_AND_IDENTIFIER_AND_DISPLAYNAME_FOR_PARENT_IS_NULL

CMFILEDIR_SQL_INSERT_GENERIC

CMFILEDIR_COLUMN_CMFILEDIR_ID

CMFILEDIR_COLUMN_CMFILEDIR_PARENT

CMFILEDIR_COLUMN_IDENTIFIER

CMFILEDIR_COLUMN_DISPLAYNAME

CMFILEDIR_TABLE

CMFILEDIR_SQL_DELETE_BY_CMFILEDIR_ID

PROPERTY_FILE_KEY_PREFIX

Constructor Detail

ManagedFileDirectoryUtilitySQLResource

Method Detail

get