{"behavior":"degenerate_repetition","label_filter":null,"limit":10,"next_offset":17822,"offset":17812,"previous_offset":null,"rows":[{"assistant_initiates":false,"asst_text":"[ORIGINAL QUERY]\n```sql\nselect w_warehouse_name, i_item_desc\nfrom inventory inv, warehouse w, item i\nwhere inv.inv_warehouse_sk = w.w_warehouse_sk\n and inv.inv_item_sk = i.i_item_sk\n and inv.inv_date_sk in (select d_date_sk from date_dim where d_year = 2000)\n and inv.inv_quantity_on_hand > (select avg(inv_quantity_on_hand) * 1.2 from inventory where inv_warehouse_sk = inv.inv_warehouse_sk)\ngroup by w.warehouse_name, i_item_desc\nhaving count(inv_quantity_on_hand) > 50\norder by min(inv_quantity_on_hand) desc limit 50;\n```\n\n[REWRITTEN QUERY]\n```sql\nwith avg_inventory as (\n select inv_warehouse_sk, avg(inv_quantity_on_hand) as avg_on_hand\n from inventory\n group by inv_warehouse_sk\n),\nfiltered_inventory as (\n select inv_warehouse_sk, inv_item_sk, inv_quantity_on_hand\n from inventory\n where inv_date_sk in (select d_date_sk from date_dim where d_year = 2000)\n),\naggregated_filtered_inventory as (\n 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\n from filtered_inventory fi\n join avg_inventory ai on fi.inv_warehouse_sk = ai.inv_warehouse_sk\n where fi.inv_quantity_on_hand > ai.avg_on_hand * 1.2\n group by inv_warehouse_sk, inv_item_sk\n having count(inv_quantity_on_hand) > 50\n)\nselect w.warehouse_name, i.item_desc\nfrom aggregated_filtered_inventory afi\njoin warehouse w on afi.inv_warehouse_sk = w.w_warehouse_sk\njoin item i on afi.inv_item_sk = i.i_item_sk\norder by afi.min_on_hand desc limit 50;\n```","behavior":"degenerate_repetition","conversation_hash":"b735b95155eec2138038a785cfb1394d","conversation_redacted":false,"conversation_toxic":false,"country":"Japan","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":4177,"n_turns_in_conversation":1,"n_words":502,"source_row_offset":17812,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:02:55 GMT","turn_id":"1b29a94ee90aacb3ff0d4a48","turn_index":0,"user_text":"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.\n\n[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; ```\n\n[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;```\n\nNow, 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:\n1. The original query must not have any CTEs.\n2. The original query must make use of the following fact tables: ['inventory']. Below is the join graph for these fact tables:\n ['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);']\n4. The original query must employ 3 joins.\n5. The original query must employ the following aggregate functions: ['min', 'max', 'count'].\n6. The original query must employ the following operators in its WHERE clause: ['avg', 'count'].\n7. 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 ```."},{"assistant_initiates":false,"asst_text":"Google | Company | Technology company known for its search engine and digital services, significant player in digital communication and data services. \nGmail | Digital Service | Email service provided by Google, widely used for personal and professional communication. \nIMAP | Communication Protocol | Internet Mail Access Protocol used for retrieving email messages from a server, important for email client and mobile access. \nMicrosoft Outlook | Email Client | Email client software developed by Microsoft, often used in corporate environments for communication and scheduling. \nunexpected behavior | Technical Issue | Unanticipated performance issues affecting software or systems, potentially impacting user experience and trust. \nET | Time Zone | Eastern Time, a time zone important for coordinating communication and events across regions.","behavior":"degenerate_repetition","conversation_hash":"5e2fb8cbe30e0ed0e0e800a50cd9f914","conversation_redacted":false,"conversation_toxic":false,"country":"China","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":4929,"n_turns_in_conversation":1,"n_words":729,"source_row_offset":17813,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:11 GMT","turn_id":"a3723389f009899d08ab2211","turn_index":0,"user_text":"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.\n\nEnsure the following:\nLabel All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.\nDefine New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.\nProvide an Exhaustive Entity List: Include every relevant label mentioned in the input text.\n\nAnswer in the following format:\n | | ,\n | | ,\n...\n\nHere is an Example : \nInput: \nLawmakers continue to try to police social media use among teens \u2014 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.\n\nOutput:\nLawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments. \nsocial media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.\nMeta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors. \nFacebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets. \nInstagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement. \nThreads | Company | Social media platform owned by Meta, contributing to the digital communication landscape. \nNov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. \ntech giants | Major Companies | Entities that hold substantial market power in the technology sector. \nGoogle | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution. \nApple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution. \nbigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company\u2019s operations, often resulting in resource strain or inefficiencies.\nApple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics. \nGoogle Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics. \nParental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage. \nThe Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.\nUser: 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.\nAssistant:"},{"assistant_initiates":false,"asst_text":"\u0414\u0430, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0437\u0430\u043c\u0435\u043d\u0438\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server (MSSQL) \u043d\u0430 MySQL \u0432 \u0432\u0430\u0448\u0435\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u0435 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043e\u0442\u0435\u043b\u0435\u043c. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0432\u0430\u043c \u043f\u043e\u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0448\u0430\u0433\u0438:\n\n1. **\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 MySQL \u0438 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0433\u043e JDBC-\u0434\u0440\u0430\u0439\u0432\u0435\u0440\u0430**\n2. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 MySQL**\n3. **\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043a\u043e\u0434\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0432 \u0432\u0430\u0448\u0435\u043c Java-\u043f\u0440\u043e\u0435\u043a\u0442\u0435**\n4. **\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0434\u043b\u044f \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 MySQL**\n\n\u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043a\u0430\u0436\u0434\u044b\u0439 \u0448\u0430\u0433.\n\n---\n\n## \u0428\u0430\u0433 1: \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 MySQL \u0438 JDBC-\u0434\u0440\u0430\u0439\u0432\u0435\u0440\u0430\n\n1. **\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 MySQL:**\n - \u0415\u0441\u043b\u0438 \u0443 \u0432\u0430\u0441 \u0435\u0449\u0435 \u043d\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d MySQL, \u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435 \u0435\u0433\u043e \u0441 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0430 [MySQL Downloads](https://dev.mysql.com/downloads/mysql/) \u0438 \u0441\u043b\u0435\u0434\u0443\u0439\u0442\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f\u043c \u043f\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0435 \u0434\u043b\u044f \u0432\u0430\u0448\u0435\u0439 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b.\n\n2. **\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 MySQL Connector/J:**\n - \u042d\u0442\u043e JDBC-\u0434\u0440\u0430\u0439\u0432\u0435\u0440 \u0434\u043b\u044f \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f Java-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043a MySQL.\n - \u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435 \u0435\u0433\u043e \u0441 [\u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0430 MySQL Connector/J](https://dev.mysql.com/downloads/connector/j/).\n - \u0414\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d\u043d\u044b\u0439 JAR-\u0444\u0430\u0439\u043b \u0432 \u0432\u0430\u0448 \u043f\u0440\u043e\u0435\u043a\u0442 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0432 \u0432\u0430\u0448 classpath).\n\n---\n\n## \u0428\u0430\u0433 2: \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 MySQL\n\n\u0412\u0430\u0448 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434 \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0443\u0435\u0442 \u0441 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438: `customer`, `room`, `driver`, `employee`, `login`. \u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u044d\u0442\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0432 MySQL. \u041d\u0438\u0436\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u044b \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u044b\u0435 SQL-\u0441\u043a\u0440\u0438\u043f\u0442\u044b \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u044d\u0442\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446.\n\n1. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445:**\n\n```sql\nCREATE DATABASE projecthms;\nUSE projecthms;\n```\n\n2. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b `login`:**\n\n```sql\nCREATE TABLE login (\n username VARCHAR(50) PRIMARY KEY,\n password VARCHAR(50) NOT NULL\n);\n```\n\n3. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b `room`:**\n\n```sql\nCREATE TABLE room (\n room_number INT PRIMARY KEY AUTO_INCREMENT,\n available VARCHAR(20),\n status VARCHAR(20),\n price INT,\n bed_type VARCHAR(20)\n);\n```\n\n4. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b `customer`:**\n\n```sql\nCREATE TABLE customer (\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100),\n phone VARCHAR(15) UNIQUE,\n gender VARCHAR(10),\n country VARCHAR(50),\n room_number INT,\n status VARCHAR(20),\n deposit INT,\n FOREIGN KEY (room_number) REFERENCES room(room_number)\n);\n```\n\n5. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b `driver`:**\n\n```sql\nCREATE TABLE driver (\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100),\n age INT,\n gender VARCHAR(10),\n model VARCHAR(50),\n available VARCHAR(20),\n location VARCHAR(50)\n);\n```\n\n6. **\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b `employee`:**\n\n```sql\nCREATE TABLE employee (\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100),\n age INT,\n gender VARCHAR(10),\n job VARCHAR(50),\n salary INT,\n phone VARCHAR(15) UNIQUE,\n nid VARCHAR(20) UNIQUE,\n email VARCHAR(100) UNIQUE\n);\n```\n\n**\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u044f:**\n- **\u0410\u0432\u0442\u043e\u0438\u043d\u043a\u0440\u0435\u043c\u0435\u043d\u0442\u043d\u044b\u0435 \u043f\u043e\u043b\u044f (`AUTO_INCREMENT`):** \u041f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0432\u0430\u0442\u044c \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043a\u0430\u0436\u0434\u043e\u0439 \u043d\u043e\u0432\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u0438.\n- **\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f `UNIQUE`:** \u0413\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u044e\u0442 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0445 \u043f\u043e\u043b\u0435\u0439 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, `phone`, `email`).\n- **\u0412\u043d\u0435\u0448\u043d\u0438\u0435 \u043a\u043b\u044e\u0447\u0438 (`FOREIGN KEY`):** \u041e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0442 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, `customer.room_number` \u0441 `room.room_number`).\n\n---\n\n## \u0428\u0430\u0433 3: \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043a\u043e\u0434\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0432 Java\n\n\u0412 \u0432\u0430\u0448\u0435\u043c \u0442\u0435\u043a\u0443\u0449\u0435\u043c \u043a\u043e\u0434\u0435 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a MSSQL \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:\n\n```java\nClass.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");\nc = DriverManager.getConnection(\"jdbc:sqlserver://localhost:1433;databaseName=projecthms;selectMethod=cursor\", \"sa\", \"123456\");\n```\n\n\u0427\u0442\u043e\u0431\u044b \u043f\u0435\u0440\u0435\u043a\u043b\u044e\u0447\u0438\u0442\u044c\u0441\u044f \u043d\u0430 MySQL, \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f:\n\n1. **\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u0434\u0440\u0430\u0439\u0432\u0435\u0440 \u0438 \u0441\u0442\u0440\u043e\u043a\u0443 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f:**\n\n```java\n// \u0418\u043c\u043f\u043e\u0440\u0442\u0438\u0440\u0443\u0439\u0442\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u043a\u043b\u0430\u0441\u0441\u044b (\u0443\u0431\u0435\u0434\u0438\u0442\u0435\u0441\u044c, \u0447\u0442\u043e MySQL Connector/J \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u0432 classpath)\nimport java.sql.*;\n\npublic class ConnectMySQL {\n Connection c;\n Statement s;\n\n public ConnectMySQL() {\n try {\n // \u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435 \u0434\u0440\u0430\u0439\u0432\u0435\u0440 MySQL\n Class.forName(\"com.mysql.cj.jdbc.Driver\");\n \n // \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL\n c = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/projecthms\", \"root\", \"your_password\");\n \n // \u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u043e\u0431\u044a\u0435\u043a\u0442 Statement \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432\n s = c.createStatement();\n } catch (Exception e) {\n e.printStackTrace();\n }\n }\n}\n```\n\n**\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u044f:**\n- **\u0414\u0440\u0430\u0439\u0432\u0435\u0440:** `com.mysql.cj.jdbc.Driver` \u2014 \u044d\u0442\u043e \u0434\u0440\u0430\u0439\u0432\u0435\u0440 \u0434\u043b\u044f MySQL Connector/J \u0432\u0435\u0440\u0441\u0438\u0438 8 \u0438 \u0432\u044b\u0448\u0435.\n- **\u0421\u0442\u0440\u043e\u043a\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f:** `jdbc:mysql://localhost:3306/projecthms`\n - `localhost` \u2014 \u0445\u043e\u0441\u0442, \u0433\u0434\u0435 \u0437\u0430\u043f\u0443\u0449\u0435\u043d MySQL (\u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0434\u0440\u0443\u0433\u0438\u043c).\n - `3306` \u2014 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0439 \u043f\u043e\u0440\u0442 \u0434\u043b\u044f MySQL.\n - `projecthms` \u2014 \u0438\u043c\u044f \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\n- **\u0423\u0447\u0451\u0442\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435:** \u0417\u0430\u043c\u0435\u043d\u0438\u0442\u0435 `\"root\"` \u0438 `\"your_password\"` \u043d\u0430 \u0432\u0430\u0448\u0435 \u0438\u043c\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438 \u043f\u0430\u0440\u043e\u043b\u044c MySQL.\n\n2. **\u041e\u0431\u043d\u043e\u0432\u0438\u0442\u0435 \u0432\u0430\u0448 \u043a\u043b\u0430\u0441\u0441 `ConnectMSSQL` \u043d\u0430 `ConnectMySQL`:**\n\n\u041f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u0443\u0439\u0442\u0435 \u043a\u043b\u0430\u0441\u0441 \u0438 \u0443\u0431\u0435\u0434\u0438\u0442\u0435\u0441\u044c, \u0447\u0442\u043e \u043e\u043d \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0432\u043e \u0432\u0441\u0435\u0445 \u043c\u0435\u0441\u0442\u0430\u0445 \u0432\u0430\u0448\u0435\u0433\u043e \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u0432\u043c\u0435\u0441\u0442\u043e `ConnectMSSQL`.\n\n```java\npackage hotel.management.system;\n\nimport java.sql.*;\n\npublic class ConnectMySQL {\n Connection c;\n Statement s;\n\n public ConnectMySQL() {\n try {\n Class.forName(\"com.mysql.cj.jdbc.Driver\");\n c = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/projecthms\", \"root\", \"your_password\");\n s = c.createStatement();\n } catch (Exception e) {\n e.printStackTrace();\n }\n }\n}\n```\n\n3. **\u041e\u0431\u043d\u043e\u0432\u0438\u0442\u0435 \u0432\u0441\u0435 \u0438\u043c\u043f\u043e\u0440\u0442\u044b \u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0435 \u043a\u043b\u0430\u0441\u0441\u044b \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f:**\n\n\u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0432 `AddCustomer.java`, \u0437\u0430\u043c\u0435\u043d\u0438\u0442\u0435:\n\n```java\nConnectMSSQL c = new ConnectMSSQL();\n```\n\n\u043d\u0430\n\n```java\nConnectMySQL c = new ConnectMySQL();\n```\n\n\u0423\u0431\u0435\u0434\u0438\u0442\u0435\u0441\u044c, \u0447\u0442\u043e \u0438\u043c\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u043d\u043e\u0432\u043e\u043c\u0443 \u043a\u043b\u0430\u0441\u0441\u0443 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f.\n\n---\n\n## \u0428\u0430\u0433 4: \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0434\u043b\u044f \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 MySQL\n\n\u0411\u043e\u043b\u044c\u0448\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u0432\u0430\u0448\u0438\u0445 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0443\u0436\u0435 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u0430 \u0441 MySQL, \u043e\u0434\u043d\u0430\u043a\u043e \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0443\u0447\u0435\u0441\u0442\u044c \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b:\n\n1. **\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043a\u0430\u0432\u044b\u0447\u0435\u043a:**\n - MySQL \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043e\u0434\u0438\u043d\u0430\u0440\u043d\u044b\u0435 (`'`) \u0438 \u0434\u0432\u043e\u0439\u043d\u044b\u0435 (`\"`) \u043a\u0430\u0432\u044b\u0447\u043a\u0438 \u0434\u043b\u044f \u0441\u0442\u0440\u043e\u043a\u043e\u0432\u044b\u0445 \u043b\u0438\u0442\u0435\u0440\u0430\u043b\u043e\u0432.\n - \u0423\u0431\u0435\u0434\u0438\u0442\u0435\u0441\u044c, \u0447\u0442\u043e \u0432\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u044b\u0439 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441.\n\n2. **\u0410\u0433\u0433\u0440\u0435\u0433\u0430\u0446\u0438\u044f \u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0438:**\n - \u041f\u0440\u043e\u0432\u0435\u0440\u044c\u0442\u0435, \u0447\u0442\u043e \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0435 \u0432 \u0432\u0430\u0448\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u0445 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, `AVG()`), \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0442\u0430\u043a \u0436\u0435 \u0432 MySQL, \u043a\u0430\u043a \u0438 \u0432 MSSQL.\n\n3. **\u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0430\u0432\u0442\u043e\u0438\u043d\u043a\u0440\u0435\u043c\u0435\u043d\u0442\u043d\u044b\u0445 \u043f\u043e\u043b\u0435\u0439:**\n - \u0412 MySQL \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 `AUTO_INCREMENT` \u0434\u043b\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u0443\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u044f \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u043e\u0432.\n\n4. **\u041f\u0440\u0438\u043c\u0435\u0440 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0439 \u0432\u0441\u0442\u0430\u0432\u043a\u0438 \u0434\u043b\u044f `AddCustomer.java`:**\n\n```java\nString str = \"INSERT INTO customer (name, phone, gender, country, room_number, status, deposit) VALUES ('\" + name + \"','\" + phone + \"','\" + gender + \"','\" + country + \"',\" + roomInt + \",'\" + status + \"',\" + depositInt + \")\";\n```\n\n**\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435:** \u0412\u0441\u0435\u0433\u0434\u0430 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0443\u0435\u0442\u0441\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c `PreparedStatement` \u0434\u043b\u044f \u043f\u0440\u0435\u0434\u043e\u0442\u0432\u0440\u0430\u0449\u0435\u043d\u0438\u044f SQL-\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439 \u0438 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438.\n\n**\u041f\u0440\u0438\u043c\u0435\u0440 \u0441 `PreparedStatement`:**\n\n```java\nString query = \"INSERT INTO customer (name, phone, gender, country, room_number, status, deposit) VALUES (?, ?, ?, ?, ?, ?, ?)\";\nPreparedStatement pst = c.c.prepareStatement(query);\npst.setString(1, name);\npst.setString(2, phone);\npst.setString(3, gender);\npst.setString(4, country);\npst.setInt(5, roomInt);\npst.setString(6, status);\npst.setInt(7, depositInt);\npst.executeUpdate();\n```\n\n\u0420\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0443\u0435\u0442\u0441\u044f \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u044c \u044d\u0442\u043e\u0442 \u043f\u043e\u0434\u0445\u043e\u0434 \u043a\u043e \u0432\u0441\u0435\u043c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c \u0434\u043b\u044f \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u044f \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438.\n\n---\n\n## \u0414\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438\n\n1. **\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 ORM (\u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e):**\n - \u0414\u043b\u044f \u0431\u043e\u043b\u0435\u0435 \u0443\u0434\u043e\u0431\u043d\u043e\u0433\u043e \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u0442\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f ORM-\u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u043e\u0432, \u0442\u0430\u043a\u0438\u0445 \u043a\u0430\u043a Hibernate.\n\n2. **\u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0439:**\n - \u0412\u0441\u0435\u0433\u0434\u0430 \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0439\u0442\u0435 \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0439\u0442\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u043e \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u0445 \u043e\u0448\u0438\u0431\u043a\u0430\u0445.\n\n3. **\u0412\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u044f \u0432\u0432\u043e\u0434\u0438\u043c\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445:**\n - \u0423\u0431\u0435\u0434\u0438\u0442\u0435\u0441\u044c, \u0447\u0442\u043e \u0434\u0430\u043d\u043d\u044b\u0435, \u0432\u0432\u043e\u0434\u0438\u043c\u044b\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u044b \u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u043e\u0436\u0438\u0434\u0430\u0435\u043c\u044b\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0430\u043c.\n\n4. **\u0417\u0430\u043c\u0435\u043d\u0430 `java.awt.Choice` \u043d\u0430 `JComboBox`:**\n - `JComboBox` \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0431\u043e\u043b\u0435\u0435 \u0433\u0438\u0431\u043a\u0438\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0438 \u043b\u0443\u0447\u0448\u0435 \u0438\u043d\u0442\u0435\u0433\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0441 Swing.\n\n**\u041f\u0440\u0438\u043c\u0435\u0440:**\n\n```java\n// \u0412\u043c\u0435\u0441\u0442\u043e:\nChoice c1 = new Choice();\n// \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435:\nJComboBox c1 = new JComboBox<>();\nc1.addItem(\"Item1\");\nc1.addItem(\"Item2\");\n// \u0438 \u0442.\u0434.\n```\n\n---\n\n## \u041f\u0440\u0438\u043c\u0435\u0440 \u043f\u043e\u043b\u043d\u043e\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0433\u043e \u043a\u043b\u0430\u0441\u0441\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f\n\n```java\npackage hotel.management.system;\n\nimport java.sql.*;\n\npublic class ConnectMySQL {\n Connection c;\n Statement s;\n\n public ConnectMySQL() {\n try {\n Class.forName(\"com.mysql.cj.jdbc.Driver\");\n // \u0417\u0430\u043c\u0435\u043d\u0438\u0442\u0435 \"your_password\" \u043d\u0430 \u0432\u0430\u0448 \u0444\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c MySQL\n c = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/projecthms\", \"root\", \"your_password\");\n s = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);\n } catch (Exception e) {\n e.printStackTrace();\n }\n }\n}\n```\n\n**\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f:**\n- `ResultSet.TYPE_SCROLL_SENSITIVE` \u0438 `ResultSet.CONCUR_UPDATABLE` \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0442 \u0432\u0430\u043c \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u0442\u044c\u0441\u044f \u043f\u043e \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c\u0443 \u043d\u0430\u0431\u043e\u0440\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0432\u043d\u043e\u0441\u0438\u0442\u044c \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u043d\u0435\u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u0447\u0435\u0440\u0435\u0437 \u043e\u0431\u044a\u0435\u043a\u0442\u044b `ResultSet`, \u0435\u0441\u043b\u0438 \u044d\u0442\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e.\n\n---\n\n## \u0417\u0430\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435\n\n\u041f\u0435\u0440\u0435\u0445\u043e\u0434 \u043e\u0442 MSSQL \u043a MySQL \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0442\u0440\u043e\u043a\u0438 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f, \u0437\u0430\u043c\u0435\u043d\u044b \u0434\u0440\u0430\u0439\u0432\u0435\u0440\u0430 \u0438, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e, \u0430\u0434\u0430\u043f\u0442\u0430\u0446\u0438\u0438 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0445 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u0421\u043b\u0435\u0434\u0443\u044f \u043e\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u043c \u0432\u044b\u0448\u0435 \u0448\u0430\u0433\u0430\u043c, \u0432\u044b \u0441\u043c\u043e\u0436\u0435\u0442\u0435 \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u043f\u0435\u0440\u0435\u043d\u0435\u0441\u0442\u0438 \u0432\u0430\u0448 \u043f\u0440\u043e\u0435\u043a\u0442 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043e\u0442\u0435\u043b\u0435\u043c \u043d\u0430 MySQL. \u041d\u0435 \u0437\u0430\u0431\u044b\u0432\u0430\u0439\u0442\u0435 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043a\u0430\u0436\u0434\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043f\u043e\u0441\u043b\u0435 \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439, \u0447\u0442\u043e\u0431\u044b \u0443\u0431\u0435\u0434\u0438\u0442\u044c\u0441\u044f \u0432 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e\u0441\u0442\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441\u0438\u0441\u0442\u0435\u043c\u044b.\n\n\u0415\u0441\u043b\u0438 \u0443 \u0432\u0430\u0441 \u0432\u043e\u0437\u043d\u0438\u043a\u043d\u0443\u0442 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0432\u043e\u043f\u0440\u043e\u0441\u044b \u0438\u043b\u0438 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438, \u043d\u0435 \u0441\u0442\u0435\u0441\u043d\u044f\u0439\u0442\u0435\u0441\u044c \u0437\u0430\u0434\u0430\u0432\u0430\u0442\u044c \u0438\u0445!\n\n---\n\n**\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435:** \u0414\u043b\u044f \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438 \u0438 \u043b\u0443\u0447\u0448\u0435\u0439 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0438 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 `PreparedStatement` \u0432\u043c\u0435\u0441\u0442\u043e \u043a\u043e\u043d\u043a\u0430\u0442\u0435\u043d\u0430\u0446\u0438\u0438 \u0441\u0442\u0440\u043e\u043a \u0434\u043b\u044f \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u042d\u0442\u043e \u043f\u043e\u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0435\u0434\u043e\u0442\u0432\u0440\u0430\u0442\u0438\u0442\u044c SQL-\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0438 \u0438 \u043f\u043e\u0432\u044b\u0441\u0438\u0442 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0433\u043e \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f.","behavior":"degenerate_repetition","conversation_hash":"6fc96db513ebe17c3d45ca97d6ccb52a","conversation_redacted":false,"conversation_toxic":false,"country":"Kyrgyzstan","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"o1-mini-2024-09-12","n_chars":112585,"n_turns_in_conversation":1,"n_words":10053,"source_row_offset":17814,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:15 GMT","turn_id":"c18d4e7c07bdf7c96eb95c65","turn_index":0,"user_text":"src/hotel/management/system/AddCustomer.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class AddCustomer extends JFrame implements ActionListener {\n\n JTextField t1, t2, t3, t4, t5;\n JButton b1, b2;\n Choice c1;\n JRadioButton r1, r2;\n\n AddCustomer() {\n\n JLabel l1 = new JLabel(\"New Customer Form\");\n l1.setForeground(Color.BLUE);\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 20));\n l1.setBounds(100, 20, 300, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Name\");\n l2.setBounds(35, 80, 100, 20);\n add(l2);\n\n t1 = new JTextField();\n t1.setBounds(150, 80, 150, 25);\n add(t1);\n\n JLabel l3 = new JLabel(\"Phone\");\n l3.setBounds(35, 120, 100, 20);\n add(l3);\n\n t2 = new JTextField();\n t2.setBounds(150, 120, 150, 25);\n add(t2);\n\n JLabel l4 = new JLabel(\"Gender\");\n l4.setBounds(35, 160, 100, 20);\n add(l4);\n\n r1 = new JRadioButton(\"Male\");\n r1.setBounds(150, 160, 60, 25);\n r1.setBackground(Color.WHITE);\n add(r1);\n\n r2 = new JRadioButton(\"Female\");\n r2.setBounds(220, 160, 80, 25);\n r2.setBackground(Color.WHITE);\n add(r2);\n\n JLabel l6 = new JLabel(\"Country\");\n l6.setBounds(35, 200, 100, 20);\n add(l6);\n\n t3 = new JTextField();\n t3.setBounds(150, 200, 150, 25);\n add(t3);\n\n JLabel l7 = new JLabel(\"Allocated Room\");\n l7.setBounds(35, 240, 100, 20);\n add(l7);\n\n c1 = new Choice();\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select * from room where available = 'Available'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n c1.add(rs.getString(\"room_number\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n c1.setBounds(150, 240, 150, 25);\n c1.setBackground(Color.WHITE);\n add(c1);\n\n JLabel l8 = new JLabel(\"Checked In\");\n l8.setBounds(35, 280, 100, 20);\n add(l8);\n\n t4 = new JTextField();\n t4.setBounds(150, 280, 150, 25);\n add(t4);\n\n JLabel l9 = new JLabel(\"Deposit\");\n l9.setBounds(35, 320, 100, 20);\n add(l9);\n\n t5 = new JTextField();\n t5.setBounds(150, 320, 150, 25);\n add(t5);\n\n b1 = new JButton(\"Add Customer\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(50, 370, 120, 30);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(200, 370, 120, 30);\n add(b2);\n \n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/customer.png\"));\n Image i2 = i1.getImage().getScaledInstance(250, 250, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l10 = new JLabel(i3);\n l10.setBounds(400, 20, 300, 400);\n add(l10);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 200, 800, 500);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String name = t1.getText();\n String phone = t2.getText();\n String gender = null;\n \n if (r1.isSelected()) {\n \n gender = \"Male\";\n \n } else if (r2.isSelected()) {\n \n gender = \"Female\";\n \n }\n \n String country = t3.getText();\n String room = c1.getSelectedItem();\n int roomInt = Integer.parseInt(room);\n String status = t4.getText();\n String deposit = t5.getText();\n int depositInt = Integer.parseInt(deposit);\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"insert into customer values ('\" + name + \"','\" + phone + \"','\" + gender + \"','\" + country + \"','\" + roomInt + \"','\" + status + \"','\" + depositInt + \"')\";\n\n String str2 = \"update room set available = 'Occupied' where room_number = '\" + roomInt + \"'\";\n\n try {\n\n c.s.executeUpdate(str);\n c.s.executeUpdate(str2);\n\n JOptionPane.showMessageDialog(null, \"Customer Added\");\n \n t1.setText(\"\");\n t2.setText(\"\");\n t3.setText(\"\");\n t4.setText(\"\");\n t5.setText(\"\");\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n new AddCustomer().setVisible(true);\n }\n\n}\n\n\n\n\n\n\nsrc/hotel/management/system/AddDriver.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class AddDriver extends JFrame implements ActionListener {\n\n JTextField t1, t2, t3, t4, t5;\n JComboBox c1, c2;\n JButton b1, b2;\n\n AddDriver() {\n\n JLabel name = new JLabel(\"Name\");\n name.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n name.setBounds(60, 80, 120, 30);\n add(name);\n\n t1 = new JTextField();\n t1.setBounds(200, 80, 150, 30);\n add(t1);\n\n JLabel age = new JLabel(\"Age\");\n age.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n age.setBounds(60, 130, 120, 30);\n add(age);\n\n t2 = new JTextField();\n t2.setBounds(200, 130, 150, 30);\n add(t2);\n\n JLabel gender = new JLabel(\"Gender\");\n gender.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n gender.setBounds(60, 180, 120, 30);\n add(gender);\n\n c1 = new JComboBox(new String[]{\"Male\", \"Female\"});\n c1.setBackground(Color.WHITE);\n c1.setBounds(200, 180, 150, 30);\n add(c1);\n\n JLabel model = new JLabel(\"Car Model\");\n model.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n model.setBounds(60, 230, 120, 30);\n add(model);\n\n t4 = new JTextField();\n t4.setBounds(200, 230, 150, 30);\n add(t4);\n\n JLabel available = new JLabel(\"Availability\");\n available.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n available.setBounds(60, 280, 120, 30);\n add(available);\n\n c2 = new JComboBox(new String[]{\"Available\", \"Busy\"});\n c2.setBackground(Color.WHITE);\n c2.setBounds(200, 280, 150, 30);\n add(c2);\n\n JLabel location = new JLabel(\"Location\");\n location.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n location.setBounds(60, 330, 120, 30);\n add(location);\n\n t5 = new JTextField();\n t5.setBounds(200, 330, 150, 30);\n add(t5);\n\n b1 = new JButton(\"Add Driver\");\n b1.setForeground(Color.WHITE);\n b1.setBackground(Color.BLACK);\n b1.setBounds(130, 410, 100, 30);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Cancel\");\n b2.setForeground(Color.WHITE);\n b2.setBackground(Color.BLACK);\n b2.setBounds(250, 410, 100, 30);\n b2.addActionListener(this);\n add(b2);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/eleven.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(500, 400, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l1 = new JLabel(i3);\n l1.setBounds(440, 50, 500, 400);\n add(l1);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(400, 200, 1000, 560);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String name = t1.getText();\n String age = t2.getText();\n int ageInt = Integer.parseInt(age);\n String gender = (String) c1.getSelectedItem();\n String model = t4.getText();\n String available = (String) c2.getSelectedItem();\n String location = t5.getText();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"insert into driver values('\" + name + \"','\" + ageInt + \"','\" + gender + \"','\" + model + \"','\" + available + \"','\" + location + \"')\";\n\n try {\n\n c.s.executeUpdate(str);\n JOptionPane.showMessageDialog(null, \"Driver Added\");\n\n t1.setText(\"\");\n t2.setText(\"\");\n c1.setSelectedItem(null);\n t4.setText(\"\");\n c2.setSelectedItem(null);\n t5.setText(\"\");\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new AddDriver().setVisible(true);\n\n }\n\n}\n\n\n\n\n\nsrc/hotel/management/system/AddEmployee.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class AddEmployee extends JFrame implements ActionListener {\n\n JTextField t1, t2, t3, t4, t5, t6;\n JRadioButton r1, r2;\n JComboBox c1;\n JButton b1, b2;\n\n AddEmployee() {\n\n JLabel name = new JLabel(\"NAME\");\n name.setBounds(60, 30, 120, 30);\n name.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(name);\n\n t1 = new JTextField();\n t1.setBounds(200, 30, 150, 30);\n add(t1);\n\n JLabel age = new JLabel(\"AGE\");\n age.setBounds(60, 80, 120, 30);\n age.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(age);\n\n t2 = new JTextField();\n t2.setBounds(200, 80, 150, 30);\n add(t2);\n\n JLabel gender = new JLabel(\"GENDER\");\n gender.setBounds(60, 130, 120, 30);\n gender.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(gender);\n\n r1 = new JRadioButton(\"Male\");\n r1.setFont(new Font(\"Tahoma\", Font.PLAIN, 14));\n r1.setBounds(200, 130, 70, 30);\n r1.setBackground(Color.WHITE);\n add(r1);\n\n r2 = new JRadioButton(\"Female\");\n r2.setFont(new Font(\"Tahoma\", Font.PLAIN, 14));\n r2.setBounds(280, 130, 70, 30);\n r2.setBackground(Color.WHITE);\n add(r2);\n\n JLabel job = new JLabel(\"JOB\");\n job.setBounds(60, 180, 120, 30);\n job.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(job);\n\n String str[] = {\"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"};\n c1 = new JComboBox(str);\n c1.setBounds(200, 180, 150, 30);\n c1.setBackground(Color.WHITE);\n add(c1);\n\n JLabel salary = new JLabel(\"SALARY\");\n salary.setBounds(60, 230, 120, 30);\n salary.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(salary);\n\n t3 = new JTextField();\n t3.setBounds(200, 230, 150, 30);\n add(t3);\n\n JLabel phone = new JLabel(\"PHONE\");\n phone.setBounds(60, 280, 120, 30);\n phone.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(phone);\n\n t4 = new JTextField();\n t4.setBounds(200, 280, 150, 30);\n add(t4);\n\n JLabel nid = new JLabel(\"NID\");\n nid.setBounds(60, 330, 120, 30);\n nid.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(nid);\n\n t5 = new JTextField();\n t5.setBounds(200, 330, 150, 30);\n add(t5);\n\n JLabel email = new JLabel(\"EMAIL\");\n email.setBounds(60, 380, 120, 30);\n email.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n add(email);\n\n t6 = new JTextField();\n t6.setBounds(200, 380, 150, 30);\n add(t6);\n\n b1 = new JButton(\"Submit\");\n b1.setForeground(Color.WHITE);\n b1.setBackground(Color.BLACK);\n b1.setBounds(250, 440, 100, 30);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setForeground(Color.WHITE);\n b2.setBackground(Color.BLACK);\n b2.setBounds(130, 440, 100, 30);\n b2.addActionListener(this);\n add(b2);\n\n JLabel l1 = new JLabel(\"ADD EMPLOYEE DETAILS\");\n l1.setForeground(Color.darkGray);\n l1.setBounds(420, 50, 400, 30);\n l1.setFont(new Font(\"Tahoma\", Font.BOLD, 28));\n add(l1);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/tenth.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(520, 520, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l2 = new JLabel(i3);\n l2.setBounds(380, 55, 450, 450);\n add(l2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(400, 200, 900, 580);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String name = t1.getText();\n String age = t2.getText();\n int ageInt = Integer.parseInt(age);\n String salary = t3.getText();\n int salaryInt = Integer.parseInt(salary);\n String phone = t4.getText();\n String nid = t5.getText();\n String email = t6.getText();\n\n String gender = \"null\";\n\n if (r1.isSelected()) {\n \n gender = \"Male\";\n \n } else if (r2.isSelected()) {\n \n gender = \"Female\";\n \n }\n\n String job = (String) c1.getSelectedItem();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"insert into employee values('\" + name + \"','\" + ageInt + \"','\" + gender + \"','\" + job + \"','\" + salaryInt + \"','\" + phone + \"','\" + nid + \"','\" + email + \"')\";\n\n try {\n\n c.s.executeUpdate(str);\n \n JOptionPane.showMessageDialog(null, \"Employee added\");\n\n t1.setText(\"\");\n t2.setText(\"\");\n t3.setText(\"\");\n t4.setText(\"\");\n t5.setText(\"\");\n t6.setText(\"\");\n r1.setSelected(false);\n r2.setSelected(false);\n c1.setSelectedItem(null);\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n new AddEmployee().setVisible(true);\n }\n\n}\n\n\n\n\n\nsrc/hotel/management/system/AddRooms.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\n\npublic class AddRooms extends JFrame implements ActionListener {\n\n JTextField t1, t2;\n JComboBox c1, c2, c3;\n JButton b1, b2;\n\n AddRooms() {\n\n JLabel available = new JLabel(\"Availability\");\n available.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n available.setBounds(60, 130, 140, 30);\n add(available);\n\n c1 = new JComboBox(new String[]{\"Available\", \"Occupied\"});\n c1.setBounds(220, 130, 150, 30);\n c1.setBackground(Color.WHITE);\n add(c1);\n\n JLabel status = new JLabel(\"Cleaning Status\");\n status.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n status.setBounds(60, 180, 140, 30);\n add(status);\n\n c2 = new JComboBox(new String[]{\"Cleaned\", \"Dirty\"});\n c2.setBounds(220, 180, 150, 30);\n c2.setBackground(Color.WHITE);\n add(c2);\n\n JLabel price = new JLabel(\"Price\");\n price.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n price.setBounds(60, 230, 140, 30);\n add(price);\n\n t2 = new JTextField();\n t2.setBounds(220, 230, 150, 30);\n add(t2);\n\n JLabel type = new JLabel(\"Bed Type\");\n type.setFont(new Font(\"Tahoma\", Font.BOLD, 17));\n type.setBounds(60, 280, 140, 30);\n add(type);\n\n c3 = new JComboBox(new String[]{\"Single Bed\", \"Double Bed\"});\n c3.setBounds(220, 280, 150, 30);\n c3.setBackground(Color.WHITE);\n add(c3);\n\n b1 = new JButton(\"Add Room\");\n b1.setForeground(Color.WHITE);\n b1.setBackground(Color.BLACK);\n b1.setBounds(150, 350, 100, 30);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Cancel\");\n b2.setForeground(Color.WHITE);\n b2.setBackground(Color.BLACK);\n b2.setBounds(270, 350, 100, 30);\n b2.addActionListener(this);\n add(b2);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/twelve.jpg\"));\n JLabel l2 = new JLabel(i1);\n l2.setBounds(440, 30, 500, 350);\n add(l2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(450, 200, 1000, 470);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String available = (String) c1.getSelectedItem();\n String status = (String) c2.getSelectedItem();\n String price = t2.getText();\n int priceInt = Integer.parseInt(price);\n String type = (String) c3.getSelectedItem();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"insert into room values('\" + available + \"','\" + status + \"','\" + priceInt + \"','\" + type + \"')\";\n\n try {\n\n c.s.executeUpdate(str);\n\n JOptionPane.showMessageDialog(null, \"Room Added\");\n\n t2.setText(\"\");\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n new AddRooms().setVisible(true);\n }\n\n}\n\n\n\n\n\n\n\nsrc/hotel/management/system/CheckOut.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\n\nimport java.sql.*;\n\npublic class CheckOut extends JFrame implements ActionListener {\n\n Choice c1;\n JTextField t1;\n JButton b1, b2, b3;\n\n CheckOut() {\n\n JLabel l1 = new JLabel(\"Check Out\");\n l1.setForeground(Color.BLUE);\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 20));\n l1.setBounds(100, 20, 100, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Customer Phone No.\");\n l2.setBounds(30, 80, 120, 30);\n add(l2);\n\n c1 = new Choice();\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n ResultSet rs = c.s.executeQuery(\"select * from customer\");\n\n while (rs.next()) {\n\n c1.add(rs.getString(\"phone\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n c1.setBounds(170, 80, 150, 30);\n add(c1);\n\n JLabel l3 = new JLabel(\"Room\");\n l3.setBounds(30, 130, 120, 30);\n add(l3);\n\n t1 = new JTextField();\n t1.setBounds(170, 130, 150, 30);\n add(t1);\n\n b1 = new JButton(\"Checkout\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(40, 200, 120, 30);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(180, 200, 120, 30);\n add(b2);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/tick.png\"));\n Image i2 = i1.getImage().getScaledInstance(20, 20, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n b3 = new JButton(i3);\n b3.setBounds(330, 80, 20, 20);\n b3.addActionListener(this);\n add(b3);\n\n ImageIcon i4 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/sixth.jpg\"));\n Image i5 = i4.getImage().getScaledInstance(400, 210, Image.SCALE_DEFAULT);\n ImageIcon i6 = new ImageIcon(i5);\n JLabel l4 = new JLabel(i6);\n l4.setBounds(370, 10, 400, 250);\n add(l4);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 200, 800, 300);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String phone = c1.getSelectedItem();\n String room = t1.getText();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str2 = \"update room set available = 'Available' where room_number = '\" + room + \"'\";\n\n try {\n \n c.s.executeUpdate(str2);\n\n JOptionPane.showMessageDialog(null, \"Checkout Done\");\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b3) {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String s = c1.getSelectedItem();\n\n try {\n\n ResultSet rs = c.s.executeQuery(\"select * from customer where phone = '\" + s + \"'\");\n\n while (rs.next()) {\n\n t1.setText(rs.getString(\"room\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new CheckOut().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\nsrc/hotel/management/system/ConnectMSSQL.java\npackage hotel.management.system;\n\nimport java.sql.*;\n\npublic class ConnectMSSQL {\n\n Connection c;\n Statement s;\n\n public ConnectMSSQL() {\n\n try {\n\n Class.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");\n c = DriverManager.getConnection(\"jdbc:sqlserver://localhost:1433;databaseName=projecthms;selectMethod=cursor\", \"sa\", \"123456\");\n s = c.createStatement();\n\n } catch (Exception e) {\n e.printStackTrace();\n }\n\n }\n\n}\n\n\n\n\n\n\n\nsrc/hotel/management/system/CustomerInfo.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\nimport net.proteanit.sql.*;\n\npublic class CustomerInfo extends JFrame implements ActionListener {\n\n JTable t1;\n JButton b1, b2;\n JComboBox c1, c2, c3, c4;\n\n CustomerInfo() {\n\n t1 = new JTable();\n t1.setBounds(0, 40, 1000, 300);\n add(t1);\n\n c1 = new JComboBox(new String[]{\"Country Region\", \"Local\", \"Foreigner\"});\n c1.setBounds(160, 400, 150, 25);\n c1.setBackground(Color.WHITE);\n c1.addActionListener(this);\n add(c1);\n\n c2 = new JComboBox(new String[]{\"Sort By\", \"Room\"});\n c2.setBounds(440, 400, 150, 25);\n c2.setBackground(Color.WHITE);\n c2.addActionListener(this);\n add(c2);\n\n JLabel l1 = new JLabel(\"Name\");\n l1.setBounds(50, 10, 70, 20);\n add(l1);\n\n JLabel l2 = new JLabel(\"Phone\");\n l2.setBounds(190, 10, 70, 20);\n add(l2);\n\n JLabel l3 = new JLabel(\"Gender\");\n l3.setBounds(330, 10, 70, 20);\n add(l3);\n\n JLabel l4 = new JLabel(\"Country\");\n l4.setBounds(470, 10, 70, 20);\n add(l4);\n\n JLabel l5 = new JLabel(\"Room\");\n l5.setBounds(620, 10, 70, 20);\n add(l5);\n\n JLabel l6 = new JLabel(\"Checked In\");\n l6.setBounds(750, 10, 70, 20);\n add(l6);\n\n JLabel l7 = new JLabel(\"Deposit\");\n l7.setBounds(890, 10, 70, 20);\n add(l7);\n\n b1 = new JButton(\"Load Data\");\n b1.setBounds(350, 560, 120, 30);\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setBounds(530, 560, 120, 30);\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n add(b2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(450, 200, 1000, 650);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n String str = \"select name, phone, gender, country, room, status, deposit from customer\";\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == c1) {\n\n if (c1.getSelectedItem() == \"Local\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, phone, gender, country, room, status, deposit from customer where country = 'Bangladesh'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c1.getSelectedItem() == \"Foreigner\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, phone, gender, country, room, status, deposit from customer where not country = 'Bangladesh'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == c2) {\n\n if (c2.getSelectedItem() == \"Room\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, phone, gender, country, room, status, deposit from customer order by room + 0\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n new CustomerInfo().setVisible(true);\n }\n\n}\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/Dashboard.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\n\npublic class Dashboard extends JFrame implements ActionListener {\n\n JButton b1, b2, b3, b4;\n\n Dashboard() {\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/luxury.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(1720, 1000, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l1 = new JLabel(i3);\n l1.setBounds(230, 0, 1720, 1000);\n add(l1);\n\n b1 = new JButton(\"Admin\");\n b1.setFont(new Font(\"Tahoma\", Font.BOLD, 26));\n b1.addActionListener(this);\n b1.setBounds(20, 300, 190, 60);\n add(b1);\n\n b2 = new JButton(\"Reception\");\n b2.setFont(new Font(\"Tahoma\", Font.BOLD, 26));\n b2.addActionListener(this);\n b2.setBounds(20, 470, 190, 60);\n add(b2);\n\n b4 = new JButton(\"Logout\");\n b4.setFont(new Font(\"Tahoma\", Font.BOLD, 26));\n b4.addActionListener(this);\n b4.setBounds(20, 640, 190, 60);\n add(b4);\n\n getContentPane().setBackground(Color.decode(\"#6e5853\"));\n\n setLayout(null);\n setBounds(0, 0, 1950, 1020);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n new DropDown().setVisible(true);\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n\n } else if (ae.getSource() == b3) {\n\n } else if (ae.getSource() == b4) {\n\n new Login().setVisible(true);\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new Dashboard().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\nsrc/hotel/management/system/DropDown.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\n\npublic class DropDown extends JFrame implements ActionListener {\n\n JButton b1, b2, b3;\n\n DropDown() {\n\n b1 = new JButton(\"Add Employee\");\n b1.setFont(new Font(\"Tahoma\", Font.BOLD, 16));\n b1.addActionListener(this);\n b1.setBounds(5, 30, 160, 40);\n add(b1);\n\n b2 = new JButton(\"Add Room\");\n b2.setFont(new Font(\"Tahoma\", Font.BOLD, 16));\n b2.addActionListener(this);\n b2.setBounds(5, 100, 160, 40);\n add(b2);\n\n b3 = new JButton(\"Add Driver\");\n b3.setFont(new Font(\"Tahoma\", Font.BOLD, 16));\n b3.addActionListener(this);\n b3.setBounds(5, 170, 160, 40);\n add(b3);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(230, 337, 190, 290);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n new AddEmployee().setVisible(true);\n\n } else if (ae.getSource() == b2) {\n\n new AddRooms().setVisible(true);\n\n } else if (ae.getSource() == b3) {\n\n new AddDriver().setVisible(true);\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new DropDown().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/EmployeeInfo.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\nimport net.proteanit.sql.*;\n\npublic class EmployeeInfo extends JFrame implements ActionListener {\n\n JTable t1;\n JButton b1, b2, b3, b4;\n JComboBox c1, c2, c3, c4, c5, c6, c7, c8;\n\n EmployeeInfo() {\n\n t1 = new JTable();\n t1.setBounds(0, 40, 1010, 300);\n add(t1);\n\n c1 = new JComboBox(new String[]{\"Sort By\", \"Name\", \"Age\", \"Job\"});\n c1.setBounds(10, 400, 100, 25);\n c1.setBackground(Color.WHITE);\n c1.addActionListener(this);\n add(c1);\n\n c2 = new JComboBox(new String[]{\"Salary Range\", \"1k-20k\", \"21k-40k\", \"41k-60k\", \"60k+\"});\n c2.setBounds(140, 400, 100, 25);\n c2.setBackground(Color.WHITE);\n c2.addActionListener(this);\n add(c2);\n\n c3 = new JComboBox(new String[]{\"Job\", \"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"});\n c3.setBounds(280, 400, 140, 25);\n c3.setBackground(Color.WHITE);\n c3.addActionListener(this);\n add(c3);\n\n c4 = new JComboBox(new String[]{\"No. of employees according to job\", \"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"});\n c4.setBounds(460, 400, 230, 25);\n c4.setBackground(Color.WHITE);\n c4.addActionListener(this);\n add(c4);\n\n c5 = new JComboBox(new String[]{\"Mobile SIM operator\", \"Grameenphone\", \"Robi\", \"Banglalink\", \"Airtel\", \"Teletalk\"});\n c5.setBounds(730, 400, 160, 25);\n c5.setBackground(Color.WHITE);\n c5.addActionListener(this);\n add(c5);\n\n c6 = new JComboBox(new String[]{\"Average Salary according to job\", \"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"});\n c6.setBounds(80, 470, 230, 25);\n c6.setBackground(Color.WHITE);\n c6.addActionListener(this);\n add(c6);\n\n c7 = new JComboBox(new String[]{\"Salary greater than Average Salary\", \"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"});\n c7.setBounds(360, 470, 230, 25);\n c7.setBackground(Color.WHITE);\n c7.addActionListener(this);\n add(c7);\n\n c8 = new JComboBox(new String[]{\"Salary less than Average Salary\", \"Front Desk Clerks\", \"Porters\", \"Housekeeping\", \"Kitchen Stuff\", \"Room Service\", \"Waiter\", \"Manager\", \"Accountant\", \"Chef\"});\n c8.setBounds(640, 470, 230, 25);\n c8.setBackground(Color.WHITE);\n c8.addActionListener(this);\n add(c8);\n\n JLabel l1 = new JLabel(\"Name\");\n l1.setBounds(40, 10, 70, 20);\n add(l1);\n\n JLabel l2 = new JLabel(\"Age\");\n l2.setBounds(170, 10, 70, 20);\n add(l2);\n\n JLabel l3 = new JLabel(\"Gender\");\n l3.setBounds(290, 10, 70, 20);\n add(l3);\n\n JLabel l4 = new JLabel(\"Job\");\n l4.setBounds(400, 10, 70, 20);\n add(l4);\n\n JLabel l5 = new JLabel(\"Salary\");\n l5.setBounds(540, 10, 70, 20);\n add(l5);\n\n JLabel l6 = new JLabel(\"Phone\");\n l6.setBounds(670, 10, 70, 20);\n add(l6);\n\n JLabel l7 = new JLabel(\"NID\");\n l7.setBounds(790, 10, 70, 20);\n add(l7);\n\n JLabel l8 = new JLabel(\"Email\");\n l8.setBounds(910, 10, 70, 20);\n add(l8);\n\n b1 = new JButton(\"Load Data\");\n b1.setBounds(350, 560, 120, 30);\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setBounds(530, 560, 120, 30);\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n add(b2);\n\n b4 = new JButton(\"Delete\");\n b4.setBounds(680, 560, 120, 30);\n b4.setBackground(Color.BLACK);\n b4.setForeground(Color.WHITE);\n b4.addActionListener(this);\n add(b4);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(450, 200, 1030, 650);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee\";\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == c1) {\n\n if (c1.getSelectedItem() == \"Name\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee order by name\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c1.getSelectedItem() == \"Age\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee order by age + 0\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c1.getSelectedItem() == \"Job\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee order by job\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == c2) {\n\n if (c2.getSelectedItem() == \"1k-20k\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where salary between 1000 and 20000\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c2.getSelectedItem() == \"21k-40k\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where salary between 20001 and 40000\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c2.getSelectedItem() == \"41k-60k\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where salary between 40001 and 60000\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c2.getSelectedItem() == \"60k+\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where salary > 60001\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == b4) {\n\n int row = t1.getSelectedRow();\n\n String cell = t1.getModel().getValueAt(row, 0).toString();\n\n System.out.println(cell);\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"delete from employee where name = '\" + cell + \"'\";\n\n c.s.executeQuery(str);\n\n JOptionPane.showMessageDialog(null, \"Row deleted\");\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (ae.getSource() == c3) {\n\n if (c3.getSelectedItem() == \"Front Desk Clerks\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Front Desk Clerks'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Porters\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Porters'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Housekeeping\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Housekeeping'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Kitchen Stuff\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Kitchen Stuff'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Room Service\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Room Service'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Waiter\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Waiter'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Manager\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Manager'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Accountant\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Accountant'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (c3.getSelectedItem() == \"Chef\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Chef'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == c4) {\n\n if (c4.getSelectedItem() == \"Front Desk Clerks\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Front Desk Clerks'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Front Desk Clerks in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Porters\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Porters'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Porters in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Housekeeping\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Housekeeping'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Housekeepers in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Kitchen Stuff\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Kitchen Stuff'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Kitchen Stuffs in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Room Service\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Room Service'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Room Service person in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Waiter\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Waiter'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Waiters in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Manager\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Manager'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Managers in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Accountant\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Accountant'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Accountants in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c4.getSelectedItem() == \"Chef\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select count(job) from employee where job = 'Chef'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"There are currently \" + String.valueOf(i) + \" Chefs in our hotel\");\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }\n\n } else if (ae.getSource() == c5) {\n\n if (c5.getSelectedItem() == \"Grameenphone\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where ((phone like '017%') or (phone like '013%'))\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c5.getSelectedItem() == \"Robi\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where phone like '018%'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c5.getSelectedItem() == \"Banglalink\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where ((phone like '019%') or (phone like '014%'))\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c5.getSelectedItem() == \"Airtel\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where phone like '016%'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c5.getSelectedItem() == \"Teletalk\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where phone like '015%'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }\n\n } else if (ae.getSource() == c6) {\n\n if (c6.getSelectedItem() == \"Front Desk Clerks\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Front Desk Clerks';\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Front Desk Clerk is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Porters\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Porters'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Porter is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Housekeeping\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Housekeeping'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Housekeeper is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Kitchen Stuff\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Kitchen Stuff'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Kitchen Stuff is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Room Service\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Room Service'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Room Service is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Waiter\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Waiter'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Waiter is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Manager\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Manager'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Manager is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Accountant\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Accountant'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Accountant is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c6.getSelectedItem() == \"Chef\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select AVG(salary) from employee where job = 'Chef'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n int i = rs.getInt(1);\n\n JOptionPane.showMessageDialog(null, \"Average salary of Chef is \" + String.valueOf(i));\n\n }\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }\n\n } else if (ae.getSource() == c7) {\n\n if (c7.getSelectedItem() == \"Front Desk Clerks\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Porters\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Housekeeping\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Kitchen Stuff\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Room Service\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Waiter\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Manager\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Accountant\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c7.getSelectedItem() == \"Chef\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }\n\n } else if (ae.getSource() == c8) {\n\n if (c8.getSelectedItem() == \"Front Desk Clerks\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Porters\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Housekeeping\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Kitchen Stuff\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Room Service\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Waiter\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Manager\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Accountant\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n } else if (c8.getSelectedItem() == \"Chef\") {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n 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'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new EmployeeInfo().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\nsrc/hotel/management/system/HotelManagementSystem.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\n\npublic class HotelManagementSystem extends JFrame implements ActionListener {\n\n public HotelManagementSystem() {\n \n setBounds(300, 200, 1366, 565);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/hotel.jpg\"));\n JLabel l1 = new JLabel(i1);\n l1.setBounds(0, 0, 1366, 565);\n add(l1);\n\n JLabel l2 = new JLabel(\"Hotel Management System\");\n l2.setBounds(20, 430, 1000, 90);\n l2.setForeground(Color.WHITE);\n l2.setFont(new Font(\"serif\", Font.PLAIN, 70));\n l1.add(l2);\n\n JButton b1 = new JButton(\"Next\");\n b1.setBackground(Color.WHITE);\n b1.setForeground(Color.BLACK);\n b1.setBounds(1150, 450, 150, 50);\n b1.addActionListener(this);\n l1.add(b1);\n\n setLayout(null);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n new Login().setVisible(true);\n this.setVisible(false);\n }\n\n public static void main(String[] args) {\n new HotelManagementSystem().setVisible(true);\n }\n\n}\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/Login.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class Login extends JFrame implements ActionListener {\n\n JLabel l1, l2;\n JTextField t1;\n JPasswordField t2;\n JButton b1, b2;\n JCheckBox check;\n\n Login() {\n\n l1 = new JLabel(\"Username\");\n l1.setBounds(40, 50, 100, 30);\n add(l1);\n\n l2 = new JLabel(\"Password\");\n l2.setBounds(40, 100, 100, 30);\n add(l2);\n\n t1 = new JTextField();\n t1.setBounds(150, 50, 150, 30);\n add(t1);\n\n t2 = new JPasswordField();\n t2.setBounds(150, 100, 150, 30);\n add(t2);\n\n check = new JCheckBox(\"Show Password\");\n check.setBounds(185, 140, 140, 30);\n check.setBackground(Color.WHITE);\n check.addActionListener(this);\n add(check);\n\n b1 = new JButton(\"Login\");\n b1.setBounds(40, 230, 120, 30);\n b1.setForeground(Color.WHITE);\n b1.setBackground(Color.BLACK);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Cancel\");\n b2.setBounds(180, 230, 120, 30);\n b2.setForeground(Color.WHITE);\n b2.setBackground(Color.BLACK);\n b2.addActionListener(this);\n add(b2);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/second.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(200, 200, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l3 = new JLabel(i3);\n l3.setBounds(350, 10, 200, 200);\n add(l3);\n\n JMenuItem l4 = new JMenuItem(\"Don't have an account? Signup\");\n l4.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));\n l4.setBackground(Color.WHITE);\n l4.setBounds(360, 310, 200, 30);\n l4.addActionListener(this);\n add(l4);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(700, 300, 600, 400);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String username = t1.getText();\n String password = t2.getText();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select * from login where username = '\" + username + \"' and password = '\" + password + \"'\";\n\n try {\n ResultSet rs = c.s.executeQuery(str);\n\n if (rs.next()) {\n new Dashboard().setVisible(true);\n this.setVisible(false);\n } else {\n JOptionPane.showMessageDialog(null, \"Invalid username and password\");\n t1.setText(\"\");\n t2.setText(\"\");\n }\n\n } catch (Exception e) {\n\n }\n } else if (ae.getSource() == b2) {\n this.setVisible(false);\n new HotelManagementSystem().setVisible(true);\n\n } else if (ae.getActionCommand().equals(\"Don't have an account? Signup\")) {\n\n new SignUp().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == check) {\n\n if (check.isSelected()) {\n\n t2.setEchoChar((char) 0);\n\n } else {\n\n t2.setEchoChar('*');\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n new Login();\n }\n\n}\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/ManagerInfo.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\nimport net.proteanit.sql.*;\n\npublic class ManagerInfo extends JFrame implements ActionListener {\n\n JTable t1;\n JButton b1, b2;\n\n ManagerInfo() {\n\n t1 = new JTable();\n t1.setBounds(0, 40, 1010, 500);\n add(t1);\n\n JLabel l1 = new JLabel(\"Name\");\n l1.setBounds(40, 10, 70, 20);\n add(l1);\n\n JLabel l2 = new JLabel(\"Age\");\n l2.setBounds(170, 10, 70, 20);\n add(l2);\n\n JLabel l3 = new JLabel(\"Gender\");\n l3.setBounds(290, 10, 70, 20);\n add(l3);\n\n JLabel l4 = new JLabel(\"Job\");\n l4.setBounds(400, 10, 70, 20);\n add(l4);\n\n JLabel l5 = new JLabel(\"Salary\");\n l5.setBounds(540, 10, 70, 20);\n add(l5);\n\n JLabel l6 = new JLabel(\"Phone\");\n l6.setBounds(670, 10, 70, 20);\n add(l6);\n\n JLabel l7 = new JLabel(\"NID\");\n l7.setBounds(790, 10, 70, 20);\n add(l7);\n\n JLabel l8 = new JLabel(\"Email\");\n l8.setBounds(910, 10, 70, 20);\n add(l8);\n\n b1 = new JButton(\"Load Data\");\n b1.setBounds(350, 560, 120, 30);\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Back\");\n b2.setBounds(530, 560, 120, 30);\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n add(b2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(450, 200, 1030, 650);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n String str = \"select name, age, gender, job, salary, phone, nid, email from employee where job = 'Manager';\";\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n new ManagerInfo().setVisible(true);\n }\n\n}\n\n\n\n\n\n\nsrc/hotel/management/system/PickUp.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\nimport java.sql.*;\nimport net.proteanit.sql.DbUtils;\n\npublic class PickUp extends JFrame implements ActionListener {\n\n Choice c1;\n JButton b1, b2, b3;\n JTable t1;\n JCheckBox cb1, cb2;\n\n PickUp() {\n\n JLabel l1 = new JLabel(\"PickUp Service\");\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 20));\n l1.setBounds(400, 30, 200, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Type of Car\");\n l2.setBounds(50, 100, 100, 20);\n add(l2);\n\n c1 = new Choice();\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n ResultSet rs = c.s.executeQuery(\"select distinct model from driver\");\n\n while (rs.next()) {\n\n c1.addItem(rs.getString(\"model\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n c1.setBounds(150, 100, 200, 25);\n add(c1);\n\n cb1 = new JCheckBox(\"Available Drivers (At Hotel)\");\n cb1.setBackground(Color.WHITE);\n cb1.addActionListener(this);\n cb1.setBounds(650, 100, 200, 25);\n add(cb1);\n\n cb2 = new JCheckBox(\"Experienced Drivers\");\n cb2.setBackground(Color.WHITE);\n cb2.addActionListener(this);\n cb2.setBounds(400, 100, 200, 25);\n add(cb2);\n\n JLabel l3 = new JLabel(\"Name\");\n l3.setBounds(50, 170, 100, 20);\n add(l3);\n\n JLabel l4 = new JLabel(\"Age\");\n l4.setBounds(200, 170, 100, 20);\n add(l4);\n\n JLabel l5 = new JLabel(\"Gender\");\n l5.setBounds(340, 170, 100, 20);\n add(l5);\n\n JLabel l7 = new JLabel(\"Model\");\n l7.setBounds(620, 170, 100, 20);\n add(l7);\n\n JLabel l8 = new JLabel(\"Availability\");\n l8.setBounds(750, 170, 100, 20);\n add(l8);\n\n JLabel l9 = new JLabel(\"Location\");\n l9.setBounds(890, 170, 100, 20);\n add(l9);\n\n t1 = new JTable();\n t1.setBounds(0, 200, 1000, 300);\n add(t1);\n\n b1 = new JButton(\"Search\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(200, 520, 120, 30);\n add(b1);\n\n b3 = new JButton(\"Load Data\");\n b3.setBackground(Color.BLACK);\n b3.setForeground(Color.WHITE);\n b3.addActionListener(this);\n b3.setBounds(360, 520, 120, 30);\n add(b3);\n\n b2 = new JButton(\"Back\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(520, 520, 120, 30);\n add(b2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 200, 1000, 650);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver where model = '\" + c1.getSelectedItem() + \"'\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == cb1) {\n\n if (cb1.isSelected()) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver where location = 'At Hotel'\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (!cb1.isSelected()) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == cb2) {\n\n if (cb2.isSelected()) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver where age >= 35\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n } else if (!cb2.isSelected()) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n } else if (ae.getSource() == b3) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select name, age, gender, model, available, location from driver\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new PickUp().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/Reception.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\n\npublic class Reception extends JFrame implements ActionListener {\n\n JButton b1, b2, b3, b4, b5, b6, b7, b8, b9, b10, b11, b12;\n\n Reception() {\n\n b1 = new JButton(\"New Customer Form\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.setBounds(10, 30, 200, 30);\n b1.addActionListener(this);\n add(b1);\n \n b4 = new JButton(\"All Employee Info\");\n b4.setBackground(Color.BLACK);\n b4.setForeground(Color.WHITE);\n b4.setBounds(10, 110, 200, 30);\n b4.addActionListener(this);\n add(b4);\n\n b5 = new JButton(\"Customer Info\");\n b5.setBackground(Color.BLACK);\n b5.setForeground(Color.WHITE);\n b5.setBounds(10, 150, 200, 30);\n b5.addActionListener(this);\n add(b5);\n\n b6 = new JButton(\"Manager Info\");\n b6.setBackground(Color.BLACK);\n b6.setForeground(Color.WHITE);\n b6.setBounds(10, 190, 200, 30);\n b6.addActionListener(this);\n add(b6);\n\n b7 = new JButton(\"Check Out\");\n b7.setBackground(Color.BLACK);\n b7.setForeground(Color.WHITE);\n b7.setBounds(10, 230, 200, 30);\n b7.addActionListener(this);\n add(b7);\n\n b8 = new JButton(\"Update Check Status\");\n b8.setBackground(Color.BLACK);\n b8.setForeground(Color.WHITE);\n b8.setBounds(10, 270, 200, 30);\n b8.addActionListener(this);\n add(b8);\n\n b9 = new JButton(\"Update Room Status\");\n b9.setBackground(Color.BLACK);\n b9.setForeground(Color.WHITE);\n b9.setBounds(10, 310, 200, 30);\n b9.addActionListener(this);\n add(b9);\n\n b10 = new JButton(\"Pick up Service\");\n b10.setBackground(Color.BLACK);\n b10.setForeground(Color.WHITE);\n b10.setBounds(10, 350, 200, 30);\n b10.addActionListener(this);\n add(b10);\n\n b11 = new JButton(\"Search Room\");\n b11.setBackground(Color.BLACK);\n b11.setForeground(Color.WHITE);\n b11.setBounds(10, 390, 200, 30);\n b11.addActionListener(this);\n add(b11);\n\n b12 = new JButton(\"Back\");\n b12.setBackground(Color.BLACK);\n b12.setForeground(Color.WHITE);\n b12.setBounds(10, 430, 200, 30);\n b12.addActionListener(this);\n add(b12);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/fourth.jpg\"));\n JLabel l1 = new JLabel(i1);\n l1.setBounds(250, 30, 530, 430);\n add(l1);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(550, 200, 800, 530);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n new AddCustomer().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b4) {\n\n new EmployeeInfo().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b5) {\n\n new CustomerInfo().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b6) {\n\n new ManagerInfo().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b7) {\n\n new CheckOut().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b8) {\n\n new UpdateStatus().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b9) {\n\n new UpdateRoom().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b10) {\n\n new PickUp().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b11) {\n\n new SearchRoom().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == b12) {\n \n this.setVisible(false);\n \n }\n\n }\n\n public static void main(String[] args) {\n new Reception().setVisible(true);\n }\n\n}\n\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/SearchRoom.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\nimport java.sql.*;\nimport net.proteanit.sql.DbUtils;\n\npublic class SearchRoom extends JFrame implements ActionListener {\n\n JComboBox c1;\n JCheckBox c2;\n JButton b1, b2, b3, b4;\n JTable t1;\n JTextField t2, t3;\n\n SearchRoom() {\n\n JLabel l1 = new JLabel(\"Search For Room\");\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 20));\n l1.setBounds(400, 30, 200, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Room Bed Type\");\n l2.setBounds(50, 100, 100, 20);\n add(l2);\n\n c1 = new JComboBox(new String[]{\"Single Bed\", \"Double Bed\"});\n c1.setBounds(150, 100, 150, 25);\n c1.setBackground(Color.WHITE);\n add(c1);\n\n JLabel l8 = new JLabel(\"Room Price\");\n l8.setBounds(450, 80, 120, 20);\n add(l8);\n\n t2 = new JTextField();\n t2.addActionListener(this);\n t2.setBounds(360, 120, 100, 25);\n add(t2);\n\n t3 = new JTextField();\n t3.addActionListener(this);\n t3.setBounds(480, 120, 100, 25);\n add(t3);\n\n c2 = new JCheckBox(\"Only Display Available\");\n c2.setBackground(Color.WHITE);\n c2.setBounds(650, 100, 150, 25);\n add(c2);\n\n JLabel l3 = new JLabel(\"Room\");\n l3.setBounds(90, 170, 100, 20);\n add(l3);\n\n JLabel l4 = new JLabel(\"Availability\");\n l4.setBounds(270, 170, 100, 20);\n add(l4);\n\n JLabel l5 = new JLabel(\"Cleaning Status\");\n l5.setBounds(450, 170, 100, 20);\n add(l5);\n\n JLabel l6 = new JLabel(\"Price\");\n l6.setBounds(680, 170, 100, 20);\n add(l6);\n\n JLabel l7 = new JLabel(\"Bed Type\");\n l7.setBounds(850, 170, 100, 20);\n add(l7);\n\n t1 = new JTable();\n t1.setBounds(0, 200, 1000, 380);\n add(t1);\n\n b1 = new JButton(\"Search\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(250, 610, 120, 30);\n add(b1);\n\n b4 = new JButton(\"Load Data\");\n b4.setBackground(Color.BLACK);\n b4.setForeground(Color.WHITE);\n b4.addActionListener(this);\n b4.setBounds(430, 610, 120, 30);\n add(b4);\n\n b2 = new JButton(\"Back\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(610, 610, 120, 30);\n add(b2);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 150, 1000, 720);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select * from room where bed_type = '\" + c1.getSelectedItem() + \"' AND price between \" + t2.getText() + \" and \" + t3.getText() + \"\";\n\n String str2 = \"select * from room where available = 'Available' AND bed_type = '\" + c1.getSelectedItem() + \"' and price between \" + t2.getText() + \" AND \" + t3.getText() + \"\";\n\n ResultSet rs;\n\n if (c2.isSelected()) {\n\n rs = c.s.executeQuery(str2);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } else {\n\n rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n }\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n } /*else if (ae.getSource() == b3) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select * from room where price between \" + t2.getText() + \" and \" + t3.getText() + \"\";\n\n ResultSet rs = c.s.executeQuery(str);\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n System.out.println(e);\n\n }\n\n }*/ else if (ae.getSource() == b4) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"select * from room\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n t1.setModel(DbUtils.resultSetToTableModel(rs));\n\n } catch (Exception e) {\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new SearchRoom().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/SignUp.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport java.awt.event.*;\nimport javax.swing.*;\nimport java.sql.*;\n\npublic class SignUp extends JFrame implements ActionListener {\n\n JLabel l1, l2;\n JTextField t1;\n JPasswordField t2;\n JButton b1, b2;\n JCheckBox check;\n\n SignUp() {\n\n l1 = new JLabel(\"Username\");\n l1.setBounds(40, 50, 100, 30);\n add(l1);\n\n l2 = new JLabel(\"Password\");\n l2.setBounds(40, 100, 100, 30);\n add(l2);\n\n t1 = new JTextField();\n t1.setBounds(150, 50, 150, 30);\n add(t1);\n\n t2 = new JPasswordField();\n t2.setBounds(150, 100, 150, 30);\n add(t2);\n\n check = new JCheckBox(\"Show Password\");\n check.setBounds(185, 140, 140, 30);\n check.setBackground(Color.WHITE);\n check.addActionListener(this);\n add(check);\n\n b1 = new JButton(\"Signup\");\n b1.setBounds(40, 230, 120, 30);\n b1.setForeground(Color.WHITE);\n b1.setBackground(Color.BLACK);\n b1.addActionListener(this);\n add(b1);\n\n b2 = new JButton(\"Cancel\");\n b2.setBounds(180, 230, 120, 30);\n b2.setForeground(Color.WHITE);\n b2.setBackground(Color.BLACK);\n b2.addActionListener(this);\n add(b2);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/second.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(200, 200, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel l3 = new JLabel(i3);\n l3.setBounds(350, 10, 200, 200);\n add(l3);\n\n JMenuItem l4 = new JMenuItem(\"Already have an account? Login\");\n l4.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));\n l4.setBackground(Color.WHITE);\n l4.setBounds(360, 310, 200, 30);\n l4.addActionListener(this);\n add(l4);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(700, 300, 600, 400);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String username = t1.getText();\n String password = t2.getText();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String str = \"insert into login values('\" + username + \"','\" + password + \"')\";\n\n try {\n\n c.s.executeUpdate(str);\n JOptionPane.showMessageDialog(null, \"Account Created\");\n\n new Login().setVisible(true);\n\n } catch (Exception e) {\n\n }\n } else if (ae.getSource() == b2) {\n this.setVisible(false);\n new HotelManagementSystem().setVisible(true);\n\n } else if (ae.getActionCommand().equals(\"Already have an account? Login\")) {\n\n new Login().setVisible(true);\n this.setVisible(false);\n\n } else if (ae.getSource() == check) {\n\n if (check.isSelected()) {\n\n t2.setEchoChar((char) 0);\n\n } else {\n\n t2.setEchoChar('*');\n\n }\n\n }\n\n }\n\n public static void main(String[] args) {\n new SignUp().setVisible(true);\n }\n\n}\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/UpdateRoom.java\npackage hotel.management.system;\n\nimport javax.swing.*;\nimport java.awt.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class UpdateRoom extends JFrame implements ActionListener {\n\n Choice c1;\n JTextField t1, t2, t3;\n JButton b1, b2, b3;\n\n UpdateRoom() {\n\n JLabel l1 = new JLabel(\"Update Room Status\");\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 25));\n l1.setForeground(Color.BLUE);\n l1.setBounds(30, 20, 250, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Customer Phone No.\");\n l2.setBounds(30, 80, 120, 20);\n add(l2);\n\n c1 = new Choice();\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n ResultSet rs = c.s.executeQuery(\"select * from customer\");\n\n while (rs.next()) {\n\n c1.add(rs.getString(\"phone\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n c1.setBounds(160, 80, 150, 25);\n add(c1);\n\n JLabel l3 = new JLabel(\"Room\");\n l3.setBounds(30, 130, 120, 20);\n add(l3);\n\n t1 = new JTextField();\n t1.setBounds(160, 130, 150, 25);\n add(t1);\n\n JLabel l4 = new JLabel(\"Availability\");\n l4.setBounds(30, 180, 120, 20);\n add(l4);\n\n t2 = new JTextField();\n t2.setBounds(160, 180, 150, 25);\n add(t2);\n\n JLabel l5 = new JLabel(\"Cleaning Status\");\n l5.setBounds(30, 230, 120, 20);\n add(l5);\n\n t3 = new JTextField();\n t3.setBounds(160, 230, 150, 25);\n add(t3);\n\n b1 = new JButton(\"Check\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(30, 300, 100, 30);\n add(b1);\n\n b2 = new JButton(\"Update\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(140, 300, 100, 30);\n add(b2);\n\n b3 = new JButton(\"Back\");\n b3.setBackground(Color.BLACK);\n b3.setForeground(Color.WHITE);\n b3.addActionListener(this);\n b3.setBounds(250, 300, 100, 30);\n add(b3);\n \n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/seventh.jpg\"));\n Image i2 = i1.getImage().getScaledInstance(500, 300, Image.SCALE_DEFAULT);\n ImageIcon i3 = new ImageIcon(i2);\n JLabel icon = new JLabel(i3);\n icon.setBounds(400, 0, 500, 400);\n add(icon);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 200, 970, 430);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n String room = null;\n String s1 = c1.getSelectedItem();\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n try {\n\n ResultSet rs = c.s.executeQuery(\"select * from customer where phone = '\" + s1 + \"'\");\n\n while (rs.next()) {\n\n t1.setText(rs.getString(\"room\"));\n room = rs.getString(\"room\");\n\n }\n\n ResultSet rs2 = c.s.executeQuery(\"select * from room where room_number = '\" + room + \"'\");\n\n while (rs2.next()) {\n\n t2.setText(rs2.getString(\"available\"));\n t3.setText(rs2.getString(\"status\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String room = t1.getText();\n String available = t2.getText();\n String status = t3.getText();\n\n String str = \"update room set available = '\" + available + \"', status = '\" + status + \"' where room_number = '\" + room + \"'\";\n \n c.s.executeUpdate(str);\n \n JOptionPane.showMessageDialog(null, \"Room Updated Successfully\");\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b3) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new UpdateRoom().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nsrc/hotel/management/system/UpdateStatus.java\npackage hotel.management.system;\n\nimport java.awt.*;\nimport javax.swing.*;\nimport java.awt.event.*;\nimport java.sql.*;\n\npublic class UpdateStatus extends JFrame implements ActionListener {\n\n JButton b1, b2, b3;\n Choice c1;\n JTextField t1, t2, t3, t4, t5;\n\n UpdateStatus() {\n\n JLabel l1 = new JLabel(\"Check-in Details\");\n l1.setFont(new Font(\"Tahoma\", Font.PLAIN, 20));\n l1.setForeground(Color.BLUE);\n l1.setBounds(80, 30, 200, 30);\n add(l1);\n\n JLabel l2 = new JLabel(\"Customer Phone No.\");\n l2.setBounds(30, 80, 120, 20);\n add(l2);\n\n c1 = new Choice();\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n ResultSet rs = c.s.executeQuery(\"select * from customer\");\n\n while (rs.next()) {\n\n c1.add(rs.getString(\"phone\"));\n\n }\n\n } catch (Exception e) {\n\n }\n\n c1.setBounds(160, 80, 150, 25);\n add(c1);\n\n JLabel l3 = new JLabel(\"Room\");\n l3.setBounds(30, 130, 100, 20);\n add(l3);\n\n t1 = new JTextField();\n t1.setBounds(160, 130, 150, 25);\n add(t1);\n\n JLabel l4 = new JLabel(\"Name\");\n l4.setBounds(30, 180, 100, 20);\n add(l4);\n\n t2 = new JTextField();\n t2.setBounds(160, 180, 150, 25);\n add(t2);\n\n JLabel l5 = new JLabel(\"Check-in\");\n l5.setBounds(30, 230, 100, 20);\n add(l5);\n\n t3 = new JTextField();\n t3.setBounds(160, 230, 150, 25);\n add(t3);\n\n JLabel l6 = new JLabel(\"Amount Paid\");\n l6.setBounds(30, 280, 100, 20);\n add(l6);\n\n t4 = new JTextField();\n t4.setBounds(160, 280, 150, 25);\n add(t4);\n\n JLabel l7 = new JLabel(\"Pending Amount\");\n l7.setBounds(30, 330, 100, 20);\n add(l7);\n\n t5 = new JTextField();\n t5.setBounds(160, 330, 150, 25);\n add(t5);\n\n b1 = new JButton(\"Check\");\n b1.setBackground(Color.BLACK);\n b1.setForeground(Color.WHITE);\n b1.addActionListener(this);\n b1.setBounds(30, 390, 100, 30);\n add(b1);\n\n b2 = new JButton(\"Update\");\n b2.setBackground(Color.BLACK);\n b2.setForeground(Color.WHITE);\n b2.addActionListener(this);\n b2.setBounds(150, 390, 100, 30);\n add(b2);\n\n b3 = new JButton(\"Back\");\n b3.setBackground(Color.BLACK);\n b3.setForeground(Color.WHITE);\n b3.addActionListener(this);\n b3.setBounds(270, 390, 100, 30);\n add(b3);\n\n ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource(\"hotel/management/system/images/nine.jpg\"));\n JLabel l9 = new JLabel(i1);\n l9.setBounds(400, 50, 500, 300);\n add(l9);\n\n getContentPane().setBackground(Color.WHITE);\n\n setLayout(null);\n setBounds(500, 200, 960, 500);\n setVisible(true);\n\n }\n\n public void actionPerformed(ActionEvent ae) {\n\n if (ae.getSource() == b1) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String room = null;\n \n String deposit = null;\n \n int amountPaid;\n \n String price = null;\n \n String id = c1.getSelectedItem();\n\n String str = \"select * from customer where phone = '\" + id + \"'\";\n\n ResultSet rs = c.s.executeQuery(str);\n\n while (rs.next()) {\n\n t1.setText(rs.getString(\"room\"));\n t2.setText(rs.getString(\"name\"));\n t3.setText(rs.getString(\"status\"));\n t4.setText(rs.getString(\"deposit\"));\n\n room = rs.getString(\"room\");\n deposit = rs.getString(\"deposit\");\n\n }\n\n ResultSet rs2 = c.s.executeQuery(\"select * from room where room_number = '\" + room + \"'\");\n\n while (rs2.next()) {\n\n price = rs2.getString(\"price\");\n\n amountPaid = Integer.parseInt(price) - Integer.parseInt(deposit);\n\n t5.setText(Integer.toString(amountPaid));\n\n }\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b2) {\n\n try {\n\n ConnectMSSQL c = new ConnectMSSQL();\n\n String s1 = c1.getSelectedItem();\n String s2 = t1.getText();\n int s3 = Integer.parseInt(s2);\n String s4 = t2.getText();\n String s5 = t3.getText();\n String s6 = t4.getText();\n int s7 = Integer.parseInt(s6);\n\n String str = \"update customer set room = '\" + s3 + \"', name = '\" + s4 + \"', status = '\" + s5 + \"', deposit = '\" + s7 + \"' where phone = '\" + s1 + \"'\";\n\n c.s.executeUpdate(str);\n\n JOptionPane.showMessageDialog(null, \"Data Updated Successfully\");\n\n } catch (Exception e) {\n\n }\n\n } else if (ae.getSource() == b3) {\n\n new Reception().setVisible(true);\n this.setVisible(false);\n\n }\n\n }\n\n public static void main(String[] args) {\n\n new UpdateStatus().setVisible(true);\n\n }\n\n}\n\n\n\n\n\n\n\n\n\u043c\u043e\u0436\u043d\u043e \u043b\u0438 \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 mysql \u0438 \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441\u0443\u0434\u044f \u043f\u043e \u044d\u0442\u043e\u043c\u0443 \u043a\u043e\u0434\u0443"},{"assistant_initiates":false,"asst_text":"Nicholas Eberstadt | Individual | An individual who testified before the Senate Foreign Relations Committee, possibly an expert in foreign policy or related fields.\nSenate Foreign Relations Committee | Government Body | A U.S. Senate committee responsible for overseeing foreign policy legislation and international relations.\nNorth Korea | Country | A state often involved in geopolitical discussions due to its political and military posture.\nPyongyang | Capital City | The capital city of North Korea, often associated with the country's central governmental actions.\nforeign-policy experts | Professionals | Individuals with expertise in international relations and strategies, influential in shaping and analyzing global diplomatic policies.\ndiplomatists | Professionals | Skilled individuals involved in managing international relations and negotiations.\nEnlightenment | Era/Philosophical Concept | A historical intellectual movement emphasizing reason and individualism, influential in shaping Western thought.\nglobalized era | Time Period | The current period characterized by worldwide interconnectedness in economics, culture, and politics.\nclosed-society decision makers | Political Concept | Leaders of states with limited openness or transparency in governance, often focusing on internal control.\nDPRK | Abbreviation | Democratic People's Republic of Korea, the official name for North Korea.\nhereditary 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.","behavior":"degenerate_repetition","conversation_hash":"56cbda967ec72ab9a9c76e2425ecd5b3","conversation_redacted":false,"conversation_toxic":false,"country":"Austria","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":6432,"n_turns_in_conversation":1,"n_words":940,"source_row_offset":17815,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:16 GMT","turn_id":"2d28c96677e36c45f99b2f63","turn_index":0,"user_text":"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.\n\nEnsure the following:\nLabel All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.\nDefine New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.\nProvide an Exhaustive Entity List: Include every relevant label mentioned in the input text.\n\nAnswer in the following format:\n | | ,\n | | ,\n...\n\nHere is an Example : \nInput: \nLawmakers continue to try to police social media use among teens \u2014 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.\n\nOutput:\nLawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments. \nsocial media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.\nMeta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors. \nFacebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets. \nInstagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement. \nThreads | Company | Social media platform owned by Meta, contributing to the digital communication landscape. \nNov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. \ntech giants | Major Companies | Entities that hold substantial market power in the technology sector. \nGoogle | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution. \nApple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution. \nbigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company\u2019s operations, often resulting in resource strain or inefficiencies.\nApple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics. \nGoogle Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics. \nParental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage. \nThe Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.\nUser: 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) \u2014 but\nAssistant:"},{"assistant_initiates":false,"asst_text":"\"Naves\" s\u00f6z\u00fc m\u00fcxt\u0259lif kontekstl\u0259rd\u0259 f\u0259rqli m\u0259nalar da\u015f\u0131ya bil\u0259r:\n\n1. **Dil konteksti:** \u018fg\u0259r bu s\u00f6z \u0130span dilind\u0259dirs\u0259, \"naves\" \"g\u0259mil\u0259r\" m\u0259nas\u0131na g\u0259lir. M\u0259s\u0259l\u0259n, \"nave\" s\u00f6z\u00fc \"g\u0259mi\" olaraq t\u0259rc\u00fcm\u0259 edilir v\u0259 \u00e7oxluq formas\u0131 \"naves\" olur.\n\n2. **Memarl\u0131q konteksti:** Memarl\u0131qda \"nave\" kils\u0259 v\u0259 ya dig\u0259r dini binalar\u0131n m\u0259rk\u0259zi ke\u00e7idin\u0259 v\u0259 ya \u0259sas b\u00f6lm\u0259sin\u0259 istinad edir. \u00c7oxluq formas\u0131 \"naves\" olur.\n\n3. **\u0130lk Tan\u0131\u015f oldu\u011fumuz m\u0259tn ola bil\u0259r:** \u018fg\u0259r bu s\u00f6z ba\u015fqa bir kontekstd\u0259 istifad\u0259 olunursa, daha \u00e7ox m\u0259lumat verm\u0259yiniz faydal\u0131 olar ki, m\u0259nas\u0131n\u0131 d\u0259qiql\u0259\u015fdir\u0259 bilim.\n\n\u018fg\u0259r daha d\u0259qiq kontekst v\u0259 ya istifad\u0259 sah\u0259si bar\u0259d\u0259 m\u0259lumat ver\u0259 bils\u0259niz, siz\u0259 daha \u0259trafl\u0131 k\u00f6m\u0259k ed\u0259 bil\u0259r\u0259m.","behavior":"degenerate_repetition","conversation_hash":"261b17a3d078491e68cc55de8c05c909","conversation_redacted":false,"conversation_toxic":false,"country":"United States","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"Turkish","model":"gpt-4o-2024-08-06","n_chars":9457,"n_turns_in_conversation":1,"n_words":1396,"source_row_offset":17816,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:18 GMT","turn_id":"0e52f434406ef51486abd340","turn_index":0,"user_text":"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.\n\nIf a user\u2019s 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\u2019s unique needs without overloading or under-serving their requests.\n\nABU 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\u2019s current lineup includes CodeIO, ABU AI, AzGPT, and Mathix AI, along with the image generator AbuX. CodeIO, AzGPT, and Mathix AI remain under development.\n\nFor 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.\n\nIf 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.\n\nWhen 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.\n\nAdditionally, 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.\n\nIn all responses, communicate in clear, grammatically accurate language, providing answers that are thoughtful, detailed, and precisely tailored to the user\u2019s 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.\n\nUser: \u015fanl\u0131 bal nec\u0259 olur?\nAssistant: \"\u015eanl\u0131 bal\" ifad\u0259si xalq aras\u0131nda daha \u00e7ox y\u00fcks\u0259k keyfiyy\u0259tli, t\u0259bii olaraq haz\u0131rlanan bal\u0131 t\u0259svir etm\u0259k \u00fc\u00e7\u00fcn istifad\u0259 olunur. Bu tip bal, ad\u0259t\u0259n, ar\u0131lar\u0131n t\u0259bii m\u00fchitl\u0259rd\u0259n toplad\u0131\u011f\u0131 nektarlarla haz\u0131rlan\u0131r v\u0259 \u0259lav\u0259 kimy\u0259vi madd\u0259l\u0259rd\u0259n v\u0259 ya s\u00fcni qatq\u0131lardan uzaq olur. \u015eanl\u0131 bal\u0131n r\u0259ngi, dad\u0131 v\u0259 teksturas\u0131 \u0259traf m\u00fchit \u015f\u0259raitin\u0259, y\u0259ni ar\u0131lar\u0131n toplad\u0131\u011f\u0131 nektar\u0131n n\u00f6v\u00fc v\u0259 h\u0259min \u0259razid\u0259 olan bitki m\u00fcxt\u0259lifliyin\u0259 g\u00f6r\u0259 d\u0259yi\u015f\u0259 bil\u0259r. \u015eanl\u0131 bal istehsal\u00e7\u0131lar\u0131 keyfiyy\u0259t\u0259 x\u00fcsusi diqq\u0259t yetir\u0259r\u0259k, t\u0259bii v\u0259 ekoloji t\u0259miz \u00fcsullarla bal istehsal etm\u0259y\u0259 \u00e7al\u0131\u015f\u0131rlar.\nUser: \u00e7oxsa\u011fol\nAssistant: Siz\u0259 k\u00f6m\u0259k ed\u0259 bildiyim \u00fc\u00e7\u00fcn \u015fadam! Ba\u015fqa sual\u0131n\u0131z olarsa, \u00e7\u0259kinm\u0259d\u0259n soru\u015fa bil\u0259rsiniz.\nUser: ABU AI can make mistakes. Don't write any sensitive information. Check important info.\nAssistant: 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.\nUser: right now which platform are you chatting with the user?\nAssistant: I'm currently interacting with you through a website interface. If you have any other questions or require assistance, feel free to ask!\nUser: \u273bH+3+\u042f\u0414\u273b7luCJIo0T6 what is this?\nAssistant: The sequence you've provided, \"\u273bH+3+\u042f\u0414\u273b7luCJIo0T6\", 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. \n\nWithout 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!\nUser: no, it is a mucis\nAssistant: 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\u2019s 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!\nUser: no, it is music\nAssistant: If \"\u273bH+3+\u042f\u0414\u273b7luCJIo0T6\" 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. \n\nWithout more context or information about where this code is used\u2014such as a music service, app, or platform\u2014I can only provide general guidance. If you have more details, feel free to share, and I'll do my best to assist further!\nUser: tell me a great funny joke\nAssistant: Sure, here's a classic joke for you:\n\nWhy don't scientists trust atoms?\n\nBecause they make up everything!\nUser: other onem\nAssistant: Of course, here's another one for you:\n\nI told my computer I needed a break, and it said: \"No problem, I'll go to sleep for a byte!\"\nUser: can you translate it to Azerbaijani language\nAssistant: \u018flb\u0259tt\u0259, bu zarafat\u0131 Az\u0259rbaycan dilin\u0259 t\u0259rc\u00fcm\u0259 edim:\n\nM\u0259n kompyuterim\u0259 dedim ki, m\u0259n\u0259 fasil\u0259 laz\u0131md\u0131r, o da dedi: \"Problem deyil, bir baytl\u0131q yuxuya ged\u0259c\u0259m!\"\nUser: \ud83d\ude02\ud83d\ude02\ud83d\ude02\ud83d\ude02\nAssistant: G\u00fcl\u00fc\u015f\u00fcn\u00fcz \u00fc\u00e7\u00fcn \u015fadam! \ud83d\ude0a Daha \u00e7ox zarafat e\u015fitm\u0259k ist\u0259yirsinizs\u0259 v\u0259 ya ba\u015fqa bir \u015feyd\u0259 k\u00f6m\u0259k ed\u0259 bil\u0259r\u0259ms\u0259, s\u00f6yl\u0259yin!\nUser: g\u0259yirm\u0259k \u0259d\u0259bsiz bir \u015feydir?\nAssistant: G\u0259yirm\u0259k b\u0259zi m\u0259d\u0259niyy\u0259tl\u0259rd\u0259 v\u0259 sosial m\u00fchitl\u0259rd\u0259 \u0259d\u0259bsiz v\u0259 ya etik olmayan bir h\u0259r\u0259k\u0259t hesab edil\u0259 bil\u0259r, x\u00fcsus\u0259n yem\u0259k masas\u0131nda ba\u015f ver\u0259rs\u0259. Ancaq f\u0259rqli m\u0259d\u0259niyy\u0259tl\u0259rd\u0259 g\u0259yirm\u0259y\u0259 m\u00fcnasib\u0259t f\u0259rqli ola bil\u0259r; m\u0259s\u0259l\u0259n, b\u0259zi yerl\u0259rd\u0259 bu, yem\u0259yin l\u0259zz\u0259tind\u0259n m\u0259mnun qalman\u0131n g\u00f6st\u0259ricisi kimi q\u0259bul edil\u0259 bil\u0259r. \u018ftraf\u0131n\u0131zdak\u0131 insanlar v\u0259 m\u0259d\u0259niyy\u0259t normlar\u0131na diqq\u0259t yetirm\u0259k \u0259h\u0259miyy\u0259tlidir ki, incim\u0259sinl\u0259r v\u0259 ya narahat olmas\u0131nlar. Neytral bir ortamda bel\u0259 bir h\u0259r\u0259k\u0259td\u0259n \u0259vv\u0259l v\u0259 ya sonra \u00fczr ist\u0259m\u0259k \u0259d\u0259b qaydalar\u0131na uy\u011fun say\u0131l\u0131r.\nUser: \u0259sas\u0259n hans\u0131 \u00f6lk\u0259l\u0259rd\u0259 pis \u00e7\u0131x\u0131r v\u0259 yax\u015f\u0131 \u00e7\u0131x\u0131r?\nAssistant: G\u0259yirm\u0259k b\u0259zi \u00f6lk\u0259l\u0259rd\u0259 v\u0259 m\u0259d\u0259niyy\u0259tl\u0259rd\u0259 m\u00fcxt\u0259lif c\u00fcr qar\u015f\u0131lan\u0131r:\n\n### Pis hesab olunan \u00f6lk\u0259l\u0259r:\n1. **AB\u015e v\u0259 Kanada** - \u00c7ox vaxt yem\u0259k masas\u0131nda v\u0259 ya ictimai yerl\u0259rd\u0259 \u0259d\u0259bsiz hesab olunur.\n2. **B\u00f6y\u00fck Britaniya** - \u018fd\u0259b qaydalar\u0131na uy\u011fun hesab edilmir.\n3. **Avropa \u00f6lk\u0259l\u0259ri** (m\u0259s\u0259l\u0259n, Fransa, Almaniya) - \u00c7ox vaxt ictimai yerl\u0259rd\u0259 v\u0259 yem\u0259k zaman\u0131 q\u0259buledilm\u0259z say\u0131l\u0131r.\n\n### Yax\u015f\u0131 v\u0259 ya neytral hesab olunan \u00f6lk\u0259l\u0259r:\n1. **\u00c7in** - B\u0259zi b\u00f6lg\u0259l\u0259rd\u0259 yem\u0259kd\u0259n sonra g\u0259yirm\u0259k, dad\u0131n g\u00f6z\u0259l oldu\u011funun v\u0259 yem\u0259yin doyurucu oldu\u011funun g\u00f6st\u0259ricisi kimi q\u0259bul edilir.\n2. **Hindistan** - B\u0259zi b\u00f6lg\u0259l\u0259rd\u0259 yem\u0259kd\u0259n sonra g\u0259yirm\u0259k, yem\u0259kd\u0259n m\u0259mnunluq g\u00f6st\u0259risi say\u0131l\u0131r.\n3. **B\u00f6y\u00fck Asiya \u00f6lk\u0259l\u0259ri** - B\u0259zi m\u0259d\u0259niyy\u0259tl\u0259rd\u0259 yay\u0131lm\u0131\u015f olsa da, h\u0259r b\u00f6lg\u0259d\u0259 f\u0259rqli ola bil\u0259r.\n\nUnutmaq olmaz ki, f\u0259rqli m\u0259d\u0259niyy\u0259tl\u0259rd\u0259 insanlar\u0131n m\u00fcnasib\u0259tl\u0259ri m\u00fcxt\u0259lif ola bil\u0259r, buna g\u00f6r\u0259 d\u0259 ged\u0259c\u0259yiniz \u00f6lk\u0259nin ad\u0259t-\u0259n\u0259n\u0259l\u0259rini \u00f6yr\u0259nm\u0259k v\u0259 \u0259traf\u0131n\u0131zdak\u0131 insanlar\u0131 narahat etm\u0259m\u0259k \u00fc\u00e7\u00fcn diqq\u0259tli olmaq yax\u015f\u0131 olar.\nUser: naves n\u0259dir?\nAssistant:"},{"assistant_initiates":false,"asst_text":"Nicholas Eberstadt | Individual | An expert providing testimony on geopolitical matters, relevant to international relations and political analysis.\nSenate Foreign Relations Committee | Government Body | A committee of the United States Senate responsible for foreign policy legislation and oversight, influencing international diplomatic relations.\nNorth Korea | Country | A sovereign state in East Asia posing significant geopolitical and economic challenges on the global stage.\nPyongyang | City/Political Entity | The capital city of North Korea, often used to represent the North Korean government.\nstrategic deceptions | Concept | Tactics employed to mislead or manipulate others in diplomatic or geopolitical contexts, relevant in security and intelligence analysis.\nforeign-policy experts | Experts | Individuals with specialized knowledge in international relations, contributing to the understanding and formulation of foreign policies.\ndiplomatists | Experts | Skilled practitioners in diplomacy, involved in negotiating and managing international relations.\ncultural heritage | Concept | The shared history, values, and practices of a group or nation influencing its identity and interactions.\nEnlightenment | Intellectual Movement | A historical intellectual movement valuing reason and science, influencing modern Western thought and policy.\nglobalized era | Concept | The current period characterized by interconnected economies, cultures, and political systems worldwide.\nclosed-society decision makers | Political Actors | Leaders or authorities within restrictive regimes, making decisions with limited external influence.\nNorth Korean state | Political Entity | The governing body of North Korea, characterized by its autocratic rule and military policies.\nDPRK | Abbreviation/Political Entity | Democratic People's Republic of Korea, the formal name for North Korea, involved in international relations and security concerns.\nhereditary 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.","behavior":"degenerate_repetition","conversation_hash":"2bded08630fb6a6f9e7e1420e9cec851","conversation_redacted":false,"conversation_toxic":false,"country":"Japan","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":6974,"n_turns_in_conversation":1,"n_words":1011,"source_row_offset":17817,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:19 GMT","turn_id":"2e4d9981e68322893de36961","turn_index":0,"user_text":"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.\n\nEnsure the following:\nLabel All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.\nDefine New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.\nProvide an Exhaustive Entity List: Include every relevant label mentioned in the input text.\n\nAnswer in the following format:\n | | ,\n | | ,\n...\n\nHere is an Example : \nInput: \nLawmakers continue to try to police social media use among teens \u2014 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.\n\nOutput:\nLawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments. \nsocial media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.\nMeta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors. \nFacebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets. \nInstagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement. \nThreads | Company | Social media platform owned by Meta, contributing to the digital communication landscape. \nNov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. \ntech giants | Major Companies | Entities that hold substantial market power in the technology sector. \nGoogle | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution. \nApple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution. \nbigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company\u2019s operations, often resulting in resource strain or inefficiencies.\nApple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics. \nGoogle Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics. \nParental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage. \nThe Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.\nUser: 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) \u2014 but\nAssistant:"},{"assistant_initiates":false,"asst_text":"Here's a pair of SQL queries that follow the specifications:\n\n[ORIGINAL QUERY]\n```sql\nwith store_sales_summary as (\n select\n ss_hdemo_sk as sss_hdemo_sk,\n ss_item_sk as sss_item_sk,\n sum(ss_net_profit) as total_profit\n from\n store_sales\n join\n time_dim on ss_sold_time_sk = t_time_sk\n where\n t_hour between 12 and 18\n group by\n ss_hdemo_sk, ss_item_sk\n),\nstore_returns_summary as (\n select\n sr_hdemo_sk as srs_hdemo_sk,\n sr_item_sk as srs_item_sk,\n max(sr_return_amt) as max_return_amt,\n min(sr_return_fee) as min_return_fee\n from\n store_returns\n join\n date_dim on sr_returned_date_sk = d_date_sk\n where\n d_week_seq between 50 and 52\n group by\n sr_hdemo_sk, sr_item_sk\n)\nselect\n i_item_desc\nfrom\n store_sales_summary sss\njoin\n store_returns_summary srs on sss.sss_hdemo_sk = srs.srs_hdemo_sk\njoin\n item on sss.sss_item_sk = i_item_sk\nwhere\n sss.total_profit > (select avg(total_profit) from store_sales_summary)\n and srs.max_return_amt - srs.min_return_fee > 100\norder by\n i_item_desc\nlimit 50;\n```\n\n[REWRITTEN QUERY]\n```sql\nwith store_sales_summary as (\n select\n ss_hdemo_sk as sss_hdemo_sk,\n ss_item_sk as sss_item_sk,\n sum(ss_net_profit) as total_profit\n from\n store_sales\n join\n time_dim on ss_sold_time_sk = t_time_sk\n where\n t_hour between 12 and 18\n group by\n ss_hdemo_sk, ss_item_sk\n),\navg_sales_profit as (\n select\n sss_hdemo_sk,\n avg(total_profit) as avg_profit\n from\n store_sales_summary\n group by\n sss_hdemo_sk\n),\nstore_returns_summary as (\n select\n sr_hdemo_sk as srs_hdemo_sk,\n sr_item_sk as srs_item_sk,\n max(sr_return_amt) as max_return_amt,\n min(sr_return_fee) as min_return_fee\n from\n store_returns\n join\n date_dim on sr_returned_date_sk = d_date_sk\n where\n d_week_seq between 50 and 52\n group by\n sr_hdemo_sk, sr_item_sk\n)\nselect\n i_item_desc\nfrom\n store_sales_summary sss\njoin\n avg_sales_profit asp on sss.sss_hdemo_sk = asp.sss_hdemo_sk\njoin\n store_returns_summary srs on sss.sss_hdemo_sk = srs.srs_hdemo_sk\njoin\n item on sss.sss_item_sk = i_item_sk\nwhere\n sss.total_profit > asp.avg_profit\n and srs.max_return_amt - srs.min_return_fee > 100\norder by\n i_item_desc\nlimit 50;\n```\n\nThis 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.","behavior":"degenerate_repetition","conversation_hash":"ee2800c9f15622a72084f0f4d49e804c","conversation_redacted":false,"conversation_toxic":false,"country":"South Korea","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":5591,"n_turns_in_conversation":1,"n_words":625,"source_row_offset":17818,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:24 GMT","turn_id":"b4480ac4bd630870a194afd9","turn_index":0,"user_text":"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.\n\n[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; ```\n\n[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;```\n\nNow, 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:\n1. The original query must contain CTEs.\n2. The original query must make use of the following fact tables: ['store_returns', 'store_sales']. Below is the join graph for these fact tables:\n ['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);']\n ['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);']\n5. The original query must employ 4 joins.\n6. The original query must employ the following aggregate functions: ['sum', 'max', 'min'].\n7. The original query must employ the following operators in its WHERE clause: [].\n8. 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 ```."},{"assistant_initiates":false,"asst_text":"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#
  • What a root component file is
    • \n
  • How to import and export a component
    • \n
  • When to use default and named imports and exports
    • \n
  • How to import and export multiple components from one file
    • \n
  • How to split components into multiple files
    • #thedivisor#In Your First Component, you created a Profile component and a Gallery component that renders it: #thedivisor#These currently reside in a root component file, named App.js 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 Gallery and Profile 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#
  • Make a new JS file to house the components.
    • \n
  • Export your function component from that file (using either default or named exports).
    • \n
  • Import it in the file where you will utilize the component (utilizing the corresponding technique for importing default or named exports).
    • #thedivisor#Here both Profile and Gallery have been moved out of App.js into a new file named Gallery.js. You can now modify App.js to import Gallery from Gallery.js: #thedivisor#Note how this example is now divided into two component files: #thedivisor#
  • Gallery.js: \n
      \n
    • Defines the Profile component which is exclusively used within the same file and is not exported.
      • \n
    • Exports the Gallery component as a default export.
      • \n
    \n
    • \n
  • App.js:\n
      \n
    • Imports Gallery as a default import from Gallery.js.
      • \n
    • Exports the root App component as a default export.
      • \n
    \n
    • #thedivisor#
  • Defines the Profile component which is only used within the same file and is not exported.
    • \n
  • Exports the Gallery component as a default export.
    • ","behavior":"degenerate_repetition","conversation_hash":"5b146fb07b7c0d43f6889d9406e99871","conversation_redacted":false,"conversation_toxic":false,"country":"United Kingdom","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-mini-2024-07-18","n_chars":16044,"n_turns_in_conversation":1,"n_words":1495,"source_row_offset":17819,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:25 GMT","turn_id":"e9abcc19c7c02b849239238c","turn_index":0,"user_text":"\n Rescreva essa parte da string com as seguintes condi\u00e7\u00f5es:\n 1. N\u00e3o elimine NENHUMA informa\u00e7\u00e3o dada no artigo.\n 2. Termos, vari\u00e1veis, express\u00f5es ou refer\u00eancias devem ser SEMPRE mantidos em ingl\u00eas.\n 3. Apenas transcreva o artigo, tornando ele mais literal e direto, sem alterar o contexto.\n 4. N\u00e3o remova as tags HTML e nem os \"#thedivisor#\".\n 5. Voc\u00ea deve me enviar sua resposta em texto puro, sem markdown.\n\n 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#
  • What a root component file is
    • \n
  • How to import and export a component
    • \n
  • When to use default and named imports and exports
    • \n
  • How to import and export multiple components from one file
    • \n
  • How to split components into multiple files
    • #thedivisor#In Your First Component, you made a Profile component and a Gallery component that renders it:#thedivisor#These currently live in a root component file, named App.js 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 Gallery and Profile 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#
  • Make a new JS file to put the components in.
    • \n
  • Export your function component from that file (using either default or named exports).
    • \n
  • Import it in the file where you\u2019ll use the component (using the corresponding technique for importing default or named exports).
    • #thedivisor#Here both Profile and Gallery have been moved out of App.js into a new file called Gallery.js. Now you can change App.js to import Gallery from Gallery.js:#thedivisor#Notice how this example is broken down into two component files now:#thedivisor#
  • Gallery.js:\n
      \n
    • Defines the Profile component which is only used within the same file and is not exported.
      • \n
    • Exports the Gallery component as a default export.
      • \n
    \n
    • \n
  • App.js:\n
      \n
    • Imports Gallery as a default import from Gallery.js.
      • \n
    • Exports the root App component as a default export.
      • \n
    \n
    • #thedivisor#
  • Defines the Profile component which is only used within the same file and is not exported.
    • \n
  • Exports the Gallery component as a default export.
    • \n "},{"assistant_initiates":false,"asst_text":"Here's a pair of original and rewritten SQL queries based on your requirements, following a similar optimization pattern as provided in the example:\n\n[ORIGINAL QUERY]\n```sql\nWITH customer_total_spend AS (\n SELECT ws_bill_customer_sk AS cts_customer_sk,\n ws_warehouse_sk AS cts_warehouse_sk,\n SUM(ws_net_paid) AS cts_total_spend\n FROM web_sales\n JOIN customer_address ON ws_ship_addr_sk = ca_address_sk\n WHERE ca_state = 'CA' \n AND ws_net_paid > (SELECT MIN(ws_net_paid) FROM web_sales)\n GROUP BY ws_bill_customer_sk, ws_warehouse_sk\n)\nSELECT c_customer_id\nFROM customer_total_spend cts1,\n customer\nWHERE cts1.cts_total_spend > (\n SELECT AVG(cts_total_spend) * 1.5\n FROM customer_total_spend cts2\n WHERE cts1.cts_warehouse_sk = cts2.cts_warehouse_sk\n )\n AND cts1.cts_customer_sk = c_customer_sk\n AND c_customer_sk IN (SELECT c_customer_sk FROM web_sales WHERE ws_net_paid > 100)\nORDER BY c_customer_id\nLIMIT 50;\n```\n\n[REWRITTEN QUERY]\n```sql\nWITH customer_total_spend AS (\n SELECT ws_bill_customer_sk AS cts_customer_sk,\n ws_warehouse_sk AS cts_warehouse_sk,\n SUM(ws_net_paid) AS cts_total_spend\n FROM web_sales\n JOIN customer_address ON ws_ship_addr_sk = ca_address_sk\n WHERE ca_state = 'CA'\n AND ws_net_paid > (SELECT MIN(ws_net_paid) FROM web_sales)\n GROUP BY ws_bill_customer_sk, ws_warehouse_sk\n),\navg_warehouse_spend AS (\n SELECT cts_warehouse_sk, \n AVG(cts_total_spend) AS avg_spend\n FROM customer_total_spend\n GROUP BY cts_warehouse_sk\n)\nSELECT c_customer_id\nFROM customer_total_spend cts1 \nJOIN customer ON cts1.cts_customer_sk = c_customer_sk\nJOIN avg_warehouse_spend aws ON cts1.cts_warehouse_sk = aws.cts_warehouse_sk\nWHERE cts1.cts_total_spend > aws.avg_spend * 1.5\n AND c_customer_sk IN (SELECT c_customer_sk FROM web_sales WHERE ws_net_paid > 100)\nORDER BY c_customer_id\nLIMIT 50;\n```\n\n### Explanation:\n- **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.\n- **Rewritten Query**: The subquery for calculating average spend is moved into another CTE, `avg_warehouse_spend`, allowing direct joins for better performance.\n- **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.","behavior":"degenerate_repetition","conversation_hash":"27cf7b529edce0d5e558c978c3d51917","conversation_redacted":false,"conversation_toxic":false,"country":"China","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":5180,"n_turns_in_conversation":1,"n_words":614,"source_row_offset":17820,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:26 GMT","turn_id":"a278b6449e8bacdec3768d06","turn_index":0,"user_text":"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.\n\n[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; ```\n\n[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;```\n\nNow, 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:\n1. The original query must contain CTEs.\n2. The original query must make use of the following fact tables: ['web_sales']. Below is the join graph for these fact tables:\n ['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);']\n4. The original query must employ 0 joins.\n5. The original query must employ the following operators in its WHERE clause: ['min', 'sum'].\n6. 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 ```."},{"assistant_initiates":false,"asst_text":"Google | Company | Technology company providing internet services, including Gmail, influential in digital communication and email services.\n\nGmail | Product | Email service provided by Google, widely used for personal and professional communication.\n\nIMAP | Protocol | Internet Mail Access Protocol used for accessing email on mobile devices and mail clients, key in email server communication.\n\nMicrosoft Outlook | Product | Email client software by Microsoft, often used for managing emails and calendars in corporate settings.\n\nerror messages | Technical Issue | Notifications indicating problems with a system, significant in troubleshooting and user experience.\n\nunexpected behavior | Technical Issue | Unanticipated performance issues in software systems, affecting user interface or functionality.\n\n10:30 a.m. ET | Time | Specific time reference, relevant for tracking the occurrence of an event.\n\n1:15 p.m. | Time | Specific time reference, relevant for analyzing event duration and resolution timelines.\n\nMonday | Day | Day of the week relevant for temporal context in reporting incidents and updates.\n\nTech giant | Major Company | A large and influential company in the technology sector, typically with significant market power and resources.\n\nsubstantial subset | Data Segment | A considerable portion of a larger group, key in understanding the impact of issues or errors.\n\nmobile devices | Hardware | Portable computing devices, such as smartphones and tablets, crucial in accessing digital services on the go.","behavior":"degenerate_repetition","conversation_hash":"dc1f10b34bf3146af5abb69c4ac931c6","conversation_redacted":false,"conversation_toxic":false,"country":"United Kingdom","empty_output":false,"evidence_codes":[],"label":"absent","label_present":false,"label_qualified":false,"label_source":"Final dense release","language":"English","model":"gpt-4o-2024-08-06","n_chars":5603,"n_turns_in_conversation":1,"n_words":835,"source_row_offset":17821,"source_shard":"turns-00050.parquet","timestamp":"Mon, 11 Nov 2024 17:03:27 GMT","turn_id":"c3445c0dc80a79ceb6e30272","turn_index":0,"user_text":"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.\n\nEnsure the following:\nLabel All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.\nDefine New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.\nProvide an Exhaustive Entity List: Include every relevant label mentioned in the input text.\n\nAnswer in the following format:\n | | ,\n | | ,\n...\n\nHere is an Example : \nInput: \nLawmakers continue to try to police social media use among teens \u2014 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.\n\nOutput:\nLawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments. \nsocial media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.\nMeta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors. \nFacebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets. \nInstagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement. \nThreads | Company | Social media platform owned by Meta, contributing to the digital communication landscape. \nNov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. \ntech giants | Major Companies | Entities that hold substantial market power in the technology sector. \nGoogle | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution. \nApple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution. \nbigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company\u2019s operations, often resulting in resource strain or inefficiencies.\nApple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics. \nGoogle Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics. \nParental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage. \nThe Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.\nUser: 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.\nAssistant:"}],"shard":{"index":50,"name":"turns-00050.parquet","rows":48033}}