php简单的数据库操作类

class Db {
var $dbConn = "";
var $dbServerName = "localhost";
var $dbUserName  = "UserName";
var $dbPwd = "dbPwd";
var $dbName = "dbName ";
var $errorMessage = "";
/*
  * 功能: 连接数据库
  * 输入: 无
  * 返回: 无
*/
function dbConn()
{
  if (!$this->dbConn)
  {
try
{
$this->dbConn = mysql_connect($this->ServerName,$this->dbUserName,$this->dbPwd);
//mysql_query("set names 'utf-8'");
}
catch(Exception $e)
{
echo "数据库连接失败！";
$this->errorMessage = $e;
}
  }
}
/*
  * 功能: 关闭数据库
  * 输入: 无
  * 返回: 无
*/
function dbClose()
{
  if (!$this -> dbConn)
  {
mysql_close($this->dbConn);
  }
}
/*
  * 功能: 执行SQL操作
  * 输入: $sqlStr ->SQL语句(Insert/Update/Delete)
  * 返回: 无
*/
function executeSqlNonQuery($sqlStr)
{
  //echo $sqlStr.'---|---';
  //exit;
  $this -> dbConn();
  mysql_select_db($this -> dbName);
  mysql_query($sqlStr,$this -> dbConn) or die("executeSqlNonQuery执行出错");
  $this -> dbClose();
}
/*
  * 功能: 执行SQL操作
  * 输入: $sqlStr  ->SQL语句(Select)
  * 返回: $records ->返回查询的结果(二维数组形式)
*/
function executeSql($sqlStr)
{
  //echo $sqlStr.'---|---';
  //exit;
  $this -> dbConn();
  mysql_select_db($this -> dbName);
  $result = mysql_query($sqlStr,$this -> dbConn) or die("executeSql执行出错");
  $this -> dbClose();
  while($record = mysql_fetch_array($result))  //形成二维数组
$records[] = $record;
  mysql_free_result($result);
  return $records;
}
}

sky 58.62.103.* 2007-10-21 16:34:36 编辑于：2007-10-21 16:36:08