hibernate调用存储(返回记录集)

 

tree.hbm.xml

<? xml version = "1.0" encoding = "utf-8" ?>

<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<!--

    Mapping file autogenerated by MyEclipse - Hibernate Tools

-->

< hibernate-mapping >

    < class name = "ds_soft.ltxsys.auto.ltxemp.LtxProTreeEmpFound" table = "tree_table" schema = "dbo" catalog = "dsltxsalary" >

       < id name = "id" type = "string" >

            < column name = "id" length = "32" />

            < generator class = "assigned" ></ generator >

        </ id >

        < property name = "name" type = "string" >

            < column name = "name" length = "50" />

        </ property >

        < property name = "cc" type = "integer" >

            < column name = "cc" not-null = "true" />

        </ property >

        < property name = "childn" type = "integer" >

            < column name = "childn"  not-null = "true" />

        </ property >

        < property name = "pid" type = "string" >

            < column name = "pid" length = "32" />

        </ property >

       

         < property name = "sort" type = "string" >

            < column name = "sort" length = "32" />

        </ property >        

         < property name = "imageurl" type = "string" >

            < column name = "imageurl" length = "200" />

        </ property >       

       

    </ class >

 

 

      <!-- 调用存储过程就在这里配了 -->

    < sql-query name = "getTreeEmpFound" callable = "true" >

     < return alias = "emptree" class = "ds_soft.ltxsys.auto.ltxemp.LtxProTreeEmpFound" >

     < return-property name = "id" column = "id" />

     < return-property name = "name" column = "name" />

      < return-property name = "cc" column = "cc" />

     < return-property name = "childn" column = "childn" />

     < return-property name = "pid" column = "pid" />

     < return-property name = "sort" column = "sort" ></ return-property >

     < return-property name = "imageurl" column = "imageurl" ></ return-property >

     </ return >

     <!-- 这里就是存储过程名 -->

     {call ltx_pro_tree_create(?)}

     </ sql-query >   

</ hibernate-mapping >

 

执行存储过程的通用方法

    public List findByNamedQuery(String querystr, Object[] parameters) {

       Session session = this .getSession();

       Query query = null ;

       List list = null ;

        try {

           query = session.getNamedQuery(querystr);

           if ( parameters. length < 1)

              list = query.list();

           else

           {

              for ( int i=0; i < (parameters. length );i++){

                  query.setParameter(i , parameters[i]);

              }

              list = query.list();

           }

       } catch (Exception e)

       {

           System. out .println( " 执行存储过程： " + querystr + " 参数： " );

           System. out .println(parameters);

           System. out .println( " 失败 " );

           e.printStackTrace();

       } finally {

           SessionFactoryUtils.closeSessionIfNecessary(session, this .getSessionFactory());

           return list;

       }

    }

调用通用方法：

           list = this . comService .findByNamedQuery(querystr, parameters);