select Firma.Name, Firma.Phone, Adress.City, Adress.Street, Adress.NumOfHouse, Supplier.Quality, Supplier.Price_Qual from Supplier s, Firm f, Adress a where (s.Firms_ID = f.Firma_ID) AND (f.Adr_ID = a.Adress_ID)

package tovar.entity;

import java.util.HashSet;
import java.util.Set;


public class Supplier {
	private Long PostID;
    private Firm Sfirm;
    private int Sfirmtype;
    private double SQual;
    private double SPrice_Qual;
    
    private Set<Tovar> tovarList = new HashSet<Tovar>();

	public Long getPostID() {
		return PostID;
	}

	public void setPostID(Long postID) {
		PostID = postID;
	}

	public Firm getSfirm() {
		return Sfirm;
	}

	public void setSfirm(Firm sfirm) {
		Sfirm = sfirm;
	}
	
	public int getSfirmtype() {
		return Sfirmtype;
	}

	public void setSfirmtype(int sfirmtype) {
		Sfirmtype = sfirmtype;
	}

	public double getSQual() {
		return SQual;
	}

	public void setSQual(double sQual) {
		SQual = sQual;
	}

	public double getSPrice_Qual() {
		return SPrice_Qual;
	}

	public void setSPrice_Qual(double sPrice_Qual) {
		SPrice_Qual = sPrice_Qual;
	}

	public Set<Tovar> getTovarList() {
		return tovarList;
	}

	public void setTovarList(Set<Tovar> tovarList) {
		this.tovarList = tovarList;
	}	
}

package tovar.entity;

import java.util.List;

import org.hibernate.Session;

import shop.utils.HibernateUtil;

public class SupplierMetods {
	
	public void addSupplier(Adress adress, Firm firm, int firmtype, double qual, double pqual) { //добавление нового товара
        Session session = HibernateUtil.configureSessionFactory().getCurrentSession(); 
        session.beginTransaction(); 
        Supplier r= new Supplier();
        r.setSfirm(firm);
        r.setSfirmtype(firmtype);
        r.setSQual(qual);
        r.setSPrice_Qual(pqual);
        session.save(r);
        session.getTransaction().commit();
    }
	
    public void updateSupplier(Object o) { //обновление товара
        
        Session session = HibernateUtil.configureSessionFactory().getCurrentSession();
        session.beginTransaction();
        session.update(o);        
        System.out.println("Updated");
        session.flush();
        session.getTransaction().commit();        
    }
    
    public List<Supplier> listSupplier() { //выборка из таблицы товаров
        Session session = HibernateUtil.configureSessionFactory().getCurrentSession();
        session.beginTransaction();
        List<Supplier> result = session.createSQLQuery(" select Firma.Name, Firma.Phone, Adress.City, Adress.Street, " +
        		"Adress.NumOfHouse, Supplier.Quality, Supplier.Price_Qual from Supplier s, Firm f, Adress a " +
        		"where (s.Firms_ID = f.Firma_ID) AND (f.Adr_ID = a.Adress_ID)").list();
        session.getTransaction().commit();
        return result;
    }

}

package tovar.entity;

import java.util.List;

import javax.swing.table.AbstractTableModel;

public class supplierTableModel extends AbstractTableModel{
	
	private String[] columnsNames = {"Name","Phone","City", "Street", "NumOfHouse", "Quality", "Price_Quality"};
	private List<Supplier> data;
	public supplierTableModel(List<Supplier> suppList) {
		super();
		data = suppList;
	}

	@Override
	public int getRowCount() {
		// TODO Auto-generated method stub
		synchronized (data) {
		return data.size();
		}
	}

	@Override
	public int getColumnCount() {
		// TODO Auto-generated method stub
		return 7;
	}

	@Override
	public String getColumnName(int column) { return columnsNames[column];}
	
	@Override
	public Object getValueAt(int row, int col){
		switch(col){
		case 0: return data.get(row).getSfirm().getFName();
		case 1: return data.get(row).getSfirm().getFPhone();
		case 2: return data.get(row).getSfirm().getAdress().getAdrCity();
		case 3: return data.get(row).getSfirm().getAdress().getAdrStreet();
		case 4: return data.get(row).getSfirm().getAdress().getAdrNoH();
		case 5: return data.get(row).getSQual();
		case 6: return data.get(row).getSPrice_Qual();
		default: return data.get(row).getPostID();
		}
	}
	
	@Override
	public void setValueAt(Object value, int row, int col){
		Supplier r = data.get(row);
		SupplierMetods t = new SupplierMetods();
		switch(col){
		case 0: r.getSfirm().setFName(value.toString());
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 1: r.getSfirm().setFPhone(value.toString());
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 2: r.getSfirm().getAdress().setAdrCity(value.toString());
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 3: r.getSfirm().getAdress().setAdrStreet(value.toString());
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 4: r.getSfirm().getAdress().setAdrNoH(Integer.parseInt(value.toString()));
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 5: r.setSQual(Double.parseDouble(value.toString()));
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		case 6: r.setSPrice_Qual(Double.parseDouble(value.toString()));
				t.updateSupplier(r);
				fireTableCellUpdated(row,col);
				break;
		}
	} 

}

cannot be cast to tovar.entity.Supplier

case 0: return data.get(row).getSfirm().getFName();

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="tovar.entity">
    <class name="Adress" table="Adress">
        <id name="AdrID" column="Adress_ID">
            <generator class="native"/>
        </id>
        <property name="AdrCity" column="City"/>
        <property name="AdrStreet" column="Street"/>
        <property name="AdrNoH" column="NumOfHouse"/>
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="tovar.entity">
    <class name="Firm" table="Firma">
        <id name="FirmID" column="Firma_ID">
            <generator class="native"/>
        </id>
        <property name="FName" column="Name"/>
        <property name="FPhone" column="Phone"/>
        <one-to-one name="adress" class="tovar.entity.Adress"></one-to-one>
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="tovar.entity">
    <class name="Supplier" table="Supplier">
        <id name="PostID" column="Supplier_ID">
            <generator class="native"/>
        </id>
        <one-to-one name="Sfirm" class="tovar.entity.Firm"></one-to-one>
        <many-to-one name="Sfirmtype" class="tovar.entity.FirmTypes">
        	<column name="Firms_Type_ID" not-null="true" /> 
		</many-to-one>
        <property name="SQual" column="Quality"/>
        <property name="SPrice_Qual" column="Price_Qual"/>
        <set name="tovarList" table="POSTUPLENIE">
            <key column="supplier"></key>
            <many-to-many column="tovar" class="tovar.entity.Tovar"/>
        </set>
    </class>
</hibernate-mapping>

List<Post> result = session.createSQLQuery(" select Firma.Name, Firma.Phone, Adress.City, Adress.Street, " +
"Adress.NumOfHouse, Supplier.Quality, Supplier.Price_Qual from Supplier s, Firm f, Adress a " +
"where (s.Firms_ID = f.Firma_ID) AND (f.Adr_ID = a.Adress_ID)").list();

List<Supplier> result = (List<Supplier>) session.createCriteria("tovar.entity.Supplier").list();

select Supplier.ID Supplier.Quality, Supplier.Price_Qual, Firma.Firma_ID, Firma,Name, Firma.Phone, Adress.City, Adress.Street, Adress.NoH from Supplier left outer join Firma on Supplier.Post_ID=Firma.Firma_ID left outer join Adress on Firma.Adr_ID=Adress.Adress_ID;

List<Supplier> result = (List<Supplier>) session.createCriteria("tovar.entity.Supplier").
add(Restrictions.sqlRestriction((Firms_ID=Firma_ID) and (Adr_ID=Adress_ID)).list();

<one-to-one name="adress" class="tovar.entity.Adress"></one-to-one>

session.createQuery("from Supplier").list();

<many-to-one name="Sfirm" column="Firms_ID" class="tovar.entity.Firm" unique="true" lazy="false"></many-to-one>

session.createQuery("from Supplier").list();