bbsinfomanageimple.java

hibernate项目实践

//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		bbsInfoTotalCounter=bbsInfoManageDAOBean.getBBSInfoTotalCounter();		
		return bbsInfoTotalCounter;
	}
	public int doGetTotalBBSTitleInfoCounter() throws WebBBSException
	{
		int bbsTitleInfoTotalCounter=0;
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		bbsTitleInfoTotalCounter=bbsTitleInfoManageDAOBean.getBBSTitleInfoTotalCounter();
		
		return bbsTitleInfoTotalCounter;
	}
	public boolean doSaveBBSInfo(BBSInfoVO oneBBSInfoVO) throws WebBBSException 
	{
		boolean OKOrNot=false;
	    BBSInfoPO oneBBSInfoPO=new BBSInfoPO();
	    String bbsAuthor=oneBBSInfoVO.getAuthor();
    
//	    oneBBSInfoPO.setId(oneBBSInfoVO.getBbsID());					//本语句只在JDBC的环境下使用 
	    oneBBSInfoPO.setAuthor(bbsAuthor);
	    oneBBSInfoPO.setTitle(oneBBSInfoVO.getTitle());
	    oneBBSInfoPO.setReplay(oneBBSInfoVO.getReplay());
	    oneBBSInfoPO.setHits(oneBBSInfoVO.getHits());

	    oneBBSInfoPO.setSendInfoTime(oneBBSInfoVO.getSendInfoTime());
	    
	    oneBBSInfoPO.setContent(oneBBSInfoVO.getContent());
	    oneBBSInfoPO.setMailto(oneBBSInfoVO.getMailto());
	    oneBBSInfoPO.setAbstractText(oneBBSInfoVO.getAbstractText());

	    oneBBSInfoPO.setLastUpdateTime(oneBBSInfoVO.getLastUpdateTime());

	    oneBBSInfoPO.setBbsIconID(oneBBSInfoVO.getBbsIconID());
	    oneBBSInfoPO.setBbsTypeID(oneBBSInfoVO.getBbsTypeID());

	    int bbsTitleID=oneBBSInfoVO.getBbsTitleID();
	    oneBBSInfoPO.setBbsTitleID(bbsTitleID);
	    String bbsUserID=oneBBSInfoVO.getUserID();
	    oneBBSInfoPO.setUserID(bbsUserID);

//	    bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
	    OKOrNot=bbsInfoManageDAOBean.insertBBSInfo(oneBBSInfoPO);

//	下面的代码是根据bbsTitleID来更新BBTitle中的 totalTopicNumber计数
	    bbsTitleInfoManageDAOBean.updateBBTitleCounterByBbsTitleID(bbsTitleID,bbsUserID,bbsAuthor);

	    return OKOrNot;		
	}
    public boolean doUpdateBBSInfoHits(int bbsID) throws  WebBBSException
    {
    	boolean OKOrNot=false;
    	
//    	bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
    	OKOrNot=bbsInfoManageDAOBean.updateBBSInfoHitsByBbsID(bbsID);
    	return OKOrNot;
    }
	public boolean doSaveBBSReplyInfo(BBSReplyInfoVO oneBBSReplyInfoVO)	throws WebBBSException 
	{
		boolean OKOrNot=false;
		BBSReplyInfoPO   oneBBSReplyInfoPO=null;
		
		oneBBSReplyInfoPO=new BBSReplyInfoPO();
		
//		oneBBSReplyInfoPO.setId(oneBBSReplyInfoVO.getReplyID());		//本语句只在JDBC的环境下使用
		oneBBSReplyInfoPO.setBbsID(oneBBSReplyInfoVO.getBbsID());
		oneBBSReplyInfoPO.setAuthor(oneBBSReplyInfoVO.getAuthor());
		oneBBSReplyInfoPO.setContent(oneBBSReplyInfoVO.getContent());		  
		oneBBSReplyInfoPO.setReplytime(oneBBSReplyInfoVO.getReplytime());
		oneBBSReplyInfoPO.setAbstractText(oneBBSReplyInfoVO.getAbstractText());		  
		oneBBSReplyInfoPO.setReplyTitle(oneBBSReplyInfoVO.getReplyTitle());		  
		oneBBSReplyInfoPO.setBbsReplyIconID(oneBBSReplyInfoVO.getBbsReplyIconID());		  
		  
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		OKOrNot=bbsReplyInfoManageDAOBean.insertBBSReplyInfo(oneBBSReplyInfoPO);
		
//		下面的代码是根据BbsID来更新BBS表中的 replay计数
		
	    bbsInfoManageDAOBean.updateBBSReplyCounterByBBSID(oneBBSReplyInfoVO.getBbsID());		
		return OKOrNot;	
	}

	public ArrayList doSeacherBBSInfo(String searchKind, String keyText)	throws WebBBSException 
	{
	    ArrayList allSearchResultBBSInfoPOArrayList=null;
	    ArrayList allSearchResultBBSInfoVOArrayList=null;
	    BBSInfoPO oneBBSInfoPO=null;
	    BBSInfoVO oneBBSInfoVO=null;
	    String hqlSelect="";
	    
	    allSearchResultBBSInfoVOArrayList=new ArrayList();
//	    bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
	    switch(Integer.parseInt(searchKind))
	    {
	    	case 1:				// 留言作者
	    		allSearchResultBBSInfoPOArrayList=bbsInfoManageDAOBean.selectBBSInfoByBBSAuthor(keyText);
	    		break;
	    	case 2:				// 留言标题
	    		allSearchResultBBSInfoPOArrayList=bbsInfoManageDAOBean.selectBBSInfoByBBSTitle(keyText);
	    		break;
	    	case 3:				// 留言时间
	    		allSearchResultBBSInfoPOArrayList=bbsInfoManageDAOBean.selectBBSInfoByBBSSendInfoTime(keyText);
	    		break;
	    }
		    
	    Iterator allBBSInfoPOIteratorItem=allSearchResultBBSInfoPOArrayList.iterator();
	    while(allBBSInfoPOIteratorItem.hasNext())
	    { //下面的代码实现将PO（BBSInfo）--->VO（BBSInfoVO）
	      oneBBSInfoPO = (BBSInfoPO) allBBSInfoPOIteratorItem.next();
	      oneBBSInfoVO = new BBSInfoVO();

	      oneBBSInfoVO.setAuthor(oneBBSInfoPO.getAuthor());
	      oneBBSInfoVO.setTitle(oneBBSInfoPO.getTitle());
	      oneBBSInfoVO.setReplay(oneBBSInfoPO.getReplay());
	      oneBBSInfoVO.setHits(oneBBSInfoPO.getHits());
	      oneBBSInfoVO.setSendInfoTime(oneBBSInfoPO.getSendInfoTime());
	      oneBBSInfoVO.setMailto(oneBBSInfoPO.getMailto());
 /*
 * 注意：由于在“在线编辑器”中已经将字符进行转换，所以不再需要进行转换		
   	     oneBBSInfoVO.setContent(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getContent()));
   	     oneBBSInfoVO.setAbstractText(TransferSpecialCharToHTMLEntity.FilterCharToHTMLEntity(oneBBSInfoPO.getAbstractText()));
*/
	      oneBBSInfoVO.setContent(oneBBSInfoPO.getContent());
	      oneBBSInfoVO.setAbstractText(oneBBSInfoPO.getAbstractText());
  
	     
	      oneBBSInfoVO.setLastUpdateTime(oneBBSInfoPO.getLastUpdateTime());
	      oneBBSInfoVO.setBbsIconID(oneBBSInfoPO.getBbsIconID());
	      oneBBSInfoVO.setBbsTypeID(oneBBSInfoPO.getBbsTypeID());
	      oneBBSInfoVO.setBbsTitleID(oneBBSInfoPO.getBbsTitleID());
	      oneBBSInfoVO.setUserID(oneBBSInfoPO.getUserID());
	      oneBBSInfoVO.setBbsID(oneBBSInfoPO.getId().intValue());

//			下面的代码实现将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);			

	      allSearchResultBBSInfoVOArrayList.add(oneBBSInfoVO);
	    }
	    return allSearchResultBBSInfoVOArrayList;  //此时在ArrayList中将包含有BBSInfoVO类型的对象雃合
	}
	public ArrayList doGetTodayAllBBSInfo() throws WebBBSException
	{
		String keyText = "";
		ArrayList newBBSInfoList = null;
	    java.util.Date rightNow = new java.util.Date();
		keyText = (1900 + rightNow.getYear()) + "-" + (rightNow.getMonth() + 1) +
												"-" + rightNow.getDate();
		String searchKind="3";			//"3"代表按照时间搜索
		newBBSInfoList=doSeacherBBSInfo(searchKind, keyText); 
		
		return newBBSInfoList;		
	}
    public ArrayList doGetTodayAllBBSInfo(int firstResult,int maxResults) throws WebBBSException
    {
    	
		ArrayList allBBSInfoVOList=null;
		ArrayList allBBSInfoPOList=null;
		Iterator allBBSInfoPOItem=null;
		
		allBBSInfoVOList=new ArrayList();
//		bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple();
		allBBSInfoPOList=bbsInfoManageDAOBean.selectPageBBSInfoByToday(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 doGetTodayAllBBSInfoCount() throws WebBBSException
	{
    	int totalBBSCounter=0;
    	String todayDate = "";
    	
    	java.util.Date rightNow = new java.util.Date();
    	todayDate = (1900 + rightNow.getYear()) + "-" + (rightNow.getMonth() + 1) +
		"-" + rightNow.getDate();
//    	bbsInfoManageDAOBean=new BBSInfoManageDAOJDBCImple(); 
    	totalBBSCounter=bbsInfoManageDAOBean.getBBSInfoCounterBySendTime(todayDate);
		return totalBBSCounter;
	}
	public boolean doUpdateBBSInfo(BBSInfoVO oneBBSInfoVO)		throws WebBBSException 
	{
		BBSInfoPO oneUpdatedBBSInfoPO=new BBSInfoPO();
		
		oneUpdatedBBSInfoPO.setId(oneBBSInfoVO.getBbsID());		
		oneUpdatedBBSInfoPO.setAuthor(oneBBSInfoVO.getAuthor());
		oneUpdatedBBSInfoPO.setTitle(oneBBSInfoVO.getTitle());
		oneUpdatedBBSInfoPO.setReplay(oneBBSInfoVO.getReplay());
		oneUpdatedBBSInfoPO.setHits(oneBBSInfoVO.getHits());

	    oneUpdatedBBSInfoPO.setSendInfoTime(oneBBSInfoVO.getSendInfoTime());

	    oneUpdatedBBSInfoPO.setContent(oneBBSInfoVO.getContent());
	    oneUpdatedBBSInfoPO.setMailto(oneBBSInfoVO.getMailto());
	    oneUpdatedBBSInfoPO.setAbstractText(oneBBSInfoVO.getAbstractText());

	    oneUpdatedBBSInfoPO.setLastUpdateTime(oneBBSInfoVO.getLastUpdateTime());

	    oneUpdatedBBSInfoPO.setBbsIconID(oneBBSInfoVO.getBbsIconID());
	    oneUpdatedBBSInfoPO.setBbsTypeID(oneBBSInfoVO.getBbsTypeID());

	    oneUpdatedBBSInfoPO.setBbsTitleID(oneBBSInfoVO.getBbsTitleID());
	    oneUpdatedBBSInfoPO.setUserID(oneBBSInfoVO.getUserID());
		
	    return bbsInfoManageDAOBean.updateBBSInfo(oneUpdatedBBSInfoPO);
	}

	public void setBbsInfoManageDAOBean(
			BBSInfoManageDAOInterface bbsInfoManageDAOBean) {
		this.bbsInfoManageDAOBean = bbsInfoManageDAOBean;
	}

	public void setBbsReplyInfoManageDAOBean(
			BBSReplyInfoManageDAOInterface bbsReplyInfoManageDAOBean) {
		this.bbsReplyInfoManageDAOBean = bbsReplyInfoManageDAOBean;
	}

	public void setBbsTitleInfoManageDAOBean(
			BBSTitleInfoManageDAOInterface bbsTitleInfoManageDAOBean) {
		this.bbsTitleInfoManageDAOBean = bbsTitleInfoManageDAOBean;
	}

}