给你一个例子:存储过程:
CREATE FUNCTION selectEvents RETURN SYS_REFCURSOR
AS
sp_cursor SYS_REFCURSOR;
BEGIN
OPEN st_cursor FOR
SELECT id, event_name, start_date, duration
FROM events;
RETURN sp_cursor;
END;配置文件:
<sql-query name="selectEvents_SP" callable="true">
<return alias="ev" class="Event">
<return-property name="id" column="id"/>
<return-property name="name" column="event_name"/>
<return-property name="startDate" column="start_date"/>
<return-property name="duration" column="duration"/>
</return>
{ ? = call selectEvents() }
</sql-query>调用:
Query query = session.getNamedQuery("selectEvents_SP");
List results = query.list();
CREATE FUNCTION selectEvents RETURN SYS_REFCURSOR
AS
sp_cursor SYS_REFCURSOR;
BEGIN
OPEN st_cursor FOR
SELECT id, event_name, start_date, duration
FROM events;
RETURN sp_cursor;
END;配置文件:
<sql-query name="selectEvents_SP" callable="true">
<return alias="ev" class="Event">
<return-property name="id" column="id"/>
<return-property name="name" column="event_name"/>
<return-property name="startDate" column="start_date"/>
<return-property name="duration" column="duration"/>
</return>
{ ? = call selectEvents() }
</sql-query>调用:
Query query = session.getNamedQuery("selectEvents_SP");
List results = query.list();
然后调用:
Query query=session.getNamedQuery("update123");
query.executeUpdate();
这样我试着写过了的,结果出错了,说不能有name属性的