Delete类位于 Tun\Db\Sql\ 目录下,是删除数据库数据的主要通道。在模型层中,可以通过Sql数调用Delete类中的方法,也可以直接引入,通过新建对象的方式使用。
如下所示:
namespace User\Model; use Tun\Db\Sql\Sql; use Tun\Db\Sql\Where; use Tun\Db\Adapter\Adapter; use Tun\Db\Sql\Expr; use Tun\Db\Sql\ExprWhere; use Tun\Paginator\Paginator; use Tun\Request\Params; use Tun\Captcha\CaptchaCode; class Document{ private $sortReg = '/^[0-9]{0,11}$/'; public function __construct(Adapter $adapter){ $this->adapter = $adapter; $this->table = 'document'; $this->categoryTable = 'document_cate'; } public function deleteById($id){ $sql = new Sql($this->adapter); $delete = $sql->delete(); $delete->table($this->table); $delete->where(array('document_id'=>$id)); $statement = $delete->statement(); // echo $result = $statement->prepareToString(); // $sql->setSql($sqlStr); // $statement = $sql->statement(); $result = $statement->prepare()->execute(); return $result; } }
也可以用以下的方法:
namespace User\Model; use Tun\Db\Sql\Sql; use Tun\Db\Sql\Delete; use Tun\Db\Sql\Where; use Tun\Db\Adapter\Adapter; use Tun\Db\Sql\Expr; use Tun\Db\Sql\ExprWhere; use Tun\Paginator\Paginator; use Tun\Request\Params; use Tun\Captcha\CaptchaCode; class Document{ private $sortReg = '/^[0-9]{0,11}$/'; public function __construct(Adapter $adapter){ $this->adapter = $adapter; $this->table = 'document'; $this->categoryTable = 'document_cate'; } public function deleteById($id){ $delete = new Delete($this->adapter); $delete->table($this->table); $delete->where(array('document_id'=>$id)); $statement = $delete->statement(); // echo $result = $statement->prepareToString(); // $sql->setSql($sqlStr); // $statement = $sql->statement(); $result = $statement->prepare()->execute(); return $result; } }
Delete类中有以下方法:
statement()
table()
where() //where的用法请参阅Where类。