1. CRUD
1.1. private final SessionFactory sf = HibernateUtil.getSessionFactory();
1.2. //get all object sf.getCurrentSession().beginTransaction(); return sf.getCurrentSession().createCriteria(Categories.class).list();
1.3. //delete object sf.getCurrentSession().beginTransaction(); sf.getCurrentSession().delete(cat); sf.getCurrentSession().getTransaction().commit(); !!! sf.getCurrentSession().getTransaction().rollback();
1.4. //get object by id sf.getCurrentSession().beginTransaction(); return (Categories) sf.getCurrentSession().get(Categories.class, id);
1.5. //add or update object sf.getCurrentSession().beginTransaction(); sf.getCurrentSession().saveOrUpdate(cat); sf.getCurrentSession().getTransaction().commit(); !!! sf.getCurrentSession().getTransaction().rollback();
2. Config
2.1. hibernate.cfg
2.1.1. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/nvgthuy?zeroDateTimeBehavior=convertToNull</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.current_session_context_class">thread</property> </session-factory> </hibernate-configuration>
2.2. hibernate.reveng
2.2.1. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd"> <hibernate-reverse-engineering> <schema-selection match-catalog="bookstore"/> <table-filter match-name="books"/> <table-filter match-name="categories"/> <table-filter match-name="users"/> </hibernate-reverse-engineering>