7,714
社区成员
发帖
与我相关
我的任务
分享
# -*- coding: cp936 -*-
import win32com.client
conn = win32com.client.Dispatch(r"ADODB.Connection")
DSN = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb ;Persist Security Info=False;Jet OLEDB:Database Password=123456' #test.mdb是access文件,123456是数据库的密码
conn.Open(DSN)
rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs_name = 'Employee'
rs.Open('[' + rs_name + ']', conn, 1, 3)
sql = "Update " + rs_name + " Set Name='咚咚' where ID = 11" #这里是sql语句
conn.Execute(sql) #执行sql语句
conn.Close()
import win32com.client
def listBrushCardInfo(condition):
conn = win32com.client.Dispatch(r"ADODB.Connection")
DSN = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb ;Persist Security Info=False;Jet OLEDB:Database Password=123456'
conn.Open(DSN)
rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs.Cursorlocation=3
rs_name = "SELECT Top 20 * FROM BrushCardInfo "+ condition + " order by Date desc,Time desc "
#这里sql语句与与mysql有点区别,例如取前20条,用top 20,不是用limit
rs.Open(rs_name, conn, 1, 3)
rs.MoveFirst()
for x in range(rs.RecordCount):
if rs.EOF:
print "End of records"
break
else:
print rs.Fields("Date").value,rs.Fields("Time").value,rs.Fields("Name").value,rs.Fields("color").value
rs.MoveNext()
conn.Close()