news.java

新闻发布系统,一个提供新闻发布,图片上传,和显示的系统,用jsp写的

/***************************************************
 *  
 *  源文件名:  News.java
 *  功    能： 梦想年华新闻系统 - 新闻管理类
 *	作者：梦想年华 [DreamTime]
 *	Email:[e-mail]
 *  QQ:122142023 
 * 	CopyRight(c)2005-2006 by DreamTime 
 *
 ****************************************************
*/


package dreamtime.dreamnews;			//指定类所在的包

import java.sql.*;
import dreamtime.dreamnews.Function;
import dreamtime.dreamnews.DBConnection;

public class News
{

    DBConnection DBConn = new DBConnection();
    Function Fun = new Function(); 
    
    public News()
    {
    	
    } 
    
    
    /*********************************************************
	* 函数名：ReadNews
	* 作  用：读取类别信息
	* 参  数：s0:新闻ID
	* 返回值：字符串数组型。类别的各项信息
	***********************************************************/
    public String[] ReadNews(String s0)
    {
    	try
    	{	
	    	Connection Conn = DBConn.getConn(); 
		    Statement stmt = Conn.createStatement(1004,1007);
		    ResultSet rs = null;
		    String sql = null;
		    int NewsID = Fun.StrToInt(s0);
		    String [] s = new String[16];
	    	if (NewsID==0)
	    		return null;
	    	else
	    	{
		    	sql = "select * from News where NewsID=" + NewsID;
			    rs = stmt.executeQuery(sql);
			    rs.next();
			    for (int i=0;i<s.length;i++)
			    {
				    s[i] = rs.getString(i+2);
			    }
			 	rs.close();
			    stmt.close();
			    Conn.close();
			    return s;
			 }
		 }catch(Exception e){
		 	//e.printStackTrace();
		 	return null;
		 }
	}
    
     
    /*********************************************************
	* 函数名:ListNews
	* 作  用:添加新闻
	* 参  数：sPage,页面地址; strPage,第几页
	* 返回值:字符串型。返回操作结果的信息
	***********************************************************/
    public String ListNews(String sPage,String strPage)
    {			
		try
    	{
	    	boolean OK = true;
    		Connection Conn = DBConn.getConn();
	    	Statement stmt = Conn.createStatement(1004,1007);
	    	ResultSet rs = null;
    		StringBuffer sb = new StringBuffer();
    		String [] s1 = null;
			int i;
			int intPage = 1; 			
			int intPageSize = 15;
			if (Fun.ReadConfig() && Fun.AdminNewsListNum>0) intPageSize = Fun.AdminNewsListNum;
			
	    	String sSql = "select * from News order by NewsID desc";
	    	rs = stmt.executeQuery(sSql);
	    	
	    	//输出表单信息
    		sb.append("<br><br><table width=\"90%\"  border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\">\r\n");
			sb.append("<tr background=\"images/bg.gif\">\r\n");
			sb.append("<td height=\"27\" colspan=\"4\" background=\"images/bg.gif\"><div align=\"center\">");
			sb.append("<strong class=\"title\">新闻列表</strong></div></td></tr>\r\n");
			sb.append("<tr class=\"chinese\" height=\"25\">\r\n");
			sb.append("<td width=\"8%\" height=\"25\"><div align=\"center\" class=\"chinese\"><strong>ID</strong></div></td>\r\n");
			sb.append("<td width=\"50%\"><div align=\"center\" class=\"chinese\"><strong>新闻标题</strong></div></td>\r\n");
			sb.append("<td width=\"26%\"><div align=\"center\" class=\"chinese\"><strong>发布时间</strong></div></td>\r\n");
			sb.append("<td width=\"16%\"><div align=\"center\" class=\"chinese\"><strong>操作</strong></div></td>\r\n");
			sb.append("</tr>\r\n");
			sb.append("<tr>\r\n");
			sb.append("<td height=\"30\" colspan=\"4\" align=\"center\">");
			sb.append("<form name=\"ListNews\" style=\"margin:0 2px 0 0; height:25px;width:500px;font-size:12px\">");
			sb.append("<div align=\"center\"><font color=\"#ff6600\"><strong>新闻管理快速通道</strong>&nbsp;&nbsp;");
			sb.append("请输入要操作新闻的ID:&nbsp;</font>");
			sb.append("<input id=\"NewsID\" type=\"text\" size=\"10\" maxlength=\"8\" class=\"chinese\">&nbsp;");
			sb.append("<input name=\"Submit\" type=\"button\" class=\"button\" value=\"修 改\" onClick=\"fastNews(false);\">&nbsp;");
			sb.append("<input name=\"Submit2\" type=\"button\" class=\"button\" value=\"删 除\" onClick=\"fastNews(true);\">");
			sb.append("</form>");
			sb.append("</td></tr>\r\n");
			
	    	//如果表中没有任何记录，刚给出提示信息
			if (!rs.next())
			{ 
				sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\"  class=\"info1\"><td colspan=\"4\">\r\n");
				sb.append("<div align=\"center\"><b>暂时还没有新闻!</b></div></td></tr>\r\n");
			}
			else 
			{
				//取得待显示页码 
				intPage = Fun.StrToInt(strPage);
				sPage = Fun.CheckReplace(sPage);
				if (intPage==0) intPage=1;	
	
				//将记录指针定位到待显示页的第一条记录上 
				rs.absolute((intPage-1) * intPageSize+1);
				i = 0; 
				while(i < intPageSize && !rs.isAfterLast())
				{		
				    int NewsID = rs.getInt("NewsID");	
					String NewsTitle = rs.getString("NewsTitle");
					String sTitle = NewsTitle;
					String sImg = "news.gif";
					String sImgTitle = "普通新闻";
					
					if (NewsTitle.length()>20) sTitle = NewsTitle.substring(0,20) + "..";
					
					if(rs.getString("IsImg").equals("Yes")) 
					{
						sImg = "ImgNews.gif";
						sImgTitle = "图片新闻";
					}
					else if(rs.getString("IsImg").equals("Yes")) 
					{
						sImg = "TopNews.gif";
						sImgTitle = "头条新闻";
					}
					sb.append("<tr bgcolor=\"#d6dff7\" height=\"22\">\r\n");
					sb.append("<td bgcolor=\"#d6dff7\" height=\"22\"><div align=\"center\" class=\"chinese\">" + NewsID + "</div></td>\r\n");
					sb.append("<td bgcolor=\"#d6dff7\"><div class=\"news\">&nbsp");
					sb.append("<img src=\"../pic/" + sImg + "\" alt=\"" + sImgTitle + "\">&nbsp;");
					sb.append("<a href=\"../ShowNews.jsp?NewsID=" + NewsID + "\"  Title=\"" + NewsTitle + "\">" + sTitle + "</div></td>\r\n");
					sb.append("<td bgcolor=\"#d6dff7\"><div align=\"center\" class=\"chinese\">" + rs.getString("NewsTime") + "</div></td>\r\n");
					sb.append("<td bgcolor=\"#d6dff7\"><div align=\"center\"  class=\"chinese\">");
					sb.append("<a href=\"ModifyNews.jsp?NewsID=" + NewsID + "\">[修改]</a>");
					sb.append("<a href=\"DelNews.jsp?NewsID=" + NewsID + "\">[删除]</a> </div></td>\r\n");
					sb.append("</tr>\r\n");
					rs.next(); 
					i++;
				}
				sb.append("</table>\r\n");
				sb.append(Fun.Page(sPage,rs,intPage,intPageSize));
			}
			rs.close();
    		stmt.close();
    		Conn.close();
    		return sb.toString();	
    	}catch(Exception e)
        {
            //e.printStackTrace();
            //System.out.print(e.getMessage());
            return "No";
        }
    }
    
    
    
    /*********************************************************
	* 函数名:AddNews
	* 作  用:添加新闻
	* 参  数:s:字符串数组，添加新闻的各项参数
	*        s1:管理员;s2:IP地址
	* 返回值:字符串型。返回操作结果的信息
	***********************************************************/
    public String AddNews(String [] s,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++)
	    	{
	    		if(i!=1) s[i] = Fun.getStrCN(Fun.CheckReplace(s[i]));
	    		else s[i] = Fun.getStrCN(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] = "新闻内容";
	    	String sOK = Fun.CheckDate(sa1,sa2);
	    	if (!sOK.equals("Yes"))
	    	{
	    		OK = false;
	    		sError = sOK; 
	    	}
	    	
	    	if(!s[13].equals(""))
	    	{
	    		s[7]="0";
	    		s[8]="0";
	    	}
	    	else
	    	{
	    		if(s[7].equals("") || s[8].equals(""))
	    		{
	    			OK = false;
	    			sError="新闻类别和专题不能同时为空";
	    		}
	    	}
	    	
	    	if(s[14].length()>120) s[14]=s[14].substring(0,120);
	    	if (s[2].equals("") || s[2].equals(""))
	    	{