public boolean EncodeSupplierDeliveryReceipt(SupplierDeliveryReceipt newSupplierDeliveryReceipt) { try { DBConnectionFactory myFactory = DBConnectionFactory.getInstance(); Connection conn = myFactory.getConnection(); String query = "insert into supplier_delivery_receipt" + "(drNumber,poNumber,itemCode,dateReceived,qty," + "receivedBy,approvedBy,status) " + "values (?,?,?,?,?,?,?,?)"; PreparedStatement pstmt = conn.prepareStatement(query); pstmt.setInt(1, newSupplierDeliveryReceipt.getDrNumber()); pstmt.setInt(2, newSupplierDeliveryReceipt.getPoNumber()); pstmt.setInt(3, newSupplierDeliveryReceipt.getItemCode()); pstmt.setDate(4, newSupplierDeliveryReceipt.getDateReceived()); pstmt.setInt(5, newSupplierDeliveryReceipt.getQty()); pstmt.setInt(6, newSupplierDeliveryReceipt.getReceivedBy()); pstmt.setInt(7, newSupplierDeliveryReceipt.getApprovedBy()); pstmt.setString(8, newSupplierDeliveryReceipt.getStatus()); int rows = pstmt.executeUpdate(); conn.close(); return rows == 1; } catch (SQLException ex) { Logger.getLogger(SupplierDeliveryReceiptDAO.class.getName()).log(Level.SEVERE, null, ex); } return false; }