Advertisement
Guest User

Untitled

a guest
Aug 18th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. #!/usr/bin/python
  2. # -*- coding: utf-8 -*-
  3.  
  4. import sqlite3 as lite
  5. import sys
  6.  
  7. con = lite.connect('one.sqlite')
  8.  
  9. with con:
  10. cur = con.cursor()
  11. cur.execute("CREATE TABLE test(Name TEXT, login TEXT, pass TEXT)")
  12.  
  13. with con:
  14. a = raw_input('Ввести зеначение: ')
  15. b = raw_input('Ввести значение: ')
  16. c = raw_input('Пароль: ')
  17.  
  18. cur.execute("INSERT INTO test VALUES(a, b, c)")
  19.  
  20. con.close()
  21.  
  22. #!/usr/bin/python
  23. # -*- coding: utf-8 -*-
  24.  
  25. import sqlite3 as lite
  26. import sys
  27.  
  28. con = lite.connect('one.sqlite')
  29.  
  30. with con:
  31. cur = con.cursor()
  32. cur.execute("CREATE TABLE test(Name TEXT, login TEXT, pass TEXT)")
  33.  
  34. with con:
  35. a = raw_input('Ввести зеначение: ')
  36. b = raw_input('Ввести значение: ')
  37. c = raw_input('Пароль: ')
  38.  
  39. cur.execute("INSERT INTO test VALUES(?, ?, ?)", [a, b, c])
  40.  
  41. con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement