Re: QueryByExample

[Jeff Butler <je...@gmail.com>]

Query 1:

CouponExample example = new CouponExample();
example.setBarcode(myBarcode);
example.setBarcode_Indicator(CouponExample.EXAMPLE_EQUALS);
example.setExpirationDate(myExpirationDate);
example.setExpirationDate_Indicator(CouponExample.EXAMPLE_EQUALS);

Query 2:

 CouponExample example = new CouponExample();
example.setBarcode(myBarcode);
example.setBarcode_Indicator(CouponExample.EXAMPLE_EQUALS);
example.setExpirationDate(myExpirationDate);
example.setExpirationDate_Indicator(CouponExample.EXAMPLE_EQUALS);
example.setCombineTypeOr(true);

Query 3:

Date now = new Date();
 CouponExample example = new CouponExample();
example.setStartDate(now);
example.setStartDate_Indicator(CouponExample.EXAMPLE_LESS_THAN_OR_EQUAL);
example.setExpirationDate(now);
example.setExpirationDate_Indicator(
CouponExample.EXAMPLE_GREATER_THAN_OR_EQUAL);


Jeff Butler


On 3/17/06, Tony Qian <da...@aol.com> wrote:
>
> All,
>
> Just started to use Abator to generate DAO codes for iBATIS.  Have a
> question on queryByExample.
>
> I have table coupon
> { coupon_id, barcode, start_date, expiration_date, ...}.  start_date and
> expiration_date have DATE as JDBCType.
> database is MySql
>
> I have three queries.
>
> select * from coupon where barcode=myBarcode AND
> expiration_date=myExpirationDate;
> select * from coupon where barcode=myBarcode OR
> expiration_date=myExpirationDate;
> select * from coupon where start_date <=NOW() AND expiration_date>=NOW();
>
> How do I set Example object?
>
> thanks, for help,
> Tony
>
>