PrimeFace datatable on a database model

Hello, I am looking for a prototype showing how to link a Primefaces datatable to a database with thousand of rows. I would like to combine pagination, sorting, a quick research field with auto completion, a context menu on rows showing additional info, and row selection. This should be done with a minimal database overload, like explained here [login to view URL] I already have a database for this project. I would like a minimal and clear code with comments to understand how it works. Ideally the code should run on my configuration: Netbeans IDE, Maven, Tomcat, MySQL.