生成的存储过程
适用于 ✅ 开源版 ✅ 专业版 ✅ 企业版
数据库中的每个存储过程或函数(例程)都会生成一个 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.
反馈
您对此页面有任何反馈吗? 我们很乐意听取您的意见!