从其他地方找到的 Hibernate 调用存储过程。

摘抄 from heweiquan123 的博客。
import java.util.List;
import java.util.Set;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
//import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import cn.jon.hib.*;
import cn.jon.hib2.*;
import java.sql.*;

public class test {

public void exe(){
fun();
System.out.println("--OK--");
}

public void fun(){
SessionFactory sessionFactory = new Configuration().configure("hibernate11.cfg.xml").buildSessionFactory();
Session session = sessionFactory.openSession();

Transaction tx = session.beginTransaction();
System.out.print("---begin---");
Connection con=session.connection();

String procedure = "{call batchUpdate (?)}";
try {
CallableStatement cstmt = con.prepareCall(procedure);
cstmt.setInt(1,15); //把年龄参数设为0
cstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}



tx.commit();
session.close();
sessionFactory.close();
}

}

－－－－－－－－－－－－－－－附 sqlserver 存储过程


CREATE  PROCEDURE  batchUpdate @age int
as
begin
update TABLE1 set AGE=AGE+1 where AGE=@age;
end;
GO
－－－－－－－－－－－－－－－附 表结构

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE1]
GO

CREATE TABLE [dbo].[TABLE1] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[age] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TABLE1] WITH NOCHECK ADD
CONSTRAINT [PK_TABLE1] PRIMARY KEY  CLUSTERED
(
[id]
)  ON [PRIMARY]
GO
这篇比较简单明了,hibernate的缺点就是不能调用存储过程,但是还是可以绕过它使用的呵呵. 

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1706474