CODEWITHSUNDEEP
hibernatejpahibernate-criteria
Rahul
Rahul

Reputation: 89

Hiberante Criteria API exact usage with association

I am having two tables : 1.Customer_Table 2.Order_Table . There is one-to-many mapping between the tables where one customer can have multiple orders.Customer_id is primary key of Customer table and foreign key of Order table. A snippet of my Customer.hbm.xml file:

enter code here

    <set name="orders">
        <key column="Customer_id" /><!-- Customer_id acts as foreign key for Order table -->
        <one-to-many   class="Order" />
    </set>

.... I write the following snippet in my Retreive.java file to get some orders for the following customers: 1.Customer name should start with Rahul 2.Customer order description should be of type 'electronics'

Criteria criteria1 = session.createCriteria(Customer.class).
        add(Restrictions.like("customerName", "Rahul%"));`
Criteria criteria = criteria1.createCriteria("orders").add(Restrictions.like("orderDescription", "electronics%"));
List list = criteria.list();

As per my understanding Hibernate is going to perform an inner join on the two tables and return a list matching the above two criteria.

After this my requirement is to get the orderDescriptions from the resultset (List in this case) .

What java code do I exactly need to write to achieve that purpose???

Upvotes: 0

Views: 144

Answers (3)

Rahul
Rahul

Reputation: 89

Have finally been able to solve my issue regarding getting a restricted set of association instead of the whole association. Hope the below code snippet helps.

Criteria criteria1 = session.createCriteria(Customer.class).
    add(Restrictions.like("customerName", "Rahul%"));`
Criteria criteria = criteria1.createCriteria("orders","order").add(Restrictions.like("orderDescription","electronics%")).setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);//order is alias to orders collection
List<Map> list = criteria.list();

Using the setResultTransformer we get a List of Map which contains the result of the inner join instead of the more traditional List of Customer.

for(Iterator itr = list.iterator();itr.hasNext();){
Map map = (Map)itr.next();
Customer student = (Customer) map.get(Criteria.ROOT_ALIAS);
Order order = (Order) map.get("order");//alias that was used earlier for orders
}

Upvotes: 1

Kevin Bowersox
Kevin Bowersox

Reputation: 94489

I would recommend casting the result to a List<Customer> which should make accessing fields of Customer easier.

List<Customer> list = (List<Customer>)criteria.list();

Then iterate through the list, accessing the orders/description through the accessor methods:

   for(Customer customer: list){
       for(Order order: customer.getOrders()){
          order.getDescription(); //pseudo code since entities were not revealed
       }
   }

This answer assumes that Customer contains a List<Order> and the Order entity has a description field.

Upvotes: 0

user528050
user528050

Reputation: 157

You can use the Iterator to get the data from the List. This code will hep to iterate your list data.

Iterator it=list.iterator();
while(it.hasNext()) {
System.out.println(it.next());//Yout can write your own implemantation
}

Upvotes: 0

Related Questions