Cineplex management system project in java swing

Cineplex Management
System
Presented By: Mountain Movers
Fowjael Ahamed
Rakib Hossain
Abu Kaiser Mohammad Masum
Md. Ashraful Islam Talukder

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

Project Summary
Cineplex Management System
Admin Counter User

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)

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"};

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

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 intelligence’s work
 Make this app more convenient to use on
different platform

Cineplex management system project in java swing

Cineplex management system project in java swing

Recommended

Recommended

More Related Content

More from Abu Kaisar

More from Abu Kaisar (15)

Recently uploaded

Recently uploaded (20)

Cineplex management system project in java swing