Cineplex management system project in java swing
Download as PPTX, PDF
0 likes335 views
1. Cineplex Management System is a project that allows admin, managers, and users to manage movie showtimes, tickets, and comments through a website or app interface. 2. The project includes ER diagrams of the backend database tables, examples of SQL queries for tasks like user login and movie information insertion, and descriptions of features like image uploading and text searching. 3. Future planned improvements include more advanced interfaces, seat selection functionality for users, and incorporating artificial intelligence.
![SQLs
Select:
o SELECT manageremail, managerpass
FROM managerlog
WHERE manageremail=? and managerpass=?;
Insert:
o INSERT into movieinfo
(MovieId,Moviename,Showtime,Date,TypeO
fMovie,Type,Price,VAT,Image,HallNo,TotalSea
t) values(?,?,?,?,?,?,?,?,?,?,?);
Query for Searching:
o String[] columnName =
{"MovieId","Moviename","Showtime","Date","TypeOfMovie","Type",
"Price","VAT","Image","HallNo","TotalSeat"};](https://image.slidesharecdn.com/cineplexmanagementsystem-180412151949/85/Cineplex-management-system-project-in-java-swing-7-320.jpg)
Cineplex management system project in java swing
- 1. Cineplex Management System Presented By: Mountain Movers Fowjael Ahamed Rakib Hossain Abu Kaiser Mohammad Masum Md. Ashraful Islam Talukder
- 2. Introduction o Project summary o Buttons and options o ER diagram o Tables of Database o SQLs o New learnt things through this project o Video flow of the project o Future works and Conclusion
- 3. Project Summary Cineplex Management System Admin Counter User
- 5. ER diagram
- 6. Tables of Database Admincreate (Adminname,Adminmail,Adminpassword,Gender,Verification) Comment(moviename,comment) Control(movieid,Totalreceive) Managerlog(managerfirstname,managerlastname,manageremail, managerpass,managergender) Movieinfo(MovieId,Moviename,Showtime,Date,TypeOfMovie, Type,Price,Vat,Image,HallNo,TotalSeat) Newmovie(NewMovieName,ReleaseDate,NewMovieImage, NewMovieType) Rank(Topmovie,PositiveReview,NegativeReview, Totalcomment) Ticketbook(reqname,reqaddress,mobilenumber,payment, accountnumber,amount,requestmovieid) Usercreate(username,useremail,userpassword,usermobile, usergender)
- 7. SQLs Select: o SELECT manageremail, managerpass FROM managerlog WHERE manageremail=? and managerpass=?; Insert: o INSERT into movieinfo (MovieId,Moviename,Showtime,Date,TypeO fMovie,Type,Price,VAT,Image,HallNo,TotalSea t) values(?,?,?,?,?,?,?,?,?,?,?); Query for Searching: o String[] columnName = {"MovieId","Moviename","Showtime","Date","TypeOfMovie","Type", "Price","VAT","Image","HallNo","TotalSeat"};
- 8. New learnt things through this project Attach and Store image in Database Short way of searching Jtable Store database value in file system Read and count word from file system Printing document
- 9. Video flow of the project
- 10. Future works More cool interface Works on some subtle things Let the admin do more control Let the user choose their seat Auto calculation and searching Artificial intelligences work Make this app more convenient to use on different platform