MeetingApp.HostHelper.java Source code

Introduction

Here is the source code for MeetingApp.HostHelper.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 MeetingApp;

import java.util.List;
import org.hibernate.SQLQuery;
import org.hibernate.Session;

/**
 *
 * @author user
 */
public class HostHelper {

    Session session = null;

    public HostHelper() {
        try {
            this.session = HibernateUtil.getSessionFactory().openSession();
            session.beginTransaction();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public int insertHost(Host a) {
        int result = 0;

        String sql = "insert into Host( HOST_EMAIL, HOST_NAME) " + "values (:email, :name)";

        try {
            // starting a transaction if on wisn't active
            if (!this.session.getTransaction().isActive()) {
                session.beginTransaction();
            }

            // creating an actul query that can be executed
            SQLQuery q = session.createSQLQuery(sql);
            //associating our Avtor POJO and table with the query 
            q.addEntity(Host.class);

            // binding values to the placeholders in the query
            q.setParameter("name", a.getHostName());
            q.setParameter("email", a.getHostEmail());

            // executing the query 
            result = q.executeUpdate();

            // commiting the query to the database
            session.getTransaction().commit();
        } catch (Exception e) {
            e.printStackTrace();
        }

        return result;
    }

    public int searchHost(Host a) {

        List<Host> host = null;

        // create the query, but as a String
        String sql = "select * from Host where HOST_EMAIL like :email and HOST_NAME like :name";

        try {
            // if the transaction isn't active, begin it
            if (!this.session.getTransaction().isActive()) {
                session.beginTransaction();
            }

            // create the actual query that will get executed
            SQLQuery q = session.createSQLQuery(sql);

            // associate the Category POJO and table with the query 
            q.addEntity(Host.class);

            q.setParameter("name", a.getHostName());
            q.setParameter("email", a.getHostEmail());

            // execute the query and cast the returned List
            // as a List of Films
            host = (List<Host>) q.list();
        } catch (Exception e) {
            e.printStackTrace();
        }

        return host.size();
    }

}