公告
财富商城
积分规则
提问
发文
2019-06-07 02:19发布
Evening l夕情丶
I'm using MySql and my query to call is like:
call SPGetChart (idNumber, nameChart);
Using EntityManager
Query query=getEntityManager(). createNativeQuery("BEGIN SPGetChart(:id, :name); END;"); query.setParameter("id", idValue); query.setParameter("name", nameChart); query.executeUpdate();
Using connection through EntityManager:
Connection con = ((SessionImpl) getEntityManager().getDelegate()).connection(); CallableStatement callableStatement = cc.prepareCall("{call SPGetChart (?,?)}"); callableStatement.setInt(1, idValue); callableStatement.setString(2, nameChart); callableStatement.execute();
Using Session:
Query query = session.createSQLQuery("CALL SPGetChart (:id, :name)") .setParameter("id", idValue) .setParameter("name", nameChart); query.executeUpdate();
I know this is a old question but for those that find this now, the EntityManager class now has support for stored procedures now.
StoredProcedureQuery query = getEntityManager().createStoredProcedureQuery("SPGetChart"); query.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN); query.registerStoredProcedureParameter(2, String.class, ParameterMode.IN); query.setParameter(1, idValue); query.setParameter(2, nameChart); query.execute();
最多设置5个标签!
Using EntityManager
Using connection through EntityManager:
Using Session:
I know this is a old question but for those that find this now, the EntityManager class now has support for stored procedures now.