火车订单管理系统sql语言代码
时间: 2023-12-13 10:00:17 浏览: 32
火车订单管理系统的SQL语言代码主要包括以下几类:
1. 创建表:
CREATE TABLE Train (
train_id INT PRIMARY KEY,
train_name VARCHAR(50) NOT NULL,
train_type VARCHAR(20) NOT NULL
);
CREATE TABLE Passenger (
passenger_id INT PRIMARY KEY,
passenger_name VARCHAR(50) NOT NULL,
passenger_phone VARCHAR(20) NOT NULL
);
CREATE TABLE Ticket (
ticket_id INT PRIMARY KEY,
train_id INT NOT NULL,
passenger_id INT NOT NULL,
seat_number INT,
ticket_date DATE,
FOREIGN KEY (train_id) REFERENCES Train(train_id),
FOREIGN KEY (passenger_id) REFERENCES Passenger(passenger_id)
);
2. 插入数据:
INSERT INTO Train (train_id, train_name, train_type)
VALUES (1, '动车', '高铁');
INSERT INTO Passenger (passenger_id, passenger_name, passenger_phone)
VALUES (1, '张三', '13800000001');
INSERT INTO Ticket (ticket_id, train_id, passenger_id, seat_number, ticket_date)
VALUES (1, 1, 1, 12, '2022-01-01');
3. 查询数据:
SELECT * FROM Train;
SELECT * FROM Passenger;
SELECT * FROM Ticket;
4. 更新数据:
UPDATE Train
SET train_name = '动车'
WHERE train_id = 1;
UPDATE Passenger
SET passenger_phone = '13800000002'
WHERE passenger_id = 1;
5. 删除数据:
DELETE FROM Ticket
WHERE ticket_id = 1;
DELETE FROM Passenger
WHERE passenger_id = 1;
以上是一个简单的火车订单管理系统的SQL语言代码示例,可以基于此进行进一步的开发和优化,以满足具体业务需求。