DBConfiguration (Hadoop 1.2.2-SNAPSHOT API)

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

```
@InterfaceAudience.Public
@InterfaceStability.Stable
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(Configuration, String, String, String, String), DBInputFormat.setInput(Job, Class, String, String), DBInputFormat.setInput(Job, Class, String, String, String, String...), DBOutputFormat.setOutput(Job, String, String...)

字段概要

字段
限定符和类型	字段和说明
`static String`	`DRIVER_CLASS_PROPERTY` The JDBC Driver class name
`static String`	`INPUT_BOUNDING_QUERY` Input query to get the max and min values of the jdbc.input.query
`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_COUNT_PROPERTY` Number of fields in the Output table
`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

构造器概要

构造器
构造器和说明

DBConfiguration(Configuration job)

构造器
构造器和说明
`DBConfiguration(Configuration job)`

方法概要

方法
限定符和类型	方法和说明
`static void`	`configureDB(Configuration job, String driverClass, String dbUrl)` Sets the DB access related fields in the JobConf.
`static void`	`configureDB(Configuration conf, String driverClass, String dbUrl, String userName, String passwd)` Sets the DB access related fields in the `Configuration`.
`Configuration`	`getConf()`
`Connection`	`getConnection()` Returns a connection object o the DB
`String`	`getInputBoundingQuery()`
`Class<?>`	`getInputClass()`
`String`	`getInputConditions()`
`String`	`getInputCountQuery()`
`String[]`	`getInputFieldNames()`
`String`	`getInputOrderBy()`
`String`	`getInputQuery()`
`String`	`getInputTableName()`
`int`	`getOutputFieldCount()`
`String[]`	`getOutputFieldNames()`
`String`	`getOutputTableName()`
`void`	`setInputBoundingQuery(String query)`
`void`	`setInputClass(Class<? extends DBWritable> inputClass)`
`void`	`setInputConditions(String conditions)`
`void`	`setInputCountQuery(String query)`
`void`	`setInputFieldNames(String... fieldNames)`
`void`	`setInputOrderBy(String orderby)`
`void`	`setInputQuery(String query)`
`void`	`setInputTableName(String tableName)`
`void`	`setOutputFieldCount(int fieldCount)`
`void`	`setOutputFieldNames(String... fieldNames)`
`void`	`setOutputTableName(String tableName)`

从类继承的方法 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_BOUNDING_QUERY
```
public static final String INPUT_BOUNDING_QUERY
```
  Input query to get the max and min values of the jdbc.input.query
  
  另请参阅:
  常量字段值
- 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
  
  另请参阅:
  常量字段值
- OUTPUT_FIELD_COUNT_PROPERTY
```
public static final String OUTPUT_FIELD_COUNT_PROPERTY
```
  Number of fields in the Output table
  
  另请参阅:
  常量字段值

构造器详细资料

DBConfiguration

public DBConfiguration(Configuration job)

方法详细资料

configureDB

public static void configureDB(Configuration conf,
               String driverClass,
               String dbUrl,
               String userName,
               String passwd)

Sets the DB access related fields in the Configuration.

参数:: conf - the configuration; driverClass - JDBC Driver class name; dbUrl - JDBC DB access URL.; userName - DB access username; passwd - DB access passwd

configureDB

public static void configureDB(Configuration 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.

getConnection

public Connection getConnection()
                         throws ClassNotFoundException,
                                SQLException

Returns a connection object o the DB

抛出:: ClassNotFoundException; SQLException

getConf
```
public Configuration getConf()
```

getInputTableName
```
public String getInputTableName()
```

setInputTableName

public void setInputTableName(String tableName)

getInputFieldNames
```
public String[] getInputFieldNames()
```

setInputFieldNames

public void setInputFieldNames(String... fieldNames)

getInputConditions
```
public String getInputConditions()
```

setInputConditions

public void setInputConditions(String conditions)

getInputOrderBy
```
public String getInputOrderBy()
```

setInputOrderBy

public void setInputOrderBy(String orderby)

getInputQuery
```
public String getInputQuery()
```

setInputQuery

public void setInputQuery(String query)

getInputCountQuery
```
public String getInputCountQuery()
```

setInputCountQuery

public void setInputCountQuery(String query)

setInputBoundingQuery

public void setInputBoundingQuery(String query)

getInputBoundingQuery
```
public String getInputBoundingQuery()
```

getInputClass
```
public Class<?> getInputClass()
```

setInputClass

public void setInputClass(Class<? extends DBWritable> inputClass)

getOutputTableName
```
public String getOutputTableName()
```

setOutputTableName

public void setOutputTableName(String tableName)

getOutputFieldNames
```
public String[] getOutputFieldNames()
```

setOutputFieldNames

public void setOutputFieldNames(String... fieldNames)

setOutputFieldCount

public void setOutputFieldCount(int fieldCount)

getOutputFieldCount
```
public int getOutputFieldCount()
```

类 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_BOUNDING_QUERY

INPUT_CLASS_PROPERTY

OUTPUT_TABLE_NAME_PROPERTY

OUTPUT_FIELD_NAMES_PROPERTY

OUTPUT_FIELD_COUNT_PROPERTY

构造器详细资料

DBConfiguration

方法详细资料

configureDB

configureDB

getConnection

getConf

getInputTableName

setInputTableName

getInputFieldNames

setInputFieldNames

getInputConditions

setInputConditions

getInputOrderBy

setInputOrderBy

getInputQuery

setInputQuery

getInputCountQuery

setInputCountQuery

setInputBoundingQuery

getInputBoundingQuery

getInputClass

setInputClass

getOutputTableName

setOutputTableName

getOutputFieldNames

setOutputFieldNames

setOutputFieldCount

getOutputFieldCount