Question about Netbeans 6 + Visual Java Server Face + JPA

Roberto Aguirre <[email protected]> Sat, 06 Sep 2008 11:41:54 -0500
Newsgroups gmane.comp.java.netbeans.education
Message-ID <1220719314.8600.3.camel@roberto-laptop>
Hi educators, im developing an application using netbeans with JPA and
visual java Server faces. I did the job very well when tables have only
a simple primary key but when it is a compose primary key I don’t know
how work with that.
My database have 3 tables, master products(Articulos), master
types(Tipos) and a listprices(listaprecios) I can only see data by this
way

http://datacentertec.com:8080/PruebaWebApp/

Now i need do this Query

SELECT l.COD_LSP,t.DESC_TIPO,a.COD_ART, a.DESC_ART, l.PRECIO 
FROM listaprecios l, Tipos t, Articulos a 
WHERE l.TIP_LSP=t.TIPO and l.COD_ART=a.COD_ART

And the result will must be something like that:

COD_LSP DESC_TIPO COD_ART DESC_ART PRECIO
======= ======================== ======= ===============
LP001 Tipo de lista de Compras IN1001 Aguas 12.45 
LP001 Tipo de lista de Venta IN1002 Alcohol cetílicoss 23.34 

My proyect and database is in this link
www.datacentertec.com/archivo/proyectoprueba.zip 
I really apréciate your help

Regards,
Roberto