查询gyf和123数据
public void test1() {
Configuration configuration=new Configuration().configure();
SessionFactory sessionFactory=configuration.buildSessionFactory();
Session session=sessionFactory.openSession();
Criteria criteria= session.createCriteria(User.class);
criteria.add(Restrictions.eq("username","gyf"));
criteria.add(Restrictions.eq("password","123"));
System.out.println(criteria.uniqueResult());
session.close();
sessionFactory.close();
}
查询id>3
public void test1() {
Configuration configuration=new Configuration().configure();
SessionFactory sessionFactory=configuration.buildSessionFactory();
Session session=sessionFactory.openSession();
Criteria criteria= session.createCriteria(User.class);
criteria.add(Restrictions.gt("userid",3));
System.out.println(criteria.list());
session.close();
sessionFactory.close();
}
模糊查询
public void test1() {
Configuration configuration=new Configuration().configure();
SessionFactory sessionFactory=configuration.buildSessionFactory();
Session session=sessionFactory.openSession();
Criteria criteria= session.createCriteria(User.class);
criteria.add(Restrictions.like("username","%1%"));
System.out.println(criteria.list());
session.close();
sessionFactory.close();
}