- import win32com.client
- connexion = win32com.client.gencache.EnsureDispatch('ADODB.Connection')
- connexion.Open("Provider='SQLOLEDB';Data Source='myserver';Initial Catalog='mydatabase';User ID='mylogin';Password='mypassword';")
- recordset = connexion.Execute('SELECT clientid, clientName FROM clients')[0]
- while not recordset.EOF:
- print 'clientid=',recordset.Fields(0).Value,' client name=',recordset.Fields(1).Value
- recordset.MoveNext()
- connexion.Close()
- #该片段来自于http://www.codesnippet.cn/detail/110120131514.html
来源: http://www.codesnippet.cn/detail/110120131514.html