Hi all,

I am very new to Hibernate.

I have two tables structure.

Dept:
-------------
dno number(2) primary key
dname varchar(20)

Emp:
---------------------
eno number(5) primary key
ename varchar(20)
dno number(2) foriegn key

---------------------------------------------

I have couple of quesions.

1. How will I insert a rcord into Emp table whose having
may-to-one relationship to dept table?

2. How will I select a particular emp details whose dno=10 using
session.createCriteria()?

Could anyone please to provide hbm files for these issues and sample
code.

please do favour with me

Thanks and Regards,
Sreekanth

I guess your pojos like this:
public class Dept{
private int dno;
private String dname;
private Set Emps;
public Dept( int dno, String dname, Set Emps){
......
}
/** set /get*/
}
public class Emp{
private int eno;
private String ename;
private Dept dept;
public Emp( int eno, String ename, Dept dept){
......
}
/** set /get*/
}
hibernate version 3.1 spring version 2.0
user spring's hibernate
1. Dept dept = new Dept();
dept.setDno(dno);
.....
dept.save(dept)

2. DetachedCriteria detachedCriteria = DetachedCriteria
.forClass(Emp.class);
detachedCriteria.createCriteria("demp").add(Expression.eq("dno",new Integer(10)));

Than k u for ur favourable reply.....