| 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数据库
|