public void add(String name, String address, String contact, String other) throws ClassNotFoundException {
        try {

            prodsQuery = dbc.connect().prepareStatement("INSERT INTO 'suppliers' (name, address, contact, other)"
                    + "VALUES (?,?,?,?);");
            prodsQuery.setString(1, name);
            prodsQuery.setString(2, address);
            prodsQuery.setString(3, contact);
            prodsQuery.setString(4, other);
            prodsQuery.executeUpdate();
            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);
            }
        }
    }