if($this->NewEdit==2)
                    $this->sName.="=".$this->sEdit;
      }

    function Update()    //存储新值到数据库
    {
      $strSQL="";

      if($this->NewEdit==0)
      {
        $this->nErr=1;
        $this->sErr="Update:请先执行AddNew()或者Edit()，再用SetValue()添加值！";
        return;
      }

      if(empty($this->sValue))
      {
        $this->nErr=1;
        $this->sErr="Update:在数据为空的情况下，不能添加或修改数据！";
        return;
      }

      switch($this->NewEdit)
      {
       case 1:       //添加
            $strSQL="insert into ";
            $strSQL.=$this->sTName;
            $strSQL.=" (".$this->sName.") ";
            $strSQL.="values (".$this->sValue.")";
            break;
      case 2:          //修改
            $strSQL="update ";
            $strSQL.=$this->sTName;
            $strSQL.=" set ";
            $strSQL.=$this->sName;
            if(!empty($this->sEditCon))
                $strSQL.=" where ".$this->sEditCon;
            break;
      default:
           $this->nErr=1;
           $this->sErr="Update:Update()生成SQL语句出错，请检查！";
           return;
      }

      $this->sSQL=$strSQL;
      if(!$this->nResult=mysql_query($strSQL))
      {
        $this->nErr=1;
        $this->sErr="Update:SQL语句：".$strSQL."<br><br>MySql错误：".mysql_error();
        return;
      }
       //echo($this->sSQL."<br>");
      //作清理工作
      $this->NewEdit=0;
      unset($this->aNew);
      mysql_query("commit");
    }
  }
?>

上一页  [1] [2] [3] [4]