Joining Multiple table in Hibernate
Hi everyone,
I'm new to Hibernate (even in JAVA), and I'm having some doubt's about one thing. I created 2 tables in PostgreSQL with 1 to many relationship, and now i'm trying to test some queries to them. Tables names are TbPessoa (one) and TbTelefone(many).
TbPessoa - idPessoa(pk), usNome(charvar), usIdade(int), usTelefone(int)
TbTelefone - idTelefone(pk), usIOperadora(charvar), usTarifario(charvar), usData(date), idPessoa(int)
Foreign Key on TbTelefone referencing TbPessoa (idPessoa to idPessoa on TbPessoa).
I'm trying to create a query where I would get the items where usNome='Peter' OR usOperadora='Vodafone' like we can do with SQL statments like,
SELECT usNome, usOperadora
FROM TbPessoa, TbTelefone
WHERE usNome='Peter' OR usOperadora='Vodafone'***
Finnaly, I need to know how a can print (using System.out.println) the query results. I've been using (just for one table) this:
transaction = session.beginTransaction();
@SuppressWarnings("unchecked")
String query = "SELECT FROM TbPessoa";
List <TbPessoa> lista = session.createQuery(query).list();
int i=0;
for( TbPessoa x : lista ) {
System.out.println( "Id: " + x.getIdPessoa() + "| Nome: " + x.getUsNome() + "| Idade:" + x.getUsIdade() + "| Morada: " + x.getUsMorada() + "| Nr. Telefone: " + x.getUsTelefone());
}
Sorry my bad English! Thanks!
Kind Regards,
Raul
View Answers
April 3, 2012 at 10:55 AM
Ads
Related Tutorials/Questions & Answers:
Joining Multiple table in Hibernate
Joining Multiple table in Hibernate Hi everyone,
I'm new to
Hibernate (even in JAVA), and I'm having some doubt's about one thing. I created 2... (using System.out.println) the query results. I've been using (just for one
table
Hibernate joining multiple tables
Hibernate joining multiple tables In join sample program, what do we mean by the line?
String sql_query = "from
Product p inner join p.dealer as d... group by p.name";
For more information, visit the following link:
Hibernate
Advertisements
Hibernate envers revinfo table
Hibernate envers revinfo table Hi,
What is the structure of
hibernate envers revinfo
table?
What is the use of envers revinfo
table and its structure?
Thanks
mysql alter table add multiple columns
mysql alter
table add
multiple columns Hi,
I have a
table in database. I want to add
multiple columns into existing
table. What is the code for mysql alter
table add
multiple columns?
Thanks
Hi,
You can use
How to update table in Hibernate
How to update
table in Hibernate Hi, I have a
table in database that has two fields in it. Student Name and ID, can anyone explain me how to update these tables in
Hibernate.
Thanks.
Update
table query in
Hibernate
SQL Alter Table Add Multiple Columns
SQL Alter
Table Add
Multiple Columns
Alter
Table Add
Multiple Columns in SQL... Add
Multiple Columns. The SQL Query create a
table 'Stu_
Table' with
table
Hibernate Criteria Multiple or
Hibernate Criteria
Multiple or
You can implements
multiple or in
hibernate... of
multiple or is given below
CriteriaMultipleOr.java
package... run this application it will display message as shown below:
Hibernate
Retrieve multiple data from database into Table.....
Retrieve
multiple data from database into
Table..... hi...........
I want to Retrieve
multiple data from database into
Table but i am not able to....
i am only able to retrieve one value not more than that. means
in my
Retrieving value from multiple table in database
Retrieving value from
multiple table in database Hi fnds, I want to maintain the financial database of 20 users for 1 year and update the details... created 12 tables with
table name - month1,month2,....,upto month12.. each
table
Hibernate table not mapped error - solution
Hibernate table not mapped error - solution Hi,
What is the reason of
Hibernate table not mapped error and it can be solved?
Thanks
HI... configuration of Entity class in
Hibernate.
Hibernate is ORM framework in Java which
Hibernate Envers custom revinfo table
Hibernate Envers custom revinfo table Hi,
How to use the custom
table instead of revinfo
table?
I don't want to use the default
table I want to give another name for this
table. How to do this?
Thanks
Hibernate Envers - REVINFO table doesn't exist
Hibernate Envers - REVINFO
table doesn't exist Hi,
In my project I...:
Hibernate Envers - REVINFO
table doesn't exist
How to resolve this?
Thanks...
hibernate to create
table automatically. For this add following property
Joining tables using criteria
Joining tables using criteria How do i join more than three tables and retrieve one column from parent
table and count of unique values in a single column from child
table,the joined tables must be maintain primary key
Hibernate envers custom revinfo table
Hibernate envers custom revinfo
table - How to specify custom revinfo
table?
In this tutorial we are going to teach you to configure the
Hibernate... in the
tutorial.
In
Hibernate envers its possible to use the custom revinfo
table
Delete database Table through hibernate and Spring
Delete database
Table through
hibernate and Spring Hi,
I am using Spring,
Hibernate and Tapestry to save and also fetch data simultaneously from... once without repetation,or Detete
table after data is fetched.
Here
Mysql Multiple Date Insert
multiple data to the
table.
Understand with Example
The Section of Tutorial... sec)
Query for
Multiple insertion of data in
table:
The Query insert into is used for
Multiple insertion of data in
table
'Employee'.
The Query
Mysql Multiple Date Insert
multiple data to the
table.
Understand with Example
The Section of Tutorial... (0.01 sec)
Query for
Multiple insertion of data in
table:
The Query insert into is used for
Multiple insertion of data in
table
'Employee
delete row from a table using hibernate
delete row from a
table using hibernate //code in java file
String hql="delete from CONTACT c where ID=6";
Query query=session.createQuery(hql);
//error when executing above code
CONTACT is not mapped
Mysql Alter Add Multiple Columns
the
table and add
multiple
columns to the specified
table.
Understand with Example...)
Query to alter
Table named employees by adding
multiple column named city:
The Query below given is used to modify the
table 'employees' and add
multiple
Hibernate Criteria load all objects from table
Hibernate Criteria load all objects from
table - Learn how to load all...
from a
table then you can easily use the
Hibernate Criteria load all objects... the
Hibernate Criteria Query to
fetch all data from a
table. Read more