/***************************************************
 *  
 *  源文件名:  Function.java
 *  功    能： 夢想年華新聞系統 - 函數定義類
 *	作者：夢想年華 [DreamTime]
 *	Email:fanwsp@126.com
 *  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 = "fanwsp@126.com";
			
			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;
	  }
  		
	}