#-*-coding:utf-8-*-
##########################
#
# by adengou 2016-01-02
# programe:python3.4.4
#
##########################
import os
import json
import win32com.client
#-------------access数据模块--------------
class Access_Model:
def __init__(self,dataUrl):
self.dataUrl =dataUrl
###定义conn
def db_conn(self):
conn = win32com.client.Dispatch(r'ADODB.Connection')
dns = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='+self.dataUrl
conn.Open(dns)
return conn
####定义rs
def db_rs(self):
rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs.CursorType = 1;
rs.CursorLocation = 3 # don't use parenthesis here
rs.LockType = 3;#可读可写模式