sf.jooq.dao

Interface DBJooq

All Known Implementing Classes:

DBJooqImpl

public interface DBJooq

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 更新

Method Detail

jooqExists

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

jooq判断是否存在

Type Parameters:

T -

Parameters:

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

condition -

clz -

Returns:

jooqSelectOne

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

jooq 查询单一对象

Type Parameters:

T -

Parameters:

select - 查询语句

returnClass - 返回类型

Returns:

jooqSelectList

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

jooq 查询list

Type Parameters:

T -

Parameters:

select -

returnClass -

Returns:

jooqSelectPage

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

jooq 查询分页

Type Parameters:

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

Parameters:

countSelect - 查询总数的select

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

returnClass - 返回值

Returns:

jooqSelectIterator

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

jooq 查询按流返回

Type Parameters:

T -

Parameters:

ormIt -

beanClass -

select -

jooqSelectStream

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

jooq 查询按流返回

Type Parameters:

T -

Parameters:

ormStream -

beanClass -

select -

jooqInsert

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

jooq 插入

Parameters:

insert -

Returns:

jooqInsert

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

带返回值的插入

Parameters:

insert -

table - 使用的表

keyValues -

Returns:

jooqUpdate

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

jooq 更新

Parameters:

update -

Returns:

jooqDelect

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

jooq 删除

Parameters:

delete -

Returns: