Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void makeReservation(int IDofFilm,int IDofCinema,String Wra,String Date ,int thesisK,int thesisS,int thesisH,int thesisR,int ThreeD) throws IOException, Exception
- {
- qh="Select FilmID"
- +" from films"
- +" where FilmID="+IDofFilm;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- if(Servlet0.DatResultSet1.next()==false)
- System.out.println("Nonexistant FilmID \n");
- // rIto();
- else
- {
- qh="Select CinemaID"
- + " from cinemas"
- + " where CinemaID="+IDofCinema;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- if(Servlet0.DatResultSet1.next()==false)
- System.out.println("Nonexistant CinemaID \n");
- else
- {
- qh="Select ProvolhTime"
- +" from provoles"
- +" where ProvolhTime="+Wra+" and Films_FilmID="+IDofFilm+" AND Cinemas_CinemaID="+IDofCinema;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- if(Servlet0.DatResultSet1.next()==false)
- System.out.println("Wrong time requested. \n");
- else
- {
- qh="Select ProvolhDate"
- +" from provoles"
- +" where ProvolhDate="+Date+" and Films_FilmID="+IDofFilm+" AND Cinemas_CinemaID="+IDofCinema;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- if(Servlet0.DatResultSet1.next()==false)
- System.out.println("Wrong date requested \n");
- else{
- d3=1;//ama dn exi zitisi 3d,8a perasi
- if(ThreeD==1)
- {
- qh="Select CinemaIs3D"
- +" from provoles,cinemas"
- +" where Cinemas_CinemaID=CinemaID AND Films_FilmID="+IDofFilm+" AND Cinemas_CinemaID="+IDofCinema+" AND ProvolhTime="+Wra+" AND ProvolhDate="+Date
- +" group by Cinemas_CinemaID";
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- Servlet0.DatResultSet1.next();
- d3=Servlet0.DatResultSet1.getInt("CinemaIs3D");
- if(d3==0)
- System.out.println("No 3D support in the requested projection \n ");
- }
- if(d3==1)
- {
- qh="Select NumberOfReservations"
- +" from provoles"
- +" where Films_FilmID="+IDofFilm+" AND Cinemas_CinemaID="+IDofCinema+" AND ProvolhTime="+Wra+" AND ProvolhDate="+Date;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- Servlet0.DatResultSet1.next();
- total=Servlet0.DatResultSet1.getInt("NumberOfProvoles")-thesisK-thesisS-thesisH-thesisR;
- if (total<0)
- System.out.println("Insufficient Seats left \n");
- else
- {
- fee=(thesisK+thesisS+thesisH+thesisR)*3*ThreeD;
- qh="Select Price"
- +" from provoles,films"
- +" where Films_FilmID=FilmID AND Films_FilmID="+IDofFilm+" AND Cinemas_CinemaID="+IDofCinema+" AND ProvolhTime="+Wra+" AND ProvolhDate="+Date
- +" group by Films_FilmID";
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh);
- Servlet0.DatResultSet1.next();
- feehelp=Servlet0.DatResultSet1.getInt("Price");
- fee=fee+feehelp*(thesisK+thesisS+thesisH+thesisR)-thesisK*2-thesisS-thesisH*3;
- qh2="Select FilmTitle"
- +" from films"
- +" where FilmID="+IDofFilm;
- Servlet0.DatResultSet1=Servlet0.DatStatement.executeQuery(qh2);
- Servlet0.DatResultSet1.next();
- titlehelp=Servlet0.DatResultSet1.getString("FilmTitle");
- qh="Insert into reservations"
- +" Values("
- +" (Select ReservationsID"
- +" from reservations"
- +" order by desc limit 1)+1,"
- +Integer.toString(thesisR+thesisH+thesisK+thesisS)+","session.getAttribute("Name",den3erw)+","+titlehelp+","+Date+","+Wra+","+feehelp+")";
- Servlet0.DatStatement.executeUpdate(qh);
- }
- }}}}}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement