catdaoimpl.java

ServletFilter+ThreadLocal+DAO

package com.xanada.helper;

import com.xanada.po.*;
import net.sf.hibernate.*;
import java.util.*;

public class CatDAOImpl implements CatDAO {

    public void creatCat(Cat cat) {
        try {
            Session s = HibernateSessionFactory.currentSession();

            s.save(cat);
            s.flush();
        } catch (HibernateException e) {
            e.printStackTrace();
        }
    }

    public List readCats() {
        List lstCats = null;

        try {
            Session s = HibernateSessionFactory.currentSession();

            Query query = s.createQuery("select cat from Cat as cat");
            lstCats = query.list();
            s.flush();
        } catch (HibernateException e) {
            e.printStackTrace();
        }

        return lstCats;
    }

    public void updateCat(Cat cat) {
        try {
            Session s = HibernateSessionFactory.currentSession();

            s.update(cat);
            s.flush();
        } catch (HibernateException e) {
            e.printStackTrace();
        }
    }

    public void delCat(String strCatId) {
        try {
            Session s = HibernateSessionFactory.currentSession();

            Object cat = s.load(Cat.class, strCatId);
            s.delete(cat);
            s.flush();
        } catch (HibernateException e) {
            e.printStackTrace();
        }
    }
}