sf.jooq

Class JooqImpl

java.lang.Object

sf.jooq.JooqImpl

All Implemented Interfaces:

JooqInf

public class JooqImpl
extends Object
implements JooqInf

Method Summary

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

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static JooqImpl getInstance()

jooqExists

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

Description copied from interface: JooqInf

判断是否存在

Specified by:

jooqExists in interface JooqInf

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

Returns:

jooqSelectOne

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

Description copied from interface: JooqInf

查询单一对象

Specified by:

jooqSelectOne in interface JooqInf

Type Parameters:

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

Returns:

jooqSelectList

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

Description copied from interface: JooqInf

查询列表

Specified by:

jooqSelectList in interface JooqInf

Type Parameters:

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

Returns:

jooqSelectPage

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

Description copied from interface: JooqInf

分页查询

Specified by:

jooqSelectPage in interface JooqInf

Type Parameters:

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

countSelect - 查询总数的select

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

returnClass - 返回值

Returns:

selectIterator

public <T> void selectIterator(Connection conn,
                               OrmIterator<T> ormIt,
                               org.jooq.Select select,
                               Class<T> returnClass)

Description copied from interface: JooqInf

迭代返回结果

Specified by:

selectIterator in interface JooqInf

ormIt - 迭代

selectStream

public <T> void selectStream(Connection conn,
                             OrmStream<T> ormStream,
                             org.jooq.Select select,
                             Class<T> returnClass)

Description copied from interface: JooqInf

流式返回结果

Specified by:

selectStream in interface JooqInf

jooqInsert

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

Description copied from interface: JooqInf

插入

Specified by:

jooqInsert in interface JooqInf

Returns:

jooqInsert

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

Description copied from interface: JooqInf

带返回值的保存

Specified by:

jooqInsert in interface JooqInf

Returns:

jooqUpdate

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

Description copied from interface: JooqInf

更新

Specified by:

jooqUpdate in interface JooqInf

Returns:

jooqDelect

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

Description copied from interface: JooqInf

删除

Specified by:

jooqDelect in interface JooqInf

Returns: