news.java

JAVA邮件系统

import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
public class news{
	Integer m_NewsId;//新闻编号
	String  m_NewsShortTitle=new String ();//新闻短标题
	String  m_NewsKeyWord=new String ();//新闻关键字
	String  m_NewsAbstract=new String ();//新闻摘要
	String  m_NewsChannel = new String ();//新闻频道
	String  m_NewsTopic = new String ();//新闻栏目
	String  m_NewsSingleUrl=new String();//新闻栏目链接
	int m_NewsCount;//某一新闻频道下新闻的栏目数
   news()
	{
       m_NewsShortTitle="";
	   m_NewsKeyWord="";
       m_NewsAbstract="";
	   m_NewsChannel="";
       m_NewsTopic="";
	   m_NewsCount=0;
	   m_NewsSingleUrl="";
   }
   public void  setNewsId(Integer nNewsId){
	   m_NewsId=nNewsId;
   }
   public void  setNewsShortTitle(String sNewsShortTitle){
       m_NewsShortTitle=sNewsShortTitle;
   }
   //设置新闻频道
   public void setNewsChannel(String sNewsChannel){
       m_NewsChannel=sNewsChannel;
   }
   //设置新闻栏目
   public void setNewsTopic(String sNewsTopic){
	   m_NewsTopic=sNewsTopic;
   }
   public Integer getNewsid(){
       return m_NewsId;
   }
   public String getNewsShortTitle(){
	   return m_NewsShortTitle;
   }
   public String getNewsChannel(){
	   return m_NewsChannel;
   }
   public String getNewsTopic(String sCateid){
	   if ((sCateid==null)&&(sCateid.trim ().length() !=8))
	   {
		   return null;
	   }
		DBOperater DB = new DBOperater ("category");
		ResultSet rs = DB.executeQuery ("select name from category where cateid='"+sCateid+"'");
		if(rs!=null){
		try{
			if( rs.next () )
				m_NewsTopic = rs.getString  (1);
			}
			catch(Exception e){
				DB.close ();
				return null;	
				}
			}
			DB.close ();
		return m_NewsTopic;
   }
   public String getCateName(String sCateid){
	   String sCateName=new String ();
		if ((sCateid==null)||(sCateid.trim ().length ()!=8))
			return null;
		DBOperater DB=new DBOperater ("category");
		ResultSet rs=DB.executeQuery ("select name from category where cateid='"+sCateid+"'");
		if(rs!=null){
			try{
				if (rs.next ())
					sCateName=rs.getString (1);
			}catch(Exception e){
				DB.close ();
				return null;
			}
		}
		DB.close ();
		return sCateName;
   }
   public int getNewCount(String sNewsTopic){
	    if ((sNewsTopic==null)||(sNewsTopic.trim ().length() <1))
			return 0;
		sNewsTopic=sNewsTopic.trim ()+"%";
		DBOperater DB = new DBOperater ("category");
		ResultSet rs = DB.executeQuery ("select count(*) from category where lmdm like'"+sNewsTopic+"' and folder ='T'");
		if(rs!=null){
		try{
			 if( rs.next () )
				m_NewsCount=rs.getInt (1);
	    }
		catch(Exception e){
			DB.close ();
		}
		}
	DB.close ();
	return m_NewsCount;
   }
   public String getNewsCateName(String sLmDm){
	   String sNewsCateName=new String ();
		if ((sLmDm==null)||(sLmDm.trim ().length ()<1))
			return null;
		DBOperater DB = new DBOperater ("userchannel");
		ResultSet rs = DB.executeQuery ("select name from category where lmdm ='"+sLmDm+"' or cateid ='"+sLmDm+"'");
		if(rs!=null){
		try{
			 if( rs.next () )
				sNewsCateName=rs.getString  (1);
	    }
		catch(Exception e){
		}
		}

		DB.close ();
		return sNewsCateName;
   }
 /*  public String showSingleNews(String sNewsCategory,Integer nNewsId){
		String sPathName=new String ();
		String sFileName=new String ();
	    if ((sNewsCategory==null)||(sNewsCategory.trim ()=="")){
			return null;
		}
        sPathName=CommonMethods.sHtmlPath +sNewsCategory;
		File fSingleNewsPath=new File (sPathName);
		if (!fSingleNewsPath.exists() || !fSingleNewsPath.isDirectory() )
		{  	try{
				 fSingleNewsPath.mkdirs();
			}catch(Exception e){
			return null;
			}
		}
	    sFileName=sPathName+"/p"+nNewsId+".htm";
		File  fSingleNewsFile=new File (sFileName);
		String sNewsShortTitle=new String ();
		String sNewsAbstract=new String ();
		String sNewsMakeTime=new String ();
		String sNewsFrom=new String ();
		/////////////////////////////
		DBOperater DB = new DBOperater ("news");
		ResultSet rs = DB.executeQuery ("select abstract,make,status,shorttitle from news where newsid="+nNewsId);
		if(rs!=null){
		try{
		if( rs.next () )
			sNewsAbstract=rs.getString ("abstract");
		    sNewsMakeTime=rs.getString  ("make");
			sNewsFrom=rs.getString ("status");
			sNewsShortTitle=rs.getString ("shorttitle");
		}
		catch(Exception e){
			}
		 }
		DB.close ();
		if (sNewsAbstract==null)
			sNewsAbstract="";
		if (sNewsShortTitle==null)
			sNewsShortTitle="";
		if ((sNewsAbstract.trim()=="")||(sNewsShortTitle.trim()==""))
			{
			return null;
			}
		if ((sNewsFrom==null)||(sNewsFrom.trim ()==""))
			sNewsFrom="";
		else
			sNewsFrom="摘自《"+sNewsFrom.trim ()+"》";
			sNewsMakeTime=sNewsMakeTime.substring(0,16);
			////////////////////////////
			sNewsAbstract=CommonMethods.DealWithSQLParameter (sNewsAbstract);
			sNewsShortTitle=CommonMethods.DealWithSQLParameter  (sNewsShortTitle);
			sNewsFrom=CommonMethods.DealWithSQLParameter  (sNewsFrom);
			TemplateList tempList=CommonMethods.getSingleNewsTemplate   ();
			SingleTemplate st;
			st = tempList.searchTemplate ("ROOT");
			if(st==null)
			{
			return null;
			}
			int nKey = st.getKeyNum ();
			String sNewsSingle="";
			String sKey= new String ();
			for(int i=0;i<nKey;i++){
				sNewsSingle+=st.getStringAt (i);
				sKey = st.getKeyAt (i);
				if( sKey.compareTo("cgi-path")==0 )
					desHtml.addString (CommonMethods.sHostNameCGI);
				if( sKey.compareTo("短标题")==0 )
					sNewsSingle+=sNewsShortTitle;
				if ( sKey.compareTo("摘要")==0)
					sNewsSingle+=sNewsAbstract;
				if (sKey.compareTo ("摘自")==0)
					sNewsSingle+=sNewsFrom;
				if (sKey.compareTo ("时间")==0)
					sNewsSingle+=sNewsMakeTime;
			}
			sNewsSingle+=st.getEndString();
			int fileLength;
			fileLength=sNewsSingle.length();
			byte[] b1=new byte[fileLength];
			b1=sNewsSingle.getBytes ();
			CommonMethods.WriteToDisk (b1,sFileName);
			m_NewsSingleUrl=CommonMethods.sWebRoot   +sNewsCategory+"/p"+nNewsId+".htm";
			return m_NewsSingleUrl;
   }*/
   public String showNewsTitle(String sCateId,int count){
	   String sResultNewsTilte="";
	   if ((sCateId==null)||(sCateId.trim ().length ()!=8))
	   {
		   return null;
	   }
	   ////////////////////////////////////////////
	   TemplateList tempList=new TemplateList ();
	//根据输入的新闻频道名称得不同的模板
	   tempList= CommonMethods.getShowTitleTemplate ();	
	   SingleTemplate st;
	   st = tempList.searchTemplate ("ROOT");
	   String sNewsShortTitle=new String ();
	   String sNewsId=new String ();
	   String sKey=new String ();
	   Calendar  dMakeTime=Calendar.getInstance ();
	   
	   if(st==null)
		{
			  return null;
		}
	    DBOperater DB=new DBOperater ("news");
		ResultSet rs=DB.executeQuery ("select newsid ,abstract,make,shorttitle from news where cateid='"+sCateId+"' ORDER by make DESC");
	    sResultNewsTilte+="<ul>";
		int nKey=st.getKeyNum ();
		String sAbstract=new String();
		int k=1;
		if (rs!=null){
			try{
				while(rs.next ()){
					if( k>count)
						break;
					try{
						sNewsId=rs.getString (1);
						sAbstract=rs.getString (2);
						dMakeTime.setTime(rs.getTimestamp(3));
						sNewsShortTitle=rs.getString (4);
					}
					catch(Exception e ){
					    continue;
					}
					if((sNewsShortTitle!=null)&&(sNewsShortTitle.trim ().length ()>1)&&(sAbstract!=null)&&(sAbstract.trim ().length ()>1))
					{
						for(int i=0;i<nKey;i++){
						sResultNewsTilte+=st.getStringAt (i);
						sKey = st.getKeyAt (i);
						
						if( sKey.compareTo("cgi-path")==0 )
							sResultNewsTilte+= (CommonMethods.sHostNameCGI);
						if (sKey.compareTo ("新闻标题")==0)
							sResultNewsTilte+=sNewsShortTitle;
						if (sKey.compareTo ("单条新闻")==0)
						{
							sResultNewsTilte+="SingleNews?id=";
							sResultNewsTilte+=sNewsId;
							sResultNewsTilte+="&cateid=";
							sResultNewsTilte+=sCateId;
						}
						if (sKey.compareTo ("时间")==0)
						{
						    int nDay=0;
							int nHour=0;
							int nMinute=0;
							nDay=dMakeTime.get (dMakeTime.DATE );
							nHour=dMakeTime.get(dMakeTime.HOUR_OF_DAY  );
							nMinute=dMakeTime.get(dMakeTime.MINUTE );
							sResultNewsTilte+=nDay;
							sResultNewsTilte+="日";
							if (nHour>=10)
								sResultNewsTilte+=nHour;
							else
							{
								sResultNewsTilte+="0";
								sResultNewsTilte+=nHour;
							}
							sResultNewsTilte+=":";
							if (nMinute>=10)
								sResultNewsTilte+=nMinute;
							else
							{
								sResultNewsTilte+="0";
								sResultNewsTilte+=nMinute;
							}
							
						}
					}
						 k++;
						 sResultNewsTilte+=st.getEndString();
					}
				   
				
				}
			}catch(Exception e){
				DB.close ();
				return null;
			}
		
		}
		sResultNewsTilte+="</ul>";
		DB.close ();
	   ///////////////////////////////////////////
	   
	   return sResultNewsTilte;
   }
   public String showNewsChannel(String sCategory,int maxNum){
	    String sNewsChannelResult="";
		if (maxNum==0)
			maxNum=5;
		if ((sCategory==null)||(sCategory.trim ()==""))
		{
			return null;
		}
		TemplateList tempList=new TemplateList ();
		//根据输入的新闻频道名称得不同的模板
		if (sCategory.trim ().compareTo ("要闻类")==0)
			tempList=CommonMethods.getImportNewsTemplate ();
			SingleTemplate st;
			st = tempList.searchTemplate ("ROOT");
			if(st==null)
			{
				  return null;
		
			}
			int nKey = st.getKeyNum ();
			String sKey= new String ();
			String sCateid=new String ();
			String sAbstract=new String ();
			for(int i=0;i<nKey;i++){
				sNewsChannelResult+=st.getStringAt (i);
				sKey = st.getKeyAt (i);
				DBOperater DB = new DBOperater ("category");
				ResultSet rs = DB.executeQuery ("select cateid from category where name='"+sKey+"'");
				if(rs!=null){
				try{
				if( rs.next () )
					sCateid=rs.getString ("cateid");
				}
				catch(Exception e){
				}
				}
				DB.close ();
				if ((sCateid!=null)&&(sCateid.trim().length ()>=1))
				{
					DBOperater DB1=new DBOperater ("news");
					ResultSet rs1=DB1.executeQuery ("select newsid,abstract,shorttitle from news where cateid='"+sCateid+"' ORDER BY  make DESC");
					if(rs1!=null){
						try{
							SingleTemplate st1;
							st1=tempList.searchTemplate ("新闻栏目");
							if (st1==null){
								return null;
							}
							int nKey1=st1.getKeyNum ();
							String sKey1=new String ();
							int nNewsId;
							String sNewsShortTitle= new String ();
							String sTitle="";
							int k=1;
							while(rs1.next ())
							{   
								if (k>maxNum)
									break;
								nNewsId=rs1.getInt (1);
								sAbstract=rs1.getString (2);
								sNewsShortTitle=rs1.getString (3);
								if ((sNewsShortTitle!=null)&&(sNewsShortTitle.trim ().length() >1)&&(sAbstract!=null)&&(sAbstract.trim ().length ()>=1))
								{
									for (int j=0;j<nKey1;j++)
									{
										sNewsChannelResult+=st1.getStringAt (j);
										sKey1 = st1.getKeyAt (j);
										sTitle="";
										sTitle+="<a href=SingleNews?id=";
										sTitle+=nNewsId;
										sTitle+="&cateid=";
										sTitle+=sCateid;
										sTitle+=">";
										sTitle+=sNewsShortTitle;
										sTitle+="</a>";
										if( sKey1.compareTo("cgi-path")==0 )
											sNewsChannelResult+= (CommonMethods.sHostNameCGI);
										if (sKey1.compareTo ("新闻标题")==0)
											sNewsChannelResult+=sTitle;
										sNewsChannelResult+=st1.getEndString ();
									}//end for
									k++;
								}//end if
								
							}//end while
						}//end try
						catch(Exception e){
						}
					}	
					DB1.close ();
				}
			}
			sNewsChannelResult+=st.getEndString();
			return sNewsChannelResult;
	   }
   
      public String showJrzxTitle(String sCateId,int count){
	   String sResultNewsTilte="";
	   if ((sCateId==null)||(sCateId.trim ().length ()!=8))
	   {
		   return null;
	   }
	   ////////////////////////////////////////////
	   TemplateList tempList=new TemplateList ();
	//根据输入的新闻频道名称得不同的模板
	   tempList= CommonMethods.getJrzxTitleTemplate  ();	
	   SingleTemplate st;
	   st = tempList.searchTemplate ("ROOT");
	   String sNewsShortTitle=new String ();
	   String sNewsId=new String ();
	   String sKey=new String ();
	   Calendar  dMakeTime=Calendar.getInstance ();
	   if(st==null)
		{
			  return null;
		}
	    DBOperater DB=new DBOperater ("news");
		ResultSet rs=DB.executeQuery ("select newsid ,abstract,make,shorttitle from news where cateid='"+sCateId+"' ORDER by make DESC");
	    //sResultNewsTilte+="<ul>";
		int nKey=st.getKeyNum ();
		String sAbstract=new String();
		int k=1;
		if (rs!=null){
			try{
				while(rs.next ()){
					if( k>count)
						break;
					try{
						sNewsId=rs.getString (1);
						sAbstract=rs.getString (2);
						dMakeTime.setTime(rs.getTimestamp(3));				
						sNewsShortTitle=rs.getString (4);
					}
					catch(Exception e ){
					    continue;
					}
					if((sNewsShortTitle!=null)&&(sNewsShortTitle.trim ().length ()>1)&&(sAbstract!=null)&&(sAbstract.trim ().length ()>1))
					{
						for(int i=0;i<nKey;i++){
						sResultNewsTilte+=st.getStringAt (i);
						sKey = st.getKeyAt (i);
						if( sKey.compareTo("cgi-path")==0 )
							sResultNewsTilte+= (CommonMethods.sHostNameCGI);
						if (sKey.compareTo ("新闻标题")==0)
							sResultNewsTilte+=sNewsShortTitle;
						if (sKey.compareTo ("单条新闻")==0)
						{
							sResultNewsTilte+="SingleNews?id=";
							sResultNewsTilte+=sNewsId;
							sResultNewsTilte+="&cateid=";
							sResultNewsTilte+=sCateId;
						}
					   if (sKey.compareTo ("时间")==0)
						{
						    int nDay=0;
							int nHour=0;
							int nMinute=0;
							nDay=dMakeTime.get(dMakeTime.DATE );
							nHour=dMakeTime.get(dMakeTime.HOUR_OF_DAY );
							nMinute=dMakeTime.get(dMakeTime.MINUTE );
							sResultNewsTilte+=nDay;
							sResultNewsTilte+="日";
							if (nHour>=10)
								sResultNewsTilte+=nHour;
							else
							{
								sResultNewsTilte+="0";
								sResultNewsTilte+=nHour;
							}
							sResultNewsTilte+=":";
							if (nMinute>=10)
								sResultNewsTilte+=nMinute;
							else
							{
								sResultNewsTilte+="0";
								sResultNewsTilte+=nMinute;
							}
						
					   }				
						
					}
						 k++;
						 sResultNewsTilte+=st.getEndString();
					}
				   
				
				}
			}catch(Exception e){
				DB.close ();
				return null;
			}
		
		}
		//sResultNewsTilte+="</ul>";
		DB.close ();
	   ///////////////////////////////////////////
	   
	   return sResultNewsTilte;
   }
}