一、建表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(16) NOT NULL default '',
`REMARK` varchar(16) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
二、建立存储过程
1、获取用户信息
CREATE DEFINER=`root`@`localhost` PROCEDURE `getUserList`()
BEGIN
select * from user;
END;
2、通过传入参数创建用户
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertUser`(nameVar varchar(16),remarkVar varchar(16))
BEGIN
insert into user(name,remark) values(nameVar,remarkVar);
END;
三、User.hbm.xml
<hibernate-mapping>
<class name="com.cj.proc.hibernate.User" table="user" catalog="temp">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native"></generator>
</id>
<property name="name" type="java.lang.String">
<column name="NAME" length="16" not-null="true" />
</property>
<property name="remark" type="java.lang.String">
<column name="REMARK" length="16" not-null="true" />
</property>
</class>
<sql-query name="getUserList" callable="true">
<return alias="aa" class="com.cj.proc.hibernate.User">
<return-property name="id" column="ID"></return-property>
<return-property name="name" column="NAME"></return-property>
<return-property name="remark" column="REMARK"></return-property>
</return>
{call getUserList()}
</sql-query>
</hibernate-mapping>
四、调用
1、获取用户信息
Session session = HibernateSessionFactory.getSession();
Query query = session.getNamedQuery("getUserList");
//query.setString(0, "");设置参数
List<User> list = query.list();
for(User user:list){
System.out.println(user.getName()+" "+user.getRemark());
}
2、通过传入参数创建用户
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
Connection conn = session.connection();
String proc = "call insertUser(?,?)";
CallableStatement cs = conn.prepareCall(proc);
cs.setString(1, "LINRZ");
cs.setString(2, "REMARK");
cs.execute();
tx.commit();
调用查询存储过程时，调用session.getNamedQuery("…")方法来获得User.hbm.xml中配置的查询存储过程。其余存储过程的调用，先通过hibernate的session获得connection，然后调用connection对象的相应方法来实现存储过程的调用。