newscommentservice.java

jsp+servlet实现的标准MVC系统 jsp-servlet-service-DAO-DBMS

package com.mycompany.news.service;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;

import com.mycompany.database.Database;
import com.mycompany.news.dao.NewsCommentDAO;
import com.mycompany.news.dao.impl.NewsCommentDAOImpl;
import com.mycompany.news.dto.News;
import com.mycompany.news.dto.NewsComment;

public class NewsCommentService extends BaseService {
	private NewsCommentDAO dao = new NewsCommentDAOImpl();
	/**
	 * 添加评论
	 * @param comment
	 * @return
	 */
	public boolean addComment(NewsComment comment){
		Connection conn=null;
		try {
			conn =Database.getConnection();
			dao.setConnection(conn);
			dao.addNewsComment(comment);
			Database.commit();
			setMessage("评论成功，等待审核");
			return true;
		} catch (Exception e) {
			setMessage(e.getMessage());
			return false;
		}finally{
			Database.releaseConnection(conn);
		}
		
		
	}
	/**
	 * 删除评论
	 * @param comment
	 * @return
	 */
	public boolean deleteComment(NewsComment comment){
		Connection conn=null;
		try {
			conn =Database.getConnection();
			dao.setConnection(conn);
			dao.deleteNewsComment(comment);
			Database.commit();
			return true;
		} catch (Exception e) {
			// TODO: handle exception
			return false;
		}finally{
			Database.releaseConnection(conn);
		}
		
	}
	/**
	 * 列出分页评论（包括未审核）
	 * @param news
	 * @param pageNo
	 * @param pageSize
	 * @return
	 */
	public List listComment(News news,int pageNo,int pageSize){
		Connection conn=null;
		try {
			conn =Database.getConnection();
			dao.setConnection(conn);
			List ret =dao.getNewsComment(news,pageNo,pageSize); 
			return ret;
		} catch (Exception e) {
			// TODO: handle exception
			return new ArrayList();
		}finally{
			Database.releaseConnection(conn);
		}
	}
	/**
	 * 分页列出已审核的评论
	 * @param news
	 * @param pageNo
	 * @param pageSize
	 * @return
	 */
	public List listPublicComment(News news,int pageNo,int pageSize){
		Connection conn=null;
		try {
			conn =Database.getConnection();
			dao.setConnection(conn);
			List ret =dao.listPublicComment(news,pageNo,pageSize); 
			return ret;
		} catch (Exception e) {
			// TODO: handle exception
			return new ArrayList();
		}finally{
			Database.releaseConnection(conn);
		}
	}
	public boolean auditComment(NewsComment comment) {
		Connection conn=null;
		try {
			conn =Database.getConnection();
			dao.setConnection(conn);
			boolean ret =dao.auditComment(comment); 
			Database.commit();
			return ret;
		} catch (Exception e) {
			setMessage(e.getMessage());
			return false;
		}finally{
			Database.releaseConnection(conn);
		}
	}
}