<!--數(shù)據(jù)庫類文件：DataBase.php-->
<?php
	require("sys_conf.inc");			//包含系統(tǒng)配置文件
	class DataBase
	{
		//屬性
		public $mConnId;		//連接標(biāo)識		
		public $mSqlString;		//待執(zhí)行的SQL語句
		public $mResultArray;	//執(zhí)行Select語句返回的結(jié)果數(shù)組		
		
		//構(gòu)造函數(shù)
		function __construct($pHost,$pUser,$pPwd,$pDbName)
		{			
			$this->mConnId=mysql_connect ($pHost,$pUser,$pPwd);//建立連接
			mysql_select_db($pDbName, $this->mConnId);	//選擇數(shù)據(jù)庫
		}
		
		//__destruct：析構(gòu)函數(shù)，斷開連接
		function __destruct()
		{
				//mysql_close($this->mConnId);
		}
		
		//增刪改數(shù)據(jù)
		function ExecuteSql()
		{
			//echo $this->SqlString."<br>";
			mysql_query($this->SqlString);
		}
		
		//查詢數(shù)據(jù)，返回值為對象數(shù)組，數(shù)組中的每一元素為一行記錄構(gòu)成的對象
		function Query(){
			//echo $this->SqlString."<br>";
			$i=0;
			$query_result=mysql_query($this->SqlString,$this->mConnId);
			while($row=mysql_fetch_object($query_result))
			{
				$this->mResultArray[$i++]=$row;
			}
		}
	
	}//class DataBase
	
/*
	$db=new DataBase($DBHOST,$DBUSER,$DBPWD,$DBNAME);
	
	$db->SqlString="insert into test(t1,t2) values('1','2')";
	$db->ExecuteSql();
	
	$db->SqlString="select * from test";
	$db->Query();	
	print_r($db->mResultArray);
	
	$db->__destruct();
	$db=NULL;
//*/
?>