hibernate 中得子查询,怎么修改(多对一得关系)。请高手看看,谢谢!

 所属目录:Java   |   类型:技术问答   |   时间:2007-05-21
 问题:

下面得sql语句要是在hibernate中怎么写啊!是多对一得关系.  
   
  select    
  (select   emp.smpalias   from   emp_employee   emp   where   emp.id   =   grade.eval_employee)   as   a,    
  grade.is_finished,    
  grade.total_point,    
  grade.createtime,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.people_relation_id)   as   people_relation,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.manage_knowledge_id)   as   manage_knowledge,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.specialty_knowledge_id)   as   specialty_knowledge,    
  grade.knowledge_ability_point,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.think_level_id)   as   think_level,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.think_environment_id)   as   think_environment,    
  grade.solvable_question_point,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.jobduty_grand_id)   as   jobduty,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.job_aftereffect_grandid)   as   job_aftereffect,    
  (select   sub.smpalias   from   pos_eval_subelementgrade   sub   where   sub.id=grade.actionfreedom_grandid)   as   actionfreedom,    
  grade.takeon_duty_point,    
  grade.job_point  
  from   pos_eval_grade   grade  
 

· 网友精彩回答:

发表者:zjjsgwm

晕晕晕,不过总算像是明白了。  
  pos_eval_grade    
  emp_employee    
  pos_eval_subelementgrade    
  三个表,  
  你要在pos_eval_grade中把字段对应其他二个表的字段.  
  比如actionfreedom_grandid你就把它映射成many-to-one对应pos_eval_subelementgrade表,其他都相同

发表者:wwwtom

做个视图,不就是一个简单的查询了吗!

.
处理 SSI 文件时出错
© 2006-2008 All Rights Reserved