如何显示数据库中的数据 [英] how to display the data from database

问题描述

我正在做员工档案管理的迷你项目..我想按层次顺序显示员工..我在数据库中有每个员工的负责人..如何显示:( :(

请帮帮我...





显示应该是这样的...

< br $>


CEO：名字

项目：名称

项目负责人：姓名

项目成员：1。

2.

PROJECT2：名称

项目负责人：姓名

项目成员：1。

2.

PROJECT3：名称

项目负责人：姓名

项目成员：1。

2.







请帮我这样做:(：（

I am doing mini project on employee profile management.. I want to display the employee in hierarchical order.. i have the head of each employee in database.. how to display that :( :(
please help me...


The display should be like this...


CEO:name
PROJECT: name
PROJECT LEADER:name
PROJECT MEMBERS: 1.
2.
PROJECT2: name
PROJECT LEADER:name
PROJECT MEMBERS: 1.
2.
PROJECT3: name
PROJECT LEADER:name
PROJECT MEMBERS: 1.
2.



please help me to do this :( :(

推荐答案

Hi Thenmozhi



查看下面的示例并逐步执行。您可以得到一个想法：



这个打击还显示了喜欢的雇员的详细信息erarchical：

Hi Thenmozhi

Look into the below example and execute step by step. you could get an idea:

The blow also display details of employes in hierarchical:

CREATE TABLE #MyEmployees
(
	EmployeeID smallint NOT NULL,
	FirstName nvarchar(30)  NOT NULL,
	LastName  nvarchar(40) NOT NULL,
	Title nvarchar(50) NOT NULL,
	DeptID smallint NOT NULL,
	ManagerID int NULL,
 CONSTRAINT PK_EmployeeID PRIMARY KEY CLUSTERED (EmployeeID ASC) 
);
INSERT INTO #MyEmployees VALUES 
 (1, N''Ken'', N''Sánchez'', N''Chief Executive Officer'',16,NULL)
,(273, N''Brian'', N''Welcker'', N''Vice President of Sales'',3,1)
,(274, N''Stephen'', N''Jiang'', N''North American Sales Manager'',3,273)
,(275, N''Michael'', N''Blythe'', N''Sales Representative'',3,274)
,(276, N''Linda'', N''Mitchell'', N''Sales Representative'',3,274)
,(285, N''Syed'', N''Abbas'', N''Pacific Sales Manager'',3,273)
,(286, N''Lynn'', N''Tsoflias'', N''Sales Representative'',3,285)
,(16,  N''David'',N''Bradley'', N''Marketing Manager'', 4, 273)
,(23,  N''Mary'', N''Gibson'', N''Marketing Specialist'', 4, 16);

--ORIGINAL TABLE
SELECT * FROM #MyEmployees;

WITH DirectReports(ManagerID, EmployeeID, Title, EmployeeLevel) AS 
(
    SELECT ManagerID, EmployeeID, Title, 0 AS EmployeeLevel
    FROM #MyEmployees 
    WHERE ManagerID IS NULL
    UNION ALL
    SELECT e.ManagerID, e.EmployeeID, e.Title, EmployeeLevel + 1
    FROM #MyEmployees AS e
        INNER JOIN DirectReports AS d
        ON e.ManagerID = d.EmployeeID 
)
--HIERARCHY
SELECT ManagerID, EmployeeID, Title, EmployeeLevel 
FROM DirectReports
ORDER BY ManagerID;

DROP TABLE #MyEmployees

问候

Willington

Regards
Willington

这篇关于如何显示数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！