Question

SQL转换HQL

select * from
(select * from opermonthlyhostkz bd order by to_date(bd.filetime,'yyyy-MM-dd') desc)
where rownum <= 5
以上SQL转换为HQL OperMonthlyKzDo 是对象名字

Answer 1

FROM pa_cons_mngt_cost pcmc , sa_sys_period sp , a ,SA_WORK_GRP wg ,loc
WHERE pcmc.charging_wk_grp_id = wg.wk_grp_id
AND pcmc.FROM_LOC_ID = loc.loc_id
AND pcmc.gc_cost_subtype_cd<>'-1'
AND pcmc.bu_id = wg.bu_id
AND sp.bu_id = pcmc.bu_id
AND buIdFilter
AND wg.OU_ID=a.childid
AND pcmc.gc_cost_type_cd IN ('O')
AND pcmc.txn_period_id = sp.sys_period_id
AND compose_date (sp.sys_period_year , sp.sys_period_month , 1)
BETWEEN compose_date ( :year , :fromMonth , 1)
AND compose_date ( :toYear , :toMonth , 1)

)
GROUP BY costtype , ou_id ,ou_cd
ORDER BY ou_id , costtype ]]>

Answer 2

这两者的区别不是很大 很多地方都是相同的，而且hql操作的是对象，感觉功能上比sql更加强大 从网下一个关于hql语法的文档 十几页，看一下就明白了，希望对你有用

Answer 3

use linklist to maintain Queue and Stack. such that project could be run as follows:
1 menu:1--Queue
2--stack
3--EXIT
2 please input the file number
3 please input the insert data
4 please inout the deleted data
5 printout all data in the struct

Answer 4

你把对象里的属性都列出来，要不怎么给你转啊