首页上一页 1 下一页尾页 6 条记录 1/1页
急等!!谢谢
发表在Java图书答疑
2010-06-03
是否精华
是
否
版块置顶:
是
否
设置时间:
非永久
永久
起始时间:
结束时间:
是否扣分:
是
否
《java项目开发全程实录》第3章企业人事管理系统里添加了考勤信息,在报表中却没有体现是什么问题
精彩评论 6
2010-06-04
地板
where
this.tbAccountItem.name='迟到'
and (
(
startDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
or endDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
)
or (
to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
and to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
)
) */ select
tbtimecard0_.id as id10_,
tbtimecard0_.ratifier_dept_id as ratifier2_10_,
tbtimecard0_.record_id as record3_10_,
tbtimecard0_.ratifier_record_id as ratifier4_10_,
tbtimecard0_.account_item_id as account5_10_,
tbtimecard0_.explain as explain10_,
tbtimecard0_.start_date as start7_10_,
tbtimecard0_.end_date as end8_10_,
tbtimecard0_.ratifier_date as ratifier9_10_
from
tb_timecard tbtimecard0_,
tb_account_item tbaccounti1_
where
tbtimecard0_.record_id = ?
and tbtimecard0_.account_item_id=tbaccounti1_.id
and tbaccounti1_.name='迟到'
and (
tbtimecard0_.start_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or tbtimecard0_.end_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
and (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
)
这是点击生成报表时控制台生成的一段代码,问题是不是出在tbtimecard0_.record_id = ? 上啊
this.tbAccountItem.name='迟到'
and (
(
startDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
or endDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
)
or (
to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
and to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
)
) */ select
tbtimecard0_.id as id10_,
tbtimecard0_.ratifier_dept_id as ratifier2_10_,
tbtimecard0_.record_id as record3_10_,
tbtimecard0_.ratifier_record_id as ratifier4_10_,
tbtimecard0_.account_item_id as account5_10_,
tbtimecard0_.explain as explain10_,
tbtimecard0_.start_date as start7_10_,
tbtimecard0_.end_date as end8_10_,
tbtimecard0_.ratifier_date as ratifier9_10_
from
tb_timecard tbtimecard0_,
tb_account_item tbaccounti1_
where
tbtimecard0_.record_id = ?
and tbtimecard0_.account_item_id=tbaccounti1_.id
and tbaccounti1_.name='迟到'
and (
tbtimecard0_.start_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or tbtimecard0_.end_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
and (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
)
这是点击生成报表时控制台生成的一段代码,问题是不是出在tbtimecard0_.record_id = ? 上啊