struts.dao.ViewDosaDao.java Source code

Introduction

Here is the source code for struts.dao.ViewDosaDao.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.DosaTable;

/**
 *
 * @author Subhadra
 */
public class ViewDosaDao {
    public ArrayList execute8(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("dosa", 0));
        ArrayList<DosaTable> list = new ArrayList();
        List<OrderTable> listd = q.list();
        if (!listd.isEmpty()) {
            for (OrderTable dst : listd) {
                DosaTable dt = new DosaTable();
                dt.setOrderId(dst.getOrderId());
                dt.setQuantity(dst.getSandwich());
                list.add(dt);
                //s1.save(sa);
                //s.save(sa);

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

}