hibernate 调用oracle存储过程

一：

 session = base.getSession();
   conn = session.connection();
   CallableStatement call = conn.prepareCall("{Call get_user_info_pk(?)}");  
   call.registerOutParameter(1,Types.VARCHAR);
   call.executeQuery();
   id = call.getString(1);

 

二：

返回结果集

SQL code

    
    

     
     

     
     create
     
      
     
     or
     
      
     
     replace
     
      package pa_query 
     
     as
     
     
 type p_cursor 
     
     is
     
      ref 
     
     cursor
     
     ;

     
     end
     
      pa_query;

     
     /
     
     

     
     create
     
      
     
     or
     
      
     
     replace
     
      
     
     procedure
     
      p_query(v_cursor out pa_query.p_cursor)

     
     is
     
     

     
     begin
     
     

     
     open
     
      v_cursor 
     
     for
     
      
     
     select
     
      
     
     *
     
      
     
     from
     
      emp;

     
     end
     
      p_query;

    
    

 

Java code

    
    

     
     

     
     package
     
      com.abing.test;


     
     import
     
      java.sql.CallableStatement;

     
     import
     
      java.sql.Connection;

     
     import
     
      java.sql.DriverManager;

     
     import
     
      java.sql.ResultSet;

     
     import
     
      java.sql.SQLException;

     
     import
     
      java.sql.Types;


     
     import
     
      oracle.jdbc.OracleTypes;


     
     public
     
      
     
     class
     
      P_test {

    
     
     public
     
      P_test() {
        
     
     super
     
     ();
    }

    
     
     public
     
      
     
     static
     
      
     
     void
     
      main(String[] args) 
     
     throws
     
      ClassNotFoundException {
        Connection conn
     
     =
     
     null
     
     ;
        ResultSet rs
     
     =
     
     null
     
     ;
        
     
     try
     
      {
            Class.forName(
     
     "
     
     oracle.jdbc.driver.OracleDriver
     
     "
     
     );
            conn 
     
     =
     
      DriverManager.getConnection(
                    
     
     "
     
     jdbc:oracle:thin:@127.0.0.1:1521:orcl
     
     "
     
     , 
     
     "
     
     scott
     
     "
     
     ,
                    
     
     "
     
     tiger
     
     "
     
     );
            conn.setAutoCommit(
     
     false
     
     );
            
     
     //
     
      调用存储过程
     
     

     
                 CallableStatement cstmt 
     
     =
     
      conn.prepareCall(
     
     "
     
     {call p_query(?)}
     
     "
     
     );
            
     
     //
     
     cstmt.setInt(1,1);
     
     

     
                 cstmt.registerOutParameter(
     
     1
     
     , OracleTypes.CURSOR);
            cstmt.execute();
            rs 
     
     =
     
      (ResultSet) cstmt.getObject(
     
     1
     
     );
            
     
     while
     
     (rs.next()) {
                String name 
     
     =
     
      rs.getString(
     
     "
     
     ename
     
     "
     
     );
                System.out.println(name);
            }
            
            conn.commit();
        } 
     
     catch
     
      (SQLException e) {
            e.printStackTrace();
            
     
     try
     
      {
                conn.rollback();
            } 
     
     catch
     
      (SQLException e1) {
                e1.printStackTrace();
            }
        } 
     
     finally
     
      {
            
     
     try
     
      {
                conn.close();
            } 
     
     catch
     
      (SQLException e) {
                e.printStackTrace();
            }
        }

    }}