Hi to all ,

i am new to hibernate ,

i am tring to retrive data from database using hql , the code which i used is---

i am getting the records, but help me to ger a better one

Thanks for support..
Session s=null;
try
{
SessionFactory sf=new Configuration().configure().buildSessionFactory();
s=sf.openSession();

String sql="from FacultyCourses";

Query q=s.createQuery(sql);

for(Iterator it=q.iterate();it.hasNext();)
{
FacultyCourses obj=(FacultyCourses) it.next();

int a=obj.getNumberOfStudentEnrolled();

FacultyCoursesId aa= obj.getId();
String ap=aa.getFacultyId();
if(ap.equalsIgnoreCase("Fact519"))
{
System.out.println("fact:"+ obj.getDateCourseStarted());
break;
}


}

SessionFactory sf=new Configuration().configure().buildSessionFactory();

s=sf.openSession();

List searchresult = null;

Criteria crit = session.createCriteria(FacultyCourses.getClass());

crit.add(Restrictions.eq(columnName, value)); //Put columname which u require and value equal to what u r expecting

searchresult = crit.list();

s.flush();

s.close;

return searchresult; //this searchresult will have your desired result.

Thanks chirag.naikec for your time and concern

still i am not getting what i want is ---

courcetable
column1
column2
column3
column4
column5

base on one column1 a want to find any record out of 1000

i.e Query q=selet column1 from coursetable where column1='some thing';

in iteration loop i am able to acees remaining columns of particular record

IF any knows this concept help me...

Thanks chirag.naikec for your time and concern

still i am not getting what i want is ---

courcetable
column1
column2
column3
column4
column5

base on one column1 a want to find any record out of 1000

i.e Query q=selet column1 from coursetable where column1='some thing';

in iteration loop i am able to acees remaining columns of particular record

IF any knows this concept help me...

Query query = session.createQuery("select f.dateCourseStarted from FacultyCourses f where f.id.facultyId = :facultyId");
query.setParameter("facultyId","Fact519");
Object dateCourseStarted = query.getSingleResult();