hibernate调用SQL存储过程

存储过程:CREATE PROCEDURE .expbackDatabase1 (@path varchar(128))ASbeginBACKUP DATABASE DocProc_IMS_nbyz to disk=@pathendGOjava语句:import java.sql.CallableStatement;import java.sql.Connection;import java.sql.SQLException;import org.hibernate.HibernateException;import org.hibernate.Session;import org.hibernate.Transaction;public class CSystemCleanDaoImpl extends CDaoBase{/*** 备份当前生产库* @return* @throws SQLException * @throws HibernateException */public boolean expDataBaseUp(String path) throws DaoException, HibernateException, SQLException{Session session = this.getSession(); Transaction t = session.beginTransaction(); Connection con = session.connection(); String procedure = "{call expbackDatabase1(?)}"; CallableStatement cstmt = con.prepareCall(procedure);cstmt.setString(1, path); cstmt.executeUpdate(); t.commit(); session.close(); return false;}}调用有返回参数的存储过程:public String expSeqNo(String opcode,String opdate,int billtype,String seqNo) throws DaoException, HibernateException, SQLException{String no="";Session session = this.getSession(); Transaction t = session.beginTransaction(); Connection con = session.connection(); //第四个?是out类型的返回参数,要注册一下这个out返回类型的参数 String pro = "{call sp_GetSeqNo(?,?,?,?)}"; CallableStatement cleancs = con.prepareCall(pro);cleancs.setString(1, opcode); cleancs.setString(2, opdate); cleancs.setInt(3, billtype); //注册out类型的返回参数cleancs.registerOutParameter(4, java.sql.Types.INTEGER);cleancs.executeUpdate();//接收out类型的返回参数值no=cleancs.getInt(4)+"";t.commit(); con.close();session.close(); return no;}