jpa调用存储过程（JPA calls stored procedures）.docVIP

jpa调用存储过程（JPA calls stored procedures） JPA stored procedure call [transfer] To call a stored procedure, we can pass the EntityManager object (createNativeQuery) method SQL Statement (Note: here is the SQL statement, not HPQL), call the stored procedure SQL format is as follows: {call stored procedure name (parameter 1, 2 parameters,... }) The stored procedure in EJB3 you can call two 1. the return value of the stored procedure. The return value is 2. ResultSet (in the form of select value returned by the stored procedure) (Note: EJB3 cannot call to return the value of the stored procedure parameters OUT. ) Here we look at the stored procedure call methods of several representative. Stored procedure call no return First, create a AddPerson stored procedure, following his DDL (Note: this example uses the MySql database): CREATE PROCEDURE (`AddPerson`) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT BEGIN INSERT into person (`PersonName`, `sex`, `age`) values (stored procedure, 1,25); END; The following code snippet shows no method calls a stored procedure return value: / / stored procedure call no return parameters Query query = em.createNativeQuery ({call (AddPerson)} ); (query.executeUpdate); The stored procedure call returns a single value To create a GetPersonName stored procedure, he has input a parameter of type INTEGER, the stored procedure DDL follows (Note: this example uses the MySql database): CREATE PROCEDURE `GetPersonName` (IN Pid INTEGER (11)) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT BEGIN Select personname from person where `personid`=Pid; END; The following code snippet shows the method call stored procedures that return single values of the: / / call a stored procedure that returns a single value Query query = em.createNativeQuery ({call GetPersonName (?)}); Query.setParameter (1, new, Integer (1)); String = query.getSingleResult (result) (.ToString); Returns all column table storage process To create a GetPersonList stored procedure, followin