From 28d2cf5b30ba18f20db54ed9447bc19cb0e4e1b0 Mon Sep 17 00:00:00 2001 From: James Moger Date: Thu, 5 Jan 2012 09:24:42 -0500 Subject: Prepare 0.7.7 release --- docs/02_usage.mkd | 5 +++++ docs/04_examples.mkd | 4 ++++ 2 files changed, 9 insertions(+) (limited to 'docs') 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"); -- cgit v1.2.3