StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I know this thread is pretty old, but I also was looking for a HqlBuilder And I found this <a href="http://forge.abcd.harvard.edu/gf/project/screensaver/scmsvn/?action=browse&path=%2Fbranches%2Ficcbl%2Ftrunk%2Fsrc%2Fedu%2Fharvard%2Fmed%2Fscreensaver%2Fdb%2Fhibernate%2FHqlBuilder.java&view=markup" rel="nofollow noreferrer">"screensaver" project</a> <br/> It is NOT a Windows screensaver, it's a "<em>Lab Information Management System (LIMS) for high-throughput screening (HTS) facilities that perform small molecule and RNAi screens.</em>"</p> <p>It contains an HQLBuilder that is looking quite good. <br/>Here is a sample list of available methods: </p> <pre><code>... HqlBuilder select(String alias); HqlBuilder select(String alias, String property); HqlBuilder from(Class<?> entityClass, String alias); HqlBuilder fromFetch(String joinAlias, String joinRelationship, String alias); HqlBuilder where(String alias, String property, Operator operator, Object value); HqlBuilder where(String alias, Operator operator, Object value); HqlBuilder where(String alias1, Operator operator, String alias2); HqlBuilder whereIn(String alias, String property, Set<?> values); HqlBuilder whereIn(String alias, Set<?> values); HqlBuilder where(Clause clause); HqlBuilder orderBy(String alias, String property); HqlBuilder orderBy(String alias, SortDirection sortDirection); HqlBuilder orderBy(String alias, String property, SortDirection sortDirection); String toHql(); ... </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload