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') )