java--hibernate中调用存储过程

阳光穿透心脏的1/2处 2022-08-27 14:54 193阅读 0赞

原文转自：[http://blog.csdn.net/chinasoftosg/article/details/8542916][http_blog.csdn.net_chinasoftosg_article_details_8542916]

/\*\*  
     \* hibernate调用函数的例子  
     \* 不用配置\*.hbm.xml文件，直接调用  
     \*/  
    public void queryFunction()  
    \{   
        try  
        \{   
            session = sessionFactory.openSession();  
            SQLQuery query = session.createSQLQuery("\{Call f\_login(?,?,?)\}");  
              
            //输入参数  
            query.setInteger(0, 1);  
            query.setString(1, "");  
            query.setString(2, "");  
              
            List list =query.list();  
        \}  
        catch (RuntimeException re)  
        \{   
            if (null != tran)  
            \{   
                tran.rollback();  
            \}  
            throw re;  
        \}  
        finally  
        \{   
            session.close();  
        \}  
    \}  
      
    /\*\*  
     \* hibernate调用函数的例子  
     \* @throws SQLException   
     \*/  
    public void queryFunction2() throws SQLException  
    \{   
        try  
        \{   
            //第二种方法  
            session = sessionFactory.openSession();  
            Connection conn = session.connection();     
            ResultSet rs =null;     
            CallableStatement call = conn.prepareCall("\{Call f\_login(?,?,?)\}");  
              
            //输入参数  
            call.setString(0,"abc");  
              
            //输出参数  
            call.registerOutParameter(1, Types.VARCHAR);  
            call.registerOutParameter(2,Types.VARCHAR);  
            rs = call.executeQuery();     
            if(rs.next())\{   
            System.out.println("存储过程得到的第一个返回值是:"+rs.getString(1));  
            System.out.println("存储过程得到的第二个返回值是:"+rs.getString(2));  
            \}   
        \}  
        catch (RuntimeException re)  
        \{   
            if (null != tran)  
            \{   
                tran.rollback();  
            \}  
            throw re;  
        \}  
        finally  
        \{   
            session.close();  
        \}  
    \}  
      
    /\*\*  
     \* hibernate调用函数的例子  
     \* @throws SQLException   
     \*/  
    public void queryFunction3() throws SQLException  
    \{   
        try  
        \{   
            //第三种方法  
            session = sessionFactory.openSession();  
            tran = session.beginTransaction();  
              
            //调用\*.hbm.xml定义的存储过程(也可以调用\*.hbm.xml定义的是SQL语句)  
            Query query=session.getNamedQuery("login\_function");  
            List list = query.list();  
            tran.commit();  
        \}  
        catch (RuntimeException re)  
        \{   
            if (null != tran)  
            \{   
                tran.rollback();  
            \}  
            throw re;  
        \}  
        finally  
        \{   
            session.close();  
        \}  
    \}  
  
  
  
  
    <sql-query name="login\_function" callable="true">  
      
        <return alias="users" class="">  
          
            <return-property name="" column=""/>  
        </return>  
        \{call f\_login(?)\}  
    </sql-query>

[http_blog.csdn.net_chinasoftosg_article_details_8542916]: http://blog.csdn.net/chinasoftosg/article/details/8542916