You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by jg...@apache.org on 2008/02/18 05:39:30 UTC
svn commit: r628612 -
/ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html
Author: jgbutler
Date: Sun Feb 17 20:39:29 2008
New Revision: 628612
URL: http://svn.apache.org/viewvc?rev=628612&view=rev
Log: (empty)
Modified:
ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html?rev=628612&r1=628611&r2=628612&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/htmldoc/generatedobjects/extendingExampleClass.html Sun Feb 17 20:39:29 2008
@@ -1,4 +1,3 @@
-<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3c.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
@@ -143,19 +142,16 @@
This method can be used to add simple tests related to a single parameter to the generated where clause.</p>
-<p>For example, suppose you wanted to select customers who are at least 16 years old.
+<p>For example, suppose you wanted to perform a case insensitve search on certain columns.
In MySQL, the predicate could look like this:</p>
-<code>DATEDIFF(CURDATE(), BIRTH_DATE) >= 5844</code>
-<p><i>Note: This assumes 365.25 days per year - a crude approximation</i></p>
+<code>upper(FIRST_NAME) like ?</code>
<p>This predicate fits the capabilities of a single parameter predicate - where the predicate
is a string value followed by a single parameter. Add the following
method to the <code>ExtendedCriteria</code> for this functionality:</p>
<pre>
-public ExtendedCriteria andAgeGreaterThanOrEqual(int value) {
- int days = (int) (365.25 * value);
-
- addCriterion("DATEDIFF(CURDATE(), BIRTH_DATE) >=",
- new Integer(days), "age");
+public ExtendedCriteria andFirstNameLikeInsensitive(String value) {
+ addCriterion("upper(FIRST_NAME) like",
+ value.toUpperCase(), "firstName");
return this;
}
@@ -165,7 +161,7 @@
<pre>
ExtendedExample example = new ExtendedExample();
ExtendedCriteria criteria = (ExtendedCriteria) example.createCriteria();
-criteria.andAgeGreaterThanOrEqual(16);
+criteria.andFirstNameLikeInsensitive("fred%");
List results = selectByExample(example);
</pre>