同僚们支持下吧:http://huameiai.taobao.com/ http://wd.koudai.com/s/260295144?wfr=cmeiai.taobao.com/
谢谢你们的帮助!
hibernate 调用存储过程 sql server 2005 -insert update delete find
hibernate-mapping package="com.yxs.base.domain">
<class name="User" table="tt_user" schema="dbo" >
<id name="id" type="java.lang.Integer" >
<column name="id" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String" length="200" >
<column name="name" />
</property>
<property name="password" type="java.lang.String" >
<column name="password" />
</property>
<sql-insert callable="true" >
{call addUserProc(?,?)}
</sql-insert>
</class>
<sql-query name="findUserByPro" callable="true" >
<return alias="User" class="com.yxs.base.domain.User" >
<return-property name="id" column="id" />
<return-property name="name" column="name" />
<return-property name="password" column="password" />
</return>
{call searchUserProc()}
</sql-query>
<sql-query name="findUserSizeByPro" callable="true" >
<return alias="User" class="com.yxs.base.domain.User" >
<return-property name="id" column="id" />
<return-property name="name" column="name" />
<return-property name="password" column="password" />
</return>
{call searchUserSizeProc()}
</sql-query>
<!-- <sql-query name="addUserByPro" callable="true" >
<return alias="User" class="com.yxs.base.domain.User" >
</return>
{call addUserProc(?,?)}
</sql-query> -->
<!-- -->
</hibernate-mapping>
sql-query 放到class 里面
hibernate里面调用就好:getHibernateTemplate().findByNamedQuery(metheodName);
-- 在 sql 2005中写存储过程还算比较容易,因为有模板吧
创建视图就更简单--