package com;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.ProjectionList;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
public class logic
{
public static void main(String s[])
{
System.out.println("logic");
SessionFactory s1=new Configuration().configure("/hibernate.cfg.xml").buildSessionFactory();
Session session=s1.openSession();
login l=new login();
/* l.setusername("v");
l.setpassword("t");
l.setemail("vipul@gmail.com");
l.setphonenumber("960261");
Transaction t=session.beginTransaction();
session.save(l);
t.commit();
*/
Criteria c1=session.createCriteria(login.class);
// c1.add(Restrictions.and(Restrictions.eq("id", new Integer(0)),Restrictions.like("username","vipul")));
// c1.addOrder(Order.desc("id"));
// c1.setProjection(Projections.property("username"));
// c1.setProjection(Projections.property("address"));
ProjectionList p1=Projections.projectionList();
p1.add(Projections.property("username"));
p1.add(Projections.property("address"));
c1.setProjection(p1);
List l1 = (List) c1.list();
Iterator i =l1.iterator();
while(i.hasNext())
{
Object o[]=(Object [])i.next();
System.out.println(o[0] + "==" + o[1]);
// String str=(String) i.next();
// System.out.println(str);
/*
Object o=i.next();
login l11=(login)o;
System.out.println(l11.getid());
System.out.println(l11.getaddress());
System.out.println(l11.getemail());
System.out.println(l11.getpassword());
System.out.println(l11.getphonenumber());
System.out.println(l11.getusername());
*/
}
System.out.println("save");
session.close();
s1.close();
}
}