【末世旅行之PHP】PHP用PDO连接MySQL数据库工具类-增删改查

工具类源码：

<?phpclass PDOUtil{    private static $dbms = "mysql";    private static $host = '127.0.0.1';    private static $port = '3306';    private static $username = 'root';    private static $password = 'root';    private static $dbname = 'worktest';    private static $charset = 'utf8';    public function getConn(){        try {//            $pdo = new PDO("mysql:host=127.0.0.1;port=3306;dbname=test", "root", "root");//            $pdo->exec("set names 'utf8'");            $pdo = new PDO(self::$dbms.":host=".self::$host.";port=".self::$port.";dbname=".self::$dbname,  self::$username,self::$password);            $pdo->exec("set names ".self::$charset);            return $pdo;        }        catch(PDOException $e){            die("数据库连接失败".$e->getMessage());        }    }    public function queryOneRow($sql, $params){        $result = self::queryRows($sql,$params);        return $result[0];    }    public function queryRows($sql, $params){        $stmt = self::getConn()->prepare($sql);        $stmt->execute($params);        $result = array();        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {            $result[] = $row;        }        return $result;    }    public function update($sql, $params){        $stmt = self::getConn()->prepare($sql);        $result = $stmt->execute($params);        return $result;    }}?>

测试代码：

<meta charset="utf-8"><?phpinclude_once "PDOUtil.php";$pdo = new PDOUtil();//无条件查询多条数据$sql = "SELECT * FROM testtable";$result = $pdo->queryRows($sql,null);var_dump($result);////条件查询//$sql = "SELECT * FROM testtable WHERE name != ? AND number != ? ";//$params = array("张三","101");//$result = $pdo->queryRows($sql,$params);//var_dump($result);//查询一条数据//$sql = "SELECT * FROM testtable WHERE name = ? AND number = ? ";//$params = array("张三","101");//$result = $pdo->queryOneRow($sql,$params);//var_dump($result);////插入//$sql = "INSERT INTO testtable (name, number) VALUES (?,?)";//$params = array("赵六","106");//$result = $pdo->update($sql,$params);//var_dump($result);////更新//$sql = "UPDATE testtable SET number = ? WHERE name = ? ";//$params = array("104","李四");//$result = $pdo->update($sql,$params);//var_dump($result);////删除//$sql = "DELETE FROM testtable  WHERE number = ? ";//$params = array("106");//$result = $pdo->update($sql,$params);//var_dump($result);?>