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 more09:38:18,837  INFO SessionFactoryImpl:153 - building session factory09: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.xml09:38:21,951  INFO SessionFactoryObjectFactory:
82 - Not binding factory to JNDI, no JNDI name configuredHibernate: ...{call testProc()}09:38:22,482  WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: S1C0009:38:22,482 ERROR JDBCExceptionReporter:72 - Callable statments not supported.

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

　　是不是挺简单的。