bbsinfomanageimple.java

hibernate项目实践

		
		allBBSTitleVOList=new ArrayList();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		allBBSTitlePOList=bbsTitleInfoManageDAOBean.selectBBSTitleByBBSTitleID(bbsTitleID);
		allBBSTitlePOItem=allBBSTitlePOList.iterator();
		while(allBBSTitlePOItem.hasNext())
		{
			BBSTitlePO oneBBSTitlePO=(BBSTitlePO)allBBSTitlePOItem.next();
			BBSTitleVO oneBBSTitleVO=new BBSTitleVO();
			
			oneBBSTitleVO.setBbsTitleID(oneBBSTitlePO.getId());
			oneBBSTitleVO.setBbsTitle(oneBBSTitlePO.getBbsTitle());			
			oneBBSTitleVO.setTitleLeaderName(oneBBSTitlePO.getTitleLeaderName());
			oneBBSTitleVO.setTotalTopicNumber(oneBBSTitlePO.getTotalTopicNumber());
			oneBBSTitleVO.setTodayTopicNumber(oneBBSTitlePO.getTodayTopicNumber());
			oneBBSTitleVO.setLastSendTime(oneBBSTitlePO.getLastSendTime());
			oneBBSTitleVO.setLastTopicAuthor(oneBBSTitlePO.getLastTopicAuthor());
			oneBBSTitleVO.setNewTopic(oneBBSTitlePO.getNewTopic());
			oneBBSTitleVO.setTitleAbstractText(oneBBSTitlePO.getTitleAbstractText());
			oneBBSTitleVO.setUserID(oneBBSTitlePO.getUserID());
			
			allBBSTitleVOList.add(oneBBSTitleVO);
		}	
		return allBBSTitleVOList;
*/		return null;
	}
	public ArrayList doGetBBSTitleInfo() throws WebBBSException 
	{
		ArrayList allBBSTitleVOList=null;
		ArrayList allBBSTitlePOList=null;
		Iterator allBBSTitlePOItem=null;
		
		allBBSTitleVOList=new ArrayList();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		allBBSTitlePOList=bbsTitleInfoManageDAOBean.getAllBbsTitleInfos();
		allBBSTitlePOItem=allBBSTitlePOList.iterator();
		while(allBBSTitlePOItem.hasNext())
		{
			BBSTitleInfoPO oneBBSTitleInfoPO=(BBSTitleInfoPO)allBBSTitlePOItem.next();
			BBSTitleVO oneBBSTitleVO=new BBSTitleVO();
			
			oneBBSTitleVO.setBbsTitleID(oneBBSTitleInfoPO.getId());
			oneBBSTitleVO.setBbsTitle(oneBBSTitleInfoPO.getBbsTitle());			
			oneBBSTitleVO.setTitleLeaderName(oneBBSTitleInfoPO.getTitleLeaderName());
			oneBBSTitleVO.setTotalTopicNumber(oneBBSTitleInfoPO.getTotalTopicNumber());
			oneBBSTitleVO.setTodayTopicNumber(oneBBSTitleInfoPO.getTodayTopicNumber());
			oneBBSTitleVO.setLastSendTime(oneBBSTitleInfoPO.getLastSendTime());
			oneBBSTitleVO.setLastTopicAuthor(oneBBSTitleInfoPO.getLastTopicAuthor());
			oneBBSTitleVO.setNewTopic(oneBBSTitleInfoPO.getNewTopic());
			oneBBSTitleVO.setTitleAbstractText(oneBBSTitleInfoPO.getTitleAbstractText());
			oneBBSTitleVO.setUserID(oneBBSTitleInfoPO.getUserID());
			
			allBBSTitleVOList.add(oneBBSTitleVO);
		}	
		return allBBSTitleVOList;
	}

	public BBSTitleVO doGetBBSTitleInfoByTitleID(int bbsTitleID)	throws WebBBSException 
	{
		BBSTitleVO oneBBSTitleVO=null;
		BBSTitleInfoPO oneBBSTitleInfoPO=null;
		
		oneBBSTitleVO=new BBSTitleVO();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		oneBBSTitleInfoPO=bbsTitleInfoManageDAOBean.selectBBSTitleByBBSTitleID(bbsTitleID);
		
		oneBBSTitleVO.setBbsTitleID(oneBBSTitleInfoPO.getId());
		oneBBSTitleVO.setBbsTitle(oneBBSTitleInfoPO.getBbsTitle());			
		oneBBSTitleVO.setTitleLeaderName(oneBBSTitleInfoPO.getTitleLeaderName());
		oneBBSTitleVO.setTotalTopicNumber(oneBBSTitleInfoPO.getTotalTopicNumber());
		oneBBSTitleVO.setTodayTopicNumber(oneBBSTitleInfoPO.getTodayTopicNumber());
		oneBBSTitleVO.setLastSendTime(oneBBSTitleInfoPO.getLastSendTime());
		oneBBSTitleVO.setLastTopicAuthor(oneBBSTitleInfoPO.getLastTopicAuthor());
		oneBBSTitleVO.setNewTopic(oneBBSTitleInfoPO.getNewTopic());
		oneBBSTitleVO.setTitleAbstractText(oneBBSTitleInfoPO.getTitleAbstractText());
		oneBBSTitleVO.setUserID(oneBBSTitleInfoPO.getUserID());
		
		return oneBBSTitleVO;
	}

	public BBSInfoVO doGetOneBBSInfoByBBSID(int bbsInfoID)		throws WebBBSException 
	{
		BBSInfoPO oneBBSInfoPO=null;
		BBSInfoVO oneBBSInfoVO=null;
			
		oneBBSInfoVO=new BBSInfoVO();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		oneBBSInfoPO=bbsInfoManageDAOBean.selectBBSInfoByBBSID(bbsInfoID);
		
		oneBBSInfoVO.setAuthor(oneBBSInfoPO.getAuthor());
		oneBBSInfoVO.setTitle(oneBBSInfoPO.getTitle());
		oneBBSInfoVO.setReplay(oneBBSInfoPO.getReplay());
		oneBBSInfoVO.setHits(oneBBSInfoPO.getHits());
		oneBBSInfoVO.setSendInfoTime(oneBBSInfoPO.getSendInfoTime());
/*
* 注意：由于在“在线编辑器”中已经将字符进行转换，所以不再需要进行转换		
	    oneBBSInfoVO.setContent(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getContent()));
	    oneBBSInfoVO.setAbstractText(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getAbstractText()));
*/
	    oneBBSInfoVO.setContent(oneBBSInfoPO.getContent());
	    oneBBSInfoVO.setAbstractText(oneBBSInfoPO.getAbstractText());
	    
		oneBBSInfoVO.setMailto(oneBBSInfoPO.getMailto());
		oneBBSInfoVO.setLastUpdateTime(oneBBSInfoPO.getLastUpdateTime());
		oneBBSInfoVO.setBbsIconID(oneBBSInfoPO.getBbsIconID());
		oneBBSInfoVO.setBbsTypeID(oneBBSInfoPO.getBbsTypeID());
		oneBBSInfoVO.setBbsTitleID(oneBBSInfoPO.getBbsTitleID());
		oneBBSInfoVO.setUserID(oneBBSInfoPO.getUserID());			
		oneBBSInfoVO.setBbsID(oneBBSInfoPO.getId());	
		
//		下面的代码实现将BBSInfoPO中的HashSet类型的BBSReplyInfoPO转换为ArrayList并保存到BBSInfoVO中
		
		ArrayList allBBSReplyInfoPOArrayList=oneBBSInfoPO.getBbsReplyInfosByBBS();
		ArrayList allBBSReplyInfoVOArrayList=new ArrayList();
		Iterator allBbsReplyInfosPOArrayListIterator=allBBSReplyInfoPOArrayList.iterator();
		while(allBbsReplyInfosPOArrayListIterator.hasNext())
		{
			BBSReplyInfoPO oneBBSReplyInfoPOInHashSet=(BBSReplyInfoPO)allBbsReplyInfosPOArrayListIterator.next();
			BBSReplyInfoVO oneBBSReplyInfoVO=new BBSReplyInfoVO();
			
			oneBBSReplyInfoVO.setBbsID(oneBBSReplyInfoPOInHashSet.getBbsID());
			oneBBSReplyInfoVO.setAuthor(oneBBSReplyInfoPOInHashSet.getAuthor());			
			oneBBSReplyInfoVO.setContent(oneBBSReplyInfoPOInHashSet.getContent());
			oneBBSReplyInfoVO.setReplytime(oneBBSReplyInfoPOInHashSet.getReplytime());
			oneBBSReplyInfoVO.setAbstractText(oneBBSReplyInfoPOInHashSet.getAbstractText());
			oneBBSReplyInfoVO.setReplyTitle(oneBBSReplyInfoPOInHashSet.getReplyTitle());
			oneBBSReplyInfoVO.setBbsReplyIconID(oneBBSReplyInfoPOInHashSet.getBbsReplyIconID());
			
			allBBSReplyInfoVOArrayList.add(oneBBSReplyInfoVO);
		}
		oneBBSInfoVO.setAllBBSReplyInfoList(allBBSReplyInfoVOArrayList);			
		
		return oneBBSInfoVO;
	}
    public ArrayList doGetPageBBSInfoByLoginUserID(String userID,int firstResult, int maxResults) throws WebBBSException
    {
		ArrayList allBBSInfoVOList=null;
		ArrayList allBBSInfoPOList=null;
		Iterator allBBSInfoPOItem=null;
		
		allBBSInfoVOList=new ArrayList();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		allBBSInfoPOList=bbsInfoManageDAOBean.selectPageBBSInfoByLoginUserID(userID,firstResult,maxResults);
		
		allBBSInfoPOItem=allBBSInfoPOList.iterator();
		while(allBBSInfoPOItem.hasNext())
		{
			BBSInfoPO oneBBSInfoPO=(BBSInfoPO)allBBSInfoPOItem.next();
			BBSInfoVO oneBBSInfoVO=new BBSInfoVO();
			
			oneBBSInfoVO.setAuthor(oneBBSInfoPO.getAuthor());
			oneBBSInfoVO.setTitle(oneBBSInfoPO.getTitle());
			oneBBSInfoVO.setReplay(oneBBSInfoPO.getReplay());
			oneBBSInfoVO.setHits(oneBBSInfoPO.getHits());
			oneBBSInfoVO.setSendInfoTime(oneBBSInfoPO.getSendInfoTime());
/*
* 注意：由于在“在线编辑器”中已经将字符进行转换，所以不再需要进行转换		
	    	oneBBSInfoVO.setContent(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getContent()));
	    	oneBBSInfoVO.setAbstractText(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getAbstractText()));
*/
		    oneBBSInfoVO.setContent(oneBBSInfoPO.getContent());
		    oneBBSInfoVO.setAbstractText(oneBBSInfoPO.getAbstractText());

			oneBBSInfoVO.setMailto(oneBBSInfoPO.getMailto());
			oneBBSInfoVO.setLastUpdateTime(oneBBSInfoPO.getLastUpdateTime());
			oneBBSInfoVO.setBbsIconID(oneBBSInfoPO.getBbsIconID());
			oneBBSInfoVO.setBbsTypeID(oneBBSInfoPO.getBbsTypeID());
			oneBBSInfoVO.setBbsTitleID(oneBBSInfoPO.getBbsTitleID());
			oneBBSInfoVO.setUserID(oneBBSInfoPO.getUserID());			
			oneBBSInfoVO.setBbsID(oneBBSInfoPO.getId());	
			
//			下面的代码实现将BBSInfoPO中的HashSet类型的BBSReplyInfoPO转换为ArrayList并保存到BBSInfoVO中
			
			ArrayList allBBSReplyInfoPOArrayList=oneBBSInfoPO.getBbsReplyInfosByBBS();
			ArrayList allBBSReplyInfoVOArrayList=new ArrayList();
			Iterator allBbsReplyInfosPOArrayListIterator=allBBSReplyInfoPOArrayList.iterator();
			while(allBbsReplyInfosPOArrayListIterator.hasNext())
			{
				BBSReplyInfoPO oneBBSReplyInfoPOInHashSet=(BBSReplyInfoPO)allBbsReplyInfosPOArrayListIterator.next();
				BBSReplyInfoVO oneBBSReplyInfoVO=new BBSReplyInfoVO();
				
				oneBBSReplyInfoVO.setBbsID(oneBBSReplyInfoPOInHashSet.getBbsID());
				oneBBSReplyInfoVO.setAuthor(oneBBSReplyInfoPOInHashSet.getAuthor());			
				oneBBSReplyInfoVO.setContent(oneBBSReplyInfoPOInHashSet.getContent());
				oneBBSReplyInfoVO.setReplytime(oneBBSReplyInfoPOInHashSet.getReplytime());
				oneBBSReplyInfoVO.setAbstractText(oneBBSReplyInfoPOInHashSet.getAbstractText());
				oneBBSReplyInfoVO.setReplyTitle(oneBBSReplyInfoPOInHashSet.getReplyTitle());
				oneBBSReplyInfoVO.setBbsReplyIconID(oneBBSReplyInfoPOInHashSet.getBbsReplyIconID());
				
				allBBSReplyInfoVOArrayList.add(oneBBSReplyInfoVO);
			}
			oneBBSInfoVO.setAllBBSReplyInfoList(allBBSReplyInfoVOArrayList);
			
			allBBSInfoVOList.add(oneBBSInfoVO);
		}		
		return allBBSInfoVOList;

    }
	public ArrayList doGetPageBBSInfoByTitleID(int bbsTitleID, int firstResult,int maxResults) throws WebBBSException 
	{
		ArrayList allBBSInfoVOList=null;
		ArrayList allBBSInfoPOList=null;
		Iterator allBBSInfoPOItem=null;
		
		allBBSInfoVOList=new ArrayList();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		allBBSInfoPOList=bbsInfoManageDAOBean.selectPageBBSInfoByTitleID(bbsTitleID,firstResult,maxResults);
		
		allBBSInfoPOItem=allBBSInfoPOList.iterator();
		while(allBBSInfoPOItem.hasNext())
		{
			BBSInfoPO oneBBSInfoPO=(BBSInfoPO)allBBSInfoPOItem.next();
			BBSInfoVO oneBBSInfoVO=new BBSInfoVO();
			
			oneBBSInfoVO.setAuthor(oneBBSInfoPO.getAuthor());
			oneBBSInfoVO.setTitle(oneBBSInfoPO.getTitle());
			oneBBSInfoVO.setReplay(oneBBSInfoPO.getReplay());
			oneBBSInfoVO.setHits(oneBBSInfoPO.getHits());
			oneBBSInfoVO.setSendInfoTime(oneBBSInfoPO.getSendInfoTime());
/*
* 注意：由于在“在线编辑器”中已经将字符进行转换，所以不再需要进行转换		
	    	oneBBSInfoVO.setContent(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getContent()));
	    	oneBBSInfoVO.setAbstractText(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getAbstractText()));
*/
		    oneBBSInfoVO.setContent(oneBBSInfoPO.getContent());
		    oneBBSInfoVO.setAbstractText(oneBBSInfoPO.getAbstractText());

			oneBBSInfoVO.setMailto(oneBBSInfoPO.getMailto());
			oneBBSInfoVO.setLastUpdateTime(oneBBSInfoPO.getLastUpdateTime());
			oneBBSInfoVO.setBbsIconID(oneBBSInfoPO.getBbsIconID());
			oneBBSInfoVO.setBbsTypeID(oneBBSInfoPO.getBbsTypeID());
			oneBBSInfoVO.setBbsTitleID(oneBBSInfoPO.getBbsTitleID());
			oneBBSInfoVO.setUserID(oneBBSInfoPO.getUserID());			
			oneBBSInfoVO.setBbsID(oneBBSInfoPO.getId());	
			
//			下面的代码实现将BBSInfoPO中的HashSet类型的BBSReplyInfoPO转换为ArrayList并保存到BBSInfoVO中
			
			ArrayList allBBSReplyInfoPOArrayList=oneBBSInfoPO.getBbsReplyInfosByBBS();
			ArrayList allBBSReplyInfoVOArrayList=new ArrayList();
			Iterator allBbsReplyInfosPOArrayListIterator=allBBSReplyInfoPOArrayList.iterator();
			while(allBbsReplyInfosPOArrayListIterator.hasNext())
			{
				BBSReplyInfoPO oneBBSReplyInfoPOInHashSet=(BBSReplyInfoPO)allBbsReplyInfosPOArrayListIterator.next();
				BBSReplyInfoVO oneBBSReplyInfoVO=new BBSReplyInfoVO();
				
				oneBBSReplyInfoVO.setBbsID(oneBBSReplyInfoPOInHashSet.getBbsID());
				oneBBSReplyInfoVO.setAuthor(oneBBSReplyInfoPOInHashSet.getAuthor());			
				oneBBSReplyInfoVO.setContent(oneBBSReplyInfoPOInHashSet.getContent());
				oneBBSReplyInfoVO.setReplytime(oneBBSReplyInfoPOInHashSet.getReplytime());
				oneBBSReplyInfoVO.setAbstractText(oneBBSReplyInfoPOInHashSet.getAbstractText());
				oneBBSReplyInfoVO.setReplyTitle(oneBBSReplyInfoPOInHashSet.getReplyTitle());
				oneBBSReplyInfoVO.setBbsReplyIconID(oneBBSReplyInfoPOInHashSet.getBbsReplyIconID());
				
				allBBSReplyInfoVOArrayList.add(oneBBSReplyInfoVO);
			}
			oneBBSInfoVO.setAllBBSReplyInfoList(allBBSReplyInfoVOArrayList);
			
			allBBSInfoVOList.add(oneBBSInfoVO);
		}		
		return allBBSInfoVOList;
	}

	public int doGetPageTotalBBSInfoCounterByTitleID(int bbsTitleID)	throws WebBBSException 
	{
		int totalCounter;
	
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		totalCounter=bbsInfoManageDAOBean.getBBSTotalCounterInOneBBSTitle(bbsTitleID);		   
		return totalCounter;
	}
    public int doGetTotalBBSInfoCounterByUserID(String userID) throws WebBBSException
    {
		int bbsInfoTotalCounterByUserID=0;
		
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		bbsInfoTotalCounterByUserID=bbsInfoManageDAOBean.getTotalBBSInfoCounterByUserID(userID);
		
		return bbsInfoTotalCounterByUserID;
    }
	public int doGetTotalHotBBSInfoCounter(int totalHits) throws WebBBSException
	{
		int hotBbsInfoTotalCounter=0;
		
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		hotBbsInfoTotalCounter=bbsInfoManageDAOBean.getHotBBSInfoTotalCounter(totalHits);
		
		return hotBbsInfoTotalCounter;
	}
	public int doGetTotalBBSInfoCounter() throws WebBBSException 
	{
		int bbsInfoTotalCounter=0;