Hibernate调用mysql5.0存储过程小记

1.hibernate3

　　到这下载hibernate3:http://sourceforge.net/project/showfiles.phpgroup_id=40712&package_id=
127784&release_id=403223

　　2.mysql (注意一定要用mysql5.0和最新驱动)
 
　　mysql官方网站http://www.mysql.com/

 
　　过程：

　　1.建张表

  
  

   
   
   
    CREATE   TABLE  `proctest` (
`id`  int ( 11
   
    )  NOT   NULL  auto_increment,
`Name`  varchar ( 20 )  default   ''''''
   
    ,
`age`  int ( 11 )  default
   
      NULL ,
`address`  varchar ( 50 )  default   ''
   
    ,
PRIMARY   KEY   (`id`)
) ENGINE = InnoDB  DEFAULT  CHARSET = gb2312;
  
  

　　2.插入几条记录

  
  

   
   
   
    INSERT   INTO  `proctest`  VALUES  ( 1 , ' tom ' , 22 , 'http://www.blogjava.net '
   
    );
INSERT   INTO  `proctest`  VALUES  ( 2 , ' wujun ' , 25 , 'http://www.blogjava.net/wujun '
   
    );
INSERT   INTO  `proctest`  VALUES  ( 3 , ' jerry ' , 30 , ' 深圳 '
   
    );
INSERT   INTO  `proctest`  VALUES  ( 4 , ' wujun ' , 40 , ' 南昌 ' );
  
  

　　3.创建存储过程
 
　　-- 这只是一个例子，就来个简单存储过程

  
  

   
   
   
   
   
    create   PROCEDURE  testProc()
 begin
    select   *
   
      from  proctest;
 end ; 
  
  

　　打开eclipce新建个java工程，记得把hiberbate3类库也一起加进去。

　　看下结构图：

　　新建UserVO.java文件

  
  

   
   
   
   package  net.wj.proc.vo;
public   class
   
     UserVO   {
private   int
   
     id;
private
   
     String name;
private   int
   
     age;
private
   
     String address;
public
   
     UserVO()
{}
  
  

　　顺便把它相对应的配置文件也写上。

　　UserVO.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" >
   
   


   
   <!-- DO NOT EDIT: This is a generated file that is synchronized -->
   
   

   
   <!-- by MyEclipse Hibernate tool integration.                   -->
   
   

   
   <!-- Created Sat Apr 22 17:08:56 CST 2006                         -->
   
   

   
   <hibernate-mapping>
   
   

    
   
   <class name="net.wj.proc.vo.UserVO" table="proctest">
   
   
        
   
   <id name="id" column="id">
   
   
            
   
   <generator class="native"/>
   
   
        
   
   </id>
   
   

        
   
   <property name="name" column="name" type="string" />
   
   
        
   
   <property name="age" column="age" type="integer" />
   
   
        
   
   <property name="address" column="address" type="string" />
   
   

    
   
   </class>
   
   

    
   
   <!--sql查询-->
   
   
     
   
   <sql-query name="select">
   
   
     
   
   <![CDATA[select {usr.*} from proctest usr ]]>
   
   
     
   
   <return alias="usr" class="net.wj.proc.vo.UserVO" />
   
   
     
   
   </sql-query>
   
   

     
   
   <!--调用存储过程就在这里配了-->
   
   
    
   
   <sql-query name="getUser" callable="true">
   
   
     
   
   <return alias="user" class="net.wj.proc.vo.UserVO">
   
   

     
   
   <return-property name="id" column="id" />
   
   
      
   
   <return-property name="name" column="name" />
   
   
       
   
   <return-property name="age" column="age" />
   
   
        
   
   <return-property name="address" column="address" />
   
   
     
   
   </return>
   
   
     
   
   <!--这里就是我们刚刚创建的存储过程名-->
   
   
     {call testProc()}
     
   
   </sql-query>
   
   

   
   </hibernate-mapping>
  
  

测试代码 

  
  

   
   
   
   package net.wj.proc.test;
import java.util.List;
import org.hibernate.*
   
   ;
import org.hibernate.cfg.*
   
   ;
import net.wj.proc.vo.*
   
   ;
import org.apache.log4j.*
   
   ;
public class
   
    ProcTest {
/** *//*
   
   *
* @param args
*/
   
   
    Logger log
   
   =Logger.getLogger(this
   
   .getClass());
public
   
    ProcTest()
{}
public static void
   
    main(String[] args) {
System.out.print("start............................."
   
   );
ProcTest tt=new
   
    ProcTest();
//
   
    tt.LoadAll();
// tt.ExampleSelect();
   
   

   
          tt.ExampleProc();
}
//得到Session,
   
   

   
       public
   
    Session  getSession()
{
try
   
   
        {
Configuration cfg 
   
   = new
   
    Configuration().configure();
SessionFactory sf=
   
   cfg.buildSessionFactory();
Session ss=
   
    sf.openSession();
return
   
    ss;
}
catch
   
   (Exception ee)
{
System.out.print("失败"+
   
   ee.getMessage());
return null
   
   ;
}
}
//
   
   这里调我们在UserVO.hbm.xml
//sql-query 写上的name属性getUser
   
   

   
       public void
   
    ExampleProc()
{
Session ss=this
   
   .getSession();
List li=ss.getNamedQuery("getUser"
   
   ).list();
for(int i=0;i<li.size();i++
   
   )
{
UserVO vo=(UserVO)li.get
   
   (i);
log.info("name:"+
   
   vo.getName());
log.info("age"+
   
   vo.getAge());
log.info("address"+
   
   vo.getAddress());
}
ss.close();
}
//配置文件的sql查询
   
   

   
       public void
   
    ExampleSelect()
{
Session ss=this
   
   .getSession();
List li= ss.getNamedQuery("select"
   
   ).list();
for(int i=0;i<li.size();i++
   
   )
{
UserVO vo=(UserVO)li.get
   
   (i);
log.info("name:"+
   
   vo.getName());
log.info("age"+
   
   vo.getAge());
log.info("address"+
   
   vo.getAddress());
}
ss.close();
}
}
  
  

　　记的用最新的驱动:

　　要不然可能会报这个错

  
  

   
   
   
   Exception in thread "main"
   
    org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
SQLStateConverter.java:91
   
   )
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79
   
   )
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43
   
   )
    at org.hibernate.loader.Loader.doList(Loader.java:2148
   
   )
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029
   
   )
    at org.hibernate.loader.Loader.list(Loader.java:2024
   
   )
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111
   
   )
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1674
   
   )
    at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:147
   
   )
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164
   
   )
    at net.wj.proc.test.ProcTest.ExampleProc(ProcTest.java:45
   
   )
    at net.wj.proc.test.ProcTest.main(ProcTest.java:22
   
   )
Caused by: java.sql.SQLException: Callable statments not supported.
    at com.mysql.jdbc.Connection.prepareCall(Connection.java:1278
   
   )
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439
   
   )
    at org.hibernate.jdbc.AbstractBatcher.prepareCallableQueryStatement(AbstractBatcher.java:115
   
   )
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1557
   
   )
    at org.hibernate.loader.Loader.doQuery(Loader.java:661
   
   )
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224
   
   )
    at org.hibernate.loader.Loader.doList(Loader.java:2145
   
   )
     8
   
    more
09:38:18,837  INFO SessionFactoryImpl:153 -
   
    building session factory
09:38:18,917  WARN Configurator:126 - No configuration found. 
Configuring ehcache from ehcache-failsafe.xml found in the classpath: 
jar:file:/E:/lib/hibernate3/ehcache-1.1.jar!/ehcache-
   
   failsafe.xml
09:38:21,951  INFO SessionFactoryObjectFactory:
82 -
   
    Not binding factory to JNDI, no JNDI name configured
Hibernate: ...{call testProc()}
   
   

   
   09:38:22,482  WARN JDBCExceptionReporter:71 - SQL Error: 0
   
   , SQLState: S1C00
09:38:22,482 ERROR JDBCExceptionReporter:72 - Callable statments not supported.
  
  

　　源代码http://www.blogjava.net/Files/wujun/Proc.rar

　　是不是挺简单的。