package example;
public class Example {
    public static void main(String[] args) {
        Horse horse = new Horse();
        horse.setBreed("red");
        horse.setHorseId(14);
        HorseDAO h = new HorseDAOImpl();
        h.add(horse);
        
        List<Horse> horses = h.getAllHorses();
        for(Horse hor : horses){
            System.out.println(hor.getBreed());
        }     
    }
}

package modelo;
public class Horse implements Serializable {
    private int horseId;
    private String breed;

    public Horse() {
    }
    public Horse(int horseId, String breed) {
        this.horseId = horseId;
        this.breed = breed;
    }
    public int getHorseId() { return this.horseId;}
    public void setHorseId (int horseId) { this.horseId = horseId; }
    public String getBreed() { return this.breed; }
    public void setBreed(String breed) {this.breed = breed; }    
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ippodrom</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <mapping resource="modelo/Horse.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd">
<hibernate-reverse-engineering>
  <schema-selection match-catalog="ippodrom"/>
  <table-filter match-name="horse"/>
</hibernate-reverse-engineering>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 13.10.2013 20:57:34 by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="modelo.Horse" table="horse" catalog="ippodrom">
        <id name="horseId" type="int">
            <column name="horse_id" />
            <generator class="assigned" />
        </id>
        <property name="breed" type="string">
            <column name="breed" length="10" />
        </property>
    </class>
</hibernate-mapping>

package example;
public class HorseDAOImpl implements HorseDAO {

    Session session = HibernateUtil.getSession();

    @Override
    public void add(Horse horse) {
        session.beginTransaction();
        session.save(horse);
        session.getTransaction().commit();
    }
    public List<Horse> getAllHorses() {
        session.beginTransaction();
        Query q = session.createSQLQuery("select * from horse");
        session.getTransaction().commit();
        return (List<Horse>) q.list();
    }
}

for(Horse hor : horses){

Query q = session.createQuery("from horse");

@Entity
@Table(name = "horse", catalog = "modelo")
public class Horse implements Serializable {

    private int horseId;
    private String breed;

    public Horse() {
    }
    public Horse(int horseId) {
        this.horseId = horseId;
    }   
    public Horse(String breed) {
        this.breed = breed;
    }
    public Horse(int horseId, String breed) {
        this.horseId = horseId;
        this.breed = breed;
    }
    @Id
    @Column(name = "horse_id", unique = true)
    public int getHorseId() {
        return this.horseId;
    }
    public void setHorseId(int horseId) {
        this.horseId = horseId;
    }
    @Column(name = "breed", length = 10)
    public String getBreed() {
        return this.breed;
    }
    public void setBreed(String breed) {
        this.breed = breed;
    }
}

Query q = session.createQuery("from Horse");

Query q = session.createQuery("from horse");