sortdao.java

新闻网络中心 sql2000 jsp tomcat

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,创建SessionFactory实例,只在该类被加载到内存时执行一次
    static {
        try {
            Configuration config = new Configuration().configure();
            sessionFactory = config.buildSessionFactory();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
    /*==========================================================================*/
   public String selectSortName(int id){     //根据自动编号查询类别名称
      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) { //对新闻详细类别的插入操作
        Session session = sessionFactory.openSession();
        try {
            tx = session.beginTransaction();
            session.save(form);
            tx.commit();
        } catch (Exception e) {
            System.out.println("插入数据出错：" + e);
        } finally {
            session.close();
        }
    }

    /*==========================================================================*/
    public List selectSort(String bigSort) { //对新闻详细类别查询操作
        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) { //对详细类别查询
        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;
    }
//=======================================================================
//以自动编号为条件修改新闻详细类别的名称
    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("修改数据出错：" + e);
          } finally {
              session.close();
          }
    }
    //=======================================================================
//以自动编号为条件删除新闻详细类别的名称
    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("删除数据出错：" + e);
              return false;
          } finally {
              session.close();
          }
    }
//======================================================================



}