public void searchByRMA(CurrentProduct currentProduct) { con = dbCon.geConnection(); currentProduct.currentProductList.clear(); try { pst = con.prepareStatement("select * from Products where RMAId=?"); pst.setString(1, currentProduct.rmaId); rs = pst.executeQuery(); while (rs.next()) { currentProduct.id = rs.getString(1); currentProduct.productId = rs.getString(2); currentProduct.productName = rs.getString(3); currentProduct.quantity = rs.getString(4); currentProduct.description = rs.getString(5); currentProduct.supplierId = rs.getString(6); currentProduct.brandId = rs.getString(7); currentProduct.catagoryId = rs.getString(8); currentProduct.unitId = rs.getString(9); currentProduct.pursesPrice = rs.getString(10); currentProduct.sellPrice = rs.getString(11); currentProduct.rmaId = rs.getString(12); currentProduct.userId = rs.getString(13); currentProduct.date = rs.getString(14); currentProduct.supplierName = sql.getName(currentProduct.supplierId, currentProduct.supplierName, "Supplyer"); currentProduct.brandName = sql.getName(currentProduct.brandId, currentProduct.brandName, "Brands"); currentProduct.catagoryName = sql.getName(currentProduct.catagoryId, currentProduct.catagoryName, "Catagory"); currentProduct.unitName = sql.getName(currentProduct.unitId, currentProduct.unitName, "Unit"); currentProduct.rmaName = sql.getName(currentProduct.rmaId, currentProduct.rmaName, "RMA"); currentProduct.userName = sql.getName(currentProduct.userId, currentProduct.userName, "User"); currentProduct.currentProductList.addAll( new ListProduct( currentProduct.id, currentProduct.productId, currentProduct.productName, currentProduct.quantity, currentProduct.description, currentProduct.supplierName, currentProduct.brandName, currentProduct.catagoryName, currentProduct.unitName, currentProduct.pursesPrice, currentProduct.sellPrice, currentProduct.rmaName, currentProduct.userName, currentProduct.date)); } pst.close(); con.close(); rs.close(); } catch (SQLException ex) { Logger.getLogger(CurrentProductGetway.class.getName()).log(Level.SEVERE, null, ex); } }
public void view(CurrentProduct currentProduct) { currentProduct.currentProductList.clear(); con = dbCon.geConnection(); try { pst = con.prepareStatement("SELECT SQL_NO_CACHE * FROM Products"); rs = pst.executeQuery(); while (rs.next()) { currentProduct.id = rs.getString(1); currentProduct.productId = rs.getString(2); currentProduct.productName = rs.getString(3); currentProduct.quantity = rs.getString(4); currentProduct.description = rs.getString(5); currentProduct.supplierId = rs.getString(6); currentProduct.brandId = rs.getString(7); currentProduct.catagoryId = rs.getString(8); currentProduct.unitId = rs.getString(9); currentProduct.pursesPrice = rs.getString(10); currentProduct.sellPrice = rs.getString(11); currentProduct.rmaId = rs.getString(12); currentProduct.userId = rs.getString(13); currentProduct.date = rs.getString(14); currentProduct.supplierName = sql.getName(currentProduct.supplierId, currentProduct.supplierName, "Supplyer"); currentProduct.brandName = sql.getName(currentProduct.brandId, currentProduct.brandName, "Brands"); currentProduct.catagoryName = sql.getName(currentProduct.catagoryId, currentProduct.catagoryName, "Catagory"); currentProduct.unitName = sql.getName(currentProduct.unitId, currentProduct.unitName, "Unit"); currentProduct.rmaName = sql.getName(currentProduct.rmaId, currentProduct.rmaName, "RMA"); currentProduct.userName = sql.getName(currentProduct.userId, currentProduct.userName, "User"); currentProduct.currentProductList.addAll( new ListProduct( currentProduct.id, currentProduct.productId, currentProduct.productName, currentProduct.quantity, currentProduct.description, currentProduct.supplierName, currentProduct.brandName, currentProduct.catagoryName, currentProduct.unitName, currentProduct.pursesPrice, currentProduct.sellPrice, currentProduct.rmaName, currentProduct.userName, currentProduct.date)); } pst.close(); con.close(); rs.close(); } catch (SQLException e) { e.printStackTrace(); } }
public void sView(CurrentProduct currentProduct) { con = dbCon.geConnection(); try { pst = con.prepareStatement("select * from Products where ProductId=?"); pst.setString(1, currentProduct.productId); rs = pst.executeQuery(); while (rs.next()) { currentProduct.id = rs.getString(1); currentProduct.productId = rs.getString(2); currentProduct.productName = rs.getString(3); currentProduct.quantity = rs.getString(4); currentProduct.description = rs.getString(5); currentProduct.supplierId = rs.getString(6); currentProduct.brandId = rs.getString(7); currentProduct.catagoryId = rs.getString(8); currentProduct.unitId = rs.getString(9); currentProduct.pursesPrice = rs.getString(10); currentProduct.sellPrice = rs.getString(11); currentProduct.rmaId = rs.getString(12); currentProduct.userId = rs.getString(13); currentProduct.date = rs.getString(14); currentProduct.supplierName = sql.getName(currentProduct.supplierId, currentProduct.supplierName, "Supplyer"); currentProduct.brandName = sql.getName(currentProduct.brandId, currentProduct.brandName, "Brands"); currentProduct.catagoryName = sql.getName(currentProduct.catagoryId, currentProduct.catagoryName, "Catagory"); currentProduct.unitName = sql.getName(currentProduct.unitId, currentProduct.unitName, "Unit"); currentProduct.rmaName = sql.getName(currentProduct.rmaId, currentProduct.rmaName, "RMA"); currentProduct.userName = sql.getName(currentProduct.userId, currentProduct.userName, "User"); currentProduct.rmaDayesss = sql.getDayes(currentProduct.rmaDayesss, currentProduct.rmaId); long dateRMA = Long.parseLong(currentProduct.rmaDayesss); currentProduct.warrentyVoidDate = LocalDate.now().plusDays(dateRMA).toString(); } pst.close(); con.close(); rs.close(); } catch (SQLException e) { e.printStackTrace(); } }