Ibatis 查询语句配置 (语句已有，求解怎么配到xml里面)
以下查询语句怎么写到 Ibatis 的xml 文件里面去了，小白不怎么懂 Ibatis ；

语句查询结果是返回 查询到的一条实体数据，其中user_id ='40281f81432228ac0143226895cb0008' 这个是通过实体传过去的

select * from S_SALE_CHRONICLE 
       where  sts='Y' 
       and user_id ='40281f81432228ac0143226895cb0008' 
       and to_date = decode(
           (select count(1) from 
                   (SELECT * FROM S_SALE_CHRONICLE 
                   WHERE user_id ='40281f81432228ac0143226895cb0008
                   'and sts='Y') 
                   where S_SALE_CHRONICLE.to_date = to_date(to_char(sysdate,'yyyy/mm/dd'), 'yyyy/mm/dd')),0,
           (select min(to_date)from 
                   (SELECT * FROM S_SALE_CHRONICLE
                    WHERE user_id ='40281f81432228ac0143226895cb0008' 
                    and sts='Y') 
                   where S_SALE_CHRONICLE.to_date > to_date(to_char(sysdate,'yyyy/mm/dd'), 'yyyy/mm/dd')),
                    to_date(to_char(sysdate,'yyyy/mm/dd'), 'yyyy/mm/dd')  ) 

[解决办法]
这个应该很简单，xml映射，可以参考下http://sarin.iteye.com/blog/1667161