数据库系统原理课程设计实验（java模拟DBMS）

create-table create-index操作完成（B+树索引） use操作完成 show操作完成 insert操作完成， alter-add alter-drop操作完成 update操作完成 delete操作完成 select操作完成，支持多表自然连接(哈希连接)，多表笛卡尔积（构造哈夫曼树） drop操作完成 exit退出 分号代表一条命令结束 支持唯一性和非空性约束 CREATE DATABASE test1; USE DATABASE test1; SHOW TABLES; CREATE TABLE person(name VARCHAR(12) PRIMARY KEY, age INTEGER NOT NULL, sex VARCHAR(4)); INSERT INTO person VALUES("宋江", 117, "男"); INSERT INTO person VALUES("扈三娘", 111, "女"); INSERT INTO person VALUES("爱新觉罗释迦牟尼尼古拉斯赵四", 115, "男"); INSERT INTO person VALUES("关胜", 113, "男"); INSERT INTO person VALUES("林冲", 109, "男"); UPDATE person SET name="林冲" WHERE person.name="宋江"; CREATE TABLE employee(name VARCHAR(12), ssn VARCHAR(22), country VARCHAR(10), sex VARCHAR(8)); INSERT INTO employee VALUES("宋江", "370783190000000000", "中国", "男"); INSERT INTO employee VALUES("吴用", "370783190200000000", "中国", "男"); INSERT INTO employee VALUES("关胜", "370783190400000000", "中国", "男"); INSERT INTO employee VALUES("扈三娘", "370783190600000000", "中国", "女"); INSERT INTO employee VALUES("林冲", "370783190800000000", "中国", "男"); SELECT * FROM employee; ALTER TABLE employee ADD department VARCHAR(12); INSERT INTO employee VALUES("麦当娜", "370783190100000000", "USA", "女", "LivaNation"); ALTER TABLE employee DROP department; ALTER TABLE employee DROP ssn, country; UPDATE employee SET department="忠义堂" WHERE employee.name="宋江"; UPDATE employee SET country="CN" WHERE employee.country="中国"; UPDATE employee SET country="美国", sex="woman" WHERE employee.country="USA" AND employee.sex="女"; UPDATE employee SET country="中国" WHERE employee.country="CN" AND employee.sex="女" OR employee.name="宋江" AND employee.country="CN"; DELETE FROM employee WHERE employee.name="林冲"; DELETE FROM employee WHERE employee.sex="woman" AND employee.country="美国" OR employee.sex="女" AND employee.country="中国"; DELETE FROM employee; CREATE TABLE salary(name VARCHAR(24), department VARCHAR(12), salary INTEGER); INSERT INTO salary VALUES("宋江", "忠义堂", 6000); INSERT INTO salary VALUES("扈三娘", "忠义堂", 7000); INSERT INTO salary VALUES("吴用", "忠义堂", 6000); INSERT INTO salary VALUES("关胜", "忠义堂", 5000); INSERT INTO salary VALUES("林冲", "忠义堂", 4000); INSERT INTO salary VALUES("超人", "忠义堂", 10000); INSERT INTO salary VALUES("贝拉克·侯赛因·奥巴马", "民主党", 8000); INSERT INTO salary VALUES("如来", "西天", 100); SELECT * FROM salary; DELETE FROM salary; DELETE FROM salary WHERE salary.name="超人"; DELETE FROM salary WHERE salary.salary<7000; SELECT * FROM employee, person, salary; SELECT person.name, person.age, employee.country, employee.sex FROM person, employee, salary WHERE salary.name=employee.name AND person.name=employee.name AND salary.salary>5500; SELECT person.name, salary.department FROM person, salary WHERE person.name=salary.name AND salary.salary>5500 OR person.name=salary.name AND salary.name="林冲"; DROP TABLE salary; USE DATABASE test1; CREATE TABLE unrepatedIndex(name VARCHAR(24), age INTEGER); CREATE TABLE index1(name VARCHAR(24), age INTEGER); CREATE INDEX unrepatedIndex_index ON person age; CREATE INDEX unrepatedIndex_index ON salary age; CREATE INDEX index1_index1 ON index1 age; CREATE INDEX index1_index2 ON index1 name; DROP INDEX index1_index1 ON index1; SELECT person.name FROM person WHERE person.age>150000; SELECT salary.name FROM salary WHERE salary.age>50; SELECT person.name, salary.name FROM person, salary WHERE person.age>240000 AND salary.age>90; SELECT index1.name FROM index1 WHERE index1.age>10000; SELECT * FROM index1 WHERE index1.name="泒袀崃" OR index1.age>10000; //退出 EXIT;