Prepare 0.7.7 releasev0.7.7

2 files changed, 9 insertions, 0 deletions

diff --git a/docs/02_usage.mkd b/docs/02_usage.mkd
index 14619f2..0c7ba06 100644
--- a/docs/02_usage.mkd
+++ b/docs/02_usage.mkd
@@ -54,6 +54,11 @@ There may be times when the hybrid approach is still too restrictive and you'd p
 %BEGINCODE%

 List<Product> allProducts = db.executeQuery(Product.class, "select * from products");

 List<Product> restock = db.executeQuery(Product.class, "select * from products where unitsInStock=?", 0);

+

+// parameterized query which can be cached and re-used later

+String q = db.from(p).where(p.unitsInStock).isParameter().toSQL();

+List<Product> restock = db.executeQuery(Product.class, q, 0);

+

 %ENDCODE% 

 

 Or if you want access to the raw *ResultSet* before building your model object instances...

diff --git a/docs/04_examples.mkd b/docs/04_examples.mkd
index eaaa579..1f605e7 100644
--- a/docs/04_examples.mkd
+++ b/docs/04_examples.mkd
@@ -114,6 +114,10 @@ Dynamic queries skip all field type checking and, depending on which approach yo
 // where fragment with object parameters

 List<Product> restock = db.from(p).where("unitsInStock=? and productName like ? order by productId", 0, "Chef%").select();

 

+// parameterized query which can be cached and re-used later

+String q = db.from(p).where(p.unitsInStock).isParameter().and(p.productName).likeParameter().orderBy(p.productId).toSQL();

+List<Product> allProducts = db.executeQuery(Product.class, q, 0, "Chef%");

+

 // statement with binding to your model class

 List<Product> allProducts = db.executeQuery(Product.class, "select * from products");