forcedao.java

新闻网络中心 sql2000 jsp tomcat

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;
    }

}