[Python] Query Access using ADO in win32 platform
#!C:\Python22\python.exe
print "Content-type:text/html\n\n"
import win32com.client
NUM_ROWS=2155
#db='E:\Workarea\\Northwind.mdb'
db='C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb'
def connect(qry):
con=win32com.client.Dispatch('ADODB.Connection')
rs=win32com.client.Dispatch('ADODB.recordset')
con.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+db)
sql=qry +";"
rs=con.Execute(sql)
con.Close
return rs
def display (NUM_ROWS):
print "<table border=1>"
print "<th>Order ID</th>"
print "<th>Product</th>"
print "<th>Unit Price</th>"
print "<th>Quantity</th>"
print "<th>Discount</th>"
for k in range(0,NUM_ROWS):
print "<tr>"
for i in s:
print "<td>",i[k],"</td>"
print "</tr>"
print "</table>"
rs=win32com.client.Dispatch('ADODB.recordset')
rs=connect("select * from [Order details]")
s=rs[0].GetRows(NUM_ROWS)
display(NUM_ROWS)
rs[0].Close
print "Content-type:text/html\n\n"
import win32com.client
NUM_ROWS=2155
#db='E:\Workarea\\Northwind.mdb'
db='C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb'
def connect(qry):
con=win32com.client.Dispatch('ADODB.Connection')
rs=win32com.client.Dispatch('ADODB.recordset')
con.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+db)
sql=qry +";"
rs=con.Execute(sql)
con.Close
return rs
def display (NUM_ROWS):
print "<table border=1>"
print "<th>Order ID</th>"
print "<th>Product</th>"
print "<th>Unit Price</th>"
print "<th>Quantity</th>"
print "<th>Discount</th>"
for k in range(0,NUM_ROWS):
print "<tr>"
for i in s:
print "<td>",i[k],"</td>"
print "</tr>"
print "</table>"
rs=win32com.client.Dispatch('ADODB.recordset')
rs=connect("select * from [Order details]")
s=rs[0].GetRows(NUM_ROWS)
display(NUM_ROWS)
rs[0].Close