package com.cnpoint.myspaces.document.dao.hibernate;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.cnpoint.myspaces.common.util.BaseDAOHibernate;
import com.cnpoint.myspaces.document.dao.DocumentNodeDAO;
import com.cnpoint.myspaces.document.model.DocumentNode;

public class DocumentNodeDAOHibernateImpl extends BaseDAOHibernate implements DocumentNodeDAO{

	public void saveDocumentNode(DocumentNode docNode) {
		// TODO Auto-generated method stub
		getHibernateTemplate().save(docNode);
	}

	public List findDocumentNodeList(final String docID) {
		// TODO Auto-generated method stub
		 return getHibernateTemplate().executeFind(new HibernateCallback() {
		      public Object doInHibernate(Session s) throws HibernateException, SQLException {
		          String q = "from DocumentNode" +
		          " document  where document.docID = '"+docID+"'   ";

		          Query query = s.createQuery(q);
		     
		          List list = query.list();
		          return list;

		      }
		    });
	}

	public void documentNodeAll() {
		// TODO Auto-generated method stub
		
	}

	public void updateDocumentNode(DocumentNode docNode) {
		// TODO Auto-generated method stub
		
	}

}