Untitled
unknown
plain_text
3 years ago
3.2 kB
4
Indexable
public void calculateTotal(){ String selectQuery = "SELECT * FROM jwrms.stockandinventory WHERE productCode = ?"; String selectQuery1 = "SELECT * FROM jwrms.customers WHERE customerID = ?"; String selectQuery2 = "SELECT * FROM jwrms.staff WHERE employeeId = ?"; try{ SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); ArrayList<StockAndInventory> products = new ArrayList<>(); var productIds = (ArrayList<String>) objIs.readObject(); var customer = (Customer) objIs.readObject(); var staff = (Staff) objIs.readObject(); PreparedStatement ps = dBConn.prepareStatement(selectQuery); for (var id : productIds) { ps.setString(1,id); var result = ps.executeQuery(); if(result.next()){ var product = new StockAndInventory(); product.setProductCode(result.getString(1)); product.setProductName(result.getString(2)); product.setShortDescription(result.getString(3)); product.setLongDescription(result.getString(4)); product.setItemsInStock(result.getInt(5)); product.setUnitPrice(result.getFloat(6)); products.add(product); } } ps = dBConn.prepareStatement(selectQuery1); ps.setString(1,customer.getCustomerID()); ResultSet resultSet = ps.executeQuery(); if(resultSet.next()){ customer.setCustomerID(resultSet.getString(1)); customer.setName(resultSet.getString(2)); customer.setDob(dateFormat.parse(String.valueOf(resultSet.getDate(3)))); customer.setAddress(resultSet.getString(4)); customer.setTelephone(resultSet.getString(5)); customer.setEmail(resultSet.getString(6)); customer.setDateOfMembership(dateFormat.parse(String.valueOf(resultSet.getDate(7)))); customer.setDateOfMembershipExpiry(dateFormat.parse(String.valueOf(resultSet.getDate(8)))); } ps = dBConn.prepareStatement(selectQuery2); ps.setInt(1,staff.getEmployeeId()); ResultSet resultSet1 = ps.executeQuery(); if(resultSet1.next()){ ps.setInt(1,staff.getEmployeeId()); ps.setString(2,staff.getName()); ps.setString(3, staff.getEmployeeType()); ps.setString(3, staff.getDepartmentCode()); } objOs.writeObject(true); objOs.flush(); objOs.writeObject(staff); objOs.flush(); objOs.writeObject(products); objOs.flush(); objOs.writeObject(customer); objOs.flush(); }catch(IOException | ClassNotFoundException e){ e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } catch (ParseException e) { e.printStackTrace(); } }
Editor is loading...