DBInfoBuilder (sorm-码云(gitee.com))

java.lang.Object
- sf.database.dbinfo.DBInfoBuilder

public class DBInfoBuilder
extends Object

Field Summary

Fields
Modifier and Type	Field and Description
`protected Connection`	`conn`
`protected DataSource`	`dataSource`
`protected DatabaseMetaData`	`dbMeta`
`protected int`	`driverMajorVersion`
`protected String`	`driverName`
`protected String`	`driverVersion`
`protected Set<String>`	`excludedTables`
`protected String[]`	`removedTableNamePrefixes`

Constructor Summary

Constructors
Constructor and Description

DBInfoBuilder(DataSource dataSource)

Constructors
Constructor and Description
`DBInfoBuilder(DataSource dataSource)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addExcludedTable(String... excludedTables)`
`List<TableInfo>`	`build()`
`protected void`	`buildColumnMetas(TableInfo tableInfo)` 文档参考： http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type- conversions.html
`protected void`	`buildPrimaryKey(TableInfo TableInfo)`
`protected void`	`buildTableNames(List<TableInfo> ret)`
`String`	`forTableBuilderDoBuild(String tableName)`
`ColumnInfo`	`getColumn(TableInfo tableInfo, String column)` 返回指定的列的信息，如果没有找到该列返回null
`protected ResultSet`	`getTablesResultSet()` 不同数据库 dbMeta.getTables(...) 的 schemaPattern 参数意义不同 1：oracle 数据库这个参数代表 dbMeta.getUserName() 2：postgresql 数据库中需要在 jdbcUrl中配置 schemaPatter，例如：jdbc:postgresql://localhost:15432/djpt?currentSchema= public,sys,app 最后的参数就是搜索schema的顺序，DruidPlugin 下测试成功 3：开发者若在其它库中发现工作不正常，可通过继承 MetaBuilder并覆盖此方法来实现功能
`protected boolean`	`isSkipTable(String tableName)` 通过继承并覆盖此方法，跳过一些不希望处理的 table，定制更加灵活的 table 过滤规则
`void`	`setRemovedTableNamePrefixes(String... removedTableNamePrefixes)` 设置需要被移除的表名前缀，仅用于生成 modelName 与 baseModelName 例如表名 "osc_account"，移除前缀 "osc_" 后变为 "account"

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - dataSource
```
protected DataSource dataSource
```
  - excludedTables
```
protected Set<String> excludedTables
```
  - conn
```
protected Connection conn
```
  - dbMeta
```
protected DatabaseMetaData dbMeta
```
  - removedTableNamePrefixes
```
protected String[] removedTableNamePrefixes
```
  - driverName
```
protected String driverName
```
  - driverVersion
```
protected String driverVersion
```
  - driverMajorVersion
```
protected int driverMajorVersion
```
- Constructor Detail
  - DBInfoBuilder
```
public DBInfoBuilder(DataSource dataSource)
```
- Method Detail
  - addExcludedTable
```
public void addExcludedTable(String... excludedTables)
```
  - setRemovedTableNamePrefixes
```
public void setRemovedTableNamePrefixes(String... removedTableNamePrefixes)
```
    设置需要被移除的表名前缀，仅用于生成 modelName 与 baseModelName 例如表名 "osc_account"，移除前缀 "osc_" 后变为 "account"
  - build
```
public List<TableInfo> build()
```
  - isSkipTable
```
protected boolean isSkipTable(String tableName)
```
    通过继承并覆盖此方法，跳过一些不希望处理的 table，定制更加灵活的 table 过滤规则
    
    Returns:
    
    返回 true 时将跳过当前 tableName 的处理
  - getTablesResultSet
```
protected ResultSet getTablesResultSet()
                                throws SQLException
```
    不同数据库 dbMeta.getTables(...) 的 schemaPattern 参数意义不同
    1：oracle 数据库这个参数代表 dbMeta.getUserName()
    2：postgresql 数据库中需要在 jdbcUrl中配置 schemaPatter，例如：jdbc:postgresql://localhost:15432/djpt?currentSchema= public,sys,app 最后的参数就是搜索schema的顺序，DruidPlugin 下测试成功
    3：开发者若在其它库中发现工作不正常，可通过继承 MetaBuilder并覆盖此方法来实现功能
    
    Throws:
    
    SQLException
  - buildTableNames
```
protected void buildTableNames(List<TableInfo> ret)
                        throws SQLException
```
    Throws:
    
    SQLException
  - buildPrimaryKey
```
protected void buildPrimaryKey(TableInfo TableInfo)
                        throws SQLException
```
    Throws:
    
    SQLException
  - buildColumnMetas
```
protected void buildColumnMetas(TableInfo tableInfo)
                         throws SQLException
```
    文档参考： http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type- conversions.html
    JDBC 与时间有关类型转换规则，mysql 类型到 java 类型如下对应关系： DATE java.sql.Date DATETIME java.sql.Timestamp TIMESTAMP[(M)] java.sql.Timestamp TIME java.sql.Time
    对数据库的 DATE、DATETIME、TIMESTAMP、TIME 四种类型注入 new java.util.Date()对象保存到库以后可以达到“秒精度” 为了便捷性，getter、setter 方法中对上述四种字段类型采用 java.util.Date，可通过定制 TypeMapping 改变此映射规则
    
    Throws:
    
    SQLException
  - forTableBuilderDoBuild
```
public String forTableBuilderDoBuild(String tableName)
```
  - getColumn
```
public ColumnInfo getColumn(TableInfo tableInfo,
                            String column)
                     throws SQLException
```
    返回指定的列的信息，如果没有找到该列返回null
    
    Parameters:
    
    tableInfo - 表名
    
    column - 列名
    
    Returns:
    
    如果没有找到该列返回null
    
    Throws:
    
    SQLException

Class DBInfoBuilder

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

dataSource

excludedTables

conn

dbMeta

removedTableNamePrefixes

driverName

driverVersion

driverMajorVersion

Constructor Detail

DBInfoBuilder

Method Detail

addExcludedTable

setRemovedTableNamePrefixes

build

isSkipTable

getTablesResultSet

buildTableNames

buildPrimaryKey

buildColumnMetas

forTableBuilderDoBuild

getColumn