Sqlbuilder (OPENHMS) 2.0.10 Publish SQL Build Library

Sqlbuilder is a SQL build library that reduces the burden of generating SQL queries in Java programs. It uses a programming language (Java) to generate code (that is, SQL) for another language. It is characterized by encapsulating SQL syntax in lightweight, Easy-to-use Java objects, following a builder paradigm similar to StringBuilder. It can change many common SQL syntax and run-time errors to Java compile-time errors.

A simple SQL select query code embedded in a Java program, as follows:

The code to try to improve is as follows:

The Sqlbuilder class corresponds to the following code:

Assuming these objects have already been created
Table table1, table2;
Column t1col1, T1col2, t2col1;
Join JOINOFT1ANDT2;

String SelectQuery =
(New SelectQuery ())
. Addcolumns (T1col1, T1col2, T2col1)
. Addjoin (SelectQuery.JoinType.INNER_JOIN, JOINOFT1ANDT2)
. Addorderings (T1col1)
. Validate (). toString ();

The Sqlbuilder (OPENHMS) version 2.0.10 is primarily about adding flexibility to support SQL constructs. The associated SQL construct has no alias handling table, and dbtable can now build a clear alias. Add SelectQuery addcustomjoin to allow full 17813.html "> customizable join clauses. Combocondition, Unarycondition, binarycondition, and comboexpression can now customize operators. Now all the options for the condition and expression to disable the wrapping bracket.

Software Information: http://openhms.sourceforge.net/sqlbuilder/

Download Address: Http://nchc.dl.sourceforge.net/project/openhms/sqlbuilder/sqlbuilder%202.0.10/sqlbuilder-2.0.10.jar