Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package si.arnes.dropbookmarks.db; import com.google.common.base.Optional; import io.dropwizard.hibernate.AbstractDAO; import java.util.List; import org.hibernate.SessionFactory; import si.arnes.dropbookmarks.core.User; /** * * @author klemen */ public class UserDAO extends AbstractDAO<User> { public UserDAO(SessionFactory sessionFactory) { super(sessionFactory); } //calls superclass methods (list) with our named query public List<User> findAll() { return list(namedQuery("si.arnes.dropbookmarks.core.User.findAll")); } public Optional<User> findByUsernamePassword(String username, String password) { return Optional .fromNullable(uniqueResult(namedQuery("si.arnes.dropbookmarks.core.User.findByUsernamePassword") .setParameter("username", username).setParameter("password", password))); } }