main
Rev | Line | |
---|
[ac151d1] | 1 | package mk.ukim.finki.eglas.services;
|
---|
| 2 |
|
---|
| 3 | import jakarta.persistence.EntityManager;
|
---|
| 4 | import jakarta.persistence.ParameterMode;
|
---|
| 5 | import jakarta.persistence.StoredProcedureQuery;
|
---|
| 6 | import org.springframework.stereotype.Service;
|
---|
| 7 |
|
---|
| 8 | @Service
|
---|
| 9 | public class TestProcedures {
|
---|
| 10 | private final EntityManager entityManager;
|
---|
| 11 |
|
---|
| 12 | public TestProcedures(EntityManager entityManager) {
|
---|
| 13 | this.entityManager = entityManager;
|
---|
| 14 | }
|
---|
| 15 |
|
---|
| 16 | public Double getTurnoutByRealizationId(long realizationId) {
|
---|
| 17 | StoredProcedureQuery query = entityManager
|
---|
| 18 | .createStoredProcedureQuery("get_turnout_by_realization_in_percentage")
|
---|
| 19 | .registerStoredProcedureParameter("realization_id", Long.class, ParameterMode.IN)
|
---|
| 20 | .registerStoredProcedureParameter("turnout_percentage", Double.class, ParameterMode.OUT)
|
---|
| 21 | .setParameter("realization_id", realizationId);
|
---|
| 22 |
|
---|
| 23 | query.execute();
|
---|
| 24 |
|
---|
| 25 | return (Double) query.getOutputParameterValue("turnout_percentage");
|
---|
| 26 | }
|
---|
| 27 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.