employees
,其中包含员工的ID和上级的ID,你可以使用以下查询来找到某个员工的上级:,,``sql,WITH RECURSIVE EmployeeHierarchy AS (, SELECT employee_id, manager_id, FROM employees, WHERE employee_id = ? 替换为你要查询的员工ID, UNION ALL, SELECT e.employee_id, e.manager_id, FROM employees e, INNER JOIN EmployeeHierarchy eh ON e.employee_id = eh.manager_id,),SELECT * FROM EmployeeHierarchy;,
``,,这个查询会返回从指定员工到最高级的上级的所有层级关系。java,Session session = HibernateUtil.getSessionFactory().openSession();,String hql = "FROM Employee WHERE department = :dept";,Query query = session.createQuery(hql);,query.setParameter("dept", "Sales");,List employees = query.list();,session.close();,
``Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.