Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3 as sql
- # Создаём базу
- base = sql.connect("test.sqlite")
- # Создаём курсор
- q = base.cursor()
- # Создание таблицы
- # q.execute('''CREATE TABLE Users (id int auto_increment primary key, name varchar, password varchar)''')
- # base.commit()
- user_name = input("Введи имя: ")
- user_password = input("Введи пас: ")
- print("Список пользователей:\n")
- q.execute("INSERT INTO Users (name, password) VALUES ('%s', '%s')"%(user_name, user_password))
- base.commit
- q.execute("SELECT * FROM Users")
- row = q.fetchone()
- while row is not None:
- print("Имя:", row[1], "| Пароль:", row[2])
- row = q.fetchone()
- # Отключение базы и курсора
- q.close()
- base.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement