External_java

/*
 * 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);
        }

    }

}