package com.elan.forum.test;

import java.util.Iterator;
import java.util.List;

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

import com.elan.db.ElHbnDB;
import com.elan.forum.elf.El;
import com.elan.forum.model.ForumTopic;
import com.elan.forum.model.view.Forumnewtopic;
import com.elan.forum.model.view.ForumnewtopicId;

public class Test5 {

	public static void main(String[] args) throws Exception {
		Session session = ElHbnDB.getSession();
		Transaction tx = session.beginTransaction();
		try {
			ForumTopic ft = (ForumTopic)session.createQuery("from ForumTopic where id = 2").list().get(0);
			tx.commit();
			System.out.println(ft.getPiece().getName());
		} catch (Exception re) {
			tx.rollback();
		} finally {
			ElHbnDB.closeSession();
		}
		
	}
}