com.library.Database.DataHelper.java Source code

Introduction

Here is the source code for com.library.Database.DataHelper.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 com.library.Database;

import com.library.controller.SearchController;
import com.library.entity.Author;
import com.library.entity.Book;
import com.library.entity.Genre;
import com.library.entity.HibernateUtil;
import com.library.entity.Publisher;
import java.util.ArrayList;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import java.util.List;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.hibernate.Criteria;
import org.hibernate.Transaction;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.transform.Transformers;

/**
 *
 * @author ?
 */
public class DataHelper {
    private SessionFactory sessionFactory = null;
    private static DataHelper dataHelper = null;

    public int getTotalBooksNumber() {
        return totalBooksNumber;
    }

    private Transaction transaction = null;
    private int totalBooksNumber = 0;

    private DataHelper() {
        sessionFactory = HibernateUtil.getSessionFactory();

    }

    public static DataHelper getInstance() {

        return dataHelper == null ? dataHelper = new DataHelper() : dataHelper;
    }

    private Session getSession() {
        return sessionFactory.getCurrentSession();
    }

    private Criteria getCriteriaWithProjection() {
        return getSession().createCriteria(Book.class).setProjection(Projections.projectionList()
                .add(Projections.property("id"), "id").add(Projections.property("isbn"), "isbn")
                .add(Projections.property("name"), "name").add(Projections.property("author"), "author")
                .add(Projections.property("genre"), "genre").add(Projections.property("publisher"), "publisher")
                .add(Projections.property("descr"), "descr").add(Projections.property("publishYear"), "publishYear")
                .add(Projections.property("pageCount"), "pageCount")).addOrder(Order.asc("name"));
    }

    public List<Book> getAllBooks(int firstNote, int notesNumber) {
        getSession().beginTransaction();
        totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id")).list()
                .size();
        List<Book> books = getCriteriaWithProjection().setFirstResult(firstNote).setMaxResults(notesNumber)
                .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
        getSession().getTransaction().commit();
        return books;
    }

    public List<Genre> getAllGenres() {
        getSession().beginTransaction();
        List<Genre> genres = getSession().createCriteria(Genre.class).addOrder(Order.asc("name")).list();
        getSession().getTransaction().commit();
        return genres;

    }

    public List<Publisher> getAllPublishers() {
        getSession().beginTransaction();
        List<Publisher> publishers = getSession().createCriteria(Publisher.class).addOrder(Order.asc("name"))
                .list();
        getSession().getTransaction().commit();
        return publishers;
    }

    public List<Author> getAllAuthors() {
        getSession().beginTransaction();
        List<Author> genres = getSession().createCriteria(Author.class).addOrder(Order.asc("fio")).list();
        getSession().getTransaction().commit();
        return genres;

    }

    public List<Book> getBooksByGenre(Long genreId, int firstNote, int notesNumber) {
        getSession().beginTransaction();
        totalBooksNumber = getSession().createCriteria(Book.class).add(Restrictions.eq("genre.id", genreId))
                .setProjection(Projections.property("id")).list().size();
        List<Book> books = getCriteriaWithProjection().add(Restrictions.eq("genre.id", genreId))
                .setFirstResult(firstNote).setMaxResults(notesNumber)
                .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
        getSession().getTransaction().commit();
        return books;

    }

    public List<Book> getBooksByLetter(Character letter, int firstNote, int notesNumber) {
        return getBookList("name", letter.toString(), MatchMode.START, firstNote, notesNumber);
    }

    public List<Book> getBookByName(String name, int firstNote, int notesNumber) {
        return getBookList("name", name, MatchMode.ANYWHERE, firstNote, notesNumber);
    }

    public List<Book> getBookByAuthor(String authorName, int firstNote, int notesNumber) {
        getSession().beginTransaction();
        totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id"))
                .createCriteria("author").add(Restrictions.ilike("fio", authorName, MatchMode.ANYWHERE)).list()
                .size();
        List<Book> books = getCriteriaWithProjection().createCriteria("author")
                .add(Restrictions.ilike("fio", authorName, MatchMode.ANYWHERE)).setFirstResult(firstNote)
                .setMaxResults(notesNumber).setResultTransformer(Transformers.aliasToBean(Book.class)).list();
        getSession().getTransaction().commit();
        return books;
    }

    public byte[] getContent(Long id) {
        return (byte[]) getFieldValue("content", id);
    }

    public byte[] getImage(Long id) {
        return (byte[]) getFieldValue("image", id);
    }

    private Object getFieldValue(String field, Long id) {
        getSession().beginTransaction();
        Object bloob = getSession().createCriteria(Book.class).setProjection(Projections.property(field))
                .add(Restrictions.eq("id", id)).uniqueResult();
        getSession().getTransaction().commit();
        return bloob;

    }

    private List<Book> getBookList(String field, String value, MatchMode matchMode, int firstNote,
            int notesNumber) {
        getSession().beginTransaction();
        totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id"))
                .add(Restrictions.ilike(field, value, matchMode)).list().size();
        List<Book> books = getCriteriaWithProjection().add(Restrictions.ilike(field, value, matchMode))
                .setFirstResult(firstNote).setMaxResults(notesNumber)
                .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
        getSession().getTransaction().commit();
        return books;

    }

    public void update(ArrayList<Book> books) {
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        for (Book b : books) {
            //session.update(b);
            if (b.isIsBookChecked()) {
                Book book = (Book) (session.createCriteria(Book.class).add(Restrictions.eq("id", b.getId()))
                        .uniqueResult());
                b.setContent(book.getContent());
                b.setImage(book.getImage());
                session.merge(b);
            }

        }
        transaction.commit();
        session.flush();
        session.close();
    }

}