Untitled
unknown
plain_text
3 years ago
1.6 kB
4
Indexable
public void searchProduct(){ String selectQuery = "SELECT * FROM jwrms.stockandinventory WHERE productCode = ?"; String updateQuery = "UPDATE jwrms.stockandinventory SET itemsInStock = itemsInStock-? WHERE productCode = ?"; try{ var product = (StockAndInventory) objIs.readObject(); int amount = (int) objIs.readObject(); PreparedStatement ps = dBConn.prepareStatement(updateQuery); ps.setString(2,product.getProductCode()); ps.setInt(1,amount); ps.executeUpdate(); ps = dBConn.prepareStatement(selectQuery); ps.setString(1, product.getProductCode()); var result = ps.executeQuery(); if(result.next()){ 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)); objOs.writeObject(true); objOs.writeObject(product); objOs.flush(); logger.info("Product has been found and updated"); return; } objOs.writeObject(false); }catch(Exception e){ logger.error("Exception:" +e.getMessage()); e.printStackTrace(); } }
Editor is loading...