sf.jooq

Interface JooqInf

All Known Implementing Classes:

JooqImpl

public interface JooqInf

只支持开源数据库:
CUBRID 8.4 and later
Derby 10.10 and later
Firebird 2.5, 3.0
H2 1.3, 1.4
HSQLDB 2.2 and later
MariaDB 5.2 and later
MySQL 5.5 and later
PostgreSQL 9.3 and later
SQLite 3

Method Summary

Modifier and Type	Method and Description
<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) 流式返回结果

Method Detail

jooqExists

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

判断是否存在

Type Parameters:

T -

Parameters:

conn -

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

condition -

clz -

Returns:

jooqSelectOne

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

查询单一对象

Type Parameters:

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

Parameters:

conn -

select -

Returns:

jooqSelectList

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

查询列表

Type Parameters:

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

Parameters:

conn -

select -

Returns:

jooqSelectPage

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

分页查询

Type Parameters:

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

Parameters:

conn -

countSelect - 查询总数的select

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

returnClass - 返回值

Returns:

selectIterator

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

迭代返回结果

Type Parameters:

T -

Parameters:

conn -

ormIt - 迭代

select -

returnClass -

selectStream

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

流式返回结果

Type Parameters:

T -

Parameters:

conn -

ormStream -

select -

returnClass -

jooqInsert

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

插入

Parameters:

conn -

insert -

Returns:

jooqInsert

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

带返回值的保存

Parameters:

conn -

insert -

table -

keyValues -

Returns:

jooqUpdate

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

更新

Parameters:

conn -

update -

Returns:

jooqDelect

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

删除

Parameters:

conn -

delete -

Returns: