package com.dao;

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

public class ManagerDao {
    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 boolean updateManager(ManagerForm form) {
       Session session = sessionFactory.openSession();
       try {
           tx = session.beginTransaction();
           session.load(ManagerForm.class, form.getId());

          // session.saveOrUpdate(form);
         session.update(form);
           tx.commit();
           return true;
       } catch (Exception e) {
           return false;
       } finally {
           session.close();
       }
   }



   public void deleteManager(int id) {
      Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            ManagerForm form=(ManagerForm)session.load(ManagerForm.class,id);
            session.delete(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("刪除數(shù)據(jù)出錯(cuò)：" + e);
        } finally {
            session.close();
        }
  }
   //==========
   public void insertManager(ManagerForm form) { //對(duì)管理員的插入操作
       Session session = sessionFactory.openSession();
       try {
           tx = session.beginTransaction();
           session.save(form);
           tx.commit();
       } catch (Exception e) {
           System.out.println("插入數(shù)據(jù)出錯(cuò)：" + e);
       } finally {
           session.close();
       }
   }


  //==========

   public ManagerForm selectOneManager(String account) { //管理員賬號(hào)為條件查詢數(shù)據(jù)
      session = sessionFactory.openSession();
      tx = session.beginTransaction();
      String hql = "from ManagerForm where account='" + account + "'";
      ManagerForm form = null;
      try {
          Query query = session.createQuery(hql);
          form = (ManagerForm) query.uniqueResult();

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

  public List selectManager() {
    session = sessionFactory.openSession();
    tx = session.beginTransaction();
    String hql = "from ManagerForm where not manager=1 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 void addManagerNumber(int id) {
   Session session = sessionFactory.openSession();
     try {
         tx = session.beginTransaction();
         String hql = "from ManagerForm where id='"+id+"'";
          Query query = session.createQuery(hql);
         List list = query.list();
         ManagerForm managerForm = (ManagerForm)list.get(0);
         managerForm.setNumber(managerForm.getNumber() + 1);
         session.saveOrUpdate(managerForm);
         tx.commit();
     } catch (Exception e) {
         System.out.println("更新數(shù)據(jù)出錯(cuò)：" + e);
     } finally {
         session.close();
     }
  }



}