Hibernate 调用存储过程示例记录

@Autowired
private HibernateTemplate hibernateTemplate;

public String equipCheck(String equipCode) {
    SessionFactory sessionFactory = this.hibernateTemplate.getSessionFactory();
    Session session = sessionFactory.getCurrentSession();
    ProcedureCall call = session.createStoredProcedureCall("EquipCheck");
    //设置输入参数
    call.registerParameter("EquipCode", String.class,  ParameterMode.IN).bindValue(equipCode);
    //设置输出参数
    call.registerParameter("Result", String.class,  ParameterMode.OUT);
    //获取输出参数的值
    String result= (String) call.getOutputs().getOutputParameterValue("Result");
    return result;
}

CREATE DEFINER=`pack`@`%` PROCEDURE `EquipCheck`(IN `EquipCode` varchar(50),OUT `Result` varchar(1000))
BEGIN

set Result='验证OK';

end