main
Line | |
---|
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.