# ManageSystem

**Repository Path**: pyfGo/manage-system

## Basic Information

- **Project Name**: ManageSystem
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-07-28
- **Last Updated**: 2025-07-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

创建ManageSystem数据库

ALTER TABLE Employee
ADD Salary DECIMAL(18,2);

/* 2. 为现有 10 条员工记录填充随机工资 */
UPDATE Employee SET Salary = 52000.00 WHERE EmployeeId = 1;
UPDATE Employee SET Salary = 63500.50 WHERE EmployeeId = 2;
UPDATE Employee SET Salary = 78000.75 WHERE EmployeeId = 3;
UPDATE Employee SET Salary = 48000.00 WHERE EmployeeId = 4;
UPDATE Employee SET Salary = 91000.25 WHERE EmployeeId = 5;
UPDATE Employee SET Salary = 55000.00 WHERE EmployeeId = 6;
UPDATE Employee SET Salary = 85000.60 WHERE EmployeeId = 7;
UPDATE Employee SET Salary = 72000.90 WHERE EmployeeId = 8;
UPDATE Employee SET Salary = 59000.00 WHERE EmployeeId = 9;
UPDATE Employee SET Salary = 68000.40 WHERE EmployeeId = 10;



-- =========  SQL Server 建表脚本  =========
-- 1. 登录表 (Login)
CREATE TABLE Login (
LoginId  INT IDENTITY(1,1) PRIMARY KEY,
UserName VARCHAR(50)  NOT NULL UNIQUE,
PassW    VARCHAR(64)  NOT NULL
);
-- 2. 部门表 (Department)
CREATE TABLE Department (
DepartmentId   INT IDENTITY(1,1) PRIMARY KEY,
DepartmentName VARCHAR(100) NOT NULL
);
-- 3. 员工表 (Employee)
CREATE TABLE Employee (
EmployeeId   INT IDENTITY(1,1) PRIMARY KEY,
Name         VARCHAR(100) NOT NULL,
Address      VARCHAR(255),
DepartmentId INT,
Phone        VARCHAR(20),
CONSTRAINT FK_Employee_Department FOREIGN KEY (DepartmentId) REFERENCES Department(DepartmentId)
);
-- =========  初始化数据脚本  =========
-- 插入 10 条部门记录
SET IDENTITY_INSERT Department ON;
INSERT INTO Department (DepartmentId, DepartmentName) VALUES
(1, 'Human Resources'),
(2, 'Finance'),
(3, 'IT'),
(4, 'Marketing'),
(5, 'Operations'),
(6, 'Sales'),
(7, 'Legal'),
(8, 'Research'),
(9, 'Customer Support'),
(10, 'Quality Assurance');
SET IDENTITY_INSERT Department OFF;
-- 插入 10 条员工记录
SET IDENTITY_INSERT Employee ON;
INSERT INTO Employee (EmployeeId, Name, Address, DepartmentId, Phone) VALUES
(1, 'Alice Johnson', '123 Maple Street, Springfield', 1, '555-0101'),
(2, 'Bob Smith', '45 Oak Avenue, Metropolis', 2, '555-0102'),
(3, 'Carol White', '678 Pine Road, Gotham', 3, '555-0103'),
(4, 'David Brown', '9 Elm Lane, Star City', 4, '555-0104'),
(5, 'Eva Green', '321 Birch Drive, Central', 5, '555-0105'),
(6, 'Frank Black', '654 Cedar Court, Coast', 6, '555-0106'),
(7, 'Grace Lee', '987 Willow Way, Keystone', 7, '555-0107'),
(8, 'Henry Adams', '147 Spruce Street, Opal', 8, '555-0108'),
(9, 'Ivy Turner', '258 Ash Boulevard, Blüdhaven', 9, '555-0109'),
(10, 'Jack Wilson', '369 Poplar Place, Fawcett', 10, '555-0110');
SET IDENTITY_INSERT Employee OFF;
-- 插入 10 条登录记录
SET IDENTITY_INSERT Login ON;
INSERT INTO Login (LoginId, UserName, PassW) VALUES
(1, 'alice', 'P@ssw0rd1'),
(2, 'bob', 'P@ssw0rd2'),
(3, 'carol', 'P@ssw0rd3'),
(4, 'david', 'P@ssw0rd4'),
(5, 'eva', 'P@ssw0rd5'),
(6, 'frank', 'P@ssw0rd6'),
(7, 'grace', 'P@ssw0rd7'),
(8, 'henry', 'P@ssw0rd8'),
(9, 'ivy', 'P@ssw0rd9'),
(10, 'jack', 'P@ssw0rd0');
SET IDENTITY_INSERT Login OFF;





演示视频地址
https://www.bilibili.com/video/BV11v8QzLEMv/?spm_id_from=333.1387.upload.video_card.click&vd_source=e0c19bf0ef7f6b2f7e5168007b80b232

![alt text](image.png)


![alt text](image-1.png)


![alt text](image-2.png)


![alt text](image-3.png)