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
Post a Comment