com.liferay.samplehibernate.util.FoodItemUtil.java Source code

Introduction

Here is the source code for com.liferay.samplehibernate.util.FoodItemUtil.java

Source

/**
 * Copyright (c) 2000-present Liferay, Inc. All rights reserved.
 *
 * This library is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Lesser General Public License as published by the Free
 * Software Foundation; either version 2.1 of the License, or (at your option)
 * any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
 * details.
 */

package com.liferay.samplehibernate.util;

import com.liferay.samplehibernate.model.FoodItem;

import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;

/**
 * @author Charles May
 */
public class FoodItemUtil {

    public static void addFoodItem(FoodItem foodItem) throws Exception {
        Session session = null;

        try {
            session = HibernateUtil.openSession();

            session.beginTransaction();

            session.save(foodItem);

            session.flush();

            session.getTransaction().commit();
        } catch (Exception e) {
            throw new Exception(e);
        } finally {
            HibernateUtil.closeSession(session);
        }
    }

    public static void deleteFoodItem(long foodItemId) throws Exception {
        Session session = null;

        try {
            session = HibernateUtil.openSession();

            session.beginTransaction();

            FoodItem foodItem = (FoodItem) session.get(FoodItem.class, new Long(foodItemId));

            if (foodItem != null) {
                session.delete(foodItem);

                session.flush();
            }

            session.getTransaction().commit();
        } catch (Exception e) {
            throw new Exception(e);
        } finally {
            HibernateUtil.closeSession(session);
        }
    }

    public static FoodItem getFoodItem(long foodItemId) throws Exception {
        Session session = null;

        try {
            session = HibernateUtil.openSession();

            session.beginTransaction();

            FoodItem foodItem = (FoodItem) session.get(FoodItem.class, new Long(foodItemId));

            session.getTransaction().commit();

            return foodItem;
        } catch (Exception e) {
            throw new Exception(e);
        } finally {
            HibernateUtil.closeSession(session);
        }
    }

    public static List getFoodItems() throws Exception {
        Session session = null;

        try {
            session = HibernateUtil.openSession();

            session.beginTransaction();

            SQLQuery q = session.createSQLQuery(_GET_FOOD_ITEMS);

            q.addEntity("FoodItem", FoodItem.class);

            List list = q.list();

            session.getTransaction().commit();

            return list;
        } catch (Exception e) {
            throw new Exception(e);
        } finally {
            HibernateUtil.closeSession(session);
        }
    }

    public static void updateFoodItem(FoodItem foodItem) throws Exception {
        Session session = null;

        try {
            session = HibernateUtil.openSession();

            session.beginTransaction();

            session.update(foodItem);

            session.flush();

            session.getTransaction().commit();
        } catch (Exception e) {
            throw new Exception(e);
        } finally {
            HibernateUtil.closeSession(session);
        }
    }

    private static final String _GET_FOOD_ITEMS = "SELECT {FoodItem.*} FROM FoodItem ORDER BY name_ ASC";

}