admindaoimpl.java

jsp学习交流网

package cfq.business.impl;

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

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cfq.business.dao.AdminDao;
import cfq.comm.utils.DateFormatUtils;
import cfq.hibernate.vo.Admin;
import cfq.hibernate.vo.News;
import cfq.hibernate.vo.Newscomment;
import cfq.struts.actionform.ModifyNewsForm;
import cfq.struts.actionform.NewsForm;
public class AdminDaoImpl extends HibernateDaoSupport implements AdminDao {

	//新增新闻
	public String addNews(int adminid,NewsForm news) {
		String result="OK";
		try{
			News ns=new News();
			ns.setNewstitle(news.getNewstitle());
			ns.setNewstontent(news.getNewstontent());
			ns.setNewsdate(DateFormatUtils.dateToStirng(new Date()));
			Admin ad=(Admin)this.getSession().load(Admin.class, adminid);
			ns.setAdmin(ad);
			this.getHibernateTemplate().save(ns);
		}catch(Exception e){
			result="fail";
			e.printStackTrace();
		}
		
		return result;
	}

	//管理员登录验证
	public String adminLogin(String adminid, String password) {
		String result="fail";
		String hql="From Admin a where a.adminname=? and a.password=?";
        List list=this.getSession().createQuery(hql).setString(0, adminid)
													.setString(1, password)
													.list();
		if(list.size()>0){
			result="OK";
		}
		return result;
	}
	
	//根据新闻Id删除新闻信息以及该新闻的所有评论
	public String delNews(int newsid) {
		String result="OK";
		try{
			News nes=(News)this.getSession().load(News.class, newsid);
			this.getHibernateTemplate().delete(nes);
		}catch(Exception e){
			result="fail";
			e.printStackTrace();
		}
		return result;
	}

	//修改新闻信息
	public String modifyNews(ModifyNewsForm mnf) {
		String result="OK";
		try{
			News ns=(News)this.getSession().load(News.class, mnf.getNewsid());
			ns.setNewstontent(mnf.getNewstontent());
			ns.setNewstitle(mnf.getNewstitle());
		}catch(Exception e){
			result="fail";
		}
		return result;
	}

	public Admin queryByName(String adminname) {
		Admin admin=null;
		String hql="From Admin a where a.adminname=?";
		List list=this.getSession().createQuery(hql).setString(0, adminname)
										  .list();
		if(list.size()>0){
			Iterator iter=list.iterator();
			admin=(Admin)iter.next();
		}
		return admin;
	}

	//根据id删除一条评论记录
	public String delNewsComment(int newscommentid) {
		String result="OK";
		try{
			Newscomment newscmt=(Newscomment)this.getSession().load(Newscomment.class, newscommentid);
			this.getHibernateTemplate().delete(newscmt);
		}catch(Exception e){
			result="fail";
			e.printStackTrace();
		}
		return result;
	}

}