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