DBConfiguration (Hadoop 1.2.2-SNAPSHOT API)

java.lang.Object
- org.apache.hadoop.mapred.lib.db.DBConfiguration

```
public class DBConfiguration
extends Object
```
A container for configuration property names for jobs with DB input/output.
The job can be configured using the static methods in this class, DBInputFormat, and DBOutputFormat.
Alternatively, the properties can be set in the configuration with proper values.

另请参阅:
configureDB(JobConf, String, String, String, String), DBInputFormat.setInput(JobConf, Class, String, String), DBInputFormat.setInput(JobConf, Class, String, String, String, String...), DBOutputFormat.setOutput(JobConf, String, String...)

字段概要

字段
限定符和类型	字段和说明
`static String`	`DRIVER_CLASS_PROPERTY` The JDBC Driver class name
`static String`	`INPUT_CLASS_PROPERTY` Class name implementing DBWritable which will hold input tuples
`static String`	`INPUT_CONDITIONS_PROPERTY` WHERE clause in the input SELECT statement
`static String`	`INPUT_COUNT_QUERY` Input query to get the count of records
`static String`	`INPUT_FIELD_NAMES_PROPERTY` Field names in the Input table
`static String`	`INPUT_ORDER_BY_PROPERTY` ORDER BY clause in the input SELECT statement
`static String`	`INPUT_QUERY` Whole input query, exluding LIMIT...OFFSET
`static String`	`INPUT_TABLE_NAME_PROPERTY` Input table name
`static String`	`OUTPUT_FIELD_NAMES_PROPERTY` Field names in the Output table
`static String`	`OUTPUT_TABLE_NAME_PROPERTY` Output table name
`static String`	`PASSWORD_PROPERTY` Password to access the database
`static String`	`URL_PROPERTY` JDBC Database access URL
`static String`	`USERNAME_PROPERTY` User name to access the database

方法概要

方法
限定符和类型	方法和说明
`static void`	`configureDB(JobConf job, String driverClass, String dbUrl)` Sets the DB access related fields in the JobConf.
`static void`	`configureDB(JobConf job, String driverClass, String dbUrl, String userName, String passwd)` Sets the DB access related fields in the JobConf.

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 字段详细资料
  - DRIVER_CLASS_PROPERTY
```
public static final String DRIVER_CLASS_PROPERTY
```
    The JDBC Driver class name
    
    另请参阅:
    常量字段值
  - URL_PROPERTY
```
public static final String URL_PROPERTY
```
    JDBC Database access URL
    
    另请参阅:
    常量字段值
  - USERNAME_PROPERTY
```
public static final String USERNAME_PROPERTY
```
    User name to access the database
    
    另请参阅:
    常量字段值
  - PASSWORD_PROPERTY
```
public static final String PASSWORD_PROPERTY
```
    Password to access the database
    
    另请参阅:
    常量字段值
  - INPUT_TABLE_NAME_PROPERTY
```
public static final String INPUT_TABLE_NAME_PROPERTY
```
    Input table name
    
    另请参阅:
    常量字段值
  - INPUT_FIELD_NAMES_PROPERTY
```
public static final String INPUT_FIELD_NAMES_PROPERTY
```
    Field names in the Input table
    
    另请参阅:
    常量字段值
  - INPUT_CONDITIONS_PROPERTY
```
public static final String INPUT_CONDITIONS_PROPERTY
```
    WHERE clause in the input SELECT statement
    
    另请参阅:
    常量字段值
  - INPUT_ORDER_BY_PROPERTY
```
public static final String INPUT_ORDER_BY_PROPERTY
```
    ORDER BY clause in the input SELECT statement
    
    另请参阅:
    常量字段值
  - INPUT_QUERY
```
public static final String INPUT_QUERY
```
    Whole input query, exluding LIMIT...OFFSET
    
    另请参阅:
    常量字段值
  - INPUT_COUNT_QUERY
```
public static final String INPUT_COUNT_QUERY
```
    Input query to get the count of records
    
    另请参阅:
    常量字段值
  - INPUT_CLASS_PROPERTY
```
public static final String INPUT_CLASS_PROPERTY
```
    Class name implementing DBWritable which will hold input tuples
    
    另请参阅:
    常量字段值
  - OUTPUT_TABLE_NAME_PROPERTY
```
public static final String OUTPUT_TABLE_NAME_PROPERTY
```
    Output table name
    
    另请参阅:
    常量字段值
  - OUTPUT_FIELD_NAMES_PROPERTY
```
public static final String OUTPUT_FIELD_NAMES_PROPERTY
```
    Field names in the Output table
    
    另请参阅:
    常量字段值
- 方法详细资料
  - configureDB
```
public static void configureDB(JobConf job,
               String driverClass,
               String dbUrl,
               String userName,
               String passwd)
```
    Sets the DB access related fields in the JobConf.
    
    参数:
    job - the job
    driverClass - JDBC Driver class name
    dbUrl - JDBC DB access URL.
    userName - DB access username
    passwd - DB access passwd
  - configureDB
```
public static void configureDB(JobConf job,
               String driverClass,
               String dbUrl)
```
    Sets the DB access related fields in the JobConf.
    
    参数:
    job - the job
    driverClass - JDBC Driver class name
    dbUrl - JDBC DB access URL.

类 DBConfiguration

字段概要

方法概要

从类继承的方法 java.lang.Object

字段详细资料

DRIVER_CLASS_PROPERTY

URL_PROPERTY

USERNAME_PROPERTY

PASSWORD_PROPERTY

INPUT_TABLE_NAME_PROPERTY

INPUT_FIELD_NAMES_PROPERTY

INPUT_CONDITIONS_PROPERTY

INPUT_ORDER_BY_PROPERTY

INPUT_QUERY

INPUT_COUNT_QUERY

INPUT_CLASS_PROPERTY

OUTPUT_TABLE_NAME_PROPERTY

OUTPUT_FIELD_NAMES_PROPERTY

方法详细资料

configureDB

configureDB