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 <[EMAIL PROTECTED]> 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
