/* * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Main.java to edit this template */ package movie; import java.util.*; import java.sql.*; /** * * @author devan */ public class Movie { /** * @param args the command line arguments */ static class Daemon extends Thread{ @Override public void run(){ Connection con=null; Statement s=null; ResultSet r=null; try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db?", "root", ""); s = con.createStatement(); String str = "SELECT name FROM movie ORDER BY rating DESC LIMIT 1"; r = s.executeQuery(str); while (r.next()) { String name = r.getString("name"); System.out.println("name: " + name); } } catch (SQLException se) { System.out.println("Error: "+se); } } } public static void main(String[] args) throws ClassNotFoundException, SQLException { // TODO code application logic here try { Class.forName("com.mysql.cj.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/exam", "root", ""); Daemon d = new Daemon(); Scanner sc = new Scanner(System.in); Statement s = con.createStatement(); String M_name, type, date; int duration, rating, mid, showtime, price, c = 0, qty, total; int ch = 0; do { System.out.println(""" ==================== Enter Your Choice: 1.Add Movide Data 2.Add Ticket Booking 3.Highest rating 4.Exit ====================="""); ch = sc.nextInt(); sc.nextLine(); switch (ch) { case 1: do { System.out.println(""" ==================== Enter Your Choice: 1.Add 2.Display 3.Edit 4.delete 5.exit ===================="""); c = sc.nextInt(); switch (c) { case 1: System.out.println("Enter Movie Name:"); M_name = sc.next(); System.out.println("Enter Movie Duration:"); duration = sc.nextInt(); System.out.println("Enter Movie MOvie Type:"); type = sc.next(); System.out.println("Enter Movie Rating:"); rating = sc.nextInt(); String sql = "INSERT INTO `movietbl` (`mid`, `m_name`, `duration`, `type`, `rating`) VALUES (NULL, '" + M_name + "', " + duration + ", '" + type + "', " + rating + ")"; s.executeUpdate(sql); break; case 2: ResultSet r = s.executeQuery("SELECT * FROM movietbl"); System.out.println("MovieId\tMovieName\tDuration\tType\tRating"); while (r.next()) { mid = r.getInt("mid"); M_name = r.getString("m_name"); duration = r.getInt("duration"); type = r.getString("type"); rating = r.getInt("rating"); System.out.println(mid + "\t" + M_name + "\t\t" + duration + "\t\t" + type + "\t" + rating); } break; case 3: System.out.println("Enter Movie Id:"); mid = sc.nextInt(); r = s.executeQuery("SELECT * FROM movietbl where mid=" + mid); System.out.println("MovieId\tMovieName\tDuration\tType\tRating"); while (r.next()) { mid = r.getInt("mid"); M_name = r.getString("m_name"); duration = r.getInt("duration"); type = r.getString("type"); rating = r.getInt("rating"); System.out.println(mid + "\t" + M_name + "\t\t" + duration + "\t\t" + type + "\t" + rating); } System.out.println("Enter Movie Name:"); M_name = sc.next(); System.out.println("Enter Movie Duration:"); duration = sc.nextInt(); System.out.println("Enter Movie MOvie Type:"); type = sc.next(); System.out.println("Enter Movie Rating:"); rating = sc.nextInt(); sql = "UPDATE `movietbl` SET `m_name`='" + M_name + "',`duration`='" + duration + "',`type`='" + type + "',`rating`='" + rating + "' WHERE mid=" + mid; s.executeUpdate(sql); break; case 4: System.out.println("Enter id you want to Delete:"); mid = sc.nextInt(); sql = "delete from movietbl where mid=" + mid; s.executeUpdate(sql); r = s.executeQuery("SELECT * FROM movietbl"); System.out.println("MovieId\tMovieName\tDuration\tType\tRating"); while (r.next()) { mid = r.getInt("mid"); M_name = r.getString("m_name"); duration = r.getInt("duration"); type = r.getString("type"); rating = r.getInt("rating"); System.out.println(mid + "\t" + M_name + "\t\t" + duration + "\t\t" + type + "\t" + rating); } break; } } while (c != 5); break; case 2: do { System.out.println(""" ==================== Enter Your Choice: 1.Add 2.Display 3.Delete 4.Edit 5.exit ===================="""); c = sc.nextInt(); switch (c) { case 1: System.out.println("Enter Movie Id:"); mid = sc.nextInt(); System.out.println("Enter Movie Show Time:"); showtime = sc.nextInt(); System.out.println("Enter Movie Date:"); date = sc.next(); System.out.println("Enter Movie Price:"); price = sc.nextInt(); System.out.println("Enter Movie Qty:"); qty = sc.nextInt(); total = price * qty; String sql = "INSERT INTO `booking` (`tid`, `mid`, `showtime`, `date`, `price`,`qty`,`total`) VALUES (NULL, '" + mid + "', '" + showtime + "', '" + date + "', '" + price + "','" + qty + "','" + total + "')"; s.executeUpdate(sql); break; case 2: ResultSet r = s.executeQuery("SELECT * FROM booking"); System.out.println("TicketId\tMovieId\tShowTime\tDate\t\tPrice\tqty\ttotal"); while (r.next()) { int tid = r.getInt("tid"); mid = r.getInt("mid"); showtime = r.getInt("showtime"); date = r.getString("date"); price = r.getInt("price"); qty = r.getInt("qty"); total = r.getInt("total"); System.out.println(tid + "\t\t" + mid + "\t" + showtime + "\t\t" + date + "\t" + price + "\t" + qty + "\t" + total+"\n"); } break; case 3: System.out.println("Enter id you want to Delete:"); int tid = sc.nextInt(); sql = "delete from booking where tid=" + tid; s.executeUpdate(sql); r = s.executeQuery("SELECT * FROM booking"); System.out.println("TicketId\tMovieId\tShowTime\tDate\t\tPrice"); while (r.next()) { tid = r.getInt("tid"); mid = r.getInt("mid"); showtime = r.getInt("showtime"); date = r.getString("date"); price = r.getInt("price"); System.out.println(tid + "\t\t" + mid + "\t" + showtime + "\t\t" + date + "\t" + price+"\n"); } break; case 4: System.out.println("Enter Movie TicketId:"); tid = sc.nextInt(); r = s.executeQuery("SELECT * FROM booking where tid=" + tid); System.out.println("TicketId\tMovieId\tShowTime\tDate\t\tPrice\tqty\ttotal"); while (r.next()) { tid = r.getInt("tid"); mid = r.getInt("mid"); showtime = r.getInt("showtime"); date = r.getString("date"); price = r.getInt("price"); qty = r.getInt("qty"); total = r.getInt("total"); System.out.println(tid + "\t\t" + mid + "\t" + showtime + "\t\t" + date + "\t" + price + "\t" + qty + "\t" + total+"\n"); } System.out.println("Enter Movie Id:"); mid = sc.nextInt(); System.out.println("Enter Movie Show Time:"); showtime = sc.nextInt(); System.out.println("Enter Movie Date:"); date = sc.next(); System.out.println("Enter Movie Price:"); price = sc.nextInt(); System.out.println("Enter Movie Qty:"); qty = sc.nextInt(); total = price * qty; sql = "UPDATE `booking` SET `mid`='" + mid + "',`showtime`='" + showtime + "',`date`='" + date + "',`price`='" + price + "',`qty`='" + qty + "',`total`='" + total + "' WHERE tid=" + tid+"\n"; s.executeUpdate(sql); break; } } while (c != 5); break; case 3: d.start(); break; } } while (ch != 4); } catch (SQLException s) { System.out.println("Error" + s); } } }