Hi friend,

package roseindia;

import org.hibernate.*;
import org.hibernate.criterion.*;
import org.hibernate.cfg.*;
import java.util.*;
import java.util.Iterator;

public class SearchRecordHibernate{
public static void main(String[] arg){
Session session = null;
try{
SessionFactory sessionFactory = new Configuration().configure()
.buildSessionFactory();
session = sessionFactory.openSession();

String SQL_QUERY = "from RecordInformation as record where record.userid LIKE 'Sandeep' order by record.userid";
Query query = session.createQuery(SQL_QUERY);
for(Iterator it = query.iterate();it.hasNext();){
RecordInformation inform = (RecordInformation) it.next();
System.out.println("Name:"+inform.getUserid());
System.out.println("Last Name:"+inform.getLastname());
System.out.println("Last Name:"+inform.getQualification());

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

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

package roseindia;

public class RecordInformation {
private String userid;
private String lastname;
private String qualification;
private String engineer;
private String docter;
private int id;

public String getUserid(){
return userid;
}
public void setUserid(String userid){
this.userid = userid;
}

public String getLastname(){
return lastname;
}
public void setLastname(String lastname){
this.lastname = lastname;
}
public String getQualification(){
return qualification;
}
public void setQualification(String qualification){
this.qualification = qualification;
}

public String getEngineer(){
return engineer;
}
public void setEngineer(String engineer){
this.engineer = engineer;
}

public String getDocter(){
return docter;
}
public void setDocter(String docter){
this.docter = docter;
}

public int getId(){
return id;
}
public void setId(int id){
this.id = id;
}

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

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

<property name="userid">
<column name="userid"/>
</property>
<property name="lastname">
<column name="lastname"/>
</property>
<property name="qualification">
<column name="qualification"/>
</property>
<property name="engineer">
<column name="engineer"/>
</property>
<property name="docter">
<column name="docter"/>
</property>
</class>

read for more information

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