I make a website on Play and ran into a problem, I need to get filtered data from the database. I cannot find anything sensible in the Internet, maybe someone knows how or where it is described to eat?

Update

There is a database there is a framework, what function to get the filtered data from the database? for analogy in hibernate , the @Filter annotation is @Filter .

  • Do you have JDBC, EBean or JPA there? - Nofate ♦
  • I use EBean - Bohdan Korinnyi

1 answer 1

search by id

 LibraryModel libraryModels; libraryModels = Ebean.find(LibraryModel.class, 7);

get all

 List<LibraryModel> models = Ebean.find(LibraryModel.class).findList();

filter

 Login extends Model{ ... public static Finder<Integer,Login> find = new Finder<Integer,Login>(Integer.class, Login.class); ... } List<Login> loginList = Login.find.where().like("login","%test%").findList(); List<Login> loginList = Login.find.where().eq("role","administrator").findList(); List<Login> loginList = Login.find.where().between("suma",number1,number2); List<Book> tasks = Book.find.where().ilike("name", "%java%").orderBy("name asc").findPagingList(25).getPage(1);