Hello,
I am using netbeans and new to JSf and Primefaces.
The CRUD Webapplication is created using Netbeans 15 - created tables, generated entities from database, created JSF using the entities (Maven Framework).
Table 1) Customer - CustID, CustName, CenterID
Table 2) Center - CenterID, CenterName
Question 1)
In the Customer LIST page, I can see the correct CenterID. I want to replace the centerID with CenterName. How do it exactly using this framework. I am aware of table joins. But not sure what is the best way to change the model and display in view
CustomerMst.java has NamedQueries:
@NamedQuery(name = "BCustomerMst.findAll", query = "SELECT b FROM BCustomerMst b")
CentreMst.java
@NamedQuery(name = "BCentreMst.findAll", query = "SELECT b.centerName FROM BCentreMst b"),
List.html is iterating items as follows:
<p:dataTable id="datalist" value="#{bCustomerMstController.items}" var="item"
selectionMode="single" selection="#{bCustomerMstController.selected}"
paginator="true"
rowKey="#{item.bid}"
rows="10"
rowsPerPageTemplate="10,20,30,40,50"
>
<h:outputText value="#{item.centerID}"/>
I want this centerID replaced with centerName
Question 2)
There are multiple named queries. The first one is picked up by List to display the data. How to select the Other Queries to show the data in LIST? I am unable to understand how the first one is selected by default. Missing something.
Can anyone help please?