生成的存储过程
适用于 ✅ 开源版 ✅ 专业版 ✅ 企业版
数据库中的每个存储过程或函数(例程)都会生成一个 org.jooq.Routine
实现,如下所示
public class AuthorExists extends AbstractRoutine<java.lang.Void> { // All IN, IN OUT, OUT parameters and function return values generate a static member public static final Parameter<String> AUTHOR_NAME = createParameter("AUTHOR_NAME", VARCHAR); public static final Parameter<BigDecimal> RESULT = createParameter("RESULT", NUMERIC); // A constructor for a new "empty" procedure call public AuthorExists() { super("AUTHOR_EXISTS", TEST); addInParameter(AUTHOR_NAME); addOutParameter(RESULT); } // Every IN and IN OUT parameter generates a setter public void setAuthorName(String value) { setValue(AUTHOR_NAME, value); } // Every IN OUT, OUT and RETURN_VALUE generates a getter public BigDecimal getResult() { return getValue(RESULT); } // [...] }
XML(独立和 Maven)
编程方式
Gradle (Kotlin)
Gradle (Groovy)
Gradle(第三方)
<configuration> <generator> <generate> <!-- Generate the Routines class and a class for each individual routine --> <routines>true</routines> </generate> </generator> </configuration>
有关更多详细信息,请参阅配置 XSD、独立代码生成和 maven 代码生成。
new org.jooq.meta.jaxb.Configuration() .withGenerator( new Generate() // Generate the Routines class and a class for each individual routine .withRoutines(true) )
import org.jooq.meta.jaxb.* configuration { generator { generate { // Generate the Routines class and a class for each individual routine isRoutines = true } } }
有关更多详细信息,请参阅配置 XSD 和 gradle 代码生成。
configuration { generator { generate { // Generate the Routines class and a class for each individual routine routines = true } } }
有关更多详细信息,请参阅配置 XSD 和 gradle 代码生成。
// The jOOQ-codegen-gradle plugin has been introduced in version 3.19. // Please use the official plugin instead of the third party plugin that was recommended before.
反馈
您对此页面有任何反馈吗? 我们很乐意听取您的意见!