设计模式：适配器模式（php实现）

1、适配器模式

1.1、简介

1、适配器模式，可以将截然不同的函数接口封装成统一的API
2、实际应用举例，PHP的数据库操作有mysql、mysqli、pdo三种，可以用适配器模式统一成一致。类似的场景还有cache适配器，将memcache，redis，file，apc等不同的缓存函数，统一成一致

2、实现

步骤1

创建适配器

IDatabase.php

//适配器接口
interface IDatabase
{
    function connect($host, $user, $passwd, $dbname);
    function query($sql);
    function close();
}

步骤2

实现适配器

MySQL.php

//适配器实例MySQL
class MySQL implements IDatabase
{
    protected $conn;
    function connect($host, $user, $passwd, $dbname)
    {
        $conn = mysql_connect($host, $user, $passwd);
        mysql_select_db($dbname, $conn);
        $this->conn = $conn;
    }
    function query($sql)
    {
        $res = mysql_query($sql, $this->conn);
        return $res;
    }
    function close()
    {
        mysql_close($this->conn);
    }
}

MySQLi.php

class MySQLi implements IDatabase
{
    protected $conn;
    function connect($host, $user, $passwd, $dbname)
    {
        $conn = mysqli_connect($host, $user, $passwd, $dbname);
        $this->conn = $conn;
    }
    function query($sql)
    {
        $res = mysqli_query($this->conn, $sql);
        return $res;
    }
    function close()
    {
        mysqli_close($this->conn);
    }
}

PDO.php

//适配器实例PDO
class PDO implements IDatabase
{
    protected $conn;
    function connect($host, $user, $passwd, $dbname)
    {
        $conn = new \PDO("mysql://host=$host;dbname=$dbname", $user, $passwd);
        $this->conn = $conn;
    }
    function query($sql)
    {
        $res = $this->conn->query($sql);
        return $res;
    }
    function close()
    {
        unset($this->conn);
    }
}

步骤3

使用

$db = new IMooc\Database\MySQL();
$db->connect('127.0.0.1', 'root', 'root', 'test');
$db->query('show tables');
$db->close();

$db = new IMooc\Database\MySQLi();
$db->connect('127.0.0.1', 'root', 'root', 'test');
$db->query('show tables');
$db->close();

$db = new IMooc\Database\PDO();
$db->connect('127.0.0.1', 'root', 'root', 'test');
$db->query('show tables');
$db->close();