program that simulates a bus ticket booking system:

 Write a program to save the database and make a bus ticket for passengers with travel date time and seat no amount of ticket paid having information of number of adults childrens and senior citizens on the tickets

Here's a simple Java program that simulates a bus ticket booking system:

```

import java.time.LocalDate;

import java.time.LocalTime;

import java.util.HashMap;

import java.util.Map;

import java.util.Scanner;

class BusTicket {

    private String ticketId;

    private String travelDate;

    private String travelTime;

    private String seatNo;

    private double amountPaid;

    private int adults;

    private int children;

    private int seniorCitizens;

    public BusTicket(String ticketId, String travelDate, String travelTime, String seatNo, double amountPaid, int adults, int children, int seniorCitizens) {

        this.ticketId = ticketId;

        this.travelDate = travelDate;

        this.travelTime = travelTime;

        this.seatNo = seatNo;

        this.amountPaid = amountPaid;

        this.adults = adults;

        this.children = children;

        this.seniorCitizens = seniorCitizens;

    }

    public String getTicketId() {

        return ticketId;

    }

    public String getTravelDate() {

        return travelDate;

    }

    public String getTravelTime() {

        return travelTime;

    }

    public String getSeatNo() {

        return seatNo;

    }

    public double getAmountPaid() {

        return amountPaid;

    }

    public int getAdults() {

        return adults;

    }

    public int getChildren() {

        return children;

    }

    public int getSeniorCitizens() {

        return seniorCitizens;

    }

}

public class BusTicketBookingSystem {

    private Map<String, BusTicket> tickets;

    private Scanner scanner;

    public BusTicketBookingSystem() {

        tickets = new HashMap<>();

        scanner = new Scanner(System.in);

    }

    public void bookTicket() {

        System.out.print("Enter ticket ID: ");

        String ticketId = scanner.nextLine();

        System.out.print("Enter travel date (yyyy-MM-dd): ");

        String travelDate = scanner.nextLine();

        System.out.print("Enter travel time (HH:mm): ");

        String travelTime = scanner.nextLine();

        System.out.print("Enter seat number: ");

        String seatNo = scanner.nextLine();

        System.out.print("Enter amount paid: ");

        double amountPaid = scanner.nextDouble();

        scanner.nextLine(); // Consume newline left-over

        System.out.print("Enter number of adults: ");

        int adults = scanner.nextInt();

        scanner.nextLine(); // Consume newline left-over

        System.out.print("Enter number of children: ");

        int children = scanner.nextInt();

        scanner.nextLine(); // Consume newline left-over

        System.out.print("Enter number of senior citizens: ");

        int seniorCitizens = scanner.nextInt();

        scanner.nextLine(); // Consume newline left-over

        BusTicket ticket = new BusTicket(ticketId, travelDate, travelTime, seatNo, amountPaid, adults, children, seniorCitizens);

        tickets.put(ticketId, ticket);

        System.out.println("Ticket booked successfully!");

    }

    public void displayTicket() {

        System.out.print("Enter ticket ID: ");

        String ticketId = scanner.nextLine();

        BusTicket ticket = tickets.get(ticketId);

        if (ticket != null) {

            System.out.println("Ticket ID: " + ticket.getTicketId());

            System.out.println("Travel Date: " + ticket.getTravelDate());

            System.out.println("Travel Time: " + ticket.getTravelTime());

            System.out.println("Seat Number: " + ticket.getSeatNo());

            System.out.println("Amount Paid: " + ticket.getAmountPaid());

            System.out.println("Number of Adults: " + ticket.getAdults());

            System.out.println("Number of Children: " + ticket.getChildren());

            System.out.println("Number of Senior Citizens: " + ticket.getSeniorCitizens());

        } else {

            System.out.println("Ticket not found!");

        }

    }

    public void run() {

        while (true) {

            System.out.println("1. Book Ticket");

            System.out.println("2. Display Ticket");

            System.out.println("3. Exit");

            System.out.print("Enter your choice: ");

            int choice = scanner.nextInt();

            scanner.nextLine(); // Consume newline left-over

            switch (choice) {

                case 1:

                    bookTicket();

                    break;

                case 2:

                    displayTicket();

                    break;

                case 3:

                    System.exit(0);

                default:

                    System.out.println("Invalid choice. Please try again.");

            }

        }

    }

    public static void main(String[] args) {

        BusTicketBookingSystem system = new BusTicketBookingSystem();

        system.run();

    }

}

```

This program allows users to:

1. Book a ticket by entering ticket ID, travel date, travel time, seat number, amount paid, and number of adults, children, and senior citizens.

2. Display a ticket by entering the ticket ID.

3. Exit the program.

Write SQL query to save the above database with connection

Here is an example SQL query to create a database and a table to store the bus ticket information:

```

-- Create a database

CREATE DATABASE BusTicketBooking;

-- Use the database

USE BusTicketBooking;

-- Create a table to store bus ticket information

CREATE TABLE BusTickets (

    TicketID INT PRIMARY KEY,

    TravelDate DATE,

    TravelTime TIME,

    SeatNumber VARCHAR(10),

    AmountPaid DECIMAL(10, 2),

    Adults INT,

    Children INT,

    SeniorCitizens INT

);

-- Insert some sample data into the table

INSERT INTO BusTickets (TicketID, TravelDate, TravelTime, SeatNumber, AmountPaid, Adults, Children, SeniorCitizens)

VALUES

(1, '2022-01-01', '08:00:00', 'A1', 100.00, 2, 1, 0),

(2, '2022-01-02', '09:00:00', 'B2', 120.00, 1, 2, 1),

(3, '2022-01-03', '10:00:00', 'C3', 150.00, 3, 0, 1);

-- Create a connection to the database

-- This will vary depending on the programming language and database driver being used

-- For example, in Java using MySQL Connector/J:

-- String url = "jdbc:mysql://localhost:3306/BusTicketBooking";

-- String username = "your_username";

-- String password = "your_password";

-- Connection conn = DriverManager.getConnection(url, username, password);

```

To connect to the database and execute SQL queries in Java, you can use the following code:

```

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class BusTicketBookingSystem {

    private static final String DB_URL = "jdbc:mysql://localhost:3306/BusTicketBooking";

    private static final String USERNAME = "your_username";

    private static final String PASSWORD = "your_password";

    public static void main(String[] args) {

        try {

            Connection conn = DriverManager.getConnection(DB_URL, USERNAME, PASSWORD);

            System.out.println("Connected to the database!");

            // Create a prepared statement to insert data into the BusTickets table

            String sql = "INSERT INTO BusTickets (TicketID, TravelDate, TravelTime, SeatNumber, AmountPaid, Adults, Children, SeniorCitizens) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

            PreparedStatement pstmt = conn.prepareStatement(sql);

            // Set the values for the prepared statement

            pstmt.setInt(1, 4);

            pstmt.setDate(2, java.sql.Date.valueOf("2022-01-04"));

            pstmt.setTime(3, java.sql.Time.valueOf("11:00:00"));

            pstmt.setString(4, "D4");

            pstmt.setDouble(5, 180.00);

            pstmt.setInt(6, 2);

            pstmt.setInt(7, 1);

            pstmt.setInt(8, 1);

            // Execute the prepared statement

            pstmt.executeUpdate();

            System.out.println("Data inserted successful

ly!");

            // Close the prepared statement and connection

            pstmt.close();

            conn.close();

        } catch (SQLException e) {

            System.out.println("Error: " + e.getMessage());

        }

    }

}

```