struts.dao.ViewSamosaDao.java Source code

Introduction

Here is the source code for struts.dao.ViewSamosaDao.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package struts.dao;

import java.util.ArrayList;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;
import struts.dto.OrderTable;
import struts.dto.SamosaTable;

/**
 *
 * @author Subhadra
 */
public class ViewSamosaDao {
    public ArrayList execute(OrderTable ot) {

        SessionFactory sf = new Configuration().configure().buildSessionFactory();
        Session s = sf.openSession();
        //Session s1=sf.openSession();
        Transaction tx = s.beginTransaction();
        //Transaction tx1= s1.beginTransaction();
        Criteria q = s.createCriteria(OrderTable.class);
        q.add(Restrictions.gt("samosa", 0));
        ArrayList<SamosaTable> list = new ArrayList();
        List<OrderTable> lists = q.list();
        if (!lists.isEmpty()) {
            for (OrderTable sst : lists) {
                SamosaTable sat = new SamosaTable();
                sat.setOrderId(sst.getOrderId());
                sat.setQuantity(sst.getSandwich());
                list.add(sat);
                //s1.save(sa);
                //s.save(sa);

            }
            //tx.commit();
            //s1.close();
        }
        return list;
    }

}