QueryByExample

[Tony Qian]

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