This tip shows you how to use the findByExample method in Hibernate. The method uses the SQL AND operator to log in a user given an email address and password. This code assumes you have a database table named Accountse mapped in the com.extensions.Accountse class:
/** * Get the list with the right account * * @param instance * @param c_email * @param c_password * @return List * @throws Exception */public List findByExampleAnd(String c_email, String c_password) throws java.lang.Exception { log.info("Finding Accountse instance by example..."); Session session = HibernateUtil.currentSession(); try { List results = session.createCriteria( "com.extensions.Accountse").add( Restrictions.and(Restrictions.eq( "email",c_email), Restrictions.eq("password",c_password))).list(); log.info("Find by example successful, result size: " + results.size()); return results; } catch (Exception re) { log.error("Find by example failed...", re); throw re; } finally { HibernateUtil.closeSession(); }}