package com.ibm.service;

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

import com.ibm.dao.TopicDAO;
import com.ibm.dto.TopicDTO;
import com.ibm.vo.TopicVO;

public class TopicService {
   private static TopicService topicservice=null;
   
   private TopicService()
   {
	   
   }
   
   public static TopicService getInstance()
   {
	   if(topicservice == null)
	   {
		   topicservice =new TopicService();
		   return topicservice;
	   }else
	   {
		   return topicservice;
	   }
   }
   

   
   /**
    * 通過子板塊的boardid返回該版塊下的所有主題列表
    * @param con
    * @param boardid
    * @return
    */
   public List queryByBoardid(Connection con,int boardid)
   {
	   return TopicDAO.getInstance().queryByBoardid(con, boardid);
   }
   
   /**
    * 返回按時間排序的第一個主題信息
    * @param con
    * @param boardid
    * @return
    */
   public TopicVO queryTopByBoardid(Connection con,int boardid)
   {
	   return TopicDAO.getInstance().queryTopByBoardid(con, boardid);
   }
   
   /**
    * 根據子板塊的boardid返回該板塊下的主題數
    * @param con
    * @param boardid
    * @return
    */
   public int queryTopicNumByBoardid(Connection con,int boardid)
   {
	   return TopicDAO.getInstance().queryTopicNumByBoardid(con, boardid);
   }
   
   /**
    * 根據主題id返回該id下所有的信息
    * @param con
    * @param topicid
    * @return
    */
   public TopicVO queryByTopicid(Connection con,int topicid)
   {
	   return TopicDAO.getInstance().queryByTopicid(con, topicid);
   }

}