package com.dao;

import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import java.util.List;
import org.hibernate.Query;
import com.actionForm.AfficheForm;

public class AfficheDao {
    private static SessionFactory sessionFactory = null;
    private Session session = null;
    Transaction tx = null;
    static {
        try {
            Configuration config = new Configuration().configure();
            sessionFactory = config.buildSessionFactory();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
//公告信息的刪除
    public void deleteAffiche(int id) {
        Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            AfficheForm form = (AfficheForm) session.load(AfficheForm.class, id);
            session.delete(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("刪除數(shù)據(jù)出錯(cuò)：" + e);
        } finally {
            session.close();
        }
    }


    /*==========================================================================*/
  //對(duì)公告信息的修改
    public void updateAffiche(AfficheForm form) {
        Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            session.load(AfficheForm.class, form.getId());
            session.update(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("修改數(shù)據(jù)出錯(cuò)：" + e);
        } finally {
            session.close();
        }
    }

    /*==========================================================================*/
    public void insertAffiche(AfficheForm form) { //對(duì)公告的插入操作
        Session session = sessionFactory.openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            session.save(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("插入數(shù)據(jù)出錯(cuò)：" + e);
        } finally {
            session.close();
        }
    }

    //全部信息公告查詢
    public List selectAffiche() {
        session = sessionFactory.openSession();
        tx = session.beginTransaction();
        String hql = "from AfficheForm order by id desc";
        List list = null;
        try {
            Query query = session.createQuery(hql);
            list = query.list();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        tx.commit();
        session.close();
        return list;
    }
    public AfficheForm selectOneAffiche(int id) { //對(duì)公告詳細(xì)查詢
          session = sessionFactory.openSession();
          tx = session.beginTransaction();
          String hql = "from AfficheForm where id='" + id + "'";
           AfficheForm form=null;
          try {
              Query query = session.createQuery(hql);
              form=(AfficheForm)query.uniqueResult();

          } catch (Exception e) {
              System.out.println(e.getMessage());
          }
          tx.commit();
          session.close();
          return form;
    }

}