Class Query
classQuery helps you to filter your list of entities in SQL manner. You do not have to write line of For Loop and/or If statements combination to get your desired result. It’s very simple curve to use and learn as it uses SQL syntax. Suppose that you have array list which has many objects, and you want to filter this list against some business conditions, using this tool, you won’t have to write for loops and/or if statements combination to select your object, just use ClassQuery to achieve your desired action simply and elegantly. It will save your time while preserving a clean code style in your logic with the least number of lines of code.
Why Class Query
- Class Query will help do your work faster, and easily.
- More readbility.
- Easy to use.
- Easy to customize.
- More complex conditions in simple lines.
- A few minutes to learn.
- Help you separate business domain about its presentation.
Features
Currently, ClassQuery avails the following features.
- Use SQL syntax.
- Use SQL relation operator
- Use SQL condition grouping like (y = 0 and j=0) or i =1
- ArrayList could have inherited classes
- Simple iteration over results
- Try to echo JDBC syntax
- Parameter passing as of inline parameter to able to do:
- statement.setParameter(parameterName, parameterValue);
- Let the user apply business check whether i should select object or not.
- Class path navigation.
- SQL Join.
Planned To Have
These features are to be implemented on the next release:s
- Deal with Date objects
- SQL Left Join.
- SQL Right Join
- SQL functions like Count.
- SQL Sub query.