Hi friend,

package roseindia;

import org.hibernate.*;
import org.hibernate.criterion.*;
import org.hibernate.cfg.*;

import java.util.*;

public class StoreprocedureExam {
public static void main(String arg[]){
Session session = null;
try {
SessionFactory sessionFactory = new Configuration().configure()
.buildSessionFactory();
session = sessionFactory.openSession();
String SQL_QUERY ="from Procedure proced";
Query query = session.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();){
Procedure procedure=(Procedure)it.next();

System.out.println("Id:"+procedure.getId());
System.out.println("Name:"+procedure.getUsername());
System.out.println("CLass:"+procedure.getRoom());
System.out.println("Address:"+procedure.getAddress());
System.out.println("Father name:"+procedure.getFaname());

}
session.close();
}
catch (Exception e) {
System.out.println(e.getMessage());
}
finally {
}
}

}
--------------------------

This is mapping code,

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">;

<hibernate-mapping>

<class name="roseindia.Procedure" table="proced">
<id name="id" type="int" column="id" >
<generator class="assigned"/>
</id>

<property name="username">
<column name="username" />
</property>
<property name="room">
<column name="room"/>
</property>
<property name="address">
<column name="address"/>
</property>
<property name="faname">
<column name="faname"/>
</property>


</class>
</hibernate-mapping>


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

package roseindia;

public class Procedure {
private String username;
private String room;
private String address;
private String faname;
private int id;

public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getRoom() {
return room;
}
public void setRoom(String room) {
this.room = room;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}

public String getFaname(){
return faname;
}
public void setFaname(String faname){
this.faname = faname;
}

}

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

read for more information,

http://www.roseindia.net/hibernate/