Advertisement
IT45200

Untitled

May 21st, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.71 KB | None | 0 0
  1. import sqlite3
  2.  
  3. CreateDataBase = sqlite3.connect('Student_Database.db')
  4.  
  5. QueryCurs = CreateDataBase.cursor()
  6.  
  7. def CreateTable():
  8.     QueryCurs.execute('''CREATE TABLE Info
  9.    (Roll INTEGER PRIMARY KEY, Name TEXT)''')
  10.  
  11. def AddEntry(Roll,Name):
  12.     QueryCurs.execute('''INSERT INTO Info (Roll,Name)
  13.    VALUES (?,?)''',(Roll,Name))
  14.  
  15. CreateTable()
  16.  
  17. Students = int(input("Enter Number of students "))
  18. for i in range(1, Students +1):
  19.     Data = input(f"Enter Name {i} : \n")
  20.     Roll = input(f"Enter Roll number {i} : \n")
  21.     AddEntry(Roll, Data)
  22.  
  23.  
  24.  
  25. CreateDataBase.commit()
  26.  
  27. QueryCurs.execute('SELECT * FROM Info')
  28.  
  29. for i in QueryCurs:
  30.     print("\n")
  31.     for j in i:
  32.         print(j)
  33.  
  34. QueryCurs.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement