TemplateCategoryDaoImpl.java

/*
 * Copyright 2005-2008 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.openuap.cms.tpl.dao.hibernate;

import java.util.List;

import org.openuap.base.dao.hibernate.BaseDaoHibernate;
import org.openuap.cms.tpl.dao.TemplateCategoryDao;
import org.openuap.cms.tpl.model.TemplateCategory;

/**
 * <p>
 * 模板分类DAO实现.
 * </p>
 * 
 * <p>
 * $Id: TemplateCategoryDaoImpl.java 3919 2010-10-26 11:41:35Z orangeforjava $
 * </p>
 * 
 * @author Joseph
 * @version 1.0
 */
public class TemplateCategoryDaoImpl extends BaseDaoHibernate implements
		TemplateCategoryDao {

	public TemplateCategoryDaoImpl() {
	}

	public Long addTemplateCategory(TemplateCategory templateCategory) {
		return (Long) this.getHibernateTemplate().save(templateCategory);
	}

	public void saveTemplateCategory(TemplateCategory templateCategory) {
		this.getHibernateTemplate().saveOrUpdate(templateCategory);
	}

	public void deleteTemplateCategory(TemplateCategory templateCategory) {
		this.getHibernateTemplate().delete(templateCategory);
	}

	public void deleteTemplateCategoryById(Long id) {
		TemplateCategory tc = this.getTemplateCategoryById(id);
		this.getHibernateTemplate().delete(tc);
	}

	public TemplateCategory getTemplateCategoryById(Long id) {
		String hql = "from TemplateCategory where id=?";
		return (TemplateCategory) this.findUniqueResult(hql,
				new Object[] { id });
	}

	public TemplateCategory getTemplateCategoryByName(String name) {
		String hql = "from TemplateCategory where cateName=?";
		return (TemplateCategory) this.findUniqueResult(hql,
				new Object[] { name });

	}

	public List getTemplateCategories(Long parentId) {
		String hql = "from TemplateCategory where parentId=?";
		return this.executeFind(hql, new Object[] { parentId });
	}

	public long getChildCategoryCount(Long parentId) {
		String hql = "select count(*) from TemplateCategory where parentId=?";
		Object obj = this.getHibernateTemplate().iterate(hql,
				new Object[] { parentId }).next();
		if (obj instanceof Integer) {
			return ((Integer) obj).longValue();
		} else if (obj instanceof Long) {
			return ((Long) obj).longValue();
		} else {
			return 0L;
		}

	}
}