Das deutsche Python-Forum

Code: Alles auswählen

connection = sqlite3.connect("fdat.db")
cursor = connection.cursor ()

#Datensatz erzeugen
cursor = connection.cursor ()

#Tabelle erzeugen
sql = "CREATE TABLE fdat (" \
      "login TEXT, " \
      "password TEXT, " \
      "user TEXT, " \
      "vorname TEXT, " \
      "name TEXT)"
cursor.execute(sql)

#Datensatz erzeugen
sql = "INSERT INTO fdat VALUES ('rasburnd', "\
      "'g46b5', 'user01', 'Max', 'Abendstern')"
cursor.execute(sql)
connection.commit()

#Datensatz erzeugen
sql = "INSERT INTO fdat VALUES ('mdad',"\
      "'xfgj5d', 'user02', 'Mirijam', 'donad')"
cursor.execute(sql)
connection.commit()

#Datensatz erzeugen
sql = "INSERT INTO fdat VALUES ('dbande',"\
      "'g07856k', 'user03', 'Dirk', 'Bdande')"
cursor.execute(sql)
connection.commit()

#Datensatz erzeugen
sql = "INSERT INTO fdat VALUES ('rbosch', "\
      "'u785oTf7', 'user04', 'Rufus', 'bosch')"
cursor.execute(sql)
connection.commit()

connection = sqlite3.connect("fdat.db")
cursor = connection.cursor ()

#sql-Abfrage
sql ="SELECT * FROM fdat"

print(sql)
cursor.execute(sql)

for dsatz in cursor:
    print(dsatz[0],dsatz[1],dsatz[2], dsatz[3], dsatz[4])
    connection.close()

#Verbindung beenden
connection.close()