hibernate 调用存储过程 sql server 2005 -insert update delete find

同僚们支持下吧：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中写存储过程还算比较容易，因为有模板吧

    创建视图就更简单--