SqlBuilderSQL生成類庫
SqlBuilder 是一個(gè)Java的類庫，它試圖幫你避免在Java程序內(nèi)直接書寫SQL查詢的痛苦。你只需要使用 SqlBuilder 的方法，它就可以幫你生成對(duì)應(yīng)的 SQL 數(shù)據(jù)庫查詢語句，例如下面一個(gè)SQL語句：
String selectQuery = "SELECT " + T1_COL1 + "," + T1_COL2 + "," +
T2_COL1 + " FROM " + TABLE1 + " " + T1 + " INNER JOIN " +
TABLE2 + " " + T2 + " ON (" + T1_IDCOL + " = " + T2_IDCOL +
") ORDER BY " + T1_COL1;
對(duì)應(yīng)的 SqlBuilder 的代碼是：
// 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();
更多的示例代碼請(qǐng)看這里。
編者：這樣的做法使得程序難以閱讀，不直觀。
評(píng)論
圖片
表情