Class: Sqlsrv

源文件路径: /Service/Database/Drivers/Sqlsrv.class.php

Class Overview

Driver
   |
   --Sqlsrv

Sqlsrv数据库驱动

Variables

Methods

Inherited Variables

Class: Driver

Driver::$bind
Driver::$config
Driver::$error
Driver::$executeTimes
Driver::$exp
Driver::$lastInsID
Driver::$linkID
Driver::$model
Driver::$modelSql
Driver::$numRows
Driver::$PDOStatement
Driver::$queryStr
Driver::$queryTimes
Driver::$transTimes
Driver::$_linkID
Driver::$_linkNum

Inherited Methods

Class: Driver

Driver::__construct(): 架构函数读取数据库配置信息
Driver::bindParam(): 参数绑定
Driver::buildSelectSql(): 生成查询SQL
Driver::close(): 关闭数据库
Driver::commit(): 用于非自动提交状态下面的查询提交
Driver::connect(): 连接数据库方法
Driver::debug(): 数据库调试记录当前SQL
Driver::delete(): 删除记录
Driver::error(): 数据库错误信息
Driver::escapeString(): SQL指令安全过滤
Driver::execute(): 执行语句
Driver::free(): 释放查询结果
Driver::getError(): 获取最近的错误信息
Driver::getExecuteTimes(): 获得执行次数
Driver::getLastInsID(): 获取最近插入的ID
Driver::getLastSql(): 获取最近一次查询的sql语句
Driver::getQueryTimes(): 获得查询次数
Driver::initConnect(): 初始化数据库连接
Driver::insert(): 插入记录
Driver::insertAll(): 批量插入记录
Driver::multiConnect(): 连接分布式服务器
Driver::parseBind(): 参数绑定分析
Driver::parseComment(): comment分析
Driver::parseDistinct(): distinct分析
Driver::parseDsn(): 解析pdo连接的dsn信息
Driver::parseDuplicate(): ON DUPLICATE KEY UPDATE 分析
Driver::parseField(): field分析
Driver::parseForce(): index分析，可在操作链中指定需要强制使用的索引
Driver::parseGroup(): group分析
Driver::parseHaving(): having分析
Driver::parseJoin(): join分析
Driver::parseKey(): 字段名分析
Driver::parseLimit(): limit分析
Driver::parseLock(): 设置锁机制
Driver::parseOrder(): order分析
Driver::parseSet(): set分析
Driver::parseSql(): 替换SQL语句中表达式
Driver::parseSteezeWhere(): 特殊条件分析
Driver::parseTable(): table分析
Driver::parseUnion(): union分析
Driver::parseValue(): value分析
Driver::parseWhere(): where分析
Driver::parseWhereItem()
Driver::query(): 执行查询返回数据集
Driver::rollback(): 事务回滚
Driver::select(): 查找记录
Driver::selectInsert(): 通过Select方式插入记录
Driver::setModel(): 设置当前操作模型
Driver::startTrans(): 启动事务
Driver::update(): 更新记录
Driver::__destruct(): 析构方法

Class Details

[line 13]
Sqlsrv数据库驱动

[ Top ]

Class Variables

$options = array(
        PDO::ATTR_CASE              =>  PDO::CASE_LOWER,
        PDO::ATTR_ERRMODE           =>  PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_STRINGIFY_FETCHES =>  false,
        PDO::SQLSRV_ATTR_ENCODING   =>  PDO::SQLSRV_ENCODING_UTF8,
    )

[line 16]

Access: protected

Type:	mixed
Overrides:	Array

[ Top ]

$selectSql = 'SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER (%ORDER%) AS ROW_NUMBER FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING% %UNION%) AS thinkphp) AS T1 %LIMIT%%COMMENT%'

[line 14]

Access: protected

Type:	mixed
Overrides:	Array

[ Top ]

Method Detail

delete [line 149]

false delete(
[array
$options = array()])

删除记录

Return: | integer
Access: public

Overrides Driver::delete() (删除记录)

Parameters:

array $options — 表达式

[ Top ]

getFields [line 42]

array getFields(

$tableName)

取得数据表的字段信息

Access: public

Parameters:

$tableName —

[ Top ]

getTables [line 72]

array getTables(
[
$dbName = ''])

取得数据表的字段信息

Access: public

Parameters:

$dbName —

[ Top ]

parseDsn [line 29]

string parseDsn(
array
$config)

解析pdo连接的dsn信息

Access: protected

Overrides Driver::parseDsn() (解析pdo连接的dsn信息)

Parameters:

array $config — 连接信息

[ Top ]

parseKey [line 100]

string parseKey(

&$key, string
$key)

字段名分析

Access: protected

Overrides Driver::parseKey() (字段名分析)

Parameters:

string	`$key`	—
	`&$key`	—

[ Top ]

parseLimit [line 114]

string parseLimit(
mixed
$limit)

limit

Access: public

Overrides Driver::parseLimit() (limit分析)

Parameters:

mixed $limit —

[ Top ]

parseOrder [line 90]

string parseOrder(
mixed
$order)

order分析

Access: protected

Overrides Driver::parseOrder() (order分析)

Parameters:

mixed $order —

[ Top ]

update [line 131]

false update(
mixed
$data, array
$options)

更新记录

Return: | integer
Access: public

Overrides Driver::update() (更新记录)

Parameters:

mixed	`$data`	—	数据
array	`$options`	—	表达式

[ Top ]

Class: Sqlsrv

Class Overview

Variables

Methods

Inherited Variables

Class: Driver

Inherited Methods

Class: Driver

Class Details

Class Variables

$options = array( PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_STRINGIFY_FETCHES => false, PDO::SQLSRV_ATTR_ENCODING => PDO::SQLSRV_ENCODING_UTF8, )

$selectSql = 'SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER (%ORDER%) AS ROW_NUMBER FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING% %UNION%) AS thinkphp) AS T1 %LIMIT%%COMMENT%'

Method Detail

delete [line 149]

Parameters:

getFields [line 42]

Parameters:

getTables [line 72]

Parameters:

parseDsn [line 29]

Parameters:

parseKey [line 100]

Parameters:

parseLimit [line 114]

Parameters:

parseOrder [line 90]

Parameters:

update [line 131]

Parameters:

$options = array(
PDO::ATTR_CASE => PDO::CASE_LOWER,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_STRINGIFY_FETCHES => false,
PDO::SQLSRV_ATTR_ENCODING => PDO::SQLSRV_ENCODING_UTF8,
)