/** * 删除数据方法 * @param $table 表名 * @param array $where * @return int */ public function delete($table, array $where) { $sql = "delete from {$table} " . $this->whereStr; try { self::$_link->beginTransaction(); $stmt = self::$_link->prepare($sql); $stmt->execute($where); if ($stmt->rowCount() > 0) { self::$_link->commit(); return 1; } else { self::$_link->rollback(); $err = $stmt->errorInfo(); throw new PDOException($err[2]); } } catch (PDOException $e) { MyException::showError($e->getMessage()); } }