index
inc/config
inc/config.bak
inc/wts
inc/class/cache
inc/class/cookie
inc/class/db <--
inc/class/error
inc/class/fso
inc/class/function
inc/class/js
inc/class/load
inc/class/log
inc/class/pagelist
inc/class/request
inc/class/response
inc/class/route
inc/class/session
inc/class/template
inc/class/valid
inc/class/crypt/a2u
inc/class/crypt/aes
inc/class/crypt/base64
inc/class/crypt/des
inc/class/crypt/escape
inc/class/crypt/hex
inc/class/crypt/md5
inc/class/crypt/num
inc/class/crypt/rsa
inc/class/crypt/sha
inc/class/ext/array
inc/class/ext/cart
inc/class/ext/date
inc/class/ext/http
inc/class/ext/jmail
inc/class/ext/jpeg
inc/class/ext/json
inc/class/ext/jsont
inc/class/ext/mail
inc/class/ext/md5
inc/class/ext/pack
inc/class/ext/stringbuilder
inc/class/ext/tqqwry
inc/class/ext/upfile
inc/class/ext/verify
inc/class/ext/webstat
inc/class/ext/wia
inc/class/ext/xml
inc/class/ext/zip
inc/class/route/module
inc/class/route/slash
inc/module/default/control/clear
inc/module/default/control/crypt
inc/module/default/control/error
inc/module/default/control/hello
inc/module/default/control/index
inc/module/default/control/json
inc/module/default/control/pic
inc/module/default/control/upload
inc/module/default/control/start/site
inc/module/default/control/start/route/key
inc/module/default/control/start/route/pic
inc/module/default/control/start/route/reg
inc/module/default/control/tag/hello
inc/module/default/language/cn/hello
inc/module/default/language/en/hello
inc/module/default/model/hello
inc/module/help/control/error
inc/module/help/control/index
inc/module/help/control/install
inc/module/help/control/start/site

类描述

title Class_DB
author ekede.com
date 2017-11-29
description 数据库操作类

类属性

conn 数据库连接

类方法

OpenConn(db_type, db_path,db_version, db_name, db_user, db_pass) 打开数据库连接
CloseConn() 关闭数据库连接
Query(ByRef sTable,ByRef sFileds,ByRef sWhere,ByRef sOrder,ByRef sGroup,ByRef sCursorType,ByRef sLockType) 查 - 返回Recordset对象
Add(ByRef sTable,ByRef sFileds,ByRef sValues) 增 - 返回id
Edit(ByRef sTable,ByRef sFileds,ByRef sValues,ByRef sWhere) 改 - 返回状态
Del(ByRef sTable,ByRef sWhere) 删 - 返回状态
AutoId(ByRef TableName)自动ID
SqlQuery(ByRef sTable,ByRef sFileds,ByRef sWhere,ByRef sOrder,ByRef sGroup) sql语句查询
SqlAdd(ByRef sTable,ByRef sFileds,ByRef sValues) sql语句添加
SqlEdit(ByRef sTable,ByRef sFileds,ByRef sValues,ByRef sWhere) sql语句修改
SqlDel(ByRef sTable,ByRef sWhere) sql语句删除
SqlExecute(ByRef sql) sql语句执行
CreateAccess(ByRef db_name) 创建Access数据库
CompactAccess(ByRef db1,ByRef db2) 压缩Access数据库

返回