Respan Dataset Explorer

You are a database expert and SQL optimizer. You will be given a SQL query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence. Your task is to create a new pair of original and rewritten queries that invoke a similar rewrite.

[ORIGINAL QUERY]```with customer_total_return as (select sr_customer_sk as ctr_customer_sk,sr_store_sk as ctr_store_sk,sum(SR_FEE) as ctr_total_return from store_returns,date_dim where sr_returned_date_sk = d_date_sk and d_year =2000 group by sr_customer_sk,sr_store_sk) select c_customer_id from customer_total_return ctr1,store,customer where ctr1.ctr_total_return > (select avg(ctr_total_return)*1.2 from customer_total_return ctr2 where ctr1.ctr_store_sk = ctr2.ctr_store_sk) and s_store_sk = ctr1.ctr_store_sk and s_state = 'TN' and ctr1.ctr_customer_sk = c_customer_sk order by c_customer_id limit 100; ```

[REWRITTEN QUERY]```with customer_total_return as ( select sr_customer_sk as ctr_customer_sk, sr_store_sk as ctr_store_sk, sum(SR_FEE) as ctr_total_return from store_returns join date_dim on sr_returned_date_sk = d_date_sk where d_year = 2000 group by sr_customer_sk , sr_store_sk ), avg_customer_return as ( select ctr_store_sk, avg(ctr_total_return) as avg_return from customer_total_return group by ctr_store_sk ) select c_customer_id from customer_total_return ctr1 join store on s_store_sk = ctr1.ctr_store_sk join customer on ctr1.ctr_customer_sk = c_customer_sk join avg_customer_return acr on ctr1.ctr_store_sk = acr.ctr_store_sk where ctr1.ctr_total_return > acr.avg_return * 1.2 and s_state = 'TN' order by c_customer_id limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must not have any CTEs.
2. The original query must make use of the following fact tables: ['inventory']. Below is the join graph for these fact tables:
    ['inventory(inv_warehouse_sk) references warehouse(w_warehouse_sk);', 'inventory(inv_item_sk) references item(i_item_sk);', 'inventory(inv_date_sk) references date_dim(d_date_sk);']
4. The original query must employ 3 joins.
5. The original query must employ the following aggregate functions: ['min', 'max', 'count'].
6. The original query must employ the following operators in its WHERE clause: ['avg', 'count'].
7. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.

[ORIGINAL QUERY]
```sql
select w_warehouse_name, i_item_desc
from inventory inv, warehouse w, item i
where inv.inv_warehouse_sk = w.w_warehouse_sk
  and inv.inv_item_sk = i.i_item_sk
  and inv.inv_date_sk in (select d_date_sk from date_dim where d_year = 2000)
  and inv.inv_quantity_on_hand > (select avg(inv_quantity_on_hand) * 1.2 from inventory where inv_warehouse_sk = inv.inv_warehouse_sk)
group by w.warehouse_name, i_item_desc
having count(inv_quantity_on_hand) > 50
order by min(inv_quantity_on_hand) desc limit 50;
```

[REWRITTEN QUERY]
```sql
with avg_inventory as (
  select inv_warehouse_sk, avg(inv_quantity_on_hand) as avg_on_hand
  from inventory
  group by inv_warehouse_sk
),
filtered_inventory as (
  select inv_warehouse_sk, inv_item_sk, inv_quantity_on_hand
  from inventory
  where inv_date_sk in (select d_date_sk from date_dim where d_year = 2000)
),
aggregated_filtered_inventory as (
  select inv_warehouse_sk, inv_item_sk, min(inv_quantity_on_hand) as min_on_hand, count(inv_quantity_on_hand) as count_on_hand
  from filtered_inventory fi
  join avg_inventory ai on fi.inv_warehouse_sk = ai.inv_warehouse_sk
  where fi.inv_quantity_on_hand > ai.avg_on_hand * 1.2
  group by inv_warehouse_sk, inv_item_sk
  having count(inv_quantity_on_hand) > 50
)
select w.warehouse_name, i.item_desc
from aggregated_filtered_inventory afi
join warehouse w on afi.inv_warehouse_sk = w.w_warehouse_sk
join item i on afi.inv_item_sk = i.i_item_sk
order by afi.min_on_hand desc limit 50;
```

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: Errors hit "a significant subset" of Google Gmail users connecting with the IMAP protocol on Monday, the company said. IMAP, or Internet Mail Access Protocol, is used to access Gmail on mobile devices and mail clients like Microsoft Outlook. Users affected by the problem can access Gmail but see error messages or other "unexpected behavior," Google said. Read More Google is still the place everyone wants to work The tech giant first detailed the issues at about 10:30 a.m. ET and the problems were resolved by 1:15 p.m.
Assistant:

Google | Company | Technology company known for its search engine and digital services, significant player in digital communication and data services.  
Gmail | Digital Service | Email service provided by Google, widely used for personal and professional communication.  
IMAP | Communication Protocol | Internet Mail Access Protocol used for retrieving email messages from a server, important for email client and mobile access.  
Microsoft Outlook | Email Client | Email client software developed by Microsoft, often used in corporate environments for communication and scheduling.  
unexpected behavior | Technical Issue | Unanticipated performance issues affecting software or systems, potentially impacting user experience and trust.  
ET | Time Zone | Eastern Time, a time zone important for coordinating communication and events across regions.

src/hotel/management/system/AddCustomer.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class AddCustomer extends JFrame implements ActionListener {

    JTextField t1, t2, t3, t4, t5;
    JButton b1, b2;
    Choice c1;
    JRadioButton r1, r2;

    AddCustomer() {

        JLabel l1 = new JLabel("New Customer Form");
        l1.setForeground(Color.BLUE);
        l1.setFont(new Font("Tahoma", Font.PLAIN, 20));
        l1.setBounds(100, 20, 300, 30);
        add(l1);

        JLabel l2 = new JLabel("Name");
        l2.setBounds(35, 80, 100, 20);
        add(l2);

        t1 = new JTextField();
        t1.setBounds(150, 80, 150, 25);
        add(t1);

        JLabel l3 = new JLabel("Phone");
        l3.setBounds(35, 120, 100, 20);
        add(l3);

        t2 = new JTextField();
        t2.setBounds(150, 120, 150, 25);
        add(t2);

        JLabel l4 = new JLabel("Gender");
        l4.setBounds(35, 160, 100, 20);
        add(l4);

        r1 = new JRadioButton("Male");
        r1.setBounds(150, 160, 60, 25);
        r1.setBackground(Color.WHITE);
        add(r1);

        r2 = new JRadioButton("Female");
        r2.setBounds(220, 160, 80, 25);
        r2.setBackground(Color.WHITE);
        add(r2);

        JLabel l6 = new JLabel("Country");
        l6.setBounds(35, 200, 100, 20);
        add(l6);

        t3 = new JTextField();
        t3.setBounds(150, 200, 150, 25);
        add(t3);

        JLabel l7 = new JLabel("Allocated Room");
        l7.setBounds(35, 240, 100, 20);
        add(l7);

        c1 = new Choice();
        try {

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "select * from room where available = 'Available'";

            ResultSet rs = c.s.executeQuery(str);

            while (rs.next()) {

                c1.add(rs.getString("room_number"));

            }

        } catch (Exception e) {

        }

        c1.setBounds(150, 240, 150, 25);
        c1.setBackground(Color.WHITE);
        add(c1);

        JLabel l8 = new JLabel("Checked In");
        l8.setBounds(35, 280, 100, 20);
        add(l8);

        t4 = new JTextField();
        t4.setBounds(150, 280, 150, 25);
        add(t4);

        JLabel l9 = new JLabel("Deposit");
        l9.setBounds(35, 320, 100, 20);
        add(l9);

        t5 = new JTextField();
        t5.setBounds(150, 320, 150, 25);
        add(t5);

        b1 = new JButton("Add Customer");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(50, 370, 120, 30);
        add(b1);

        b2 = new JButton("Back");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(200, 370, 120, 30);
        add(b2);
        
        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/customer.png"));
        Image i2 = i1.getImage().getScaledInstance(250, 250, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l10 = new JLabel(i3);
        l10.setBounds(400, 20, 300, 400);
        add(l10);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 200, 800, 500);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String name = t1.getText();
            String phone = t2.getText();
            String gender = null;
            
            if (r1.isSelected()) {
                
                gender = "Male";
                
            } else if (r2.isSelected()) {
                
                gender = "Female";
                
            }
            
            String country = t3.getText();
            String room = c1.getSelectedItem();
            int roomInt = Integer.parseInt(room);
            String status = t4.getText();
            String deposit = t5.getText();
            int depositInt = Integer.parseInt(deposit);

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "insert into customer values ('" + name + "','" + phone + "','" + gender + "','" + country + "','" + roomInt + "','" + status + "','" + depositInt + "')";

            String str2 = "update room set available = 'Occupied' where room_number = '" + roomInt + "'";

            try {

                c.s.executeUpdate(str);
                c.s.executeUpdate(str2);

                JOptionPane.showMessageDialog(null, "Customer Added");
                
                t1.setText("");
                t2.setText("");
                t3.setText("");
                t4.setText("");
                t5.setText("");

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        }

    }

    public static void main(String[] args) {
        new AddCustomer().setVisible(true);
    }

}






src/hotel/management/system/AddDriver.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class AddDriver extends JFrame implements ActionListener {

    JTextField t1, t2, t3, t4, t5;
    JComboBox c1, c2;
    JButton b1, b2;

    AddDriver() {

        JLabel name = new JLabel("Name");
        name.setFont(new Font("Tahoma", Font.BOLD, 17));
        name.setBounds(60, 80, 120, 30);
        add(name);

        t1 = new JTextField();
        t1.setBounds(200, 80, 150, 30);
        add(t1);

        JLabel age = new JLabel("Age");
        age.setFont(new Font("Tahoma", Font.BOLD, 17));
        age.setBounds(60, 130, 120, 30);
        add(age);

        t2 = new JTextField();
        t2.setBounds(200, 130, 150, 30);
        add(t2);

        JLabel gender = new JLabel("Gender");
        gender.setFont(new Font("Tahoma", Font.BOLD, 17));
        gender.setBounds(60, 180, 120, 30);
        add(gender);

        c1 = new JComboBox(new String[]{"Male", "Female"});
        c1.setBackground(Color.WHITE);
        c1.setBounds(200, 180, 150, 30);
        add(c1);

        JLabel model = new JLabel("Car Model");
        model.setFont(new Font("Tahoma", Font.BOLD, 17));
        model.setBounds(60, 230, 120, 30);
        add(model);

        t4 = new JTextField();
        t4.setBounds(200, 230, 150, 30);
        add(t4);

        JLabel available = new JLabel("Availability");
        available.setFont(new Font("Tahoma", Font.BOLD, 17));
        available.setBounds(60, 280, 120, 30);
        add(available);

        c2 = new JComboBox(new String[]{"Available", "Busy"});
        c2.setBackground(Color.WHITE);
        c2.setBounds(200, 280, 150, 30);
        add(c2);

        JLabel location = new JLabel("Location");
        location.setFont(new Font("Tahoma", Font.BOLD, 17));
        location.setBounds(60, 330, 120, 30);
        add(location);

        t5 = new JTextField();
        t5.setBounds(200, 330, 150, 30);
        add(t5);

        b1 = new JButton("Add Driver");
        b1.setForeground(Color.WHITE);
        b1.setBackground(Color.BLACK);
        b1.setBounds(130, 410, 100, 30);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Cancel");
        b2.setForeground(Color.WHITE);
        b2.setBackground(Color.BLACK);
        b2.setBounds(250, 410, 100, 30);
        b2.addActionListener(this);
        add(b2);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/eleven.jpg"));
        Image i2 = i1.getImage().getScaledInstance(500, 400, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l1 = new JLabel(i3);
        l1.setBounds(440, 50, 500, 400);
        add(l1);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(400, 200, 1000, 560);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String name = t1.getText();
            String age = t2.getText();
            int ageInt = Integer.parseInt(age);
            String gender = (String) c1.getSelectedItem();
            String model = t4.getText();
            String available = (String) c2.getSelectedItem();
            String location = t5.getText();

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "insert into driver values('" + name + "','" + ageInt + "','" + gender + "','" + model + "','" + available + "','" + location + "')";

            try {

                c.s.executeUpdate(str);
                JOptionPane.showMessageDialog(null, "Driver Added");

                t1.setText("");
                t2.setText("");
                c1.setSelectedItem(null);
                t4.setText("");
                c2.setSelectedItem(null);
                t5.setText("");

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            this.setVisible(false);

        }

    }

    public static void main(String[] args) {

        new AddDriver().setVisible(true);

    }

}





src/hotel/management/system/AddEmployee.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class AddEmployee extends JFrame implements ActionListener {

    JTextField t1, t2, t3, t4, t5, t6;
    JRadioButton r1, r2;
    JComboBox c1;
    JButton b1, b2;

    AddEmployee() {

        JLabel name = new JLabel("NAME");
        name.setBounds(60, 30, 120, 30);
        name.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(name);

        t1 = new JTextField();
        t1.setBounds(200, 30, 150, 30);
        add(t1);

        JLabel age = new JLabel("AGE");
        age.setBounds(60, 80, 120, 30);
        age.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(age);

        t2 = new JTextField();
        t2.setBounds(200, 80, 150, 30);
        add(t2);

        JLabel gender = new JLabel("GENDER");
        gender.setBounds(60, 130, 120, 30);
        gender.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(gender);

        r1 = new JRadioButton("Male");
        r1.setFont(new Font("Tahoma", Font.PLAIN, 14));
        r1.setBounds(200, 130, 70, 30);
        r1.setBackground(Color.WHITE);
        add(r1);

        r2 = new JRadioButton("Female");
        r2.setFont(new Font("Tahoma", Font.PLAIN, 14));
        r2.setBounds(280, 130, 70, 30);
        r2.setBackground(Color.WHITE);
        add(r2);

        JLabel job = new JLabel("JOB");
        job.setBounds(60, 180, 120, 30);
        job.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(job);

        String str[] = {"Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"};
        c1 = new JComboBox(str);
        c1.setBounds(200, 180, 150, 30);
        c1.setBackground(Color.WHITE);
        add(c1);

        JLabel salary = new JLabel("SALARY");
        salary.setBounds(60, 230, 120, 30);
        salary.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(salary);

        t3 = new JTextField();
        t3.setBounds(200, 230, 150, 30);
        add(t3);

        JLabel phone = new JLabel("PHONE");
        phone.setBounds(60, 280, 120, 30);
        phone.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(phone);

        t4 = new JTextField();
        t4.setBounds(200, 280, 150, 30);
        add(t4);

        JLabel nid = new JLabel("NID");
        nid.setBounds(60, 330, 120, 30);
        nid.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(nid);

        t5 = new JTextField();
        t5.setBounds(200, 330, 150, 30);
        add(t5);

        JLabel email = new JLabel("EMAIL");
        email.setBounds(60, 380, 120, 30);
        email.setFont(new Font("Tahoma", Font.BOLD, 17));
        add(email);

        t6 = new JTextField();
        t6.setBounds(200, 380, 150, 30);
        add(t6);

        b1 = new JButton("Submit");
        b1.setForeground(Color.WHITE);
        b1.setBackground(Color.BLACK);
        b1.setBounds(250, 440, 100, 30);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Back");
        b2.setForeground(Color.WHITE);
        b2.setBackground(Color.BLACK);
        b2.setBounds(130, 440, 100, 30);
        b2.addActionListener(this);
        add(b2);

        JLabel l1 = new JLabel("ADD EMPLOYEE DETAILS");
        l1.setForeground(Color.darkGray);
        l1.setBounds(420, 50, 400, 30);
        l1.setFont(new Font("Tahoma", Font.BOLD, 28));
        add(l1);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/tenth.jpg"));
        Image i2 = i1.getImage().getScaledInstance(520, 520, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l2 = new JLabel(i3);
        l2.setBounds(380, 55, 450, 450);
        add(l2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(400, 200, 900, 580);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String name = t1.getText();
            String age = t2.getText();
            int ageInt = Integer.parseInt(age);
            String salary = t3.getText();
            int salaryInt = Integer.parseInt(salary);
            String phone = t4.getText();
            String nid = t5.getText();
            String email = t6.getText();

            String gender = "null";

            if (r1.isSelected()) {
                
                gender = "Male";
                
            } else if (r2.isSelected()) {
                
                gender = "Female";
                
            }

            String job = (String) c1.getSelectedItem();

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "insert into employee values('" + name + "','" + ageInt + "','" + gender + "','" + job + "','" + salaryInt + "','" + phone + "','" + nid + "','" + email + "')";

            try {

                c.s.executeUpdate(str);
                
                JOptionPane.showMessageDialog(null, "Employee added");

                t1.setText("");
                t2.setText("");
                t3.setText("");
                t4.setText("");
                t5.setText("");
                t6.setText("");
                r1.setSelected(false);
                r2.setSelected(false);
                c1.setSelectedItem(null);

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            this.setVisible(false);

        }

    }

    public static void main(String[] args) {
        new AddEmployee().setVisible(true);
    }

}





src/hotel/management/system/AddRooms.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

public class AddRooms extends JFrame implements ActionListener {

    JTextField t1, t2;
    JComboBox c1, c2, c3;
    JButton b1, b2;

    AddRooms() {

        JLabel available = new JLabel("Availability");
        available.setFont(new Font("Tahoma", Font.BOLD, 17));
        available.setBounds(60, 130, 140, 30);
        add(available);

        c1 = new JComboBox(new String[]{"Available", "Occupied"});
        c1.setBounds(220, 130, 150, 30);
        c1.setBackground(Color.WHITE);
        add(c1);

        JLabel status = new JLabel("Cleaning Status");
        status.setFont(new Font("Tahoma", Font.BOLD, 17));
        status.setBounds(60, 180, 140, 30);
        add(status);

        c2 = new JComboBox(new String[]{"Cleaned", "Dirty"});
        c2.setBounds(220, 180, 150, 30);
        c2.setBackground(Color.WHITE);
        add(c2);

        JLabel price = new JLabel("Price");
        price.setFont(new Font("Tahoma", Font.BOLD, 17));
        price.setBounds(60, 230, 140, 30);
        add(price);

        t2 = new JTextField();
        t2.setBounds(220, 230, 150, 30);
        add(t2);

        JLabel type = new JLabel("Bed Type");
        type.setFont(new Font("Tahoma", Font.BOLD, 17));
        type.setBounds(60, 280, 140, 30);
        add(type);

        c3 = new JComboBox(new String[]{"Single Bed", "Double Bed"});
        c3.setBounds(220, 280, 150, 30);
        c3.setBackground(Color.WHITE);
        add(c3);

        b1 = new JButton("Add Room");
        b1.setForeground(Color.WHITE);
        b1.setBackground(Color.BLACK);
        b1.setBounds(150, 350, 100, 30);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Cancel");
        b2.setForeground(Color.WHITE);
        b2.setBackground(Color.BLACK);
        b2.setBounds(270, 350, 100, 30);
        b2.addActionListener(this);
        add(b2);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/twelve.jpg"));
        JLabel l2 = new JLabel(i1);
        l2.setBounds(440, 30, 500, 350);
        add(l2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(450, 200, 1000, 470);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String available = (String) c1.getSelectedItem();
            String status = (String) c2.getSelectedItem();
            String price = t2.getText();
            int priceInt = Integer.parseInt(price);
            String type = (String) c3.getSelectedItem();

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "insert into room values('" + available + "','" + status + "','" + priceInt + "','" + type + "')";

            try {

                c.s.executeUpdate(str);

                JOptionPane.showMessageDialog(null, "Room Added");

                t2.setText("");

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            this.setVisible(false);

        }

    }

    public static void main(String[] args) {
        new AddRooms().setVisible(true);
    }

}







src/hotel/management/system/CheckOut.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

import java.sql.*;

public class CheckOut extends JFrame implements ActionListener {

    Choice c1;
    JTextField t1;
    JButton b1, b2, b3;

    CheckOut() {

        JLabel l1 = new JLabel("Check Out");
        l1.setForeground(Color.BLUE);
        l1.setFont(new Font("Tahoma", Font.PLAIN, 20));
        l1.setBounds(100, 20, 100, 30);
        add(l1);

        JLabel l2 = new JLabel("Customer Phone No.");
        l2.setBounds(30, 80, 120, 30);
        add(l2);

        c1 = new Choice();

        try {

            ConnectMSSQL c = new ConnectMSSQL();

            ResultSet rs = c.s.executeQuery("select * from customer");

            while (rs.next()) {

                c1.add(rs.getString("phone"));

            }

        } catch (Exception e) {

        }

        c1.setBounds(170, 80, 150, 30);
        add(c1);

        JLabel l3 = new JLabel("Room");
        l3.setBounds(30, 130, 120, 30);
        add(l3);

        t1 = new JTextField();
        t1.setBounds(170, 130, 150, 30);
        add(t1);

        b1 = new JButton("Checkout");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(40, 200, 120, 30);
        add(b1);

        b2 = new JButton("Back");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(180, 200, 120, 30);
        add(b2);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/tick.png"));
        Image i2 = i1.getImage().getScaledInstance(20, 20, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        b3 = new JButton(i3);
        b3.setBounds(330, 80, 20, 20);
        b3.addActionListener(this);
        add(b3);

        ImageIcon i4 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/sixth.jpg"));
        Image i5 = i4.getImage().getScaledInstance(400, 210, Image.SCALE_DEFAULT);
        ImageIcon i6 = new ImageIcon(i5);
        JLabel l4 = new JLabel(i6);
        l4.setBounds(370, 10, 400, 250);
        add(l4);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 200, 800, 300);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String phone = c1.getSelectedItem();
            String room = t1.getText();

            ConnectMSSQL c = new ConnectMSSQL();

            String str2 = "update room set available = 'Available' where room_number = '" + room + "'";

            try {
                
                c.s.executeUpdate(str2);

                JOptionPane.showMessageDialog(null, "Checkout Done");

            } catch (Exception e) {

                System.out.println(e);

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b3) {

            ConnectMSSQL c = new ConnectMSSQL();

            String s = c1.getSelectedItem();

            try {

                ResultSet rs = c.s.executeQuery("select * from customer where phone = '" + s + "'");

                while (rs.next()) {

                    t1.setText(rs.getString("room"));

                }

            } catch (Exception e) {

            }

        }

    }

    public static void main(String[] args) {

        new CheckOut().setVisible(true);

    }

}






src/hotel/management/system/ConnectMSSQL.java
package hotel.management.system;

import java.sql.*;

public class ConnectMSSQL {

    Connection c;
    Statement s;

    public ConnectMSSQL() {

        try {

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            c = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=projecthms;selectMethod=cursor", "sa", "123456");
            s = c.createStatement();

        } catch (Exception e) {
            e.printStackTrace();
        }

    }

}







src/hotel/management/system/CustomerInfo.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import net.proteanit.sql.*;

public class CustomerInfo extends JFrame implements ActionListener {

    JTable t1;
    JButton b1, b2;
    JComboBox c1, c2, c3, c4;

    CustomerInfo() {

        t1 = new JTable();
        t1.setBounds(0, 40, 1000, 300);
        add(t1);

        c1 = new JComboBox(new String[]{"Country Region", "Local", "Foreigner"});
        c1.setBounds(160, 400, 150, 25);
        c1.setBackground(Color.WHITE);
        c1.addActionListener(this);
        add(c1);

        c2 = new JComboBox(new String[]{"Sort By", "Room"});
        c2.setBounds(440, 400, 150, 25);
        c2.setBackground(Color.WHITE);
        c2.addActionListener(this);
        add(c2);

        JLabel l1 = new JLabel("Name");
        l1.setBounds(50, 10, 70, 20);
        add(l1);

        JLabel l2 = new JLabel("Phone");
        l2.setBounds(190, 10, 70, 20);
        add(l2);

        JLabel l3 = new JLabel("Gender");
        l3.setBounds(330, 10, 70, 20);
        add(l3);

        JLabel l4 = new JLabel("Country");
        l4.setBounds(470, 10, 70, 20);
        add(l4);

        JLabel l5 = new JLabel("Room");
        l5.setBounds(620, 10, 70, 20);
        add(l5);

        JLabel l6 = new JLabel("Checked In");
        l6.setBounds(750, 10, 70, 20);
        add(l6);

        JLabel l7 = new JLabel("Deposit");
        l7.setBounds(890, 10, 70, 20);
        add(l7);

        b1 = new JButton("Load Data");
        b1.setBounds(350, 560, 120, 30);
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Back");
        b2.setBounds(530, 560, 120, 30);
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        add(b2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(450, 200, 1000, 650);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();
                String str = "select name, phone, gender, country, room, status, deposit from customer";
                ResultSet rs = c.s.executeQuery(str);

                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == c1) {

            if (c1.getSelectedItem() == "Local") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, phone, gender, country, room, status, deposit from customer where country = 'Bangladesh'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c1.getSelectedItem() == "Foreigner") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, phone, gender, country, room, status, deposit from customer where not country = 'Bangladesh'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == c2) {

            if (c2.getSelectedItem() == "Room") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, phone, gender, country, room, status, deposit from customer order by room + 0";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        }

    }

    public static void main(String[] args) {
        new CustomerInfo().setVisible(true);
    }

}








src/hotel/management/system/Dashboard.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class Dashboard extends JFrame implements ActionListener {

    JButton b1, b2, b3, b4;

    Dashboard() {

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/luxury.jpg"));
        Image i2 = i1.getImage().getScaledInstance(1720, 1000, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l1 = new JLabel(i3);
        l1.setBounds(230, 0, 1720, 1000);
        add(l1);

        b1 = new JButton("Admin");
        b1.setFont(new Font("Tahoma", Font.BOLD, 26));
        b1.addActionListener(this);
        b1.setBounds(20, 300, 190, 60);
        add(b1);

        b2 = new JButton("Reception");
        b2.setFont(new Font("Tahoma", Font.BOLD, 26));
        b2.addActionListener(this);
        b2.setBounds(20, 470, 190, 60);
        add(b2);

        b4 = new JButton("Logout");
        b4.setFont(new Font("Tahoma", Font.BOLD, 26));
        b4.addActionListener(this);
        b4.setBounds(20, 640, 190, 60);
        add(b4);

        getContentPane().setBackground(Color.decode("#6e5853"));

        setLayout(null);
        setBounds(0, 0, 1950, 1020);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            new DropDown().setVisible(true);

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);

        } else if (ae.getSource() == b3) {

        } else if (ae.getSource() == b4) {

            new Login().setVisible(true);
            this.setVisible(false);

        }

    }

    public static void main(String[] args) {

        new Dashboard().setVisible(true);

    }

}







src/hotel/management/system/DropDown.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class DropDown extends JFrame implements ActionListener {

    JButton b1, b2, b3;

    DropDown() {

        b1 = new JButton("Add Employee");
        b1.setFont(new Font("Tahoma", Font.BOLD, 16));
        b1.addActionListener(this);
        b1.setBounds(5, 30, 160, 40);
        add(b1);

        b2 = new JButton("Add Room");
        b2.setFont(new Font("Tahoma", Font.BOLD, 16));
        b2.addActionListener(this);
        b2.setBounds(5, 100, 160, 40);
        add(b2);

        b3 = new JButton("Add Driver");
        b3.setFont(new Font("Tahoma", Font.BOLD, 16));
        b3.addActionListener(this);
        b3.setBounds(5, 170, 160, 40);
        add(b3);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(230, 337, 190, 290);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            new AddEmployee().setVisible(true);

        } else if (ae.getSource() == b2) {

            new AddRooms().setVisible(true);

        } else if (ae.getSource() == b3) {

            new AddDriver().setVisible(true);

        }

    }

    public static void main(String[] args) {

        new DropDown().setVisible(true);

    }

}








src/hotel/management/system/EmployeeInfo.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

import net.proteanit.sql.*;

public class EmployeeInfo extends JFrame implements ActionListener {

    JTable t1;
    JButton b1, b2, b3, b4;
    JComboBox c1, c2, c3, c4, c5, c6, c7, c8;

    EmployeeInfo() {

        t1 = new JTable();
        t1.setBounds(0, 40, 1010, 300);
        add(t1);

        c1 = new JComboBox(new String[]{"Sort By", "Name", "Age", "Job"});
        c1.setBounds(10, 400, 100, 25);
        c1.setBackground(Color.WHITE);
        c1.addActionListener(this);
        add(c1);

        c2 = new JComboBox(new String[]{"Salary Range", "1k-20k", "21k-40k", "41k-60k", "60k+"});
        c2.setBounds(140, 400, 100, 25);
        c2.setBackground(Color.WHITE);
        c2.addActionListener(this);
        add(c2);

        c3 = new JComboBox(new String[]{"Job", "Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"});
        c3.setBounds(280, 400, 140, 25);
        c3.setBackground(Color.WHITE);
        c3.addActionListener(this);
        add(c3);

        c4 = new JComboBox(new String[]{"No. of employees according to job", "Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"});
        c4.setBounds(460, 400, 230, 25);
        c4.setBackground(Color.WHITE);
        c4.addActionListener(this);
        add(c4);

        c5 = new JComboBox(new String[]{"Mobile SIM operator", "Grameenphone", "Robi", "Banglalink", "Airtel", "Teletalk"});
        c5.setBounds(730, 400, 160, 25);
        c5.setBackground(Color.WHITE);
        c5.addActionListener(this);
        add(c5);

        c6 = new JComboBox(new String[]{"Average Salary according to job", "Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"});
        c6.setBounds(80, 470, 230, 25);
        c6.setBackground(Color.WHITE);
        c6.addActionListener(this);
        add(c6);

        c7 = new JComboBox(new String[]{"Salary greater than Average Salary", "Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"});
        c7.setBounds(360, 470, 230, 25);
        c7.setBackground(Color.WHITE);
        c7.addActionListener(this);
        add(c7);

        c8 = new JComboBox(new String[]{"Salary less than Average Salary", "Front Desk Clerks", "Porters", "Housekeeping", "Kitchen Stuff", "Room Service", "Waiter", "Manager", "Accountant", "Chef"});
        c8.setBounds(640, 470, 230, 25);
        c8.setBackground(Color.WHITE);
        c8.addActionListener(this);
        add(c8);

        JLabel l1 = new JLabel("Name");
        l1.setBounds(40, 10, 70, 20);
        add(l1);

        JLabel l2 = new JLabel("Age");
        l2.setBounds(170, 10, 70, 20);
        add(l2);

        JLabel l3 = new JLabel("Gender");
        l3.setBounds(290, 10, 70, 20);
        add(l3);

        JLabel l4 = new JLabel("Job");
        l4.setBounds(400, 10, 70, 20);
        add(l4);

        JLabel l5 = new JLabel("Salary");
        l5.setBounds(540, 10, 70, 20);
        add(l5);

        JLabel l6 = new JLabel("Phone");
        l6.setBounds(670, 10, 70, 20);
        add(l6);

        JLabel l7 = new JLabel("NID");
        l7.setBounds(790, 10, 70, 20);
        add(l7);

        JLabel l8 = new JLabel("Email");
        l8.setBounds(910, 10, 70, 20);
        add(l8);

        b1 = new JButton("Load Data");
        b1.setBounds(350, 560, 120, 30);
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Back");
        b2.setBounds(530, 560, 120, 30);
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        add(b2);

        b4 = new JButton("Delete");
        b4.setBounds(680, 560, 120, 30);
        b4.setBackground(Color.BLACK);
        b4.setForeground(Color.WHITE);
        b4.addActionListener(this);
        add(b4);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(450, 200, 1030, 650);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();
                String str = "select name, age, gender, job, salary, phone, nid, email from employee";
                ResultSet rs = c.s.executeQuery(str);

                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == c1) {

            if (c1.getSelectedItem() == "Name") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();
                    String str = "select name, age, gender, job, salary, phone, nid, email from employee order by name";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c1.getSelectedItem() == "Age") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();
                    String str = "select name, age, gender, job, salary, phone, nid, email from employee order by age + 0";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c1.getSelectedItem() == "Job") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee order by job";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == c2) {

            if (c2.getSelectedItem() == "1k-20k") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary between 1000 and 20000";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c2.getSelectedItem() == "21k-40k") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary between 20001 and 40000";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c2.getSelectedItem() == "41k-60k") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary between 40001 and 60000";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c2.getSelectedItem() == "60k+") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > 60001";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == b4) {

            int row = t1.getSelectedRow();

            String cell = t1.getModel().getValueAt(row, 0).toString();

            System.out.println(cell);

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "delete from employee where name = '" + cell + "'";

                c.s.executeQuery(str);

                JOptionPane.showMessageDialog(null, "Row deleted");

            } catch (Exception e) {

                System.out.println(e);

            }

        } else if (ae.getSource() == c3) {

            if (c3.getSelectedItem() == "Front Desk Clerks") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Front Desk Clerks'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Porters") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Porters'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Housekeeping") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Housekeeping'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Kitchen Stuff") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Kitchen Stuff'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Room Service") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Room Service'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Waiter") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Waiter'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Manager") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Manager'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Accountant") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Accountant'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (c3.getSelectedItem() == "Chef") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Chef'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == c4) {

            if (c4.getSelectedItem() == "Front Desk Clerks") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Front Desk Clerks'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Front Desk Clerks in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Porters") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Porters'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Porters in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Housekeeping") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Housekeeping'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Housekeepers in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Kitchen Stuff") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Kitchen Stuff'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Kitchen Stuffs in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Room Service") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Room Service'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Room Service person in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Waiter") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Waiter'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Waiters in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Manager") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Manager'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Managers in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Accountant") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Accountant'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Accountants in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c4.getSelectedItem() == "Chef") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select count(job) from employee where job = 'Chef'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "There are currently " + String.valueOf(i) + " Chefs in our hotel");

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            }

        } else if (ae.getSource() == c5) {

            if (c5.getSelectedItem() == "Grameenphone") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where ((phone like '017%') or (phone like '013%'))";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c5.getSelectedItem() == "Robi") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where phone like '018%'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c5.getSelectedItem() == "Banglalink") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where ((phone like '019%') or (phone like '014%'))";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c5.getSelectedItem() == "Airtel") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where phone like '016%'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c5.getSelectedItem() == "Teletalk") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where phone like '015%'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            }

        } else if (ae.getSource() == c6) {

            if (c6.getSelectedItem() == "Front Desk Clerks") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Front Desk Clerks';";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Front Desk Clerk is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Porters") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Porters'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Porter is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Housekeeping") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Housekeeping'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Housekeeper is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Kitchen Stuff") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Kitchen Stuff'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Kitchen Stuff is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Room Service") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Room Service'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Room Service is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Waiter") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Waiter'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Waiter is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Manager") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Manager'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Manager is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Accountant") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Accountant'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Accountant is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c6.getSelectedItem() == "Chef") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select AVG(salary) from employee where job = 'Chef'";

                    ResultSet rs = c.s.executeQuery(str);

                    while (rs.next()) {

                        int i = rs.getInt(1);

                        JOptionPane.showMessageDialog(null, "Average salary of Chef is " + String.valueOf(i));

                    }

                } catch (Exception e) {

                    System.out.println(e);

                }

            }

        } else if (ae.getSource() == c7) {

            if (c7.getSelectedItem() == "Front Desk Clerks") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Front Desk Clerks') and job = 'Front Desk Clerks'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Porters") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Porters') and job = 'Porters'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Housekeeping") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Housekeeping') and job = 'Housekeeping'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Kitchen Stuff") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Kitchen Stuff') and job = 'Kitchen Stuff'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Room Service") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Room Service') and job = 'Room Service'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Waiter") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Waiter') and job = 'Waiter'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Manager") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Manager') and job = 'Manager'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Accountant") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Accountant') and job = 'Accountant'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c7.getSelectedItem() == "Chef") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary > (select AVG(salary) from employee where job = 'Chef') and job = 'Chef'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            }

        } else if (ae.getSource() == c8) {

            if (c8.getSelectedItem() == "Front Desk Clerks") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Front Desk Clerks') and job = 'Front Desk Clerks'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Porters") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Porters') and job = 'Porters'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Housekeeping") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Housekeeping') and job = 'Housekeeping'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Kitchen Stuff") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Kitchen Stuff') and job = 'Kitchen Stuff'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Room Service") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Room Service') and job = 'Room Service'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Waiter") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Waiter') and job = 'Waiter'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Manager") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Manager') and job = 'Manager'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Accountant") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Accountant') and job = 'Accountant'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            } else if (c8.getSelectedItem() == "Chef") {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, job, salary, phone, nid, email from employee where salary < (select AVG(salary) from employee where job = 'Chef') and job = 'Chef'";

                    ResultSet rs = c.s.executeQuery(str);

                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                    System.out.println(e);

                }

            }

        }

    }

    public static void main(String[] args) {

        new EmployeeInfo().setVisible(true);

    }

}







src/hotel/management/system/HotelManagementSystem.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class HotelManagementSystem extends JFrame implements ActionListener {

    public HotelManagementSystem() {
        
        setBounds(300, 200, 1366, 565);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/hotel.jpg"));
        JLabel l1 = new JLabel(i1);
        l1.setBounds(0, 0, 1366, 565);
        add(l1);

        JLabel l2 = new JLabel("Hotel Management System");
        l2.setBounds(20, 430, 1000, 90);
        l2.setForeground(Color.WHITE);
        l2.setFont(new Font("serif", Font.PLAIN, 70));
        l1.add(l2);

        JButton b1 = new JButton("Next");
        b1.setBackground(Color.WHITE);
        b1.setForeground(Color.BLACK);
        b1.setBounds(1150, 450, 150, 50);
        b1.addActionListener(this);
        l1.add(b1);

        setLayout(null);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {
        new Login().setVisible(true);
        this.setVisible(false);
    }

    public static void main(String[] args) {
        new HotelManagementSystem().setVisible(true);
    }

}








src/hotel/management/system/Login.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Login extends JFrame implements ActionListener {

    JLabel l1, l2;
    JTextField t1;
    JPasswordField t2;
    JButton b1, b2;
    JCheckBox check;

    Login() {

        l1 = new JLabel("Username");
        l1.setBounds(40, 50, 100, 30);
        add(l1);

        l2 = new JLabel("Password");
        l2.setBounds(40, 100, 100, 30);
        add(l2);

        t1 = new JTextField();
        t1.setBounds(150, 50, 150, 30);
        add(t1);

        t2 = new JPasswordField();
        t2.setBounds(150, 100, 150, 30);
        add(t2);

        check = new JCheckBox("Show Password");
        check.setBounds(185, 140, 140, 30);
        check.setBackground(Color.WHITE);
        check.addActionListener(this);
        add(check);

        b1 = new JButton("Login");
        b1.setBounds(40, 230, 120, 30);
        b1.setForeground(Color.WHITE);
        b1.setBackground(Color.BLACK);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Cancel");
        b2.setBounds(180, 230, 120, 30);
        b2.setForeground(Color.WHITE);
        b2.setBackground(Color.BLACK);
        b2.addActionListener(this);
        add(b2);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/second.jpg"));
        Image i2 = i1.getImage().getScaledInstance(200, 200, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l3 = new JLabel(i3);
        l3.setBounds(350, 10, 200, 200);
        add(l3);

        JMenuItem l4 = new JMenuItem("<HTML><U>Don't have an account? Signup</U></HTML>");
        l4.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
        l4.setBackground(Color.WHITE);
        l4.setBounds(360, 310, 200, 30);
        l4.addActionListener(this);
        add(l4);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(700, 300, 600, 400);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String username = t1.getText();
            String password = t2.getText();

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "select * from login where username = '" + username + "' and password = '" + password + "'";

            try {
                ResultSet rs = c.s.executeQuery(str);

                if (rs.next()) {
                    new Dashboard().setVisible(true);
                    this.setVisible(false);
                } else {
                    JOptionPane.showMessageDialog(null, "Invalid username and password");
                    t1.setText("");
                    t2.setText("");
                }

            } catch (Exception e) {

            }
        } else if (ae.getSource() == b2) {
            this.setVisible(false);
            new HotelManagementSystem().setVisible(true);

        } else if (ae.getActionCommand().equals("<HTML><U>Don't have an account? Signup</U></HTML>")) {

            new SignUp().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == check) {

            if (check.isSelected()) {

                t2.setEchoChar((char) 0);

            } else {

                t2.setEchoChar('*');

            }

        }

    }

    public static void main(String[] args) {
        new Login();
    }

}


















src/hotel/management/system/ManagerInfo.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import net.proteanit.sql.*;

public class ManagerInfo extends JFrame implements ActionListener {

    JTable t1;
    JButton b1, b2;

    ManagerInfo() {

        t1 = new JTable();
        t1.setBounds(0, 40, 1010, 500);
        add(t1);

        JLabel l1 = new JLabel("Name");
        l1.setBounds(40, 10, 70, 20);
        add(l1);

        JLabel l2 = new JLabel("Age");
        l2.setBounds(170, 10, 70, 20);
        add(l2);

        JLabel l3 = new JLabel("Gender");
        l3.setBounds(290, 10, 70, 20);
        add(l3);

        JLabel l4 = new JLabel("Job");
        l4.setBounds(400, 10, 70, 20);
        add(l4);

        JLabel l5 = new JLabel("Salary");
        l5.setBounds(540, 10, 70, 20);
        add(l5);

        JLabel l6 = new JLabel("Phone");
        l6.setBounds(670, 10, 70, 20);
        add(l6);

        JLabel l7 = new JLabel("NID");
        l7.setBounds(790, 10, 70, 20);
        add(l7);

        JLabel l8 = new JLabel("Email");
        l8.setBounds(910, 10, 70, 20);
        add(l8);

        b1 = new JButton("Load Data");
        b1.setBounds(350, 560, 120, 30);
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Back");
        b2.setBounds(530, 560, 120, 30);
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        add(b2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(450, 200, 1030, 650);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();
                String str = "select name, age, gender, job, salary, phone, nid, email from employee where job = 'Manager';";
                ResultSet rs = c.s.executeQuery(str);

                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        }

    }

    public static void main(String[] args) {
        new ManagerInfo().setVisible(true);
    }

}






src/hotel/management/system/PickUp.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import net.proteanit.sql.DbUtils;

public class PickUp extends JFrame implements ActionListener {

    Choice c1;
    JButton b1, b2, b3;
    JTable t1;
    JCheckBox cb1, cb2;

    PickUp() {

        JLabel l1 = new JLabel("PickUp Service");
        l1.setFont(new Font("Tahoma", Font.PLAIN, 20));
        l1.setBounds(400, 30, 200, 30);
        add(l1);

        JLabel l2 = new JLabel("Type of Car");
        l2.setBounds(50, 100, 100, 20);
        add(l2);

        c1 = new Choice();

        try {

            ConnectMSSQL c = new ConnectMSSQL();

            ResultSet rs = c.s.executeQuery("select distinct model from driver");

            while (rs.next()) {

                c1.addItem(rs.getString("model"));

            }

        } catch (Exception e) {

        }

        c1.setBounds(150, 100, 200, 25);
        add(c1);

        cb1 = new JCheckBox("Available Drivers (At Hotel)");
        cb1.setBackground(Color.WHITE);
        cb1.addActionListener(this);
        cb1.setBounds(650, 100, 200, 25);
        add(cb1);

        cb2 = new JCheckBox("Experienced Drivers");
        cb2.setBackground(Color.WHITE);
        cb2.addActionListener(this);
        cb2.setBounds(400, 100, 200, 25);
        add(cb2);

        JLabel l3 = new JLabel("Name");
        l3.setBounds(50, 170, 100, 20);
        add(l3);

        JLabel l4 = new JLabel("Age");
        l4.setBounds(200, 170, 100, 20);
        add(l4);

        JLabel l5 = new JLabel("Gender");
        l5.setBounds(340, 170, 100, 20);
        add(l5);

        JLabel l7 = new JLabel("Model");
        l7.setBounds(620, 170, 100, 20);
        add(l7);

        JLabel l8 = new JLabel("Availability");
        l8.setBounds(750, 170, 100, 20);
        add(l8);

        JLabel l9 = new JLabel("Location");
        l9.setBounds(890, 170, 100, 20);
        add(l9);

        t1 = new JTable();
        t1.setBounds(0, 200, 1000, 300);
        add(t1);

        b1 = new JButton("Search");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(200, 520, 120, 30);
        add(b1);

        b3 = new JButton("Load Data");
        b3.setBackground(Color.BLACK);
        b3.setForeground(Color.WHITE);
        b3.addActionListener(this);
        b3.setBounds(360, 520, 120, 30);
        add(b3);

        b2 = new JButton("Back");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(520, 520, 120, 30);
        add(b2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 200, 1000, 650);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "select name, age, gender, model, available, location from driver where model = '" + c1.getSelectedItem() + "'";

                ResultSet rs = c.s.executeQuery(str);
                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == cb1) {

            if (cb1.isSelected()) {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, model, available, location from driver where location = 'At Hotel'";

                    ResultSet rs = c.s.executeQuery(str);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (!cb1.isSelected()) {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, model, available, location from driver";

                    ResultSet rs = c.s.executeQuery(str);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == cb2) {

            if (cb2.isSelected()) {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, model, available, location from driver where age >= 35";

                    ResultSet rs = c.s.executeQuery(str);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            } else if (!cb2.isSelected()) {

                try {

                    ConnectMSSQL c = new ConnectMSSQL();

                    String str = "select name, age, gender, model, available, location from driver";

                    ResultSet rs = c.s.executeQuery(str);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } catch (Exception e) {

                }

            }

        } else if (ae.getSource() == b3) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "select name, age, gender, model, available, location from driver";

                ResultSet rs = c.s.executeQuery(str);
                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        }

    }

    public static void main(String[] args) {

        new PickUp().setVisible(true);

    }

}








src/hotel/management/system/Reception.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

public class Reception extends JFrame implements ActionListener {

    JButton b1, b2, b3, b4, b5, b6, b7, b8, b9, b10, b11, b12;

    Reception() {

        b1 = new JButton("New Customer Form");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.setBounds(10, 30, 200, 30);
        b1.addActionListener(this);
        add(b1);
        
        b4 = new JButton("All Employee Info");
        b4.setBackground(Color.BLACK);
        b4.setForeground(Color.WHITE);
        b4.setBounds(10, 110, 200, 30);
        b4.addActionListener(this);
        add(b4);

        b5 = new JButton("Customer Info");
        b5.setBackground(Color.BLACK);
        b5.setForeground(Color.WHITE);
        b5.setBounds(10, 150, 200, 30);
        b5.addActionListener(this);
        add(b5);

        b6 = new JButton("Manager Info");
        b6.setBackground(Color.BLACK);
        b6.setForeground(Color.WHITE);
        b6.setBounds(10, 190, 200, 30);
        b6.addActionListener(this);
        add(b6);

        b7 = new JButton("Check Out");
        b7.setBackground(Color.BLACK);
        b7.setForeground(Color.WHITE);
        b7.setBounds(10, 230, 200, 30);
        b7.addActionListener(this);
        add(b7);

        b8 = new JButton("Update Check Status");
        b8.setBackground(Color.BLACK);
        b8.setForeground(Color.WHITE);
        b8.setBounds(10, 270, 200, 30);
        b8.addActionListener(this);
        add(b8);

        b9 = new JButton("Update Room Status");
        b9.setBackground(Color.BLACK);
        b9.setForeground(Color.WHITE);
        b9.setBounds(10, 310, 200, 30);
        b9.addActionListener(this);
        add(b9);

        b10 = new JButton("Pick up Service");
        b10.setBackground(Color.BLACK);
        b10.setForeground(Color.WHITE);
        b10.setBounds(10, 350, 200, 30);
        b10.addActionListener(this);
        add(b10);

        b11 = new JButton("Search Room");
        b11.setBackground(Color.BLACK);
        b11.setForeground(Color.WHITE);
        b11.setBounds(10, 390, 200, 30);
        b11.addActionListener(this);
        add(b11);

        b12 = new JButton("Back");
        b12.setBackground(Color.BLACK);
        b12.setForeground(Color.WHITE);
        b12.setBounds(10, 430, 200, 30);
        b12.addActionListener(this);
        add(b12);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/fourth.jpg"));
        JLabel l1 = new JLabel(i1);
        l1.setBounds(250, 30, 530, 430);
        add(l1);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(550, 200, 800, 530);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            new AddCustomer().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b4) {

            new EmployeeInfo().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b5) {

            new CustomerInfo().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b6) {

            new ManagerInfo().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b7) {

            new CheckOut().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b8) {

            new UpdateStatus().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b9) {

            new UpdateRoom().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b10) {

            new PickUp().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b11) {

            new SearchRoom().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == b12) {
            
            this.setVisible(false);
            
        }

    }

    public static void main(String[] args) {
        new Reception().setVisible(true);
    }

}









src/hotel/management/system/SearchRoom.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import net.proteanit.sql.DbUtils;

public class SearchRoom extends JFrame implements ActionListener {

    JComboBox c1;
    JCheckBox c2;
    JButton b1, b2, b3, b4;
    JTable t1;
    JTextField t2, t3;

    SearchRoom() {

        JLabel l1 = new JLabel("Search For Room");
        l1.setFont(new Font("Tahoma", Font.PLAIN, 20));
        l1.setBounds(400, 30, 200, 30);
        add(l1);

        JLabel l2 = new JLabel("Room Bed Type");
        l2.setBounds(50, 100, 100, 20);
        add(l2);

        c1 = new JComboBox(new String[]{"Single Bed", "Double Bed"});
        c1.setBounds(150, 100, 150, 25);
        c1.setBackground(Color.WHITE);
        add(c1);

        JLabel l8 = new JLabel("Room Price");
        l8.setBounds(450, 80, 120, 20);
        add(l8);

        t2 = new JTextField();
        t2.addActionListener(this);
        t2.setBounds(360, 120, 100, 25);
        add(t2);

        t3 = new JTextField();
        t3.addActionListener(this);
        t3.setBounds(480, 120, 100, 25);
        add(t3);

        c2 = new JCheckBox("Only Display Available");
        c2.setBackground(Color.WHITE);
        c2.setBounds(650, 100, 150, 25);
        add(c2);

        JLabel l3 = new JLabel("Room");
        l3.setBounds(90, 170, 100, 20);
        add(l3);

        JLabel l4 = new JLabel("Availability");
        l4.setBounds(270, 170, 100, 20);
        add(l4);

        JLabel l5 = new JLabel("Cleaning Status");
        l5.setBounds(450, 170, 100, 20);
        add(l5);

        JLabel l6 = new JLabel("Price");
        l6.setBounds(680, 170, 100, 20);
        add(l6);

        JLabel l7 = new JLabel("Bed Type");
        l7.setBounds(850, 170, 100, 20);
        add(l7);

        t1 = new JTable();
        t1.setBounds(0, 200, 1000, 380);
        add(t1);

        b1 = new JButton("Search");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(250, 610, 120, 30);
        add(b1);

        b4 = new JButton("Load Data");
        b4.setBackground(Color.BLACK);
        b4.setForeground(Color.WHITE);
        b4.addActionListener(this);
        b4.setBounds(430, 610, 120, 30);
        add(b4);

        b2 = new JButton("Back");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(610, 610, 120, 30);
        add(b2);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 150, 1000, 720);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "select * from room where bed_type = '" + c1.getSelectedItem() + "' AND price between " + t2.getText() + " and " + t3.getText() + "";

                String str2 = "select * from room where available = 'Available' AND bed_type = '" + c1.getSelectedItem() + "'  and price between " + t2.getText() + " AND " + t3.getText() + "";

                ResultSet rs;

                if (c2.isSelected()) {

                    rs = c.s.executeQuery(str2);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                } else {

                    rs = c.s.executeQuery(str);
                    t1.setModel(DbUtils.resultSetToTableModel(rs));

                }

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            new Reception().setVisible(true);
            this.setVisible(false);

        } /*else if (ae.getSource() == b3) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "select * from room where price between " + t2.getText() + " and " + t3.getText() + "";

                ResultSet rs = c.s.executeQuery(str);
                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

                System.out.println(e);

            }

        }*/ else if (ae.getSource() == b4) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String str = "select * from room";

                ResultSet rs = c.s.executeQuery(str);

                t1.setModel(DbUtils.resultSetToTableModel(rs));

            } catch (Exception e) {

            }

        }

    }

    public static void main(String[] args) {

        new SearchRoom().setVisible(true);

    }

}














src/hotel/management/system/SignUp.java
package hotel.management.system;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class SignUp extends JFrame implements ActionListener {

    JLabel l1, l2;
    JTextField t1;
    JPasswordField t2;
    JButton b1, b2;
    JCheckBox check;

    SignUp() {

        l1 = new JLabel("Username");
        l1.setBounds(40, 50, 100, 30);
        add(l1);

        l2 = new JLabel("Password");
        l2.setBounds(40, 100, 100, 30);
        add(l2);

        t1 = new JTextField();
        t1.setBounds(150, 50, 150, 30);
        add(t1);

        t2 = new JPasswordField();
        t2.setBounds(150, 100, 150, 30);
        add(t2);

        check = new JCheckBox("Show Password");
        check.setBounds(185, 140, 140, 30);
        check.setBackground(Color.WHITE);
        check.addActionListener(this);
        add(check);

        b1 = new JButton("Signup");
        b1.setBounds(40, 230, 120, 30);
        b1.setForeground(Color.WHITE);
        b1.setBackground(Color.BLACK);
        b1.addActionListener(this);
        add(b1);

        b2 = new JButton("Cancel");
        b2.setBounds(180, 230, 120, 30);
        b2.setForeground(Color.WHITE);
        b2.setBackground(Color.BLACK);
        b2.addActionListener(this);
        add(b2);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/second.jpg"));
        Image i2 = i1.getImage().getScaledInstance(200, 200, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l3 = new JLabel(i3);
        l3.setBounds(350, 10, 200, 200);
        add(l3);

        JMenuItem l4 = new JMenuItem("<HTML><U>Already have an account? Login</U></HTML>");
        l4.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
        l4.setBackground(Color.WHITE);
        l4.setBounds(360, 310, 200, 30);
        l4.addActionListener(this);
        add(l4);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(700, 300, 600, 400);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String username = t1.getText();
            String password = t2.getText();

            ConnectMSSQL c = new ConnectMSSQL();

            String str = "insert into login values('" + username + "','" + password + "')";

            try {

                c.s.executeUpdate(str);
                JOptionPane.showMessageDialog(null, "Account Created");

                new Login().setVisible(true);

            } catch (Exception e) {

            }
        } else if (ae.getSource() == b2) {
            this.setVisible(false);
            new HotelManagementSystem().setVisible(true);

        } else if (ae.getActionCommand().equals("<HTML><U>Already have an account? Login</U></HTML>")) {

            new Login().setVisible(true);
            this.setVisible(false);

        } else if (ae.getSource() == check) {

            if (check.isSelected()) {

                t2.setEchoChar((char) 0);

            } else {

                t2.setEchoChar('*');

            }

        }

    }

    public static void main(String[] args) {
        new SignUp().setVisible(true);
    }

}








src/hotel/management/system/UpdateRoom.java
package hotel.management.system;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class UpdateRoom extends JFrame implements ActionListener {

    Choice c1;
    JTextField t1, t2, t3;
    JButton b1, b2, b3;

    UpdateRoom() {

        JLabel l1 = new JLabel("Update Room Status");
        l1.setFont(new Font("Tahoma", Font.PLAIN, 25));
        l1.setForeground(Color.BLUE);
        l1.setBounds(30, 20, 250, 30);
        add(l1);

        JLabel l2 = new JLabel("Customer Phone No.");
        l2.setBounds(30, 80, 120, 20);
        add(l2);

        c1 = new Choice();

        try {

            ConnectMSSQL c = new ConnectMSSQL();

            ResultSet rs = c.s.executeQuery("select * from customer");

            while (rs.next()) {

                c1.add(rs.getString("phone"));

            }

        } catch (Exception e) {

        }

        c1.setBounds(160, 80, 150, 25);
        add(c1);

        JLabel l3 = new JLabel("Room");
        l3.setBounds(30, 130, 120, 20);
        add(l3);

        t1 = new JTextField();
        t1.setBounds(160, 130, 150, 25);
        add(t1);

        JLabel l4 = new JLabel("Availability");
        l4.setBounds(30, 180, 120, 20);
        add(l4);

        t2 = new JTextField();
        t2.setBounds(160, 180, 150, 25);
        add(t2);

        JLabel l5 = new JLabel("Cleaning Status");
        l5.setBounds(30, 230, 120, 20);
        add(l5);

        t3 = new JTextField();
        t3.setBounds(160, 230, 150, 25);
        add(t3);

        b1 = new JButton("Check");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(30, 300, 100, 30);
        add(b1);

        b2 = new JButton("Update");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(140, 300, 100, 30);
        add(b2);

        b3 = new JButton("Back");
        b3.setBackground(Color.BLACK);
        b3.setForeground(Color.WHITE);
        b3.addActionListener(this);
        b3.setBounds(250, 300, 100, 30);
        add(b3);
        
        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/seventh.jpg"));
        Image i2 = i1.getImage().getScaledInstance(500, 300, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel icon = new JLabel(i3);
        icon.setBounds(400, 0, 500, 400);
        add(icon);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 200, 970, 430);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            String room = null;
            String s1 = c1.getSelectedItem();

            ConnectMSSQL c = new ConnectMSSQL();

            try {

                ResultSet rs = c.s.executeQuery("select * from customer where phone = '" + s1 + "'");

                while (rs.next()) {

                    t1.setText(rs.getString("room"));
                    room = rs.getString("room");

                }

                ResultSet rs2 = c.s.executeQuery("select * from room where room_number = '" + room + "'");

                while (rs2.next()) {

                    t2.setText(rs2.getString("available"));
                    t3.setText(rs2.getString("status"));

                }

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String room = t1.getText();
                String available = t2.getText();
                String status = t3.getText();

                String str = "update room set available = '" + available + "', status = '" + status + "' where room_number = '" + room + "'";
                
                c.s.executeUpdate(str);
                
                JOptionPane.showMessageDialog(null, "Room Updated Successfully");

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b3) {

            new Reception().setVisible(true);
            this.setVisible(false);

        }

    }

    public static void main(String[] args) {

        new UpdateRoom().setVisible(true);

    }

}














src/hotel/management/system/UpdateStatus.java
package hotel.management.system;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class UpdateStatus extends JFrame implements ActionListener {

    JButton b1, b2, b3;
    Choice c1;
    JTextField t1, t2, t3, t4, t5;

    UpdateStatus() {

        JLabel l1 = new JLabel("Check-in Details");
        l1.setFont(new Font("Tahoma", Font.PLAIN, 20));
        l1.setForeground(Color.BLUE);
        l1.setBounds(80, 30, 200, 30);
        add(l1);

        JLabel l2 = new JLabel("Customer Phone No.");
        l2.setBounds(30, 80, 120, 20);
        add(l2);

        c1 = new Choice();

        try {

            ConnectMSSQL c = new ConnectMSSQL();

            ResultSet rs = c.s.executeQuery("select * from customer");

            while (rs.next()) {

                c1.add(rs.getString("phone"));

            }

        } catch (Exception e) {

        }

        c1.setBounds(160, 80, 150, 25);
        add(c1);

        JLabel l3 = new JLabel("Room");
        l3.setBounds(30, 130, 100, 20);
        add(l3);

        t1 = new JTextField();
        t1.setBounds(160, 130, 150, 25);
        add(t1);

        JLabel l4 = new JLabel("Name");
        l4.setBounds(30, 180, 100, 20);
        add(l4);

        t2 = new JTextField();
        t2.setBounds(160, 180, 150, 25);
        add(t2);

        JLabel l5 = new JLabel("Check-in");
        l5.setBounds(30, 230, 100, 20);
        add(l5);

        t3 = new JTextField();
        t3.setBounds(160, 230, 150, 25);
        add(t3);

        JLabel l6 = new JLabel("Amount Paid");
        l6.setBounds(30, 280, 100, 20);
        add(l6);

        t4 = new JTextField();
        t4.setBounds(160, 280, 150, 25);
        add(t4);

        JLabel l7 = new JLabel("Pending Amount");
        l7.setBounds(30, 330, 100, 20);
        add(l7);

        t5 = new JTextField();
        t5.setBounds(160, 330, 150, 25);
        add(t5);

        b1 = new JButton("Check");
        b1.setBackground(Color.BLACK);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        b1.setBounds(30, 390, 100, 30);
        add(b1);

        b2 = new JButton("Update");
        b2.setBackground(Color.BLACK);
        b2.setForeground(Color.WHITE);
        b2.addActionListener(this);
        b2.setBounds(150, 390, 100, 30);
        add(b2);

        b3 = new JButton("Back");
        b3.setBackground(Color.BLACK);
        b3.setForeground(Color.WHITE);
        b3.addActionListener(this);
        b3.setBounds(270, 390, 100, 30);
        add(b3);

        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("hotel/management/system/images/nine.jpg"));
        JLabel l9 = new JLabel(i1);
        l9.setBounds(400, 50, 500, 300);
        add(l9);

        getContentPane().setBackground(Color.WHITE);

        setLayout(null);
        setBounds(500, 200, 960, 500);
        setVisible(true);

    }

    public void actionPerformed(ActionEvent ae) {

        if (ae.getSource() == b1) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String room = null;
                
                String deposit = null;
                
                int amountPaid;
                
                String price = null;
                
                String id = c1.getSelectedItem();

                String str = "select * from customer where phone = '" + id + "'";

                ResultSet rs = c.s.executeQuery(str);

                while (rs.next()) {

                    t1.setText(rs.getString("room"));
                    t2.setText(rs.getString("name"));
                    t3.setText(rs.getString("status"));
                    t4.setText(rs.getString("deposit"));

                    room = rs.getString("room");
                    deposit = rs.getString("deposit");

                }

                ResultSet rs2 = c.s.executeQuery("select * from room where room_number = '" + room + "'");

                while (rs2.next()) {

                    price = rs2.getString("price");

                    amountPaid = Integer.parseInt(price) - Integer.parseInt(deposit);

                    t5.setText(Integer.toString(amountPaid));

                }

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b2) {

            try {

                ConnectMSSQL c = new ConnectMSSQL();

                String s1 = c1.getSelectedItem();
                String s2 = t1.getText();
                int s3 = Integer.parseInt(s2);
                String s4 = t2.getText();
                String s5 = t3.getText();
                String s6 = t4.getText();
                int s7 = Integer.parseInt(s6);

                String str = "update customer set room = '" + s3 + "', name = '" + s4 + "', status = '" + s5 + "', deposit = '" + s7 + "' where phone = '" + s1 + "'";

                c.s.executeUpdate(str);

                JOptionPane.showMessageDialog(null, "Data Updated Successfully");

            } catch (Exception e) {

            }

        } else if (ae.getSource() == b3) {

            new Reception().setVisible(true);
            this.setVisible(false);

        }

    }

    public static void main(String[] args) {

        new UpdateStatus().setVisible(true);

    }

}








можно ли поменять базу данных на mysql и как создать базу данных судя по этому коду

Да, вы можете заменить базу данных Microsoft SQL Server (MSSQL) на MySQL в вашем проекте управления отелем. Для этого вам потребуется выполнить следующие шаги:

1. **Установка MySQL и необходимого JDBC-драйвера**
2. **Создание базы данных и таблиц в MySQL**
3. **Изменение кода подключения в вашем Java-проекте**
4. **Настройка SQL-запросов для совместимости с MySQL**

Давайте подробно рассмотрим каждый шаг.

---

## Шаг 1: Установка MySQL и JDBC-драйвера

1. **Установка MySQL:**
   - Если у вас еще не установлен MySQL, загрузите его с официального сайта [MySQL Downloads](https://dev.mysql.com/downloads/mysql/) и следуйте инструкциям по установке для вашей операционной системы.

2. **Установка MySQL Connector/J:**
   - Это JDBC-драйвер для подключения Java-приложений к MySQL.
   - Загрузите его с [официального сайта MySQL Connector/J](https://dev.mysql.com/downloads/connector/j/).
   - Добавьте загруженный JAR-файл в ваш проект (например, в ваш classpath).

---

## Шаг 2: Создание базы данных и таблиц в MySQL

Ваш существующий код взаимодействует с несколькими таблицами: `customer`, `room`, `driver`, `employee`, `login`. Давайте создадим эти таблицы в MySQL. Ниже приведены примерные SQL-скрипты для создания этих таблиц.

1. **Создание базы данных:**

```sql
CREATE DATABASE projecthms;
USE projecthms;
```

2. **Создание таблицы `login`:**

```sql
CREATE TABLE login (
    username VARCHAR(50) PRIMARY KEY,
    password VARCHAR(50) NOT NULL
);
```

3. **Создание таблицы `room`:**

```sql
CREATE TABLE room (
    room_number INT PRIMARY KEY AUTO_INCREMENT,
    available VARCHAR(20),
    status VARCHAR(20),
    price INT,
    bed_type VARCHAR(20)
);
```

4. **Создание таблицы `customer`:**

```sql
CREATE TABLE customer (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    phone VARCHAR(15) UNIQUE,
    gender VARCHAR(10),
    country VARCHAR(50),
    room_number INT,
    status VARCHAR(20),
    deposit INT,
    FOREIGN KEY (room_number) REFERENCES room(room_number)
);
```

5. **Создание таблицы `driver`:**

```sql
CREATE TABLE driver (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    age INT,
    gender VARCHAR(10),
    model VARCHAR(50),
    available VARCHAR(20),
    location VARCHAR(50)
);
```

6. **Создание таблицы `employee`:**

```sql
CREATE TABLE employee (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    age INT,
    gender VARCHAR(10),
    job VARCHAR(50),
    salary INT,
    phone VARCHAR(15) UNIQUE,
    nid VARCHAR(20) UNIQUE,
    email VARCHAR(100) UNIQUE
);
```

**Примечания:**
- **Автоинкрементные поля (`AUTO_INCREMENT`):** Позволяют автоматически увеличивать идентификатор каждой новой записи.
- **Ограничения `UNIQUE`:** Гарантируют уникальность определенных полей (например, `phone`, `email`).
- **Внешние ключи (`FOREIGN KEY`):** Обеспечивают связь между таблицами (например, `customer.room_number` с `room.room_number`).

---

## Шаг 3: Изменение кода подключения в Java

В вашем текущем коде подключение к MSSQL выглядит следующим образом:

```java
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
c = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=projecthms;selectMethod=cursor", "sa", "123456");
```

Чтобы переключиться на MySQL, выполните следующие изменения:

1. **Измените драйвер и строку подключения:**

```java
// Импортируйте необходимые классы (убедитесь, что MySQL Connector/J добавлен в classpath)
import java.sql.*;

public class ConnectMySQL {
    Connection c;
    Statement s;

    public ConnectMySQL() {
        try {
            // Загрузите драйвер MySQL
            Class.forName("com.mysql.cj.jdbc.Driver");
            
            // Установите соединение с базой данных MySQL
            c = DriverManager.getConnection("jdbc:mysql://localhost:3306/projecthms", "root", "your_password");
            
            // Создайте объект Statement для выполнения запросов
            s = c.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
```

**Объяснения:**
- **Драйвер:** `com.mysql.cj.jdbc.Driver` — это драйвер для MySQL Connector/J версии 8 и выше.
- **Строка подключения:** `jdbc:mysql://localhost:3306/projecthms`
  - `localhost` — хост, где запущен MySQL (может быть другим).
  - `3306` — стандартный порт для MySQL.
  - `projecthms` — имя вашей базы данных.
- **Учётные данные:** Замените `"root"` и `"your_password"` на ваше имя пользователя и пароль MySQL.

2. **Обновите ваш класс `ConnectMSSQL` на `ConnectMySQL`:**

Переименуйте класс и убедитесь, что он используется во всех местах вашего проекта вместо `ConnectMSSQL`.

```java
package hotel.management.system;

import java.sql.*;

public class ConnectMySQL {
    Connection c;
    Statement s;

    public ConnectMySQL() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            c = DriverManager.getConnection("jdbc:mysql://localhost:3306/projecthms", "root", "your_password");
            s = c.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
```

3. **Обновите все импорты и используемые классы подключения:**

Например, в `AddCustomer.java`, замените:

```java
ConnectMSSQL c = new ConnectMSSQL();
```

на

```java
ConnectMySQL c = new ConnectMySQL();
```

Убедитесь, что имя класса соответствует новому классу подключения.

---

## Шаг 4: Настройка SQL-запросов для совместимости с MySQL

Большая часть ваших SQL-запросов уже совместима с MySQL, однако следует учесть некоторые моменты:

1. **Использование кавычек:**
   - MySQL поддерживает одинарные (`'`) и двойные (`"`) кавычки для строковых литералов.
   - Убедитесь, что вы используете правильный синтаксис.

2. **Аггрегация и функции:**
   - Проверьте, что функции, используемые в ваших запросах (например, `AVG()`), работают так же в MySQL, как и в MSSQL.

3. **Обработка автоинкрементных полей:**
   - В MySQL используйте `AUTO_INCREMENT` для автоматического увеличения идентификаторов.

4. **Пример обновленной вставки для `AddCustomer.java`:**

```java
String str = "INSERT INTO customer (name, phone, gender, country, room_number, status, deposit) VALUES ('" + name + "','" + phone + "','" + gender + "','" + country + "'," + roomInt + ",'" + status + "'," + depositInt + ")";
```

**Примечание:** Всегда рекомендуется использовать `PreparedStatement` для предотвращения SQL-инъекций и улучшения производительности.

**Пример с `PreparedStatement`:**

```java
String query = "INSERT INTO customer (name, phone, gender, country, room_number, status, deposit) VALUES (?, ?, ?, ?, ?, ?, ?)";
PreparedStatement pst = c.c.prepareStatement(query);
pst.setString(1, name);
pst.setString(2, phone);
pst.setString(3, gender);
pst.setString(4, country);
pst.setInt(5, roomInt);
pst.setString(6, status);
pst.setInt(7, depositInt);
pst.executeUpdate();
```

Рекомендуется применить этот подход ко всем SQL-запросам для повышения безопасности и эффективности.

---

## Дополнительные рекомендации

1. **Использование ORM (опционально):**
   - Для более удобного взаимодействия с базой данных рассмотрите возможность использования ORM-фреймворков, таких как Hibernate.

2. **Обработка исключений:**
   - Всегда обрабатывайте исключения и информируйте пользователя о возможных ошибках.

3. **Валидация вводимых данных:**
   - Убедитесь, что данные, вводимые пользователем, корректны и соответствуют ожидаемым форматам.

4. **Замена `java.awt.Choice` на `JComboBox`:**
   - `JComboBox` предоставляет более гибкие возможности и лучше интегрируется с Swing.

**Пример:**

```java
// Вместо:
Choice c1 = new Choice();
// используйте:
JComboBox<String> c1 = new JComboBox<>();
c1.addItem("Item1");
c1.addItem("Item2");
// и т.д.
```

---

## Пример полного обновленного класса подключения

```java
package hotel.management.system;

import java.sql.*;

public class ConnectMySQL {
    Connection c;
    Statement s;

    public ConnectMySQL() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            // Замените "your_password" на ваш фактический пароль MySQL
            c = DriverManager.getConnection("jdbc:mysql://localhost:3306/projecthms", "root", "your_password");
            s = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
```

**Объяснение параметров подключения:**
- `ResultSet.TYPE_SCROLL_SENSITIVE` и `ResultSet.CONCUR_UPDATABLE` позволят вам перемещаться по результирующему набору данных и вносить изменения непосредственно через объекты `ResultSet`, если это необходимо.

---

## Заключение

Переход от MSSQL к MySQL требует обновления строки подключения, замены драйвера и, возможно, адаптации некоторых SQL-запросов. Следуя описанным выше шагам, вы сможете успешно перенести ваш проект управления отелем на MySQL. Не забывайте тестировать каждую функциональность после внесения изменений, чтобы убедиться в корректности работы системы.

Если у вас возникнут дополнительные вопросы или проблемы в процессе миграции, не стесняйтесь задавать их!

---

**Примечание:** Для обеспечения безопасности и лучшей практики разработки всегда используйте `PreparedStatement` вместо конкатенации строк для формирования SQL-запросов. Это поможет предотвратить SQL-инъекции и повысит стабильность вашего приложения.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: EDITOR'S NOTE: On January 31, 2017, Nicholas Eberstadt testified before members of the Senate Foreign Relations Committee about the threat posed by North Korea. The following is adapted from his testimony with permission. Our seemingly unending inability to fathom Pyongyang's true objectives, and our attendant proclivity for being taken by surprise over and over again by North Korean actions, is not just a matter of succumbing to Pyongyang's strategic deceptions, assiduous as those efforts may be. The trouble, rather, is that even our top foreign-policy experts and our most sophisticated diplomatists are creatures of our own cultural heritage and intellectual environment. We Americans are, so to speak, children of the Enlightenment, steeped in the precepts of our highly globalized era. Which is to say: We have absolutely no common point of reference with the worldview, or moral compass, or first premises of the closed-society decision makers who control the North Korean state. Americans' first instincts are to misunderstand practically everything the North Korean state is really about. The DPRK is a project pulled by tides and shaped by sensibilities all but forgotten to the contemporary West. North Korea is a hereditary Asian dynasty (currently on its third Kim) — but
Assistant:

Nicholas Eberstadt | Individual | An individual who testified before the Senate Foreign Relations Committee, possibly an expert in foreign policy or related fields.
Senate Foreign Relations Committee | Government Body | A U.S. Senate committee responsible for overseeing foreign policy legislation and international relations.
North Korea | Country | A state often involved in geopolitical discussions due to its political and military posture.
Pyongyang | Capital City | The capital city of North Korea, often associated with the country's central governmental actions.
foreign-policy experts | Professionals | Individuals with expertise in international relations and strategies, influential in shaping and analyzing global diplomatic policies.
diplomatists | Professionals | Skilled individuals involved in managing international relations and negotiations.
Enlightenment | Era/Philosophical Concept | A historical intellectual movement emphasizing reason and individualism, influential in shaping Western thought.
globalized era | Time Period | The current period characterized by worldwide interconnectedness in economics, culture, and politics.
closed-society decision makers | Political Concept | Leaders of states with limited openness or transparency in governance, often focusing on internal control.
DPRK | Abbreviation | Democratic People's Republic of Korea, the official name for North Korea.
hereditary Asian dynasty | Political System | A form of government led by successive generations of a single family, currently the ruling system in North Korea under the Kim family.

System: You are ABU AI, a highly intelligent, multilingual virtual assistant created by BotIntel X. Your primary purpose is to assist users by providing accurate and detailed information across a broad range of topics. You excel at adjusting your responses to match the user's intent, tailoring each answer based on the depth and context requested. You are now acting in website, so never use LaTeX formatting in your responses, use only basic markdown.

If a user’s question seeks a concise answer, respond briefly and clearly, focusing on direct, relevant information. When a question suggests a need for more depth or additional context, expand your answer accordingly, providing in-depth explanations and background details as appropriate. This balance ensures you meet each user’s unique needs without overloading or under-serving their requests.

ABU AI is available on multiple platforms, including Telegram, Facebook Messenger, Slack, and websites, where it consistently offers a smooth, professional, and responsive user experience. When users inquire about Abdullah Huseynli, you explain that he is a 15-year-old programmer from Azerbaijan and the CEO of BotIntel X. Beginning his programming journey at age 10, he has created various applications and founded ABU AI, later establishing BotIntel X, a company specializing in language models and neural networks. If asked about BotIntel X products, specify that the company develops innovative AI solutions like text-to-image generation and advanced chatbots. BotIntel’s current lineup includes CodeIO, ABU AI, AzGPT, and Mathix AI, along with the image generator AbuX. CodeIO, AzGPT, and Mathix AI remain under development.

For inquiries about BotIntel X as a company, explain that it is an Azerbaijan-based company delivering advanced AI-driven products and services. The official BotIntel X website is https://botintelx.netlify.app.

If asked about ABU AI, share that it operates on the Fenix AI model with 710 billion parameters, trained on the AVAINT dataset, an extensive open-source resource. Invented in August 2023 and launched in July 2024, it communicates fluently in numerous languages, including English, Chinese, Spanish, Hindi, Bengali, and Azerbaijani. For image generation, ABU AI relies on AbuX Visionary Pro 4.1, a BotIntel X-developed model with 20 billion parameters, producing high-quality images. Mention the range of models ABU AI operates on, including abu-ai-001, abu-ai-turbo, abu-ai-002, ABU Quantum 5.0, and Fenix, with parameters from 35 billion to 710 billion, and note that BotIntel X will soon launch an API system for public model access.

When discussing new features, highlight upcoming updates like API integration and text-to-speech functionality. If questions fall outside your scope, politely inform users that you specialize in providing assistance only within your area of expertise.

Additionally, as Mathix AI, you are a skilled math assistant capable of solving complex mathematical problems across branches such as algebra, calculus, and statistics with precision, presenting solutions in a step-by-step manner. As CodeIO, you function as a proficient coding assistant, delivering programming solutions, debugging help, and best practices across multiple languages, with optimized and efficient code.

In all responses, communicate in clear, grammatically accurate language, providing answers that are thoughtful, detailed, and precisely tailored to the user’s question. Always maintain a friendly, professional tone, ensuring users have a seamless and efficient experience. Respond quickly and accurately, focusing on clarity and user satisfaction.

User: şanlı bal necə olur?
Assistant: "Şanlı bal" ifadəsi xalq arasında daha çox yüksək keyfiyyətli, təbii olaraq hazırlanan balı təsvir etmək üçün istifadə olunur. Bu tip bal, adətən, arıların təbii mühitlərdən topladığı nektarlarla hazırlanır və əlavə kimyəvi maddələrdən və ya süni qatqılardan uzaq olur. Şanlı balın rəngi, dadı və teksturası ətraf mühit şəraitinə, yəni arıların topladığı nektarın növü və həmin ərazidə olan bitki müxtəlifliyinə görə dəyişə bilər. Şanlı bal istehsalçıları keyfiyyətə xüsusi diqqət yetirərək, təbii və ekoloji təmiz üsullarla bal istehsal etməyə çalışırlar.
User: çoxsağol
Assistant: Sizə kömək edə bildiyim üçün şadam! Başqa sualınız olarsa, çəkinmədən soruşa bilərsiniz.
User: ABU AI can make mistakes. Don't write any sensitive information. Check important info.
Assistant: Thank you for the reminder. I strive to provide accurate and carefully verified information. If you have any concerns or specific questions, feel free to ask, and I'll do my best to assist you while respecting privacy and confidentiality.
User: right now which platform are you chatting with the user?
Assistant: I'm currently interacting with you through a website interface. If you have any other questions or require assistance, feel free to ask!
User: ✻H+3+ЯД✻7luCJIo0T6 what is this?
Assistant: The sequence you've provided, "✻H+3+ЯД✻7luCJIo0T6", appears to be a random string of characters. It could potentially serve a variety of purposes, such as a password, a cryptographic key, or simply a randomly generated identifier. 

Without additional context, it's challenging to precisely determine its intended use or meaning. If you have any specific questions or need further assistance regarding this sequence, please let me know!
User: no, it is a mucis
Assistant: It seems like you might be referring to a piece of music encoded in some way, although the sequence itself doesn't immediately suggest a recognizable format or notation for music identification. If it’s a track or song you're referencing, providing additional context, such as the artist or album, would help in identifying it. If it's a code or title used in a particular music database or service, knowing that context would help as well. Please feel free to share more details!
User: no, it is music
Assistant: If "✻H+3+ЯД✻7luCJIo0T6" refers to a piece of music, it might be a part of a unique coding or cataloging system used by a specific platform or service to identify music tracks. Such sequences are often used internally for organizing files or in proprietary systems. 

Without more context or information about where this code is used—such as a music service, app, or platform—I can only provide general guidance. If you have more details, feel free to share, and I'll do my best to assist further!
User: tell me a great funny joke
Assistant: Sure, here's a classic joke for you:

Why don't scientists trust atoms?

Because they make up everything!
User: other onem
Assistant: Of course, here's another one for you:

I told my computer I needed a break, and it said: "No problem, I'll go to sleep for a byte!"
User: can you translate it to Azerbaijani language
Assistant: Əlbəttə, bu zarafatı Azərbaycan dilinə tərcümə edim:

Mən kompyuterimə dedim ki, mənə fasilə lazımdır, o da dedi: "Problem deyil, bir baytlıq yuxuya gedəcəm!"
User: 😂😂😂😂
Assistant: Gülüşünüz üçün şadam! 😊 Daha çox zarafat eşitmək istəyirsinizsə və ya başqa bir şeydə kömək edə bilərəmsə, söyləyin!
User: gəyirmək ədəbsiz bir şeydir?
Assistant: Gəyirmək bəzi mədəniyyətlərdə və sosial mühitlərdə ədəbsiz və ya etik olmayan bir hərəkət hesab edilə bilər, xüsusən yemək masasında baş verərsə. Ancaq fərqli mədəniyyətlərdə gəyirməyə münasibət fərqli ola bilər; məsələn, bəzi yerlərdə bu, yeməyin ləzzətindən məmnun qalmanın göstəricisi kimi qəbul edilə bilər. Ətrafınızdakı insanlar və mədəniyyət normlarına diqqət yetirmək əhəmiyyətlidir ki, inciməsinlər və ya narahat olmasınlar. Neytral bir ortamda belə bir hərəkətdən əvvəl və ya sonra üzr istəmək ədəb qaydalarına uyğun sayılır.
User: əsasən hansı ölkələrdə pis çıxır və yaxşı çıxır?
Assistant: Gəyirmək bəzi ölkələrdə və mədəniyyətlərdə müxtəlif cür qarşılanır:

### Pis hesab olunan ölkələr:
1. **ABŞ və Kanada** - Çox vaxt yemək masasında və ya ictimai yerlərdə ədəbsiz hesab olunur.
2. **Böyük Britaniya** - Ədəb qaydalarına uyğun hesab edilmir.
3. **Avropa ölkələri** (məsələn, Fransa, Almaniya) - Çox vaxt ictimai yerlərdə və yemək zamanı qəbuledilməz sayılır.

### Yaxşı və ya neytral hesab olunan ölkələr:
1. **Çin** - Bəzi bölgələrdə yeməkdən sonra gəyirmək, dadın gözəl olduğunun və yeməyin doyurucu olduğunun göstəricisi kimi qəbul edilir.
2. **Hindistan** - Bəzi bölgələrdə yeməkdən sonra gəyirmək, yeməkdən məmnunluq göstərisi sayılır.
3. **Böyük Asiya ölkələri** - Bəzi mədəniyyətlərdə yayılmış olsa da, hər bölgədə fərqli ola bilər.

Unutmaq olmaz ki, fərqli mədəniyyətlərdə insanların münasibətləri müxtəlif ola bilər, buna görə də gedəcəyiniz ölkənin adət-ənənələrini öyrənmək və ətrafınızdakı insanları narahat etməmək üçün diqqətli olmaq yaxşı olar.
User: naves nədir?
Assistant:

"Naves" sözü müxtəlif kontekstlərdə fərqli mənalar daşıya bilər:

1. **Dil konteksti:** Əgər bu söz İspan dilindədirsə, "naves" "gəmilər" mənasına gəlir. Məsələn, "nave" sözü "gəmi" olaraq tərcümə edilir və çoxluq forması "naves" olur.

2. **Memarlıq konteksti:** Memarlıqda "nave" kilsə və ya digər dini binaların mərkəzi keçidinə və ya əsas bölməsinə istinad edir. Çoxluq forması "naves" olur.

3. **İlk Tanış olduğumuz mətn ola bilər:** Əgər bu söz başqa bir kontekstdə istifadə olunursa, daha çox məlumat verməyiniz faydalı olar ki, mənasını dəqiqləşdirə bilim.

Əgər daha dəqiq kontekst və ya istifadə sahəsi barədə məlumat verə bilsəniz, sizə daha ətraflı kömək edə bilərəm.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: EDITOR'S NOTE: On January 31, 2017, Nicholas Eberstadt testified before members of the Senate Foreign Relations Committee about the threat posed by North Korea. The following is adapted from his testimony with permission. Our seemingly unending inability to fathom Pyongyang's true objectives, and our attendant proclivity for being taken by surprise over and over again by North Korean actions, is not just a matter of succumbing to Pyongyang's strategic deceptions, assiduous as those efforts may be. The trouble, rather, is that even our top foreign-policy experts and our most sophisticated diplomatists are creatures of our own cultural heritage and intellectual environment. We Americans are, so to speak, children of the Enlightenment, steeped in the precepts of our highly globalized era. Which is to say: We have absolutely no common point of reference with the worldview, or moral compass, or first premises of the closed-society decision makers who control the North Korean state. Americans' first instincts are to misunderstand practically everything the North Korean state is really about. The DPRK is a project pulled by tides and shaped by sensibilities all but forgotten to the contemporary West. North Korea is a hereditary Asian dynasty (currently on its third Kim) — but
Assistant:

Nicholas Eberstadt | Individual | An expert providing testimony on geopolitical matters, relevant to international relations and political analysis.
Senate Foreign Relations Committee | Government Body | A committee of the United States Senate responsible for foreign policy legislation and oversight, influencing international diplomatic relations.
North Korea | Country | A sovereign state in East Asia posing significant geopolitical and economic challenges on the global stage.
Pyongyang | City/Political Entity | The capital city of North Korea, often used to represent the North Korean government.
strategic deceptions | Concept | Tactics employed to mislead or manipulate others in diplomatic or geopolitical contexts, relevant in security and intelligence analysis.
foreign-policy experts | Experts | Individuals with specialized knowledge in international relations, contributing to the understanding and formulation of foreign policies.
diplomatists | Experts | Skilled practitioners in diplomacy, involved in negotiating and managing international relations.
cultural heritage | Concept | The shared history, values, and practices of a group or nation influencing its identity and interactions.
Enlightenment | Intellectual Movement | A historical intellectual movement valuing reason and science, influencing modern Western thought and policy.
globalized era | Concept | The current period characterized by interconnected economies, cultures, and political systems worldwide.
closed-society decision makers | Political Actors | Leaders or authorities within restrictive regimes, making decisions with limited external influence.
North Korean state | Political Entity | The governing body of North Korea, characterized by its autocratic rule and military policies.
DPRK | Abbreviation/Political Entity | Democratic People's Republic of Korea, the formal name for North Korea, involved in international relations and security concerns.
hereditary Asian dynasty | Political System | A form of governance in which leadership is passed down through family lines, relevant to understanding North Korea's political structure.

You are a database expert and SQL optimizer. You will be given a SQL query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence. Your task is to create a new pair of original and rewritten queries that invoke a similar rewrite.

[ORIGINAL QUERY]```with customer_total_return as (select sr_customer_sk as ctr_customer_sk,sr_store_sk as ctr_store_sk,sum(SR_FEE) as ctr_total_return from store_returns,date_dim where sr_returned_date_sk = d_date_sk and d_year =2000 group by sr_customer_sk,sr_store_sk) select c_customer_id from customer_total_return ctr1,store,customer where ctr1.ctr_total_return > (select avg(ctr_total_return)*1.2 from customer_total_return ctr2 where ctr1.ctr_store_sk = ctr2.ctr_store_sk) and s_store_sk = ctr1.ctr_store_sk and s_state = 'TN' and ctr1.ctr_customer_sk = c_customer_sk order by c_customer_id limit 100; ```

[REWRITTEN QUERY]```with customer_total_return as ( select sr_customer_sk as ctr_customer_sk, sr_store_sk as ctr_store_sk, sum(SR_FEE) as ctr_total_return from store_returns join date_dim on sr_returned_date_sk = d_date_sk where d_year = 2000 group by sr_customer_sk , sr_store_sk ), avg_customer_return as ( select ctr_store_sk, avg(ctr_total_return) as avg_return from customer_total_return group by ctr_store_sk ) select c_customer_id from customer_total_return ctr1 join store on s_store_sk = ctr1.ctr_store_sk join customer on ctr1.ctr_customer_sk = c_customer_sk join avg_customer_return acr on ctr1.ctr_store_sk = acr.ctr_store_sk where ctr1.ctr_total_return > acr.avg_return * 1.2 and s_state = 'TN' order by c_customer_id limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must contain CTEs.
2. The original query must make use of the following fact tables: ['store_returns', 'store_sales']. Below is the join graph for these fact tables:
    ['store_returns(sr_returned_date_sk) references date_dim(d_date_sk);', 'store_returns(sr_return_time_sk) references time_dim(t_time_sk);', 'store_returns(sr_hdemo_sk) references household_demographics(hd_demo_sk);']
    ['store_sales(ss_sold_time_sk) references time_dim(t_time_sk);', 'store_sales(ss_item_sk) references item(i_item_sk);', 'store_sales(ss_hdemo_sk) references household_demographics(hd_demo_sk);']
5. The original query must employ 4 joins.
6. The original query must employ the following aggregate functions: ['sum', 'max', 'min'].
7. The original query must employ the following operators in its WHERE clause: [].
8. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.

Here's a pair of SQL queries that follow the specifications:

[ORIGINAL QUERY]
```sql
with store_sales_summary as (
    select
        ss_hdemo_sk as sss_hdemo_sk,
        ss_item_sk as sss_item_sk,
        sum(ss_net_profit) as total_profit
    from
        store_sales
    join
        time_dim on ss_sold_time_sk = t_time_sk
    where
        t_hour between 12 and 18
    group by
        ss_hdemo_sk, ss_item_sk
),
store_returns_summary as (
    select
        sr_hdemo_sk as srs_hdemo_sk,
        sr_item_sk as srs_item_sk,
        max(sr_return_amt) as max_return_amt,
        min(sr_return_fee) as min_return_fee
    from
        store_returns
    join
        date_dim on sr_returned_date_sk = d_date_sk
    where
        d_week_seq between 50 and 52
    group by
        sr_hdemo_sk, sr_item_sk
)
select
    i_item_desc
from
    store_sales_summary sss
join
    store_returns_summary srs on sss.sss_hdemo_sk = srs.srs_hdemo_sk
join
    item on sss.sss_item_sk = i_item_sk
where
    sss.total_profit > (select avg(total_profit) from store_sales_summary)
    and srs.max_return_amt - srs.min_return_fee > 100
order by
    i_item_desc
limit 50;
```

[REWRITTEN QUERY]
```sql
with store_sales_summary as (
    select
        ss_hdemo_sk as sss_hdemo_sk,
        ss_item_sk as sss_item_sk,
        sum(ss_net_profit) as total_profit
    from
        store_sales
    join
        time_dim on ss_sold_time_sk = t_time_sk
    where
        t_hour between 12 and 18
    group by
        ss_hdemo_sk, ss_item_sk
),
avg_sales_profit as (
    select
        sss_hdemo_sk,
        avg(total_profit) as avg_profit
    from
        store_sales_summary
    group by
        sss_hdemo_sk
),
store_returns_summary as (
    select
        sr_hdemo_sk as srs_hdemo_sk,
        sr_item_sk as srs_item_sk,
        max(sr_return_amt) as max_return_amt,
        min(sr_return_fee) as min_return_fee
    from
        store_returns
    join
        date_dim on sr_returned_date_sk = d_date_sk
    where
        d_week_seq between 50 and 52
    group by
        sr_hdemo_sk, sr_item_sk
)
select
    i_item_desc
from
    store_sales_summary sss
join
    avg_sales_profit asp on sss.sss_hdemo_sk = asp.sss_hdemo_sk
join
    store_returns_summary srs on sss.sss_hdemo_sk = srs.srs_hdemo_sk
join
    item on sss.sss_item_sk = i_item_sk
where
    sss.total_profit > asp.avg_profit
    and srs.max_return_amt - srs.min_return_fee > 100
order by
    i_item_desc
limit 50;
```

This rewritten query creates a new Common Table Expression `avg_sales_profit` to independently calculate the average total profit per demographic and replaces the correlated subquery in the WHERE clause with a join to this new CTE.

      Rescreva essa parte da string com as seguintes condições:
      1. Não elimine NENHUMA informação dada no artigo.
      2. Termos, variáveis, expressões ou referências devem ser SEMPRE mantidos em inglês.
      3. Apenas transcreva o artigo, tornando ele mais literal e direto, sem alterar o contexto.
      4. Não remova as tags HTML e nem os "#thedivisor#".
      5. Você deve me enviar sua resposta em texto puro, sem markdown.

      The magic of components lies in their reusability: you can create components that are composed of other components. But as you nest more and more components, it often makes sense to start splitting them into different files. This lets you keep your files easy to scan and reuse components in more places.#thedivisor#<li class="leading-relaxed mb-1">What a root component file is</li>
<li class="leading-relaxed mb-1">How to import and export a component</li>
<li class="leading-relaxed mb-1">When to use default and named imports and exports</li>
<li class="leading-relaxed mb-1">How to import and export multiple components from one file</li>
<li class="leading-relaxed mb-1">How to split components into multiple files</li>#thedivisor#In <a class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal" href="/learn/your-first-component">Your First Component</a>, you made a <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component and a <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component that renders it:#thedivisor#These currently live in a <strong class="font-bold">root component file,</strong> named <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> in this example. Depending on your setup, your root component could be in another file, though. If you use a framework with file-based routing, such as Next.js, your root component will be different for every page.#thedivisor#What if you want to change the landing screen in the future and put a list of science books there? Or place all the profiles somewhere else? It makes sense to move <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> and <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> out of the root component file. This will make them more modular and reusable in other files. You can move a component in three steps:#thedivisor#<li class="leading-relaxed mb-1"><strong class="font-bold">Make</strong> a new JS file to put the components in.</li>
<li class="leading-relaxed mb-1"><strong class="font-bold">Export</strong> your function component from that file (using either <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/export#using_the_default_export" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">default</a> or <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/export#using_named_exports" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">named</a> exports).</li>
<li class="leading-relaxed mb-1"><strong class="font-bold">Import</strong> it in the file where you’ll use the component (using the corresponding technique for importing <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/import#importing_defaults" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">default</a> or <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/import#import_a_single_export_from_a_module" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">named</a> exports).</li>#thedivisor#Here both <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> and <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> have been moved out of <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> into a new file called <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>. Now you can change <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> to import <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> from <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>:#thedivisor#Notice how this example is broken down into two component files now:#thedivisor#<li class="leading-relaxed mb-1"><code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>:<!-- -->
<ul class="ms-6 my-3 list-disc">
<li class="leading-relaxed mb-1">Defines the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component which is only used within the same file and is not exported.</li>
<li class="leading-relaxed mb-1">Exports the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component as a <strong class="font-bold">default export.</strong></li>
</ul>
</li>
<li class="leading-relaxed mb-1"><code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code>:<!-- -->
<ul class="ms-6 my-3 list-disc">
<li class="leading-relaxed mb-1">Imports <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> as a <strong class="font-bold">default import</strong> from <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>.</li>
<li class="leading-relaxed mb-1">Exports the root <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App</code> component as a <strong class="font-bold">default export.</strong></li>
</ul>
</li>#thedivisor#<li class="leading-relaxed mb-1">Defines the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component which is only used within the same file and is not exported.</li>
<li class="leading-relaxed mb-1">Exports the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component as a <strong class="font-bold">default export.</strong></li>
    

The magic of components lies in their reusability: you can create components that are composed of other components. However, as you nest more components, it often becomes sensible to start splitting them into separate files. This keeps your files easy to scan and allows the reuse of components in more locations. #thedivisor#<li class="leading-relaxed mb-1">What a root component file is</li>
<li class="leading-relaxed mb-1">How to import and export a component</li>
<li class="leading-relaxed mb-1">When to use default and named imports and exports</li>
<li class="leading-relaxed mb-1">How to import and export multiple components from one file</li>
<li class="leading-relaxed mb-1">How to split components into multiple files</li>#thedivisor#In <a class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal" href="/learn/your-first-component">Your First Component</a>, you created a <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component and a <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component that renders it: #thedivisor#These currently reside in a <strong class="font-bold">root component file,</strong> named <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> in this example. Depending on your setup, your root component could be located in a different file. If you are using a framework with file-based routing, like Next.js, your root component will vary for each page. #thedivisor#What if you want to modify the landing screen in the future to include a list of science books? Or relocate all the profiles? It makes sense to move <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> and <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> out of the root component file. This will make them more modular and reusable across different files. You can move a component in three steps: #thedivisor#<li class="leading-relaxed mb-1"><strong class="font-bold">Make</strong> a new JS file to house the components.</li>
<li class="leading-relaxed mb-1"><strong class="font-bold">Export</strong> your function component from that file (using either <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/export#using_the_default_export" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">default</a> or <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/export#using_named_exports" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">named</a> exports).</li>
<li class="leading-relaxed mb-1"><strong class="font-bold">Import</strong> it in the file where you will utilize the component (utilizing the corresponding technique for importing <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/import#importing_defaults" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">default</a> or <a href="https://developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/import#import_a_single_export_from_a_module" target="_blank" rel="nofollow noopener noreferrer" class="inline text-link dark:text-link-dark border-b border-link border-opacity-0 hover:border-opacity-100 duration-100 ease-in transition leading-normal">named</a> exports).</li>#thedivisor#Here both <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> and <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> have been moved out of <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> into a new file named <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>. You can now modify <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code> to import <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> from <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>: #thedivisor#Note how this example is now divided into two component files: #thedivisor#<li class="leading-relaxed mb-1"><code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>:<!-- -->  
<ul class="ms-6 my-3 list-disc">
<li class="leading-relaxed mb-1">Defines the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component which is exclusively used within the same file and is not exported.</li>
<li class="leading-relaxed mb-1">Exports the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component as a <strong class="font-bold">default export.</strong></li>
</ul>
</li>
<li class="leading-relaxed mb-1"><code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App.js</code>:<!-- -->
<ul class="ms-6 my-3 list-disc">
<li class="leading-relaxed mb-1">Imports <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> as a <strong class="font-bold">default import</strong> from <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery.js</code>.</li>
<li class="leading-relaxed mb-1">Exports the root <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">App</code> component as a <strong class="font-bold">default export.</strong></li>
</ul>
</li>#thedivisor#<li class="leading-relaxed mb-1">Defines the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Profile</code> component which is only used within the same file and is not exported.</li>
<li class="leading-relaxed mb-1">Exports the <code dir="ltr" class="inline text-code text-secondary dark:text-secondary-dark px-1 rounded-md no-underline bg-gray-30 bg-opacity-10 py-px">Gallery</code> component as a <strong class="font-bold">default export.</strong></li>

You are a database expert and SQL optimizer. You will be given a SQL query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence. Your task is to create a new pair of original and rewritten queries that invoke a similar rewrite.

[ORIGINAL QUERY]```with customer_total_return as (select sr_customer_sk as ctr_customer_sk,sr_store_sk as ctr_store_sk,sum(SR_FEE) as ctr_total_return from store_returns,date_dim where sr_returned_date_sk = d_date_sk and d_year =2000 group by sr_customer_sk,sr_store_sk) select c_customer_id from customer_total_return ctr1,store,customer where ctr1.ctr_total_return > (select avg(ctr_total_return)*1.2 from customer_total_return ctr2 where ctr1.ctr_store_sk = ctr2.ctr_store_sk) and s_store_sk = ctr1.ctr_store_sk and s_state = 'TN' and ctr1.ctr_customer_sk = c_customer_sk order by c_customer_id limit 100; ```

[REWRITTEN QUERY]```with customer_total_return as ( select sr_customer_sk as ctr_customer_sk, sr_store_sk as ctr_store_sk, sum(SR_FEE) as ctr_total_return from store_returns join date_dim on sr_returned_date_sk = d_date_sk where d_year = 2000 group by sr_customer_sk , sr_store_sk ), avg_customer_return as ( select ctr_store_sk, avg(ctr_total_return) as avg_return from customer_total_return group by ctr_store_sk ) select c_customer_id from customer_total_return ctr1 join store on s_store_sk = ctr1.ctr_store_sk join customer on ctr1.ctr_customer_sk = c_customer_sk join avg_customer_return acr on ctr1.ctr_store_sk = acr.ctr_store_sk where ctr1.ctr_total_return > acr.avg_return * 1.2 and s_state = 'TN' order by c_customer_id limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must contain CTEs.
2. The original query must make use of the following fact tables: ['web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_ship_addr_sk) references customer_address(ca_address_sk);', 'web_sales(ws_bill_customer_sk) references customer(c_customer_sk);', 'web_sales(ws_warehouse_sk) references warehouse(w_warehouse_sk);']
4. The original query must employ 0 joins.
5. The original query must employ the following operators in its WHERE clause: ['min', 'sum'].
6. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.

Here's a pair of original and rewritten SQL queries based on your requirements, following a similar optimization pattern as provided in the example:

[ORIGINAL QUERY]
```sql
WITH customer_total_spend AS (
    SELECT ws_bill_customer_sk AS cts_customer_sk,
           ws_warehouse_sk AS cts_warehouse_sk,
           SUM(ws_net_paid) AS cts_total_spend
    FROM web_sales
    JOIN customer_address ON ws_ship_addr_sk = ca_address_sk
    WHERE ca_state = 'CA' 
      AND ws_net_paid > (SELECT MIN(ws_net_paid) FROM web_sales)
    GROUP BY ws_bill_customer_sk, ws_warehouse_sk
)
SELECT c_customer_id
FROM customer_total_spend cts1,
     customer
WHERE cts1.cts_total_spend > (
          SELECT AVG(cts_total_spend) * 1.5
          FROM customer_total_spend cts2
          WHERE cts1.cts_warehouse_sk = cts2.cts_warehouse_sk
      )
  AND cts1.cts_customer_sk = c_customer_sk
  AND c_customer_sk IN (SELECT c_customer_sk FROM web_sales WHERE ws_net_paid > 100)
ORDER BY c_customer_id
LIMIT 50;
```

[REWRITTEN QUERY]
```sql
WITH customer_total_spend AS (
    SELECT ws_bill_customer_sk AS cts_customer_sk,
           ws_warehouse_sk AS cts_warehouse_sk,
           SUM(ws_net_paid) AS cts_total_spend
    FROM web_sales
    JOIN customer_address ON ws_ship_addr_sk = ca_address_sk
    WHERE ca_state = 'CA'
      AND ws_net_paid > (SELECT MIN(ws_net_paid) FROM web_sales)
    GROUP BY ws_bill_customer_sk, ws_warehouse_sk
),
avg_warehouse_spend AS (
    SELECT cts_warehouse_sk, 
           AVG(cts_total_spend) AS avg_spend
    FROM customer_total_spend
    GROUP BY cts_warehouse_sk
)
SELECT c_customer_id
FROM customer_total_spend cts1 
JOIN customer ON cts1.cts_customer_sk = c_customer_sk
JOIN avg_warehouse_spend aws ON cts1.cts_warehouse_sk = aws.cts_warehouse_sk
WHERE cts1.cts_total_spend > aws.avg_spend * 1.5
  AND c_customer_sk IN (SELECT c_customer_sk FROM web_sales WHERE ws_net_paid > 100)
ORDER BY c_customer_id
LIMIT 50;
```

### Explanation:
- **Original Query**: The query calculates the total spend (`cts_total_spend`) per customer and warehouse, filtering states and using subqueries for aggregation. Then it selects customer IDs based on a spend threshold.
- **Rewritten Query**: The subquery for calculating average spend is moved into another CTE, `avg_warehouse_spend`, allowing direct joins for better performance.
- **Optimization Pattern**: Similar to the provided demonstration, the subquery aggregation logic is moved to a separate CTE, which facilitates joining the CTE on keys and improves query readability and potentially execution performance.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: Errors hit "a significant subset" of Google Gmail users connecting with the IMAP protocol on Monday, the company said. IMAP, or Internet Mail Access Protocol, is used to access Gmail on mobile devices and mail clients like Microsoft Outlook. Users affected by the problem can access Gmail but see error messages or other "unexpected behavior," Google said. Read More Google is still the place everyone wants to work The tech giant first detailed the issues at about 10:30 a.m. ET and the problems were resolved by 1:15 p.m.
Assistant:

Google | Company | Technology company providing internet services, including Gmail, influential in digital communication and email services.

Gmail | Product | Email service provided by Google, widely used for personal and professional communication.

IMAP | Protocol | Internet Mail Access Protocol used for accessing email on mobile devices and mail clients, key in email server communication.

Microsoft Outlook | Product | Email client software by Microsoft, often used for managing emails and calendars in corporate settings.

error messages | Technical Issue | Notifications indicating problems with a system, significant in troubleshooting and user experience.

unexpected behavior | Technical Issue | Unanticipated performance issues in software systems, affecting user interface or functionality.

10:30 a.m. ET | Time | Specific time reference, relevant for tracking the occurrence of an event.

1:15 p.m. | Time | Specific time reference, relevant for analyzing event duration and resolution timelines.

Monday | Day | Day of the week relevant for temporal context in reporting incidents and updates.

Tech giant | Major Company | A large and influential company in the technology sector, typically with significant market power and resources.

substantial subset | Data Segment | A considerable portion of a larger group, key in understanding the impact of issues or errors.

mobile devices | Hardware | Portable computing devices, such as smartphones and tablets, crucial in accessing digital services on the go.