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.ForceForm;

public class ForceDao {
    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 deleteForce(int id) {
        Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            ForceForm form = (ForceForm) session.load(ForceForm.class, id);
            session.delete(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("刪除數據出錯：" + e);
        } finally {
            session.close();
        }
    }


    /*==========================================================================*/
  //對焦點新聞的修改
    public void updateForce(ForceForm form) {
        Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            session.load(ForceForm.class, form.getId());
             System.out.println("423432");
        String sql="update";
            session.update(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("修改數據出錯：" + e);
        } finally {
            session.close();
        }
    }

    /*==========================================================================*/
    public void insertForce(ForceForm form) { //對焦點新聞的插入操作
        Session session = sessionFactory.openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            session.save(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("插入數據出錯：" + e);
        } finally {
            session.close();
        }
    }

    //全部焦點新聞查詢
    public List selectForce() {
        session = sessionFactory.openSession();
        tx = session.beginTransaction();
        String hql = "from ForceForm 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 ForceForm selectOneForce(int id) { //對焦點新聞的詳細查詢
          session = sessionFactory.openSession();
          tx = session.beginTransaction();
          String hql = "from ForceForm where id='" + id + "'";
           ForceForm form=null;
          try {
              Query query = session.createQuery(hql);
              form=(ForceForm)query.uniqueResult();

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

}