Oracle课程设计之电影售票系统(后台)

这学期的Oracle课程设计我也做的差不多了,这里就和大家分享一下了,希望共同进步,加油!因为前台用户界面做的有点丑,这里就不展示了,仅展示后台管理员部分,前端模板大家也可以套用,代码已经上传到GitHub上,链接为https://github.com/229394/filmsystem

首先介绍一下项目用到的技术吧,后端框架是SpringBoot,数据库持久层框架是Mybatis,前端是Vue.js+Element UI,数据库是Oracle。

好了,接下来就进行效果截图演示了,如下所示。

(1)管理员登录界面

(2)用户信息列表界面

(3)影片列表界面

  • 6
    点赞
  • 25
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
Connect scott/****@myoracle AS SYSDBA create USER goupiaoXT IDENTIFIED BY passward DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; grant connect to goupiaoXT; grant resource to goupiaoXT; connect goupiaoXT/passward; CREATE TABLE YINGPIAN ( YPID NUMBER NOT NULL Primary Key, YPNAME VARCHAR(50) ); CREATE TABLE YINGTING ( YTID NUMBER NOT NULL Primary Key, YTNAME VARCHAR(8), HANG NUMBER, LIE NUMBER ); CREATE TABLE HUIYUAN ( HYID NUMBER NOT NULL Primary Key, HYNAME VARCHAR(8), JINE VARCHAR(15), PASSWORD VARCHAR(20) ); CREATE TABLE PIAO ( PID NUMBER NOT NULL Primary Key, LEIXING VARCHAR(8), PRICE VARCHAR(4) ); CREATE TABLE FANGYING ( FYID NUMBER NOT NULL, YPIDO NUMBER NOT NULL REFERENCES YINGPIAN(YPID), YTIDO NUMBER NOT NULL REFERENCES YINGTING(YTID), FYDATE DATE NOT NULL, FYTIME DATE NOT NULL, Primary Key(FYID) ); CREATE TABLE ZWYD ( ZWYDID NUMBER NOT NULL PRIMARY KEY, FYIDO NUMBER NOT NULL REFERENCES FANGYING (FYID), ZWZHT VARCHAR(20) , HYIDO NUMBER REFERENCES HUIYUAN (HYID), PIDO NUMBER REFERENCES PIAO (PID), HANG NUMBER, LIE NUMBER, ZT NUMBER ); create sequence seqZWYDId increment by 1 start with 1 cache 10 ; create or replace trigger ZWYDTRI after insert on FANGYING for each row declare TMPHANG NUMBER; TMPLIE NUMBER; i NUMBER :=1; j NUMBER :=1; begin select HANG,LIE into TMPHANG,TMPLIE from YINGTING where YTID =:NEW.YTIDO; for i in 1..TMPHANG loop for j in 1..TMPLIE loop insert into ZWYD(ZWYDID,FYIDO,HANG,LIE,ZT) values(seqZWYDId.nextval,:new.FYID,i,j,0); end loop; end loop; end ZWYDTRI; / insert into HUIYUAN values(2004322888,'123456','500'); insert into HUIYUAN values(2004322889,'123456','400'); insert into HUIYUAN values(2004322898,'123456','300'); insert into YINGTING values(100,'大厅',10,10); insert into YINGTING values(101,'一号厅',4,5); insert into YINGTING values(102,'二号厅',6,8); insert into YINGPIAN values(10001,'《梅兰芳》'); insert into YINGPIAN values(10002,'《拯救飓风》'); insert into YINGPIAN values(10003,'《画皮》'); insert into HUIYUAN values(1,'he','2000','123456'); insert into HUIYUAN values(2,'lei','50','12345'); insert into HUIYUAN values(3,'helei','405','1234567'); insert into PIAO values(0,'普通票','65'); insert into PIAO values(1,'团体票','35'); insert into PIAO values(2,'学生票','30'); insert into FANGYING values(100001,10001,100,to_date('08-10-10','yy-mm-dd'),to_date('08-10-10 8:20','yy-mm-dd hh24:mi')); insert into FANGYING values(100002,10001,101,to_date('08-10-10','yy-mm-dd'),to_date('08-10-12 9:20','yy-mm-dd hh24:mi')); insert into FANGYING values(100003,10001,102,to_date('08-10-12','yy-mm-dd'),to_date('08-10-13 12:20','yy-mm-dd hh24:mi')); insert into FANGYING values(100004,10001,101,to_date('08-10-12','yy-mm-dd'),to_date('08-10-12 6:20','yy-mm-dd hh24:mi')); insert into FANGYING values(100005,10002,102,to_date('08-10-13','yy-mm-dd'),to_date('08-10-13 20:20','yy-mm-dd hh24:mi')); insert into FANGYING values(100006,10003,101,to_date('08-10-12','yy-mm-dd'),to_date('08-10-12 9:20','yy-mm-dd hh24:mi'));

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值