Commons DAO will facilitate query preparation by providing a mechanism based on the FilterRequest.java.
For further information regarding the implementation, please refer to commons-dao-sample.