Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- CreateDataBase = sqlite3.connect('Student_Database.db')
- QueryCurs = CreateDataBase.cursor()
- def CreateTable():
- QueryCurs.execute('''CREATE TABLE Info
- (Roll INTEGER PRIMARY KEY, Name TEXT)''')
- def AddEntry(Roll,Name):
- QueryCurs.execute('''INSERT INTO Info (Roll,Name)
- VALUES (?,?)''',(Roll,Name))
- CreateTable()
- Students = int(input("Enter Number of students "))
- for i in range(1, Students +1):
- Data = input(f"Enter Name {i} : \n")
- Roll = input(f"Enter Roll number {i} : \n")
- AddEntry(Roll, Data)
- CreateDataBase.commit()
- QueryCurs.execute('SELECT * FROM Info')
- for i in QueryCurs:
- print("\n")
- for j in i:
- print(j)
- QueryCurs.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement