Code: Alles auswählen
import sys,string
import sapdb,dbm
def connection():
user = 'Test'
pwd = 'test'
dbname = 'Test'
host = 'localhost'
session = sapdb.connect(string.upper(user), pwd, dbname, host) # Es wird eine Verbindung zur Datenbank hergestellt.
select(session,'select * from T_CONFIGURATION')
session.release() # Beendet die Datenbankverbindung
def select(session,sql):
result = session.sql(sql)
print result
desc = result.getDescription()
for i in desc:
print i[0] +'\t' ,
print
for i in result:
print i[0], i[1], i[2], i[3],i[4]
connection()
Greetz from 2bock