javaweb期末课程设计大作业自助售票系统源码+数据库.zip

create database tickets character set utf8; use tickets; //ticket表 CREATE TABLE `ticket` ( `id` int NOT NULL, `name` varchar(255) DEFAULT NULL, `ename` varchar(255) DEFAULT NULL, `fare` int DEFAULT NULL, `distance` int DEFAULT NULL, `quantity` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; //record表 CREATE TABLE `record` ( `rid` int auto_increment, `id` int NOT NULL, `createTime` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`rid`), FOREIGN KEY (`id`) REFERENCES ticket(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; //初始数据 insert into ticket values (0,'莆田','Henghua',200,13,33); insert into ticket values (1,'厦门','Amoy',345,26,30); insert into ticket values (2,'泉州','Zayton',446,34,28); insert into ticket values (3,'南平','Nanping',557,46,26); insert into ticket values (4,'福州','Foochow',670,53,22); insert into record (id) values (0); insert into record (id) values(3); //连表查询 select r.rid,t.id,t.name,t.fare from ticket t,record r where t.id=r.id;