CBSE COMPUTER SCIENCE
Open in Telegram
QUESTION BANK, REFERENCE BOOK, LAB MANUAL , WORKSHEET ETC., PYTHON TEXT BOOK AND REFERENCE BOOKS, 01. ASK QUESTIONS AT https://t.me/joinchat/FJ1noGs-64I0OWI1
Show more549
Subscribers
No data24 hours
No data7 days
No data30 days
Posts Archive
#Program to create a binary file to store Rollno and name
#Search for Rollno and display record if found
#otherwise "Roll no. not found"
import pickle
student=[]
#Binary file opened as Write Mode
f1=open('student.dat','ab')
ans=input("1.Add Record 2. Search Record 3. Exit (1/2/3) : ")
while ans=='1' or ans=='Y':
roll = int(input("Enter Roll Number : "))
name = input("Enter Name : ")
student.append([roll,name,"\n"])
pickle.dump(student,f1)
ans=input("Add More ?(Y/N)")
f1.close()
#Binary file opened as Read Mode
f2=open('student.dat','rb')
student=[]
student = pickle.load(f2)
while ans=='2' or ans=='Y':
f2.seek(0)
found=False
r = int(input("Enter Roll number to search : "))
for s in student:
if s[0]==r:
print(" Name is : ",s[1])
found=True
break
if not found:
print("####Sorry! Roll number not found ####")
ans=input("Search more ?(Y/N) : ")
f2.close()
print("Process is Over...")
import mysql.connector as mcr
try:
cn = mcr.connect(host='127.0.0.1',user='root',password="admin")
cr = cn.cursor()
cr.execute("create database company")
print("Databse Created Successfully...")
cn.commit()
except:
print("Database already exist...")
cn.close()
import mysql.connector as mcr
try:
cn = mcr.connect(host='127.0.0.1',user='root',password="admin",database='company')
cr = cn.cursor()
cr.execute("use company")
cr.execute("create table employee(empno int, name varchar(20), dept varchar(20),salary int)")
print("Table Created Successfully...")
cn.commit()
except:
print("Table already exist...")
cn.close()
import mysql.connector as mcr
try:
cn = mcr.connect(host='127.0.0.1',user='root',password="admin",database='company')
cr = cn.cursor()
cr.execute("use company")
cr.execute("show tables")
tables=cr.fetchall()
for record in tables:
print(record)
cn.commit()
except:
print("Table already exist...")
cn.close()
import mysql.connector as mcr
cn = mcr.connect(host='127.0.0.1',user='root',password="admin",database='company')
cr = cn.cursor()
cr.execute("use company")
cn.commit()
choice=int(input("1. ADD RECORD 2. UPDATE RECORD 3.DELETE RECORD 4. SEARCH 5.DISPLAY 6.EXIT : "))
while choice!=0:
if choice==1: #INSERTING A RECORD
e = int(input("Enter Employee Number :"))
n = input("Enter Name :")
d = input("Enter Department :")
s = int(input("Enter Salary :"))
query="insert into employee values({},'{}','{}',{})".format(e,n,d,s)
cr.execute(query)
cn.commit()
print("A RECORD INSERTED...")
elif choice == 2: #UPDATING A RECORD
eno=int(input("Enter employee number to be updated "))
sal=int(input("Enter salary to be updated "))
query="update employee set salary={} where empno={}".format(sal,eno)
cr.execute(query)
print("A Record Updated ")
cn.commit()
elif choice == 3: #DELETING A RECORD
eno=int(input("Enter employee number to be deleted"))
query="delete from employee where empno={}".format(eno)
cr.execute(query)
print("Record(s) Deleted ")
cn.commit()
elif choice == 4: #SEARCHING A RECORD
eno=int(input("Enter employee number to be searched"))
query="select * from employee where empno={}".format(eno)
cr.execute(query)
result = cr.fetchall()
if cr.rowcount==0:
print("Record not found")
else:
print("EMPNO","NAME","DEPARTMENT","SALARY")
for row in result:
print(row[0],row[1],row[2],row[3])
cn.commit()
elif choice == 5: #DISPLAYING RECORDS
query="select * from employee"
cr.execute(query)
result = cr.fetchall()
print("EMPNO","NAME","DEPARTMENT","SALARY")
for row in result:
print(row[0],row[1],row[2],row[3])
cn.commit()
elif choice==6: #CLOSING DATABASE
cn.close()
print("File closed successfully...")
break
else:
print("Invalid Choice...")
choice=int(input("1. ADD RECORD 2. UPDATE RECORD 3.DELETE RECORD 4. SEARCH 5.DISPLAY 6.EXIT : "))
#To create CSV File for storing empno, name and salary
import csv
with open('myfile.csv','a') as f1:
x = csv.writer(f1,delimiter=',')
ans='y'
while ans =='y' or ans=='Y':
eno=int(input("Enter Employee Number "))
name=input("Enter Employee Name ")
salary=int(input("Enter Employee Salary :"))
x.writerow([eno,name,salary])
print("## Data Saved... ##")
ans=input("Add More (Y/N):")
print("A CSV File created...")
with open('myfile.csv','r') as f2:
ans='y'
while ans=='y' or ans=='Y':
x = csv.reader(f2,delimiter=',')
found=False
n = int(input("Enter Employee Number to search :"))
for row in x:
if len(row)!=0:
if int(row[0])==n:
print("============================")
print("NAME :",row[1])
print("SALARY :",row[2])
found=True
break
if not found:
print("==========================")
print(" EMPNO NOT FOUND")
print("==========================")
f2.seek(0)
ans = input("Search More ? (Y/N):")
Dear Student.. Execute above programs in your pc/laptop... if u have any doubt ask/call me..
IF U HAVE ANY DOUBT POST YOUR QUESTIONS IN https://t.me/joinchat/FJ1noGs-64I0OWI1
import mysql.connector as mcr
cn = mcr.connect(host='127.0.0.1',user='root',password="admin",database='company')
cr = cn.cursor()
cr.execute("use company")
cn.commit()
choice=int(input("1. ADD RECORD 2. UPDATE RECORD 3.DELETE RECORD 4. SEARCH 5.DISPLAY 6.EXIT : "))
while choice!=0:
if choice==1: #INSERTING A RECORD
e = int(input("Enter Employee Number :"))
n = input("Enter Name :")
d = input("Enter Department :")
s = int(input("Enter Salary :"))
query="insert into employee values({},'{}','{}',{})".format(e,n,d,s)
cr.execute(query)
cn.commit()
print("A RECORD INSERTED...")
elif choice == 2: #UPDATING A RECORD
eno=int(input("Enter employee number to be updated "))
sal=int(input("Enter salary to be updated "))
query="update employee set salary={} where empno={}".format(sal,eno)
cr.execute(query)
print("A Record Updated ")
cn.commit()
elif choice == 3: #DELETING A RECORD
eno=int(input("Enter employee number to be deleted"))
query="delete from employee where empno={}".format(eno)
cr.execute(query)
print("Record(s) Deleted ")
cn.commit()
elif choice == 4: #SEARCHING A RECORD
eno=int(input("Enter employee number to be searched"))
query="select * from employee where empno={}".format(eno)
cr.execute(query)
result = cr.fetchall()
if cr.rowcount==0:
print("Record not found")
else:
print("EMPNO","NAME","DEPARTMENT","SALARY")
for row in result:
print(row[0],row[1],row[2],row[3])
cn.commit()
elif choice == 5: #DISPLAYING RECORDS
query="select * from employee"
cr.execute(query)
result = cr.fetchall()
print("EMPNO","NAME","DEPARTMENT","SALARY")
for row in result:
print(row[0],row[1],row[2],row[3])
cn.commit()
elif choice==6: #CLOSING DATABASE
cn.close()
print("File closed successfully...")
break
else:
print("Invalid Choice...")
choice=int(input("1. ADD RECORD 2. UPDATE RECORD 3.DELETE RECORD 4. SEARCH 5.DISPLAY 6.EXIT : "))
