news.java

新闻管理系统,使用Struts框架编写. 系统包括前端页面和后端管理页面

	    		s[2] = s[0];
	    	}
	    	if(OK)
	    	{	
		    	String NowTime = (new java.util.Date()).toLocaleString();
		    	String [] sLog = new String[5];
		    	String sql = "insert into News (NewsTitle,NewsContent,NewsKey,NewsAuthor,";
		    	sql += "NewsFrom,NewsTime,NewsPicture,BigClassID,SmallClassID,";
				sql += "IsHead,HeadPicture,IsImg,IsHot,SpecialID,NewsInfo,AdminName) values (";
				sql += "'" + s[0] + "',";
				sql += "'" + s[1] + "',";
				sql += "'" + s[2] + "',";
				sql += "'" + s[3] + "',";
				sql += "'" + s[4] + "',";
				sql += "'" + s[5] + "',";
				sql += "'" + s[6] + "',";
				sql += Fun.StrToInt(s[7]) + ",";
				sql += Fun.StrToInt(s[8]) + ",";
				sql += "'" + s[9] + "',";
				sql += "'" + s[10] + "',";
				sql += "'" + s[11] + "',";
				sql += "'" + s[12] + "',";
				sql += Fun.StrToInt(s[13]) + ",";
				sql += "'" + s[14] + "',";
				sql += "'" + s1    + "')";
				//out.println(sql);
				String sql1= "update Admin set NewsNum=NewsNum+1 where AdminName='" + Fun.CheckReplace(s1) + "'";
				try{
					Conn.setAutoCommit(false);
					stmt.executeUpdate(sql);
					stmt.executeUpdate(sql1);
					Conn.commit();
					Conn.setAutoCommit(true);
					stmt.close();
					Conn.close();
			    	sLog[0] = s1;
			    	sLog[1] = "添加新闻[" + s[0] + "]";
			    	sLog[2] = NowTime;
			    	sLog[3] = s2; 
			    	sLog[4] = "Yes";
			    	Fun.AddLog(sLog);
					stmt.close();
					Conn.close();
			    	return "Yes";
			    }catch (Exception e) {
						Conn.rollback();		//回滚JDBC事务
						e.printStackTrace();
						Conn.close();
						return "事务操作失败!";
						}  
		    }
		    else return sError;
	    }catch(Exception e)
        {
            e.printStackTrace();
            //System.out.print(e.getMessage());
            return "添加新闻操作失败!";
        }
     }
    
    
    
    /*********************************************************
	* 函数名:EditNews
	* 作  用:修改新闻
	* 参  数:字符串数组，添加新闻的各项参数
	*         s0:新闻ID,s1:管理员;s2:IP地址
	* 返回值:字符串型。返回操作结果的信息
	***********************************************************/
    public String EditNews(String [] s,String s0,String s1,String s2)
    {			
		try
    	{
	    	boolean OK = true;
    		Connection Conn = DBConn.getConn();
	    	Statement stmt = Conn.createStatement(1004,1007);
	    	ResultSet rs = null;
    		String sError = "";
	    	for(int i=0;i<s.length;i++)
	    	{
	    		s[i] = Fun.getStrCN(Fun.CheckReplace(s[i]));
	    	}
	    	String [] sa1 = new String [4];
	    	String [] sa2 = new String [4];
	    	sa1[0] = s[0];
	    	sa1[1] = s[3];
	    	sa1[2] = s[4];
	    	sa1[3] = s[1];
	    	sa2[0] = "新闻标题";
	    	sa2[1] = "新闻发布人";
	    	sa2[2] = "新闻出处";
	    	sa2[3] = "新闻内容";
	    	int NewsID = Fun.StrToInt(s0);
	    	if (NewsID==0)
	    	{
	    		OK = false;
	    		sError = "新闻ID参数传递错误，请重试!"; 
	    	}
	    	
	    	if(!s[13].equals(""))
	    	{
	    		s[7]="0";
	    		s[8]="0";
	    	}
	    	else
	    	{
	    		if(s[7].equals("") || s[8].equals(""))
	    		{
	    			OK = false;
	    			sError="新闻类别和专题不能同时为空";
	    		}
	    	}
	    	
	    	String sOK = Fun.CheckDate(sa1,sa2);
	    	if (!sOK.equals("Yes"))
	    	{
	    		OK = false;
	    		sError = sOK; 
	    	}
	    	if(s[14].length()>120) s[14]=s[14].substring(0,120);
	    	if (s[2].equals("") || s[2].equals(" "))
	    	{
	    		s[2] = s[0];
	    	}
	    	if(OK)
	    	{	
		    	String NowTime = (new java.util.Date()).toLocaleString();
		    	String [] sLog = new String[5];
		    	String sql = "update News set ";
	    		sql += "NewsTitle='"   + s[0] + "',";
	    		sql += "NewsContent='" + s[1] + "',";
	    		sql += "NewsKey='"     + s[2] + "',";
	    		sql += "NewsAuthor='"  + s[3] + "',";
	    		sql += "NewsFrom='"    + s[4] + "',";
	    		sql += "NewsTime='"    + s[5] + "',";
	    		sql += "NewsPicture='" + s[6] + "',";
	    		sql += "BigClassID="   + Fun.StrToInt(s[7]) + ",";
	    		sql += "SmallClassID=" + Fun.StrToInt(s[8]) + ",";
	    		sql += "IsHead='"      + s[9] + "',";
	    		sql += "HeadPicture='" + s[10]+ "',";
	    		sql += "IsImg='"       + s[11]+ "',";
	    		sql += "IsHot='"   + s[12]+ "',";
	    		sql += "SpecialID="   + Fun.StrToInt(s[13]) + ",";
	    		sql += "NewsInfo='"   + s[14]+ "'";
	    		sql += " where NewsID="+ NewsID;
				stmt.executeUpdate(sql);
				stmt.close();
				Conn.close();
		    	sLog[0] = s1;
		    	sLog[1] = "修改ID为[" + NewsID + "]的新闻";
		    	sLog[2] = NowTime;
		    	sLog[3] = s2; 
		    	sLog[4] = "Yes";
		    	Fun.AddLog(sLog);
				stmt.close();
				Conn.close();
		    	return "Yes";
		    }
		    else return sError;
	    }catch(Exception e)
        {
            e.printStackTrace();
            System.out.print(e.getMessage());
            return "修改新闻操作失败!";
        }
     }
    
    
    /*********************************************************
	* 函数名：DelNews
	* 作  用：删除新闻
	* 参  数：s0:新闻ID；s1:管理员；s2:IP
	* 返回值：成功　true ，否则返回　false
	***********************************************************/ 
	public boolean DelNews(String s0,String s1,String s2)
    {
    	String NowTime = (new java.util.Date()).toLocaleString();
		String [] sLog = new String[5];
		sLog[0] = s1;
		sLog[2] = NowTime;
		sLog[3] = s2; 
    	try{
	    	Connection Conn = DBConn.getConn();
	    	Statement stmt = Conn.createStatement();
	    	int NewsID = Fun.StrToInt(s0);
	    	if (NewsID==0)
	    		return false;
	    	else
	    	{
			  try{
			    	String sql = "delete from News where NewsID=" + NewsID;
			    	String sql1= "update Admin set NewsNum=NewsNum-1 where AdminName='" + Fun.CheckReplace(s1) + "'";
			    	Conn.setAutoCommit(false);
			    	stmt.executeUpdate(sql);
			    	stmt.executeUpdate(sql1);
			    	Conn.commit();
			    	Conn.setAutoCommit(true);
			    	sLog[1] = "删除ID为[" + s0 + "]的新闻";
			    	sLog[4] = "Yes";
			    	Fun.AddLog(sLog);
					stmt.close();
					Conn.close();
			    	return true;
		    	}catch (Exception e) {
						Conn.rollback();		//回滚JDBC事务
						////e.printStackTrace();
						Conn.close();
						return false;
						}  
		    }
    	}catch(Exception e){
    		//e.printStackTrace();
    		System.out.print(e.getMessage());
    		//System.out.print(sql);
    		sLog[1] = "删除新闻[" + s0 + "]出错";
	    	sLog[4] = "No";
	    	Fun.AddLog(sLog);
    		return false;
    	}
	
	}
    
    
    
    
    //测试
	public static void main(String[] args)
	{	
		News n1 = new News();
		String [] as = n1.ReadNews("1");
		//System.out.println(n1.ListNews("ListNews.jsp","1"));
		for(int i=0;i<as.length;i++)
		{
			System.out.println(as[i]);		
		}
	}
}