public void remove(String name) throws ClassNotFoundException {
        try {
            prodsQuery = dbc.connect().prepareStatement("DELETE FROM suppliers WHERE name=?");
            prodsQuery.setString(1, name);
            prodsQuery.executeUpdate();
            System.out.println("removed");
            prodsQuery.close();
        } catch (SQLException ex) {
            Logger.getLogger(SuppliersDB.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            try {
                prodsQuery.close();
            } catch (SQLException ex) {
                Logger.getLogger(SuppliersDB.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

    }