一、环境
1.此随笔内容基于spring boot整合的spring data jpa项目,
2.数据库为mysql 5.7.9版本
二、内容
1. 新建存储过程 pro_query_object
BEGIN
#Routine body goes here...a_theme_code varchar(10),out num int
select o.obj_code,o.obj_name,o.obj_id from qt_object o where o.theme_code=a_theme_code;
select count(*) into num from qt_object o where o.theme_code=a_theme_code GROUP BY o.theme_code;
END
2. 新建实体,首先把我们需要返回的结果集的实体字段定义好,然后加上@NamedStoredProcedureQueries 注解绑定存储过程
@Entity
@NamedStoredProcedureQueries({
//管理列表
@NamedStoredProcedureQuery(name =
"pro_general_list", procedureName =
"pro_general_list",
resultClasses = {
QtObject.class },
parameters = {
@StoredProcedureParameter(mode = ParameterMode.IN, name =