【脚本语言系列】关于Python数据库访问DAO, 你需要知道的事

如何使用DAO

# -*- coding:utf-8 -*-import win32com.clientengine = win32com.client.Dispatch("DAO.DBEngine.36")db = engine.OpenDatabase(r"addresses.mdb")rs = db.OpenRecordset("address")rs = db.OpenRecordset("select * from address")# insert the datadb.Execute('''insert into address(name, address, createtime)values("am","shanghai","1990-01-01")''')while not rs.EOF:    print (rs.Fields("address").Value).encode("utf-8")    rs.MoveNext()

----------------------------------------------------------------------com_error                            Traceback (most recent call last)<ipython-input-7-be7d7f19dd76> in <module>()      4 engine = win32com.client.Dispatch("DAO.DBEngine.36")      5 db = engine.OpenDatabase(r"addresses.mdb")----> 6 rs = db.OpenRecordset("address")      7 rs = db.OpenRecordset("select * from address")      8 # insert the datac:\python27\lib\site-packages\win32com\client\dynamic.pyc in OpenRecordset(self, Name, Type, Options, LockEdit)com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, u'DAO.Database', u"Microsoft Jet \u6570\u636e\u5e93\u5f15\u64ce\u627e\u4e0d\u5230\u8f93\u5165\u8868\u6216\u67e5\u8be2 'address'\u3002 \u786e\u5b9a\u5b83\u662f\u5426\u5b58\u5728\uff0c\u4ee5\u53ca\u5b83\u7684\u540d\u79f0\u7684\u62fc\u5199\u662f\u5426\u6b63\u786e\u3002", u'jeterr40.chm', 5003078, -2146825210), None)

什么是DAO

DAO(Data Access Object)具有面向对象的接口，提供了Microsoft Jet数据库引擎。
DAO模型是设计关系数据库系统结构的对象类的集合。