- @Override
- public String processData(final String taxPayerNo,final String period) throws Exception {
- return (String)this.getHibernateTemplate().execute(new HibernateCallback() {
- @Override
- public Object doInHibernate(Session session) throws HibernateException,
- SQLException {
- Connection conn = session.connection();
- CallableStatement pstmt = null;
- String result = null;
- try{
- pstmt = conn.prepareCall("{ call creat_cal_report_data(?,?,?)}");
- pstmt.setString(1, taxPayerNo);
- pstmt.setString(2, period);
- pstmt.registerOutParameter(3,java.sql.Types.VARCHAR);
- pstmt.executeQuery();
- result = (String) pstmt.getObject(3);
- }catch(Exception e){
- e.printStackTrace();
- }
- return result;
- }
- });
- }
hibernate 调用mysql存储过程
最新推荐文章于 2021-03-04 04:07:07 发布