userdaoimpl.java

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

package com.web.user.dao.impl;


import java.util.Date;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;

import com.web.common.bean.Article;
import com.web.common.bean.ArticleUser;
import com.web.common.transaction.HibernateSessionFactory;
import com.web.user.dao.IUserDao;
import com.web.user.exception.UserException;

public class UserDaoImpl implements IUserDao {
	
	public List findAllArticle() throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Criteria query = session.createCriteria(Article.class);
		List<Article> list = (List<Article>)query.list();
		for(Article a:list){
			a.getPubname();
		}
		System.out.println("yyyyyyyyyyyy"+list);
		return list;
	}

	public ArticleUser findUser(String loginName) throws UserException{
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from ArticleUser where name=?");
		query.setString(0, loginName);
		ArticleUser user = (ArticleUser) query.uniqueResult();
		System.out.println("1212121212"+user);
		return user;
		
	}

	public ArticleUser findUser(String loginname, String password) throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from ArticleUser where name = ? and password = ?");
		query.setString(0, loginname);
		query.setString(1, password);
		System.out.println("----into user-----");
		ArticleUser user = (ArticleUser) query.uniqueResult();
		System.out.println("------------user----------"+user);
		return user;
	}
	public List findArticleByCondition(String type,
			Date startDate,Date endDate,String orderby,boolean flag)
			throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Criteria c = session.createCriteria(Article.class);
		System.out.println("---------type------"+type);
		if(type!=null&&type.trim().length()>0)
			c.add(Expression.eq("type", type));
		
		if(startDate!=null&&endDate!=null)
			c.add(Expression.between("senddate", startDate, endDate));
		if(orderby!=null&&flag==true){
			c.addOrder(Order.asc(orderby));
		}else{
			c.addOrder(Order.desc(orderby));
		}
		List list = c.list();
		System.out.println("listlsitppslfjdllist"+list.size());
		
		return list;
	}

	public List findTopArticle(int start,int end) throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from Article order by hits desc");		
		query.setFirstResult(start);
		query.setMaxResults(end);
		List list = query.list();
		return list;
	}

	public Article findArticle(String title) throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		Query query = session.createQuery("from Article where topic=?");
		query.setString(0, title);
		Article article = (Article) query.uniqueResult();
		
		return article;
	}
	public void saveOrupdate(Article article) throws UserException{
		Session session = HibernateSessionFactory.currentSession();
		session.saveOrUpdate(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;
	}

	public void save(ArticleUser user) throws UserException {
			Session session = HibernateSessionFactory.currentSession();
			session.save(user);
		}
	

	public void saveOrupdate(ArticleUser user) throws UserException {
		Session session = HibernateSessionFactory.currentSession();
		session.saveOrUpdate(user);
	}

	}