Untitled

public void updateCustomer(){
        try {
            var customer = (Customer) objIs.readObject();
            String sql = " UPDATE jwrms.customers SET customerID=?,name=?,dob=?,address=?,telephone=?,email=?,dateOfMembership=?,dateOfMembershipExpiry=? where customerID = ?";

            PreparedStatement ps = dBConn.prepareStatement(sql);
            ps.setString(9, customer.getCustomerID());

            ps.setString(1, customer.getCustomerID());
            ps.setString(2, customer.getName());
            ps.setString(3, customer.getDob());
            ps.setString(4, customer.getAddress());
            ps.setString(5, customer.getTelephone());
            ps.setString(6, customer.getEmail());
            ps.setString(7, customer.getDateOfMembership());
            ps.setString(8,customer.getDateOfMembershipExpiry());
            ps.executeUpdate();
            objOs.writeObject(true);
            objOs.flush();
        }catch(IOException e){
            e.printStackTrace();
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }catch(SQLException e){
            e.printStackTrace();
        }

}