sql语句自动更新怎么写

merge GroupStage a using

(select GroupStageId, sum(Adult+Children) over() as sumAC from LineSchedule where ScheduleDate<='2014/9/23 10:37:19') b on a.GroupStageId=b.GroupStageId

when matched then update set a.ApplyBit=b.sumAC

类页面

<?php

include_once (dirname(__FILE__)."\ConnDB.php")

class SqlHelper{

private $_arr

public $tableName

public function dataBind($key,$value)

{

$this->_arr[$key]=$value

}

public function validate()

{

if(!isset($this->tableName))

{

die("表名不能为空！")

}

if(!isset($this->_arr))

{

die("值与列名未绑定")

}

}

public function update($condition){

foreach($this->_arr as $key =>$value){

$s .= "$key = $value,"

}

$ss = substr($s,0,-1)

$sql = "update $this->tableName set $ss where $condition"

$query = mysql_query($sql)

echo $sql

if($query)

{

echo "数据修改成功"

}

else

{

echo "数据修改失败"

}

}

public function insert()

{

$this->validate()

$keys = ""

$values = ""

foreach($this->_arr as $key=>$value)

{

$keys.="`$key`,"

if($value=="")

{

$values.="null,"

}

else

{

$values.="'$value',"

}

}

$keys = substr($keys,0,strlen($keys)-1)

$values = substr($values,0,strlen($values)-1)

$sql = "insert into `$this->tableName`($keys)values($values)"

$query = mysql_query($sql)

if($query)

{

echo "ok"

}

else

{

echo "no"

}

//echo mysql_error()

//return $query

}

public function Delete($condition)

{

if(!isset($this->tableName))

{

die("表名不能为空！")

}

$sql="delete from $this->tableName where $condition"

$query=mysql_query($sql)

if($query)

{

echo "删除成功！"

}

else

{

echo mysql_error()

}

}

function select($sqls)//读取出符合where子句的所有信息

{

$sql = "select * from `$this->tableName` where $sqls"

$query = mysql_query($sql)

/*

$result = array()

while($rs = mysql_fetch_array($query))

{

$result[]=$rs

}

return $result*/

$num = mysql_num_rows($query)

return $num

}

function selectNew($sqls,$n)//读取出符合where子句的最新的n条信息

{

$sql = "select * from `$this->tableName`

where $sqls

order by `id` desc

limit 0,$n"

$query = mysql_query($sql)

$result = array()

while($rs = mysql_fetch_array($query))

{

$result[]=$rs

}

return $result

}

}

?>

实例化页面

$inserts = new SqlHelper()

$inserts->tableName="user"

$inserts->dataBind("name","bbbb")

$inserts->dataBind("address","")

$inserts->insert()

$inserts = new SqlHelper()

$inserts->tableName="user"

$inserts->dataBind("name","33333")

$inserts->dataBind("address","44444")

$inserts->update("id = 13")

$inserts=new SqlHelper()

$inserts->tableName="user"

$inserts->Delete("id=4")

这是我以前写的类，你看看！

---