/*事务脚本模式: 类似于thinkphp中的model层，或者说就是操作数据库的类。
个人觉得实践中使用起来还是挺简单方便的，就是sql语句写死了的话，灵活性就不够。
示例代码如下：*/namespace woo\process;abstract class base{static $db; //pdo对象static $stmts = array(); //sql语句句柄function __construct (){$dsn = \woo\base\applicationregistry::getdsn();if(is_null($dsn)){throw new \woo\base\appexception(no dsn);
}
self::$db = new pdo($dsn);
self::$db->setattribute(\pdo::attr_errmode,\pdo::errmode_exception);
} function preparestatement($stmt_s){ //缓存sql语句句柄if(isset(self::$stmts($stmt_s)){return self::$stmts[$stmt_s];
}$stmt_handle = self::$db->prepare($stmt_s);
self::$stmts[$stmt_s] = $stmt_handle;return $stmt_handle;
} protected function dostatement($stmt_s,$values_a){ //执行sql并获取一个语句资源$sth = $this->preparestatement($stmt_s);$sth->closecursor();$db_result = $sth->execute($values_a);return $sth;
}
}//这个类就是向数据库中写入一些数据，比较简单没什么好多说的class venuemanager extends base{static $add_venue = insert into venue (name) values(?);static $add_space = insert into space (name,venue) values(?,?);static $check_slot = select id,name from event where space = ? and (start+duration)>? and start <?";static $add_event = "insert into event (name,space,start,duration) values(?,?,?,?)"; function addvenue($name,$space_array){$ret = array();$ret['venue'] = array($name);$this->dostatement(self::$add_venue,$ret['venue']);$v_id = self::$db->lastinsertid();$ret['spaces'] = array();foreach($space_array as $space_name){$values = array($space_name,$v_id);$this->dostatement(self::$add_space,$values);$s_id = self::$db->lastinsertid();array_unshift($values,$s_id);$ret['spaces'][] = $values;
}return $ret;
} function bookevent ($space_id,$name,$time,$duration){$values = array($space_id,$time,($time+$duration));$stmt = $this->dostatement(self::$check_slot,$values,false);if($result = $stmt->fetch()){throw new \woo\base\appexception(double booked! try again);
}$this->dostatement(self::$add_event,array($name,$space_id,$time,$duration));
}
}//客户端,使用起来还是比较简便的$venue = new venuemanager();$venue->addvenue('test',array('test1','test2','test3'));
以上就是事务脚本模式是什么意思？的详细内容。