taskdaoimpl.java

这是大唐电信的一个管理系统

package com.tatang.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.tatang.dao.ITaskDao;
import com.tatang.po.TTask;
import com.tatang.util.HibernateSessionFactory;

public class TaskDaoImpl implements ITaskDao{

	public List  allTaskList() {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql= "from TTask";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			List list = new ArrayList();
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public boolean addTask(TTask task) {
		Session session = null;
		Transaction tx = null;
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			session.save(task);
			tx.commit();
			return true;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return false;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public List<TTask> taskList(Integer id) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql="from TTask where id=? and state='-1'";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setInteger(0,id);
			List<TTask> list =new ArrayList(); 
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public List<TTask> findTaskById(Integer id) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql="from TTask where id=?";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setInteger(0,id);
			List<TTask> list = new ArrayList();
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public List<TTask> findTaskByName(String name) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql="from TTask where name=?";
		try{
			HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setString(0,name);
			List<TTask> list = new ArrayList();
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

}