cs544.wamp_blog_engine.dao.impl.CategoryDAOImpl.java Source code

Introduction

Here is the source code for cs544.wamp_blog_engine.dao.impl.CategoryDAOImpl.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 cs544.wamp_blog_engine.dao.impl;

import cs544.wamp_blog_engine.dao.CategoryDAO;
import cs544.wamp_blog_engine.domain.Category;
import cs544.wamp_blog_engine.domain.Post;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author Weldino
 */
public class CategoryDAOImpl implements CategoryDAO {

    private SessionFactory sf;

    public void setSf(SessionFactory sf) {
        this.sf = sf;
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void createCategory(Category category) {
        sf.getCurrentSession().save(category);
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void updateCategory(Category category) {
        sf.getCurrentSession().saveOrUpdate(category);
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void removeCategory(Category category) {
        sf.getCurrentSession().delete(category);
    }

    @Transactional(propagation = Propagation.SUPPORTS)
    @Override
    public Category getCategory(int categoryid) {
        Category category = (Category) sf.getCurrentSession().get(Category.class, categoryid);
        return category;
    }

    @Transactional(propagation = Propagation.SUPPORTS)
    @Override
    public List<Category> getAllCategorys() {
        Query query = sf.getCurrentSession().createQuery("from Category");

        List<Category> categorys = query.list();
        System.out.println("num of cats: in dao " + categorys.size());
        return categorys;
    }

    @Override
    public List<Category> getCategoriesByPost(Post post) {
        Query query = sf.getCurrentSession()
                .createQuery("select c from Category c join c.catogorizedPosts p where p.id=:pid");
        query.setParameter("pid", post.getId());
        return query.list();
    }

}