The Save Transaction button depicted in the screen attached is used to save relevant data to the sales table and the salesdetails tables from the depicted schema. When this button is clicked it calls the saveTransaction() function that is within the PosDAO class, it passes to this function an ArrayList of salesdetails object, this list contains the data entered into the jTable which is the products and qty being sold.Write the saveTransaction function. You are to loop through the items and get the total sales, next you are to insert the current date and the total sales into the sales table. Reminder that the sales table SalesNumber field is set to AUTO-INCREMENT, hence the reason for only entering the total sales and current date in sales table. public class PosDAO {}private Connection conn;PreparedStatement stmt = null;public boolean openConnection(){try {// db parametersString url = "jdbc:mysql://localhost: 4306/swen2005";String user = "root";String password = "";// create a connection to the databaseconn - DriverManager.getConnection(url, user, password);if (conn!= null)return true;}catch(SQLException e) {System.out.println(e.getMessage());}|}return false;}public void closeConnection ()return false;try{}if (conn!=null)conn.close();catch(SQLException ex) {System.out.println(ex.getMessage());}public void saveTransaction(List items) throws SQLException{}public List getSales (String fromDate, String toDate) {VO swen2005 salesSalesNumber: int(10)SalesDate : date# Sales Total: decimal(7,2)v swen2005 salesdetailsnumber: int(10)# SalesNumber: int(10)prodid: varchar(20)# price : decimal(7,2)# qty: int(10)Vclass Product{public int number;public String prodID;public String prodName;public float prodPrice;public int prodOnHand;Product(int num, String id, String name, float price, int qty){number-num;prodID=id;prodName=name;prodPrice-price;prodonHand-qty;}class Salesdetails {public String prodcode;public String prodname;public double unit;public int qty;public Salesdetails(String pcode, String pname, double ucost, int q){this.prodcode = pcode;this.qty = q;this.prodname = pname;this.unit = ucost;swen2005 productsnumber: int(11)prodid: varchar(20)prodname : varchar(30)#price: decimal(10,2)#onhand int(11)public class Pos {public String salesDate;public int sales Number;public String prodcode;public String prodname;public double salesTotal;public double unit;public int qty;public Pos (String sd,int sn, String pcode, String pname,double ucost, int q, double st)this.salesDate = sd;this.salesNumber - sn;this.prodcode - pcode;this.qty = 9;this.prodname - pname;this.unit = ucost;this.salesTotal = st; Point of Sales ScreenProduct Code 4225Code98133700Product NameWine Muscadet Sur LieCompound - RumSave TransactionCancel TransactionQuantity 20Unit Price34.132.15IQty Total1526X511.5835.91347.40

In this question we have to understand and code for the Java function saveTransaction function with…

The Save Transaction button depicted in the screen attached is used to save relevant data to the sales table and the salesdetails tables from the depicted schema. When this button is clicked it calls the saveTransaction() function that is within the PosDAO class, it passes to this function an ArrayList of salesdetails object, this list contains the data entered into the jTable which is the products and qty being sold. Write the saveTransaction function. You are to loop through the items and get the total sales, next you are to insert the current date and the total sales into the sales table. Reminder that the sales table SalesNumber field is set to AUTO-INCREMENT, hence the reason for only entering the total sales and current date in sales table.

The Save Transaction button depicted in the screen attached is used to save relevant data to the sales table and the salesdetails tables from the depicted schema. When this button is clicked it calls the saveTransaction() function that is within the PosDAO class, it passes to this function an ArrayList of salesdetails object, this list contains the data entered into the jTable which is the products and qty being sold. Write the saveTransaction function. You are to loop through the items and get the total sales, next you are to insert the current date and the total sales into the sales table. Reminder that the sales table SalesNumber field is set to AUTO-INCREMENT, hence the reason for only entering the total sales and current date in sales table.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Supplier PK PK Id FK CompanyName ContactName Contact Title City Country Phone Product Fax Id ProductName Supplierld UnitPrice Package IsDiscontinued Northwind Traders (Simplified) Order Johan | April 14, 2020 PK Id FK OrderDate OrderNumber Customerld TotalAmount Orderltem PK FK Orderld FK Productld UnitPrice Quantity ld Customer PK Id FirstName LastName City Country Phone
.Here it isstudent Relation Student_ID Student_Name Dept_Name 0000 AAAAA Computer Science 1111 BBBBB Computer Science 2222 CCCCC Business Administration 3333 DDDDD Education 4444 EEEEE Physics 5555 FFFFF History Student_Courses Relation Student_ID Course_ID Section Year Grade 0000 CS 2203 2 2020 A 0000 CS 1101 1 2019 A 1111 CS 1101 5 2019 B 1111 CS 1102 1 2019 B 1111 CS 2204 1 2020 A 1111 CS 2401 1 2020 A 2222 BUS 1101 3 2019 C 2222 BUS 2201 1 2020 B 2222 BUS 3302 1 2020 B 3333 EDUC 5010 1 2019 A 3333 EDUC 5210 1 2020 B 4444 PHY 1101 4 2019 A 4444 PHY 2202 1 2020 C 4444 PHY 3304 1 2020 A Considering Student and Student_Courses relations shown above, discuss when Union, Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join should be used and provide examples using the above relations. I AM GETTING USED TO MYSQL WORKBENCH. (Kindly take me through the path)?
When a transaction is rolled-back under timestamp ordering, it is assigned a new timestamp. Why can it not simply keep its old timestamp?
What is a "nested transaction" and how does it differ from a standard transaction?
Consider the following relation: TempID 111 222 333 444 555 666 TempName Joe Mike Sue Pat Bob Joe TemplD JobID J111 J222 J333 J444 J555 J666 TempName TEMP AGENCY Job TypelD T1 T2 T1 JobID T2 T1 T2 Job TypeDesc Bookkeepiing Answering calls Bookkeepiing Answering calls Bookkeepiing Answering calls • Each job has one job type, but multiple jobs can have the same job type • Each job is assigned to one employer. Same employer can have multiple jobs. 5a) In the figure below, indicate functional dependencies by drawing lines with arrows. -| Some of the requirements that this table is based on are as follows: • Each temporary worker has a unique TempID, and a non-unique TempName. • Each employer has a unique EID, and a non-unique EName. • Each job has a unique JobID, and a job type. • Each job type has a unique JobTypeID and a non-unique job type description (JobTypeDesc). • Each temporary worker is assigned to only one job. EID E1 E1 E2 E2 E2 E1 Job TypeID Job TypeDesc Ename Mid Bank Mid Bank…
DEPENDENT FNAME DOB Relationship ЕMPID 111 MAI 29/1/2001 Mother 012 222 SALEH 7/4/2001 Single 033 333 AHMED 23/2/1980 Father 087 NORMALIZE THIS TABLE THIS 3NF
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
QUESTION 5 Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing Skiing Swimming 50.00 Skiing Swimming 200.00 0.00 200 Davis 200.00 0.00 200 Davis 50.00 300 Garrett 200.00 100.00 300 Garrett 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. StudentID → StudentName StudentID , StudentName → Activity
PRACTICE ACTIVITY FOR JOINS (using APEX) Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad Tamil A105 A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 D103 IT BSD D104 ENG Table name: STUDENTS | STUDENTID GENDER STUDENTNAME DOB ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 6/1/1999 Male 90 D102 A102 Level 1 Hisham 22 S102 Sara 12/30/1994 Female 45 D103 A104 Diploma 27 6/1/1999 Male 5/6/1995 Male S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 10/15/1992 Male 45 D104 A101 Advanced Diploma 29 S100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 4/5/1998 Male 2/23/1992 Female S104 Faisal 90 D104 A101 Advanced Diploma 23 S105 Fatima 90 D102 A102 Level 2 29 S106 Arwa 9/12/1999 Female 45 D102 A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 0103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student…
Question 24 Dynamic & manually defined blacklist are composed of the Botset Traffie Filher (BTF) & manually created black lists True False Question 25 can be accessed by any entity trying to check the validity of any giveu certificate Question 26 The tatag T LSee w t el True False 539
customers calls to orders împtoyee asist and inquires it Start order and balan ce confirmed Employee chacks order and Nalid Yes balance No Yes NO Invalid Received the cash amount Proceed to log Transaction END
Answer the query using SQL. For each department which has more than 5 female employees, retrieve the department name, the number of female employees in the department, and their average salary.