java - JSTL Persistence Query from single table -


i have database set follows:

id | environment | name | value ______________________________ 1  | test        | prop | value 2  | ex          | prop | value2 

in java class have query:

list<test> test = em.createquery(     "select p db p p.environment=:env or p.environment=:env2") 

and set :env , :env2 variables via getparameter

in jsp file have:

<table>     <tr>         <th>name</th>         <th>value</th>         <th>value2</th>     </tr>     <c:foreach items="${test}" var="test">         <tr>             <td><b>${test.name}</b></td>             <td>${test.value}</td>             <td>???????</td>         </tr>     </c:foreach> </table> 

my question in row question marks, how combine results of query each prop 'name' row, , 2 values different environments display in 2 columns in same row.


Comments