<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

结果：<br>

<?php

require_once 'ADOConn.php';

$ADOConnObj = new ADOConn();

//$ADOConnObj->OnInitADOConn();

$sql="select id,sccoun,cpname,cpip,dwname,[memo] from z_sc where id=3 or id=4 or id=5";

$ADOConnObj->GetRecordSet($sql);

$sql="select id,sccoun,cpname,cpip,dwname,[memo] from z_sc where sccoun='成都'";

$ADOConnObj->GetRecordSet($sql);

/*

"update z_sc set cpname='%s',[memo]='%s' ,cpip='%s',dwname='%s',cpmodel='%s',cpno='%s',snno='%s', 	sperson='%s',sphone='%s',azdate='%s' where ID=%d ",

"insert into z_sc(sccoun,cpname,dwname,[memo],cpip,cpmodel,cpno,snno,sperson,sphone,azdate)

"delete from z_sc where ID=%d "

*/

$sql="update z_sc set [memo]='已修改' where id=3 " ;

$ADOConnObj->ExecuteSQL($sql);

echo "</br>"."over....";

?>

<?php

class ADOConn

{

	public function OnInitADOConn()

	{

		//读取mdb数据库例程1.连接数据库 --完全没用到这个函数

		$conn = new com("ADODB.Connection") or die ("创建数据库连接失败！");

		$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=**; DBQ=". realpath("D:/AppServ/www/php_access/PhoSys.mdb"); 

		$conn->Open($connstr);

		/*方法二 D:\AppServ\Apache2.2\PhoSys.mdb

		 $connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PhoSys.mdb;Persist Security Info=False;Jet OLEDB:Database Password=hzcjy";   */

		/*方法三 解决乱码

		require_once 'adodb/adodb.inc.php';

		$conn = new COM ( "ADODB.Connection", NULL, 65001) or die ( "ADO connect failed!" );

		$connstr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" . realpath ( "database/testDB.mdb" ) . ";Uid=;Pwd=;";

		//$conn = new com("ADODB.Connection") or die ("创建数据库连接失败！");

		//乱码这个不管用，下边管用 $conn->exec("set names utf8");

		*/

	}

	//函数主要用于打开并获得记录集

	public function GetRecordSet($query)

	{

		$conn = new COM ( "ADODB.Connection", NULL, 65001) or die ( "ADO connect failed!" );

		$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=hzcjy; DBQ=". realpath("D:/AppServ/www/php_access/PhoSys.mdb");

		$conn->Open($connstr);

		$rs=$conn->Execute($query);

		$row="0";

	if($rs){

		while(!$rs->EOF)

		{

			$string ="";

			for ($i=0;$i<$rs->Fields->count;$i++)

			{

				if ($i==0)

				{

			$string.=$rs->Fields($i)->Value;

			continue;

				}

				$string.='|'.$rs->Fields($i)->Value;

			}

			$string.="\n"."<br>";

			if ($row==300)

			{

				break;

			}

			$row++;

			   echo "

			";

			   echo $string;

			   $rs->MoveNext();

		}

	}//end if

	else

	{ print $conn->ErrorMsg ();}

	$rs = null;

	$conn->close ();

	$conn = null;

	}	

	public function ExecuteSQL($query)

	{//执行数据库语句 delete,update,

		//--OnInitADOConn();

		$conn = new COM ( "ADODB.Connection", NULL, 65001) or die ( "ADO connect failed!" );

		$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=hzcjy; DBQ=". realpath("D:/AppServ/www/php_access/PhoSys.mdb");

		$conn->Open($connstr);

		$result   =$conn->Execute($query);  

		if($result)

			echo   "successful";

		else

			{  $conn->ErrorMsg();echo   "failed"; 	 }

		$rs = null;

		$conn->close ();

		$conn = null;

	}

}

?>