Advertisement
Guest User

Question

a guest
Jan 1st, 2019
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.77 KB | None | 0 0
  1. import sqlite3 as sql
  2.  
  3. # Создаём базу
  4. base = sql.connect("test.sqlite")
  5. # Создаём курсор
  6. q = base.cursor()
  7.  
  8. # Создание таблицы
  9. # q.execute('''CREATE TABLE Users (id int auto_increment primary key, name varchar, password varchar)''')
  10. # base.commit()
  11.  
  12. user_name = input("Введи имя: ")
  13. user_password = input("Введи пас: ")
  14.  
  15. print("Список пользователей:\n")
  16. q.execute("INSERT INTO Users (name, password) VALUES ('%s', '%s')"%(user_name, user_password))
  17. base.commit
  18.  
  19. q.execute("SELECT * FROM Users")
  20. row = q.fetchone()
  21.  
  22. while row is not None:
  23.     print("Имя:", row[1], "| Пароль:", row[2])
  24.     row = q.fetchone()
  25.  
  26. # Отключение базы и курсора
  27. q.close()
  28. base.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement