admindaoimpl.java

随着信息技术的飞速发展、网上信息量发布的不断增大。针对文章管理这一环节

package com.web.admin.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.web.admin.dao.IAdminDao;
import com.web.admin.exception.AdminException;
import com.web.common.bean.Article;
import com.web.common.bean.ArticleAdmin;
import com.web.common.transaction.HibernateSessionFactory;
import com.web.user.exception.UserException;


public class AdminDaoImpl implements IAdminDao {
	
	public void deleteArticle(Article article) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();		
		session.delete(article);
	}

	public ArticleAdmin findAdmin(String loginName) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from ArticleAdmin where name = ? ");
		query.setString(0, loginName);
		ArticleAdmin admin = (ArticleAdmin) query.uniqueResult();
		return admin;
	}

	public List findAllArticle() throws AdminException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from Article");
		List list = query.list();
		return list;
	}

	public void saveOrupdate(Article article) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();		
		session.saveOrUpdate(article);
	}

	public void saveOrupdate(ArticleAdmin admin) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();		
		session.saveOrUpdate(admin);
	}

	public ArticleAdmin findAdmin(String loginname, String password) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from ArticleAdmin where name = ? and password = ?");
		System.out.println(loginname);
		System.out.println(password);
		query.setString(0, loginname);
		query.setString(1, password);
		
		System.out.println("----into articleAdmin-----");
		ArticleAdmin admin = (ArticleAdmin) query.uniqueResult();
		
		System.out.println("------Aaaaaaaa-------"+admin);
		return admin;

	}

	public Article findArticle(String title) throws AdminException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from Article where topic = ? ");		
		query.setString(0, title);
		Article article = (Article) query.uniqueResult();
		return article;
	}

	public List searchArticle(int start, int end) throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Query query=session.createQuery("from Article");
		int s=(start-1)*end;
		query.setFirstResult(s);
		query.setMaxResults(end);
		List list=query.list();
		return list;
	}

}