Class: AbstractWindPdoAdapter

Source Location: /db/AbstractWindPdoAdapter.php

Class AbstractWindPdoAdapter

Class Overview

db连接适配器抽象类定义

Located in /db/AbstractWindPdoAdapter.php [line 11]

PDO
   |
   --AbstractWindPdoAdapter

Author(s):

Qiong Wu <papa0924@gmail.com> 2011-9-22

API Tags:

Abstract:

Information Tags:

Version:	$Id: AbstractWindPdoAdapter.php 3113 2011-11-11 07:28:09Z yishuo $
Copyright:	©2003-2103 phpwind.com
License:	http://www.windframework.com

Methods

[ Top ]

Descendants

Child Class	Description
WindMysqlPdoAdapter	mysql类型数据库连接类

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )

beginTransaction ( )

commit ( )

errorCode ( )

errorInfo ( )

exec ( $query )

getAttribute ( $attribute )

getAvailableDrivers ( )

inTransaction ( )

lastInsertId ( [$seqname = ] )

prepare ( $statment, [$options = ] )

query ( )

quote ( $string, [$paramtype = ] )

rollBack ( )

setAttribute ( $attribute, $value )

__sleep ( )

__wakeup ( )

Inherited From PDO (Internal Class)

ATTR_AUTOCOMMIT = 0

ATTR_CASE = 8

ATTR_CLIENT_VERSION = 5

ATTR_CONNECTION_STATUS = 7

ATTR_CURSOR = 10

ATTR_CURSOR_NAME = 9

ATTR_DEFAULT_FETCH_MODE = 19

ATTR_DRIVER_NAME = 16

ATTR_EMULATE_PREPARES = 20

ATTR_ERRMODE = 3

ATTR_FETCH_CATALOG_NAMES = 15

ATTR_FETCH_TABLE_NAMES = 14

ATTR_MAX_COLUMN_LEN = 18

ATTR_ORACLE_NULLS = 11

ATTR_PERSISTENT = 12

ATTR_PREFETCH = 1

ATTR_SERVER_INFO = 6

ATTR_SERVER_VERSION = 4

ATTR_STATEMENT_CLASS = 13

ATTR_STRINGIFY_FETCHES = 17

ATTR_TIMEOUT = 2

CASE_LOWER = 2

CASE_NATURAL = 0

CASE_UPPER = 1

CURSOR_FWDONLY = 0

CURSOR_SCROLL = 1

ERRMODE_EXCEPTION = 2

ERRMODE_SILENT = 0

ERRMODE_WARNING = 1

ERR_NONE = '00000'

FETCH_ASSOC = 2

FETCH_BOTH = 4

FETCH_BOUND = 6

FETCH_CLASS = 8

FETCH_CLASSTYPE = 262144

FETCH_COLUMN = 7

FETCH_FUNC = 10

FETCH_GROUP = 65536

FETCH_INTO = 9

FETCH_KEY_PAIR = 12

FETCH_LAZY = 1

FETCH_NAMED = 11

FETCH_NUM = 3

FETCH_OBJ = 5

FETCH_ORI_ABS = 4

FETCH_ORI_FIRST = 2

FETCH_ORI_LAST = 3

FETCH_ORI_NEXT = 0

FETCH_ORI_PRIOR = 1

FETCH_ORI_REL = 5

FETCH_PROPS_LATE = 1048576

FETCH_SERIALIZE = 524288

FETCH_UNIQUE = 196608

MYSQL_ATTR_COMPRESS = 1006

MYSQL_ATTR_DIRECT_QUERY = 1007

MYSQL_ATTR_FOUND_ROWS = 1008

MYSQL_ATTR_IGNORE_SPACE = 1009

MYSQL_ATTR_INIT_COMMAND = 1002

MYSQL_ATTR_LOCAL_INFILE = 1001

MYSQL_ATTR_MAX_BUFFER_SIZE = 1005

MYSQL_ATTR_READ_DEFAULT_FILE = 1003

MYSQL_ATTR_READ_DEFAULT_GROUP = 1004

MYSQL_ATTR_USE_BUFFERED_QUERY = 1000

NULL_EMPTY_STRING = 1

NULL_NATURAL = 0

NULL_TO_STRING = 2

PARAM_BOOL = 5

PARAM_EVT_ALLOC = 0

PARAM_EVT_EXEC_POST = 3

PARAM_EVT_EXEC_PRE = 2

PARAM_EVT_FETCH_POST = 5

PARAM_EVT_FETCH_PRE = 4

PARAM_EVT_FREE = 1

PARAM_EVT_NORMALIZE = 6

PARAM_INPUT_OUTPUT = 2147483648

PARAM_INT = 1

PARAM_LOB = 3

PARAM_NULL = 0

PARAM_STMT = 4

PARAM_STR = 2

[ Top ]

Method Summary

boolean	createTable()	添加数据表
string	fieldMeta()	过滤SQL元数据，数据库对象(如表名字，字段等)
void	quote()
string	quoteArray()	过滤数组并将数组变量转换为sql字符串
string	quoteMultiArray()	过滤二维数组将数组变量转换为多组的sql字符串
void	setCharset()	设置连接数据库是所用的编码方式
string	sqlSingle()	过滤数组并组装单条 key=value 形式的SQL查询语句值(insert/update)
int	_getPdoDataType()	获得绑定参数的类型

[ Top ]

Methods

createTable [line 78]

boolean createTable(
string
$tableName, string|array
$values, [boolean
$replace = false] 
)

添加数据表

添加数据表<note>注意:最后一个参数'$replace',有两个取值'true,false',当值为false时表示如果数据表存在不创建新表, 值为true时则删除已经存在的数据表并创建新表</note>

Parameters:

string	$tableName:	数据表名称
string\|array	$values:	数据表字段信息
boolean	$replace:	如果表已经存在是否覆盖,接收两个值true\|false

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::createTable() : 创建数据表

[ Top ]

fieldMeta [line 42]

string fieldMeta(
array
$data 
)

过滤SQL元数据，数据库对象(如表名字，字段等)

Parameters:

array

$data:

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::fieldMeta()

[ Top ]

quote [line 31]

void quote(

$value, [
$type = null] 
)

Parameters:

	$value:
	$type:

API Tags:

Access:

public

Redefinition of:

PDO::quote ( $string, [$paramtype = ] )

[ Top ]

quoteArray [line 58]

string quoteArray(
array
$variable 
)

过滤数组并将数组变量转换为sql字符串

Parameters:

array

$variable:

需要组装的数据

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::quoteArray() : 过滤数组并将数组变量转换为sql字符串

[ Top ]

quoteMultiArray [line 66]

string quoteMultiArray(
array
$var 
)

过滤二维数组将数组变量转换为多组的sql字符串

Parameters:

array

$var:

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::quoteMultiArray() : 过滤二维数组将数组变量转换为多组的sql字符串

[ Top ]

setCharset [line 85]

void setCharset(
string
$charset 
)

设置连接数据库是所用的编码方式

Parameters:

string

$charset:

编码格式

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::setCharset()

[ Top ]

sqlSingle [line 50]

string sqlSingle(
array
$array 
)

过滤数组并组装单条 key=value 形式的SQL查询语句值(insert/update)

Parameters:

array

$array:

API Tags:

Abstract:
Access:	public

Redefined in descendants as:

WindMysqlPdoAdapter::sqlSingle() : 组装单条 key=value 形式的SQL查询语句值 insert/update

[ Top ]

_getPdoDataType [line 24]

int _getPdoDataType(
string
$variable 
)

获得绑定参数的类型

Parameters:

string

$variable:

API Tags:

Access:

protected

[ Top ]

Documentation generated on Fri, 30 Mar 2012 11:43:25 +0800 by phpDocumentor 1.4.4