function.java

JSP+JAVAbean写的一个很好的新闻发布系统,一个好的新闻发布系统 JSP+JAVAbean

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



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

import java.sql.*;
import dreamtime.dreamnews.DBConnection;
public class Function					
{        
	DBConnection DBConn = new DBConnection();
	public static int AdminUserListNum;
	public static int AdminLogListNum;
	public static int AdminNewsListNum;
	
	public static int HotNewsNum;
	public static int TopNewsNum;
	public static int TopImgNum;
	public static int HeadNewsNum;
	public static int ClassNewsNum;
	public static int ClassImgNum;
	public static int SpecNum;
	public static int SpecNewsNum;
	
	public static int BHotNewsNum;
	public static int BTopNewsNum;
	public static int BTopImgNum;
	public static int BHeadNewsNum;
	public static int BClassNewsNum;
	public static int BClassImgNum;
	public static int BSpecNum;
	public static int BSpecNewsNum;
	
	//专题参数
	public static int ListSpecNum;
	
	public static int ListNewsNum;
	public static int SearchNewsNum;
	
	
	//网站全局信息
	public static String DreamNewsTitle;
	public static String DreamNewsCopyRight;
	public static String DreamNewsEmail;
	
	public Function()
	{
	
	}
		
	
	public boolean ReadConfig()
	{
	try{
		Connection Conn = DBConn.getConn();
    	Statement stmt = Conn.createStatement(1004,1007);
    	String sSql = "select * from Config";	
    	ResultSet rs = stmt.executeQuery(sSql);
    	String [] s = new String [10];
    	if(rs.next())
    	{
			//后台管理参数
			AdminUserListNum = rs.getInt("AdminUserListNum");
			AdminLogListNum = rs.getInt("AdminLogListNum");
			AdminNewsListNum = rs.getInt("AdminNewsListNum");
			
			//首页参数
			HotNewsNum = rs.getInt("HotNewsNum");
			HeadNewsNum = rs.getInt("HeadNewsNum");
			TopNewsNum = rs.getInt("TopNewsNum");
			TopImgNum = rs.getInt("TopImgNum");
			ClassNewsNum = rs.getInt("ClassNewsNum");
			ClassImgNum = rs.getInt("ClassImgNum");
			SpecNum = rs.getInt("SpecNum");
			SpecNewsNum = rs.getInt("SpecNewsNum");
			
			//一级分类参数
			BHotNewsNum = rs.getInt("BHotNewsNum");
			BHeadNewsNum = rs.getInt("BHeadNewsNum");
			BTopNewsNum = rs.getInt("BTopNewsNum");
			BTopImgNum = rs.getInt("BTopImgNum");
			BClassNewsNum = rs.getInt("BClassNewsNum");
			BClassImgNum = rs.getInt("BClassImgNum");
			BSpecNum = rs.getInt("BSpecNum");
			BSpecNewsNum = rs.getInt("BSpecNewsNum");
			
			//二级分类显示参数
			ListNewsNum = rs.getInt("ListNewsNum");
			
			SearchNewsNum = rs.getInt("SearchNewsNum");
			
			//专题列表数
			ListSpecNum = rs.getInt("ListSpecNum");
			
			//网站全局信息参数
			DreamNewsTitle = rs.getString("DreamNewsTitle");
			DreamNewsCopyRight = rs.getString("DreamNewsCopyRight");
			DreamNewsEmail = rs.getString("DreamNewsEmail");
			if(DreamNewsTitle==null) DreamNewsTitle = "梦想年华新闻系统";
			if(DreamNewsCopyRight==null) DreamNewsCopyRight = "梦想年华";
			if(DreamNewsEmail==null) DreamNewsEmail = "[e-mail]";
			
			rs.close();
			stmt.close();
			Conn.close();
			return true;
		}
		else return false;
		}catch(Exception e){
			//System.out.print(e.getMessage());
			//e.printStackTrace();
			return false;
		}
	}
	
	
	
	/*********************************************************
	* 函数名：CheckReplace
	* 作  用：转化SQL特殊字符串
	* 参  数：s: 字符串型，待转化的字符
	* 返回值：转化以后的字符串
	* 调　用：String s2 = CheckReplace(s1);
	***********************************************************/	
	public String CheckReplace(String s)
	{
	    try
	    {
		    if(s == null || s.equals("")) return "";
			else
			{
				StringBuffer stringbuffer = new StringBuffer();
				for(int i = 0; i < s.length(); i++)
				{
					char c = s.charAt(i);
					switch(c)
					{							
											
					case 34: // '"'
						stringbuffer.append("&quot;");
						break;
		
					case 39: // '\''									
						stringbuffer.append("&#039;");
						break;
	
					case 124: // '|'
						stringbuffer.append("");
						break;
					
					case '&':
						stringbuffer.append("&amp;");
						break;
					
					case '<':
						stringbuffer.append("&lt;");
						break;
					
					case '>':
						stringbuffer.append("&gt;");
						break;
					
					default:
						stringbuffer.append(c);
						break;
					}
				}
				return stringbuffer.toString().trim();		//返回转化以后的字符串
	  		}
  		}catch(Exception e){ 
  			return "";
  		}
	}
		
		
	
	
	/*********************************************************
	* 函数名：CheckDate
	* 作  用：检测数据是否为空
	* 参  数：数组　s1: 检测的变量，s2，变量的名称
	* 返回值：转化以后的字符串
	***********************************************************/	
	public String CheckDate(String [] s1,String [] s2)
	{
	    boolean OK = true;
	    StringBuffer sb = new StringBuffer();
	    try
	    {
		    for(int i = 0; i < s1.length; i++)
		    {
			    if(s1[i] == null || s1[i].equals("") || s1[i].equals(" "))
				{					
					sb.append("<li> [ " + s2[i] + " ] 不能为空!"); 											
					OK = false;
		  		}
		  	}
		  	if (OK) return "Yes";
		  	else return sb.toString().trim();
		 }catch(Exception e) { return "操作失败！";}
	}

	
	/*********************************************************
	* 函数名：getStrCN
	* 作  用：转化字符编码
	* 参  数：数组　s1:等转化的字符
	* 返回值：转化以后的字符串
	***********************************************************/
	public String getStrCN(String s)
    {
	    if(s == null) s = "";
	    try
	    {
		    byte abyte0[] = s.getBytes("GBK");
		    s = new String(abyte0);
	    }catch(Exception e) {s="";}
	    return s;
    }
	
	
   /***********************************************************
	* 函数名：StrToInt
	* 作  用：把字符串转为整型
	* 参  数：s: 字符串型
	* 返回值：整型
	***********************************************************/	
	public int StrToInt(String s)
	{
	  try
	  {
		int i = Integer.parseInt(CheckReplace(s));
		return i;		//返回转化以后的字符串
	  }catch(Exception e)
	  {
	  	return 0;
	  }
  		
	}