dimanche 21 juin 2015

How to call MySQL view in Struts2 or Hibernate

I have a view in MySQL
CREATE VIEW CustInfo AS SELECT a.custName, a.custMobile, b.profession, b.companyName, b.annualIncome FROM customer a INNER JOIN cust_proffessional_info b ON a.cust_id=b.cust_id

Is there any way that i can call this view using Struts2 or in Hibernate. I have tried to search it but could not find any solution on it. Could any one please help me with this.

Aucun commentaire:

Enregistrer un commentaire