java-mysql : convert stored procedure to hibernate criteria query

In the attached zip file you will find a mysql table definition, a stored procedure, some sample data, and the Java code which calls the Stored Procedure. For details on opening the zip file, please check documentation here: [login to view URL] The requirement for this project is: 1. To use Hibernate (latest version) to generate data classes from the table definition, 2. To eliminate the Stored Procedure and instead use Hibernate Criteria Query (not HQL, not SQL) to achieve same functionality. This is a very simple project (1 or 2 java classes), maximum payment will be $30 flat fee (not hourly rate) for completed work.