newsservice.java

在线考试功能

package com.onlinestudy.service;

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

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.onlinestudy.domain.News;
import com.onlinestudy.domain.NewsClasses;
import com.onlinestudy.domain.Students;

public class NewsService extends HibernateDaoSupport {
	ListForPage listForPage;
	
	//查询新闻栏目
	public List selectNewsClasses(){
		List list = this.getHibernateTemplate().find("from NewsClasses");
		
		return list;
	}
	
	//按ID号查询新闻栏目
	public NewsClasses selectNewsClassesById(int id){
		NewsClasses nc = (NewsClasses)this.getHibernateTemplate().get(NewsClasses.class, id);
		
		return nc;
	}
	
	//修改新闻栏目
	public void updateNewsClasses(NewsClasses nc){
		this.getHibernateTemplate().update(nc);
	
	}
	
	//增加新闻栏目
	public boolean addNewsClasses(NewsClasses nc){
		this.getHibernateTemplate().save(nc);
		
		return true;
	}
	//删除新闻栏目
	public boolean deleteNewsClasses(NewsClasses nc){
		this.getHibernateTemplate().delete(nc);
		
		return true;
	}
	
	//////////////////////////////////////////////////////////////////////////

	//查询新闻条数
	public int selectAllNewsId(String hql){
		List list = this.getHibernateTemplate().find(hql);
		int count = list.size();
		return count;
	}
	//分页查询新闻
	public List selectNewsForPage(String hql,int offset,int length){
		List list = listForPage.getListForPage(hql, offset, length);
		return list;
	}
	
	
	//增加新闻
	public boolean addNews(News news){
		String content = news.getContent();
		System.out.println("-------------------------------------");
		System.out.println(content);
		System.out.println("-------------------------------------");
		this.getHibernateTemplate().save(news);
		return true;
	}
	
	
	//修改新闻
	public boolean updateNews(News news){
		this.getHibernateTemplate().update(news);
		return true;
	}
	//按ID号查询新闻
	public News selectNewsById(int id){
		News ns = (News)this.getHibernateTemplate().get(News.class, id);
		return ns;
	}
	
	//按分类查询新闻
	public List selectNewsByClass(String hql, int offset, int length){
		List list = listForPage.getListForPage(hql, offset, length);
		return list;
	}
	
	//删除新闻
	public boolean deleteNewsById(int id){
		News news = (News)this.getHibernateTemplate().find("from News where id="+id).get(0);
		this.getHibernateTemplate().delete(news);
		return true;
	}
	
	//批量删除新闻
	public boolean deleteStudentBatch(final String[] array){
	this.getHibernateTemplate().execute(new HibernateCallback(){
			
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				int id;
				
				for(int i = 0; i < array.length; i++){					
					id = Integer.parseInt(array[i]);
					News news = new News();
					news.setId(id);
					session.delete(news);
					System.out.println("delete news where id="+id);
					session.close();
				}
				return null;
			}
			
			
		});
		
		return true;
	}
	
	
	public void setListForPage(ListForPage listForPage) {
		this.listForPage = listForPage;
	}
}