HibernateTest

package it.unibo.tw.hibernate;

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

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;

public class HibernateTest {

	  public static void main(String[] args){// throws Exception{

		  Session session = new Configuration().configure().buildSessionFactory().openSession();
		  Transaction tx = null;

		  try {
			  tx = session.beginTransaction();

			  // Student

			  Student student = new Student();
			  student.setId(1);
			  student.setFirstName("Marco");
			  student.setLastName("Rossi");
			  Calendar c = Calendar.getInstance();
			  c.set(1984, 1, 24);
			  student.setBirthDate(c.getTime());
			  session.persist(student);

			  student = new Student();
			  student.setId(2);
			  student.setFirstName("Giovanni");
			  student.setLastName("Gialli");
			  c = Calendar.getInstance();
			  c.set(1983, 4, 13);
			  student.setBirthDate(c.getTime());
			  session.persist(student);

			  tx.commit();


			  // richiedo l'elenco degli studenti che hanno cognome "Gialli"
			  // versione SQL
			  System.out.println();
			  System.out.println("query students: sql/hql");

			  // query HQL: il nome della tabella è ottenuto tramite il mapping
			  //			presente nel file XML relativo alla classe Student
			  Query query = session.createQuery("from "+Student.class.getSimpleName()+" where lastName = ?");

			  // variante SQL: classica query in cui sis pecifica il nome della tabella
			  //Query query = session.createSQLQuery("select * from students where lastName = ?").addEntity(Student.class);

			  query.setString(0, "Gialli");
			  List<Student> students = query.list();
			  System.out.println("students.size() "+ students.size());
			  Iterator<Student> it = students.iterator();
			  while(it.hasNext()){
				  Student studentResult = it.next();
				  System.out.println(studentResult.getFirstName()+" "+ studentResult.getLastName()+" "+studentResult.getBirthDate());
			  }

			  // versione Criteria: soluzione completamente object-oriented
			  System.out.println();
			  System.out.println("query students: criteria");
			  Criteria criteria = session.createCriteria(Student.class);
			  criteria.add(Restrictions.eq("lastName", "Gialli"));
			  students = criteria.list();
			  System.out.println("students.size() "+ students.size());
			  for(Student studentResult : students){
				  System.out.println(studentResult.getFirstName()+" "+ studentResult.getLastName()+" "+studentResult.getBirthDate());
			  }

		  }
		  catch (Exception e1) {
		      if (tx != null){
		    	  try{
		    		  tx.rollback();
		    	  }
		    	  catch(Exception e2){
		    		  e2.printStackTrace();
		    	  }
		      }
		      e1.printStackTrace();
		  }
		  finally {
			  session.close();
		  }

		  session = new Configuration().configure().buildSessionFactory().openSession();

		  try {
			  tx = session.beginTransaction();

			  // Student

			  Course course = new Course();
			  course.setId(1);
			  course.setName("Tecnologie Web");

			  session.persist(course);

			  course = new Course();
			  course.setId(2);
			  course.setName("Fondamenti di Informatica");

			  session.persist(course);

			  tx.commit();


			  // richiedo l'elenco degli studenti che hanno cognome "Gialli"
			  // versione SQL
			  System.out.println();
			  System.out.println("query courses: sql/hql");

			  // query HQL: il nome della tabella è ottenuto tramite il mapping
			  //			presente nel file XML relativo alla classe Student
			  Query query = session.createQuery("from "+Course.class.getSimpleName()+" where name = ?");

			  // variante SQL: classica query in cui sis pecifica il nome della tabella
			  //Query query = session.createSQLQuery("select * from students where lastName = ?").addEntity(Student.class);

			  query.setString(0, "Tecnologie Web");
			  List<Course> courses = query.list();
			  System.out.println("courses.size() "+ courses.size());
			  Iterator<Course> it = courses.iterator();
			  while(it.hasNext()){
				  Course courseResult = it.next();
				  System.out.println(courseResult.getName());
			  }

			  // versione Criteria: soluzione completamente object-oriented
			  System.out.println();
			  System.out.println("query courses: criteria");
			  Criteria criteria = session.createCriteria(Course.class);
			  criteria.add(Restrictions.eq("name", "Tecnologie Web"));
			  courses = criteria.list();
			  System.out.println("students.size() "+ courses.size());
			  for(Course courseResult : courses){
				  System.out.println(courseResult.getName());
			  }

		  }
		  catch (Exception e1) {
		      if (tx != null){
		    	  try{
		    		  tx.rollback();
		    	  }
		    	  catch(Exception e2){
		    		  e2.printStackTrace();
		    	  }
		      }
		      e1.printStackTrace();
		  }
		  finally {
			  session.close();
		  }

		  session = new Configuration().configure().buildSessionFactory().openSession();

		  try {
			  tx = session.beginTransaction();

			  // Student

			  Course course = new Course();
			  course.setId(1);
			  course.setName("Tecnologie Web");

			  session.persist(course);

			  Course course2 = new Course();
			  course2.setId(2);
			  course2.setName("Fondamenti di Informatica");

			  session.persist(course2);


			  Student student = new Student();
			  student.setId(1);
			  student.setFirstName("Marco");
			  student.setLastName("Rossi");
			  Calendar c = Calendar.getInstance();
			  c.set(1984, 1, 24);
			  student.setBirthDate(c.getTime());
			  session.persist(student);

			  SCMapping m= new SCMapping();
			  m.setCourse(course);
			  m.setStudent(student);

			  session.persist(m);

			  m = new SCMapping();
			  m.setCourse(course2);
			  m.setStudent(student);

			  session.persist(m);

			  tx.commit();

			  // richiedo l'elenco degli studenti che hanno cognome "Gialli"
			  // versione SQL
			  System.out.println();
			  System.out.println("query mappings: sql/hql");

			  // query HQL: il nome della tabella è ottenuto tramite il mapping
			  //			presente nel file XML relativo alla classe Student
			  Query query = session.createQuery("from "+SCMapping.class.getSimpleName());

			  // variante SQL: classica query in cui sis pecifica il nome della tabella
			  //Query query = session.createSQLQuery("select * from students where lastName = ?").addEntity(Student.class);


			  List<SCMapping> mappings = query.list();
			  System.out.println("mappings.size() "+ mappings.size());
			  Iterator<SCMapping> it = mappings.iterator();
			  while(it.hasNext()){
				  SCMapping mappingResult = it.next();
				  System.out.println("Course: "+mappingResult.getCourse()+ " Student: "+mappingResult.getStudent());
			  }

			  // versione Criteria: soluzione completamente object-oriented
			  System.out.println();
			  System.out.println("query courses: criteria");
			  Criteria criteria = session.createCriteria(SCMapping.class);
			  criteria.add(Restrictions.eq("course", course));
			  mappings = criteria.list();
			  System.out.println("mappings.size() "+ mappings.size());
			  for(SCMapping mappingResult : mappings){
				  System.out.println("Course: "+mappingResult.getCourse()+ " Student: "+mappingResult.getStudent());
			  }

		  }
		  catch (Exception e1) {
		      if (tx != null){
		    	  try{
		    		  tx.rollback();
		    	  }
		    	  catch(Exception e2){
		    		  e2.printStackTrace();
		    	  }
		      }
		      e1.printStackTrace();
		  }
		  finally {
			  session.close();
		  }

	  }
}