使用Select Query的Jooq AddCondition方法(Jooq AddCondition method with Select Query)

这是我的问题我试图添加一个选择查询在哪里条件我怎么能在Jooq实现这一点？

selectQuery.addFrom(DefaultInfo.DEFAULT_INFO); selectQuery.addConditions(DefaultInfo.DEFAULT_INFO.FOLDER_TYPE=+"(Select FolderType From Folder Where Folder.FolderRSN = folderRSN )" );

我知道这是错的，但是如何在另一个查询条件中添加Select Query输出？

Here is my problem I am trying to add a Select query in where condition how can i achieve this in Jooq?

selectQuery.addFrom(DefaultInfo.DEFAULT_INFO); selectQuery.addConditions(DefaultInfo.DEFAULT_INFO.FOLDER_TYPE=+"(Select FolderType From Folder Where Folder.FolderRSN = folderRSN )" );

I know this is wrong but how to add a Select Query output in another query where condition?

最满意答案

在Field.in(Select<? extends Record1<T>>)使用Field.in(Select<? extends Record1<T>>)方法。 例如：

DEFAULT_INFO.FOLDER_TYPE.in( select(FOLDER.FOLDER_TYPE) .from(FOLDER) .where(FOLDER.FOLDER_RSN.eq("folderRSN")) )

IN谓词记录在手册中，在这里：

http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate/ http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate-degree-n/

Use the Field.in(Select<? extends Record1<T>>) method on your column. For example:

DEFAULT_INFO.FOLDER_TYPE.in( select(FOLDER.FOLDER_TYPE) .from(FOLDER) .where(FOLDER.FOLDER_RSN.eq("folderRSN")) )

The IN predicate is documented in the manual, here:

http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate/ http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate-degree-n/使用Select Query的Jooq AddCondition方法(Jooq AddCondition method with Select Query)

这是我的问题我试图添加一个选择查询在哪里条件我怎么能在Jooq实现这一点？

selectQuery.addFrom(DefaultInfo.DEFAULT_INFO); selectQuery.addConditions(DefaultInfo.DEFAULT_INFO.FOLDER_TYPE=+"(Select FolderType From Folder Where Folder.FolderRSN = folderRSN )" );

我知道这是错的，但是如何在另一个查询条件中添加Select Query输出？

Here is my problem I am trying to add a Select query in where condition how can i achieve this in Jooq?

selectQuery.addFrom(DefaultInfo.DEFAULT_INFO); selectQuery.addConditions(DefaultInfo.DEFAULT_INFO.FOLDER_TYPE=+"(Select FolderType From Folder Where Folder.FolderRSN = folderRSN )" );

I know this is wrong but how to add a Select Query output in another query where condition?

最满意答案

在Field.in(Select<? extends Record1<T>>)使用Field.in(Select<? extends Record1<T>>)方法。 例如：

DEFAULT_INFO.FOLDER_TYPE.in( select(FOLDER.FOLDER_TYPE) .from(FOLDER) .where(FOLDER.FOLDER_RSN.eq("folderRSN")) )

IN谓词记录在手册中，在这里：

http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate/ http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate-degree-n/

Use the Field.in(Select<? extends Record1<T>>) method on your column. For example:

DEFAULT_INFO.FOLDER_TYPE.in( select(FOLDER.FOLDER_TYPE) .from(FOLDER) .where(FOLDER.FOLDER_RSN.eq("folderRSN")) )

The IN predicate is documented in the manual, here:

http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate/ http://www.jooq.org/doc/latest/manual/sql-building/conditional-expressions/in-predicate-degree-n/