package com.dao;

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

public class SortDao {
    static SessionFactory sessionFactory;
    private Session session = null;
    Transaction tx = null;
    //初始化Hibernate,創(chuàng)建SessionFactory實(shí)例,只在該類被加載到內(nèi)存時(shí)執(zhí)行一次
    static {
        try {
            Configuration config = new Configuration().configure();
            sessionFactory = config.buildSessionFactory();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
    /*==========================================================================*/
   public String selectSortName(int id){     //根據(jù)自動(dòng)編號(hào)查詢類別名稱
      session = sessionFactory.openSession();
      tx = session.beginTransaction();
      String hql = "from SortForm where id='" + id + "'";
      SortForm form=null;
     try {
         Query query = session.createQuery(hql);
         form=(SortForm)query.uniqueResult();

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

    /*==========================================================================*/
    public void insertSort(SortForm form) { //對(duì)新聞詳細(xì)類別的插入操作
        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 List selectSort(String bigSort) { //對(duì)新聞詳細(xì)類別查詢操作
        session = sessionFactory.openSession();
        tx = session.beginTransaction();
        String hql = "from SortForm where bigSort='" + bigSort + "' 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 SortForm selectOneSort(String smallSort) { //對(duì)詳細(xì)類別查詢
        session = sessionFactory.openSession();
        tx = session.beginTransaction();
        String hql = "from SortForm where smallSort='" + smallSort + "'";
         SortForm form=null;
        try {
            Query query = session.createQuery(hql);
            form=(SortForm)query.uniqueResult();

        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        tx.commit();
        session.close();
        return form;
    }
//=======================================================================
//以自動(dòng)編號(hào)為條件修改新聞詳細(xì)類別的名稱
    public void updateSort(SortForm form) {
        Session session = sessionFactory.openSession();
          try {
              tx = session.beginTransaction();
              session.load(SortForm.class,form.getId());
              session.update(form);
              tx.commit();
          } catch (Exception e) {
              System.out.println("修改數(shù)據(jù)出錯(cuò)：" + e);
          } finally {
              session.close();
          }
    }
    //=======================================================================
//以自動(dòng)編號(hào)為條件刪除新聞詳細(xì)類別的名稱
    public boolean deleteSort(int id) {
        Session session = sessionFactory.openSession();
          try {
              tx = session.beginTransaction();
              SortForm form=(SortForm)session.load(SortForm.class,id);
              session.delete(form);
              tx.commit();
              return true;
          } catch (Exception e) {
              System.out.println("刪除數(shù)據(jù)出錯(cuò)：" + e);
              return false;
          } finally {
              session.close();
          }
    }
//======================================================================



}