Looking for the latest version? Download easy-jpa-3.0-alpha.jar (48.5 kB)
Home
Name Modified Size Downloads / Week Status
3.0-alpha 2011-05-20 0
2.0-alpha 2011-05-16 0
1.0-alpha 2011-05-16 0
readme.txt 2011-05-25 2.7 kB 0
CriteriaProcessorTest.java 2011-05-06 21.7 kB 0
gpl-3.0.txt 2011-05-06 35.1 kB 0
easy-jpa-1.0-alpha-SNAPSHOT-javadoc.zip 2011-05-06 226.9 kB 0
easy-jpa-1.0-alpha-SNAPSHOT.jar 2011-05-06 41.9 kB 0
Totals: 8 Items   328.3 kB
----------------------------------------------------------------------------------------------------- NOTE: THIS PROJECT IS RENAMED TO EASY-CRITERIA (https://sourceforge.net/projects/easy-criteria/). ----------------------------------------------------------------------------------------------------- Tired of writing SQL in Java? Afraid of fragility of named queries?  Want to write metadata based type-safe queries, but lost in verbose JPA api? Then this framework is for you. Now you can now write metadata based, type-safe, debugable, readable, and maintainable queries in Object Oriented way easily. No prior knowledge of SQL or JPA required. ----------- HOW TO USE: ----------- There are two main classes in this framework; 1- CriteriaComposer, 2- CriteriaProcessor Use CriteriaComposer to construct your query using one or all of the following constructs: Select, Where, Group by, Order By, Join, Logical Operators (AND, OR, NOT), Comparison Operator (EQUAL, LIKE, IN, etc..), AggregateFunction (SUM, COUNT, AVERAGE, etc..). Use CrieriaProcessor to execute this query and get the results. There are two types of API in this class; 1- Entity based, 2- Tuple based Use Entity based API when you want to get all columns of the root entity. Use Tuple based API when you to retrieve selected columns from one or more than one entities. Please note that Entity based API ignores the Select clause that you may have in you criteria. ----------- EXAMPLE 1: SQL : select person.name, sum(course.unit) from person inner join course_session inner join course group by person.name ----------- CriteriaComposer<Person> studentUnitCount = CriteriaComposer.createComposer(Person.class).select(Person_.name).groupBy(Person_.name); studentUnitCount.join(Person_.courseSessions).join(CourseSession_.course).select(AggregateFunction.SUM, Course_.unit); List<Tuple> result= criteriaProcessor.findAllTuple(studentUnitCount); for(Tuple tuple: result) System.print(tuple.get("Person.name")); Alternatively you can define your own alias e.g. {select(Person_.name, "name")}. This alias should be unique across your criteria, if you select another column with the same alias e.g.{select(Course_.name, "name")} then it would result in an error. ----------- EXAMPLE 2: SQL: select * from course where course.last_update_date_time between ? and ? ----------- CriteriaComposer<Course> courseCriteria = new CriteriaComposer<Course>(Course.class); criteria.where(Course_.lastUpdateDateTime, ComparisonOperator.BETWEEN, thatDate, toDate); List<Course> result = criteriaProcessor.findAllEntity(courseCriteria);
Source: readme.txt, updated 2011-05-25

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks