67,513
社区成员
发帖
与我相关
我的任务
分享
//struts
String HQL =
"SELECT s.corp_Name,s.corp_Id,sc2.corp_Name FROM Sys_Corporation s LEFT JOIN Sys_Corporation sc2 " +
"ON s.super_Corp=sc2.corp_Id";
List list = dao.findBySql(HQL);
//hibernate
public List<?> findBySql(String sql) {
List<?> list = null;
try{
session = this.getSession();
list = session.createSQLQuery(sql).list();
}catch(Exception e){
log.error("CommonDAO.findBySql Exception");
}finally{
this.sessionTransactionGc();
}
return list;
}
select fugongsi.corp_name, ziji.corp_name from Sys_Corporation ziji ,Sys_Corporation fugongsi where ziji.super_corp = fugongsi.corp_id ;
SELECT s.corp_Name,s.corp_Id,sc2.corp_Name FROM Sys_Corporation s , Sys_Corporation sc2
where s.super_Corp=sc2.corp_Id
一个简单的条件查询而已。没必要用连接查询。