PHP面向对象之事务脚本模式(详解)
程序员文章站
2024-03-12 13:43:38
如下所示:
/*
事务脚本模式: 类似于thinkphp中的model层,或者说就是操作数据库的类。
个人觉得实践中使用起来还是挺简单方便的,就是sql语句写...
如下所示:
/* 事务脚本模式: 类似于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'));
以上这篇php面向对象之事务脚本模式(详解)就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。