Below is the mapping files for parnet and child tables;
Parent
*****
ID NAME
1 STEVEN
2 JOHNSON
Child
*****
ID FIRSTNAME LASTNAME PID
1 XXX AAA 1
2 YYYY LLL 1
3 GGGG JJJJ 2
4 JJJJ BJB 1
5 HGHH JUIU 2
i have 2 qustions in this..
1.Using hibernate how to retrieve child records by passing corresponding parentid(pid);i want to know how to use hibernate in a good way?
2.how to write below queries in Hibernate??
select * from parent p,child c where p.id=c.pid and c.pid=1
Parent.hbm.xml
**********
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.dao.Parent" table="PARENT" schema="SCOTT">
<id name="pid" type="java.lang.Long">
<column name="PID" precision="6" scale="0" />
<generator class="increment" />
</id>
<property name="pname" type="java.lang.String">
<column name="PNAME" length="50" />
</property>
<set name="childs" inverse="true">
<key>
<column name="PID" precision="6" scale="0" />
</key>
<one-to-many class="com.dao.Child" />
</set>
</class>
</hibernate-mapping>
Child.hbm.xml
************
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.dao.Child" table="CHILD" schema="SCOTT">
<id name="cid" type="java.lang.Long">
<column name="CID" precision="6" scale="0" />
<generator class="increment" />
</id>
<many-to-one name="parent" class="com.dao.Parent" fetch="select">
<column name="PID" precision="6" scale="0" />
</many-to-one>
<property name="firstname" type="java.lang.String">
<column name="FIRSTNAME" length="12" />
</property>
<property name="lastname" type="java.lang.String">
<column name="LASTNAME" length="12" />
</property>
</class>
</hibernate-mapping>
