Hibernate调用存储过程

Hibernate调用存储过程

Hibernate调用存储过程方法一&＃xff1a;
 List list &＃61; new ArrayList();
try {
session &＃61; getCurrentSession(entityClass);
SQLQuery query &＃61; session.createSQLQuery(procedure);
query.setString(0, requestId);
list &＃61; query.list();
} catch (HibernateException e) {
e.printStackTrace();
logger.log(RMTManagementLevel.ERROR, e);
} finally {
this.closeConnection();
}
return list;

SQLQuery query&＃61;this.getSession().createSQLQuery("{call procName(?,?,?)}");
query.setString(0,x);
query.setString(1,xxx);
query.setString(2,xxxx);
List list &＃61; query.list();
Hibernate调用存储过程方法二&＃xff1a;
 Session session &＃61;HibernateSessionFactory.getSession(); 
Connection conn &＃61; session.connection(); 
ResultSet rs &＃61;null; 
CallableStatement call &＃61; conn.prepareCall("{Call proc()}"); 
rs &＃61; call.executeQuery(); 
rs.close(); 
session.close(); 

&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;

hibernate调用mysql存储过程

　　在mysql中创建两个存储过程&＃xff0c;如下&＃xff1a;
 
1、根据id查找某条数据&＃xff1a;
 
1 CREATE PROCEDURE &＃96;findEmpById&＃96;(IN id INTEGER(11))
2 begin
3      select * from emp where empId&＃61;id;
4 end;

2、根据id查找某个字段&＃xff0c;并返回
 
1 CREATE PROCEDURE &＃96;getNameById&＃96;(in id integer(11),out eName varchar(50))
2 begin
3      select empName into eName from emp where empId&＃61;id;
4 end;
　　在存储过程的参数列表里面&＃xff0c;in修饰的参数代表输入参数&＃xff0c;out修饰的代表输出参数。
 
使用hibernate调用上面两个存储过程&＃xff1a;
 
　　&＃xff08;1&＃xff09;调用第一个存储过程
 

 1 package com.test;
 2
 3 import java.sql.CallableStatement;
 4 import java.sql.Connection;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7
 8 import org.hibernate.Session;
 9 import org.hibernate.SessionFactory;
10 import org.hibernate.cfg.Configuration;
11
12
13 public class 调用存储过程 {
14
15     /**
16      * &＃64;param args
17      * &＃64;throws SQLException
18      */
19     public static void main(String[] args) throws SQLException {
20         Configuration cfg &＃61; new Configuration().configure();
21         SessionFactory factory &＃61; cfg.buildSessionFactory();
22         Session session &＃61; factory.openSession();
23         Connection con &＃61; session.connection();
24         String sql &＃61; "{call findEmpById(?)}";
25         CallableStatement cs &＃61; con.prepareCall(sql);
26         cs.setObject(1, 2);
27         ResultSet rs &＃61; cs.executeQuery();
28         while(rs.next()){
29             int id &＃61; rs.getInt("empId");
30             String name &＃61; rs.getString("empName");
31             System.out.println(id&＃43;"\t"&＃43;name);
32         }
33     }
34
35 }

   　调用存储过程的sql语句为:call 存储过程名(参数...)&＃xff0c;不过在java中调用存储过程一般都加{}。调用存储过程使用的是CallableStatement。
 
　　&＃xff08;2&＃xff09;调用第二个存储过程
 

 1 package com.test;
 2
 3 import java.sql.CallableStatement;
 4 import java.sql.Connection;
 5 import java.sql.SQLException;
 6
 7 import org.hibernate.Session;
 8 import org.hibernate.SessionFactory;
 9 import org.hibernate.cfg.Configuration;
10
11 public class 调用存储过程1 {
12
13    
14     public static void main(String[] args) throws SQLException {
15         Configuration config &＃61; new Configuration().configure();
16         SessionFactory sessionFactory &＃61; config.buildSessionFactory();
17         Session session &＃61; sessionFactory.openSession();
18         Connection conn &＃61; session.connection();
19         String sql &＃61; "{call getNameById(?,?)}";
20         CallableStatement cs &＃61; conn.prepareCall(sql); 
21         cs.setObject(1, 3); //设置输出参数
22         cs.registerOutParameter(2, java.sql.Types.VARCHAR); //设置第二个参数为输出参数
23         cs.execute(); //调用存储过程
24         String name &＃61; cs.getString(2);//获取输出参数
25         System.out.println(name);
26     }
27
28 }
&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;

如何通过hibernate去调用存储过程&＃xff1f;

说实话还真看不出来hibernate调用存储过程有什么优势
Java代码
  CREATE   TABLE  &＃96;proctab&＃96; (    &＃96;id&＃96;  int ( 11 )  NOT   NULL  auto_increment,    &＃96;Name&＃96;  varchar ( 20 ),    &＃96;age&＃96;  int ( 11 ),    PRIMARY   KEY   (&＃96;id&＃96;)    )  CREATE TABLE &＃96;proctab&＃96; ( &＃96;id&＃96; int ( 11 ) NOT NULL auto_increment, &＃96;Name&＃96;

varchar ( 20 ), &＃96;age&＃96; int ( 11 ), PRIMARY KEY (&＃96;id&＃96;) )简单的存储过程Java代码  create   PROCEDURE  proc()     begin      select   *   from  proctab;    end ;   create PROCEDURE proc() begin select * from proctab; end ;一种方法是通过

hibernate传统的xml映射方式去调用Java代码                              

name&＃61;"age" column&＃61;"age" type&＃61;"integer" />                                  

name&＃61;"name" column&＃61;"name" />                         {call proc()}        

class&＃61;"native"/>

property name&＃61;"id" column&＃61;"id" /> {call proc()} 调用方法Java代码  Session ss&＃61; HibernateSessionFactory.getSession()    List

li&＃61;ss.getNamedQuery("getUser").list();    ss.close();  Session ss&＃61; HibernateSessionFactory.getSession() List li&＃61;ss.getNamedQuery("getUser").list(); ss.close();及其类似jdbc的方法Java代码  Session session

&＃61;HibernateSessionFactory.getSession();     Connection conn &＃61; session.connection();     ResultSet rs &＃61;null;    CallableStatement call &＃61; conn.prepareCall("{Call proc()}");    rs &＃61; call.executeQuery();    rs.close();    session.close(); 

Session session &＃61;HibernateSessionFactory.getSession(); Connection conn &＃61; session.connection(); ResultSet rs &＃61;null; CallableStatement call &＃61; conn.prepareCall("{Call proc()}"); rs &＃61; call.executeQuery(); rs.close(); session.close();

这种方法基本上就是jdbc还有就是通过强大的createSQLQuery来实现个人比较喜欢这种方法
Java代码
  Session session &＃61;HibernateSessionFactory.getSession();     SQLQuery query &＃61; session.createSQLQuery("{Call proc()}");    List list &＃61;query.list();    session.close();  Session session &＃61;HibernateSessionFactory.getSession(); SQLQuery query

&＃61; session.createSQLQuery("{Call proc()}"); List list &＃61;query.list(); session.close();如果没有返回值 直接用execute的方法就可以了还有一个重要的问题就是存储过程的传参问题Java代码  CallableStatement call &＃61; conn.prepareCall("{Call proc(?)}"); 

  call.setString(1, 参数);    rs &＃61; call.executeQuery();  CallableStatement call &＃61; conn.prepareCall("{Call proc(?)}"); call.setString(1, 参数); rs &＃61; call.executeQuery();Java代码  SQLQuery query &＃61; session.createSQLQuery("{Call proc(?)}"); 

  query.setString(0, 参数);    List list &＃61;query.list();