org.nutz.dao.impl.jdbc

Class AbstractJdbcExpert

java.lang.Object

org.nutz.dao.impl.jdbc.AbstractJdbcExpert

All Implemented Interfaces:

JdbcExpert

Direct Known Subclasses:

Db2JdbcExpert, GBaseJdbcExpert, HsqldbJdbcExpert, MysqlJdbcExpert, OracleJdbcExpert, PsqlJdbcExpert, SQLiteJdbcExpert, Sqlserver2005JdbcExpert, SybaseIQJdbcExpert

public abstract class AbstractJdbcExpert
extends Object
implements JdbcExpert

对于所有数据库的抽象实现

Author:

zozoh(zozohtnt@gmail.com)

Field Summary

Fields

Modifier and Type	Field and Description
protected JdbcExpertConfigFile	conf 提供给子类使用的配置文件对象
protected Set<String>	keywords

Constructor Summary

Constructors

Constructor and Description
AbstractJdbcExpert(JdbcExpertConfigFile conf)

Method Summary

Modifier and Type	Method and Description
boolean	addColumnNeedColumn()
void	addComment(Dao dao, Entity<?> en)
void	addComment(Dao dao, Entity<?> en, String commentTable, String commentColumn)
void	addDefaultValue(StringBuilder sb, MappingField mf)
boolean	canCommentWhenAddIndex()
void	checkDataSource(Connection conn)
Sql	createAddColumnSql(Entity<?> en, MappingField mf)
protected List<Sql>	createIndexs(Entity<?> en)
Sql	createIndexSql(Entity<?> en, EntityIndex index)
Pojo	createPojo(SqlType type) 根据类型创建一个 SQL 语句的实例
void	createRelation(Dao dao, Entity<?> en)
protected Sql	createRelation(Dao dao, LinkField lf)
protected String	createResultSetMetaSql(Entity<?> en)
boolean	dropEntity(Dao dao, Entity<?> en) 根据实体信息，返回某实体的删表语句
void	dropRelation(Dao dao, Entity<?> en)
String	evalFieldType(MappingField mf)
Pojo	fetchPojoId(Entity<?> en, MappingField idField)
void	formatQuery(DaoStatement daoStatement) 根据 Dao 查询语句，以及其翻页信息，对其进行格式化
abstract void	formatQuery(Pojo pojo)
void	formatQuery(Sql sql)
ValueAdaptor	getAdaptor(MappingField ef) 根据字段类型为其获取一个字段适配器
Map<String,Object>	getConf()
protected String	getDefaultValue(MappingField mf)
List<String>	getIndexNames(Entity<?> en, Connection conn)
Set<String>	getKeywords()
protected static String	gSQL(String ptn, String table, String field)
boolean	isSupportAutoIncrement()
boolean	isSupportGeneratedKeys()
String	makePksName(Entity<?> en)
void	setKeywords(Set<String> keywords)
void	setupEntityField(Connection conn, Entity<?> en) 通过访问数据库，为实体的映射字段设置约束
boolean	supportTimestampDefault()
protected static List<DaoStatement>	wrap(List<String> sqls)
protected static List<DaoStatement>	wrap(String... sqls)
String	wrapKeywork(String columnName, boolean force)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.nutz.dao.jdbc.JdbcExpert

createEntity, getDatabaseType

Field Detail

keywords

protected Set<String> keywords

conf

protected JdbcExpertConfigFile conf

提供给子类使用的配置文件对象

Constructor Detail

AbstractJdbcExpert

public AbstractJdbcExpert(JdbcExpertConfigFile conf)

Method Detail

setupEntityField

public void setupEntityField(Connection conn,
                             Entity<?> en)

Description copied from interface: JdbcExpert

通过访问数据库，为实体的映射字段设置约束

实体类在解析的时候会用到这个函数

Specified by:

setupEntityField in interface JdbcExpert

Parameters:

conn - 数据库连接

en - 实体

getAdaptor

public ValueAdaptor getAdaptor(MappingField ef)

Description copied from interface: JdbcExpert

根据字段类型为其获取一个字段适配器

Specified by:

getAdaptor in interface JdbcExpert

Parameters:

ef - 实体数据库映射字段

Returns:

ValueAdaptor 工厂类的实例

createPojo

public Pojo createPojo(SqlType type)

Description copied from interface: JdbcExpert

根据类型创建一个 SQL 语句的实例

Specified by:

createPojo in interface JdbcExpert

Parameters:

type - POJO 语句的 SQL 类型

Returns:

创建本数据库特有的 POJO 语句实现类

See Also:

SqlType

dropEntity

public boolean dropEntity(Dao dao,
                          Entity<?> en)

Description copied from interface: JdbcExpert

根据实体信息，返回某实体的删表语句

Specified by:

dropEntity in interface JdbcExpert

en - 实体

Returns:

是否删除成功

getConf

public Map<String,Object> getConf()

Specified by:

getConf in interface JdbcExpert

Returns:

当前的配置信息

createResultSetMetaSql

protected String createResultSetMetaSql(Entity<?> en)

createRelation

public void createRelation(Dao dao,
                           Entity<?> en)

Specified by:

createRelation in interface JdbcExpert

createRelation

protected Sql createRelation(Dao dao,
                             LinkField lf)

dropRelation

public void dropRelation(Dao dao,
                         Entity<?> en)

Specified by:

dropRelation in interface JdbcExpert

evalFieldType

public String evalFieldType(MappingField mf)

Specified by:

evalFieldType in interface JdbcExpert

wrap

protected static List<DaoStatement> wrap(String... sqls)

wrap

protected static List<DaoStatement> wrap(List<String> sqls)

gSQL

protected static String gSQL(String ptn,
                             String table,
                             String field)

getDefaultValue

protected String getDefaultValue(MappingField mf)

createIndexs

protected List<Sql> createIndexs(Entity<?> en)

createIndexSql

public Sql createIndexSql(Entity<?> en,
                          EntityIndex index)

Specified by:

createIndexSql in interface JdbcExpert

addComment

public void addComment(Dao dao,
                       Entity<?> en)

addComment

public void addComment(Dao dao,
                       Entity<?> en,
                       String commentTable,
                       String commentColumn)

formatQuery

public void formatQuery(DaoStatement daoStatement)

Description copied from interface: JdbcExpert

根据 Dao 查询语句，以及其翻页信息，对其进行格式化

Specified by:

formatQuery in interface JdbcExpert

Parameters:

daoStatement - Dao 语句

formatQuery

public abstract void formatQuery(Pojo pojo)

formatQuery

public void formatQuery(Sql sql)

fetchPojoId

public Pojo fetchPojoId(Entity<?> en,
                        MappingField idField)

Specified by:

fetchPojoId in interface JdbcExpert

isSupportAutoIncrement

public boolean isSupportAutoIncrement()

Specified by:

isSupportAutoIncrement in interface JdbcExpert

makePksName

public String makePksName(Entity<?> en)

addDefaultValue

public void addDefaultValue(StringBuilder sb,
                            MappingField mf)

addColumnNeedColumn

public boolean addColumnNeedColumn()

Specified by:

addColumnNeedColumn in interface JdbcExpert

supportTimestampDefault

public boolean supportTimestampDefault()

Specified by:

supportTimestampDefault in interface JdbcExpert

setKeywords

public void setKeywords(Set<String> keywords)

Specified by:

setKeywords in interface JdbcExpert

getKeywords

public Set<String> getKeywords()

wrapKeywork

public String wrapKeywork(String columnName,
                          boolean force)

Specified by:

wrapKeywork in interface JdbcExpert

isSupportGeneratedKeys

public boolean isSupportGeneratedKeys()

Specified by:

isSupportGeneratedKeys in interface JdbcExpert

checkDataSource

public void checkDataSource(Connection conn)
                     throws SQLException

Specified by:

checkDataSource in interface JdbcExpert

Throws:

SQLException

createAddColumnSql

public Sql createAddColumnSql(Entity<?> en,
                              MappingField mf)

Specified by:

createAddColumnSql in interface JdbcExpert

canCommentWhenAddIndex

public boolean canCommentWhenAddIndex()

Specified by:

canCommentWhenAddIndex in interface JdbcExpert

getIndexNames

public List<String> getIndexNames(Entity<?> en,
                                  Connection conn)
                           throws SQLException

Specified by:

getIndexNames in interface JdbcExpert

Throws:

SQLException