Hibernate调用存储过程参数传递设置问题(在线等,急!)
小弟开始做毕业设计了,刚开始做就遇见一个问题,做一个登录验证用户密码是否正确,用户名作为参数,返回整条记录
存储过程如下:
create procedure select_Login_UM
@universitymanagename varchar(50)
as
begin
select * from universityManage where universitymanagename=@universitymanagename
end
go
配置文档如下:
<sql-query name="select_Login_UM" callable="true">
<query-param name="universitymanagename" type="java.lang.String"/>
<return alias="loginum" class="cn.edu.gdou.beans.UniversityManage">
<return-property name="universitymanageid" column="universitymanageid"></return-property>
<return-property name="universitymanagename" column="universitymanagename"></return-property>
<return-property name="universitymanagepwd" column="universitymanagepwd"></return-property>
<return-property name="universitymanagepwdstream" column="universitymanagepwdstream"></return-property>
<return-property name="universitymanageturename" column="universitymanageturename"></return-property>
<return-property name="universitymanagepopedom" column="universitymanagepopedom"></return-property>
<return-property name="sysiden" column="sysiden"></return-property>
</return>
{?=call select_Login_UM(?)}
</sql-query>
java代码如下:
Query q = session.createQuery("select_Login_UM");
q.setString("universitymanagename", umn); //umn为用户名参数
List list = q.list();
配置文档有错吗?各位大虾,帮帮小弟,帮忙解决者都有分,能给出正确关于hibernate调用存储过程需要传递参数的例子给高分,问题解决立即结贴。