sf.jooq.dao

Class DBJooqImpl

java.lang.Object

sf.jooq.dao.DBJooqImpl

All Implemented Interfaces:

DBJooq

public class DBJooqImpl
extends Object
implements DBJooq

Field Summary

Fields

Modifier and Type	Field and Description
protected DBClient	client

Constructor Summary

Constructors

Constructor and Description
DBJooqImpl(DBClient client)

Method Summary

Modifier and Type	Method and Description
<T extends org.jooq.Record> int	jooqDelect(org.jooq.Delete<T> delete) jooq 删除
<T extends DBObject> boolean	jooqExists(org.jooq.SQLDialect sqlDialect, List<org.jooq.Condition> condition, Class<T> clz) jooq判断是否存在
<T extends org.jooq.Record> int	jooqInsert(org.jooq.Insert<T> insert) jooq 插入
<T extends org.jooq.Record> int	jooqInsert(org.jooq.Insert<T> insert, org.jooq.Table<T> table, Map<String,Object> keyValues) 带返回值的插入
<T> void	jooqSelectIterator(OrmIterator<T> ormIt, Class<T> beanClass, org.jooq.Select<?> select) jooq 查询按流返回
<T> List<T>	jooqSelectList(org.jooq.Select<?> select, Class<T> returnClass) jooq 查询list
<T> T	jooqSelectOne(org.jooq.Select<?> select, Class<T> returnClass) jooq 查询单一对象
<T> Page<T>	jooqSelectPage(org.jooq.Select<?> countSelect, org.jooq.Select<?> pageSelect, Class<T> returnClass) jooq 查询分页
<T> void	jooqSelectStream(OrmStream<T> ormStream, Class<T> beanClass, org.jooq.Select<?> select) jooq 查询按流返回
<T extends org.jooq.Record> int	jooqUpdate(org.jooq.Update<T> update) jooq 更新

Methods inherited from class java.lang.Object

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

Field Detail

client

protected DBClient client

Constructor Detail

DBJooqImpl

public DBJooqImpl(DBClient client)

Method Detail

jooqExists

public <T extends DBObject> boolean jooqExists(org.jooq.SQLDialect sqlDialect,
                                               List<org.jooq.Condition> condition,
                                               Class<T> clz)

Description copied from interface: DBJooq

jooq判断是否存在

Specified by:

jooqExists in interface DBJooq

Parameters:

sqlDialect - 可以传null,主要是用于商业版需要传入.

Returns:

jooqSelectOne

public <T> T jooqSelectOne(org.jooq.Select<?> select,
                           Class<T> returnClass)

Description copied from interface: DBJooq

jooq 查询单一对象

Specified by:

jooqSelectOne in interface DBJooq

Parameters:

select - 查询语句

returnClass - 返回类型

Returns:

jooqSelectList

public <T> List<T> jooqSelectList(org.jooq.Select<?> select,
                                  Class<T> returnClass)

Description copied from interface: DBJooq

jooq 查询list

Specified by:

jooqSelectList in interface DBJooq

Returns:

jooqSelectPage

public <T> Page<T> jooqSelectPage(org.jooq.Select<?> countSelect,
                                  org.jooq.Select<?> pageSelect,
                                  Class<T> returnClass)

Description copied from interface: DBJooq

jooq 查询分页

Specified by:

jooqSelectPage in interface DBJooq

Type Parameters:

T - 返回值根据select的查询条件变化,可能为bean,单一值,或Map

Parameters:

countSelect - 查询总数的select

pageSelect - 查询列表的select,必须包含分页参数.

returnClass - 返回值

Returns:

jooqSelectIterator

public <T> void jooqSelectIterator(OrmIterator<T> ormIt,
                                   Class<T> beanClass,
                                   org.jooq.Select<?> select)

Description copied from interface: DBJooq

jooq 查询按流返回

Specified by:

jooqSelectIterator in interface DBJooq

jooqSelectStream

public <T> void jooqSelectStream(OrmStream<T> ormStream,
                                 Class<T> beanClass,
                                 org.jooq.Select<?> select)

Description copied from interface: DBJooq

jooq 查询按流返回

Specified by:

jooqSelectStream in interface DBJooq

jooqInsert

public <T extends org.jooq.Record> int jooqInsert(org.jooq.Insert<T> insert)

Description copied from interface: DBJooq

jooq 插入

Specified by:

jooqInsert in interface DBJooq

Returns:

jooqInsert

public <T extends org.jooq.Record> int jooqInsert(org.jooq.Insert<T> insert,
                                                  org.jooq.Table<T> table,
                                                  Map<String,Object> keyValues)

Description copied from interface: DBJooq

带返回值的插入

Specified by:

jooqInsert in interface DBJooq

table - 使用的表

Returns:

jooqUpdate

public <T extends org.jooq.Record> int jooqUpdate(org.jooq.Update<T> update)

Description copied from interface: DBJooq

jooq 更新

Specified by:

jooqUpdate in interface DBJooq

Returns:

jooqDelect

public <T extends org.jooq.Record> int jooqDelect(org.jooq.Delete<T> delete)

Description copied from interface: DBJooq

jooq 删除

Specified by:

jooqDelect in interface DBJooq

Returns: