hibernate 调用mysql存储过程

1. @Override  
2.     public String processData(final String taxPayerNo,final String period) throws Exception {  
3.            
4.         return (String)this.getHibernateTemplate().execute(new HibernateCallback() {  
5.               
6.             @Override  
7.             public Object doInHibernate(Session session) throws HibernateException,  
8.                     SQLException {  
9.                 Connection conn = session.connection();  
10.                 CallableStatement pstmt = null;  
11.                 String result = null;  
12.                 try{  
13.                     pstmt = conn.prepareCall("{ call creat_cal_report_data(?,?,?)}");  
14.                     pstmt.setString(1, taxPayerNo);  
15.                     pstmt.setString(2, period);  
16.                     pstmt.registerOutParameter(3,java.sql.Types.VARCHAR);  
17.                     pstmt.executeQuery();    
18.                     result = (String) pstmt.getObject(3);  
19.                       
20.                 }catch(Exception e){  
21.                     e.printStackTrace();  
22.                 }  
23.                   
24.                 return result;  
25.             }  
26.         });  
27.     }