Skip to main content

Python MySQL CRUD Program

 Create python program to create,read,update and delete student details in MySQL database


import mysql.connector as p
con = p.connect(host="localhost",user="root",passwd="1234",database="useless")
if con.is_connected():
    print("Connection Established")
    cur = con.cursor()
    while True:
        print("Enter 1 to add new student")
        print("Enter 2 to update student details")
        print("Enter 3 to delete student")
        print("Enter 4 to show student list")
        print("Enter 5 to exit system")
        ch = int(input())
        if ch==1: #insert data into table
            ids = int(input("Enter the student id:"))
            name = input("Enter the student name:")
            cls = int(input("Enter student class:"))
            q = "insert into student(id,name,class) values({},'{}',{})".format(ids,name,cls)
            cur.execute(q)
            con.commit()
        elif ch==2:
            k = int(input("Enter 1 to change name\nEnter 2 to change class:\n"))
            if k==1:
                ids = int(input("Enter the student id:"))
                name = input("Enter the new name:")
                q = "update student set name='{}' where id={}".format(name,ids)
                cur.execute(q)
                con.commit()
            elif k==2:
                ids = int(input("Enter the student id:"))
                cls = int(input("Enter student class:"))
                q = "update student set class={} where id={}".format(cls,ids)
                cur.execute(q)
                con.commit()
            else:
                print("Wrong Option Selected")
        elif ch==3:
            ids = int(input("Enter the student id you want remove:"))
            q = "delete from student where id={}".format(ids)
            cur.execute(q)
            con.commit()
        elif ch==4:
            k = int(input("Enter 1 to display entire list\nEnter 2 to search by starting alphabet:\n"))
            if k==1:
                print("The records are:")
                q = "select * from student"
                cur.execute(q)
                data = cur.fetchall() #a list of tuples,where each tuple represents a row
                for i in data:
                    print(i)
            elif k==2:
                t=input("Enter the letter:")
                q = "select * from student where name like '{}%'".format(t)
                cur.execute(q)
                data = cur.fetchall()
                if data==[]:
                    print("No names found")
                else:
                    print("The names are:")
                    for i in data:
                        print(i)
            else:
                print("Wrong option selected")
        else:
            print("Thank You :D")
            con.close()
            break
else:
    print("Access Denied")

Labels

Labels:

Popular posts from this blog

Panagram ISC 2025 Specimen Practical Paper

import java.util.*; class panagram //ISC 2025 Practical Question {     //str for storing the sentence     String str;     panagram()     {         str="";     }     void accept()     {         Scanner sc=new Scanner(System.in);         System.out.println("Enter a sentence:");         str=sc.nextLine();     }     void panagramcheck()     {         int letters[]=new int[26];          StringTokenizer st=new StringTokenizer(str);         while(st.hasMoreTokens())         {             String w = st.nextToken().toUpperCase();             for(int i=65;i<=90;i++)             {                 for(int j=...
Read more

Program in Java: ISC Program CellPhone Keystrokes

import java.util.Scanner; public class Keypad {     public static void main(String args[])     {         //Array to hold keystrokes for each letter         int keys[] = new int[26];         //intialise         keys['A'-'A']=1; //A         keys['B'-'A']=2; //B         keys['C'-'A']=3; //C         keys['D'-'A']=1; //D         keys['E'-'A']=2; //E         keys['F'-'A']=3; //F         keys['G'-'A']=1; //G         keys['H'-'A']=2; //H         keys['I'-'A']=3; //I         keys['J'-'A']=1; //J         keys['K'-'A']=2; //K         keys['L'-'A']=3; //L         keys['M'-'A']=1; //M         keys['N'-'A']=2; //N       ...
Read more

ISC Program: Predict day of the week from date

Algorithm : 1)Take the last two digits of the year. 2)Divide by 4, discarding any fraction. 3)Add the day of the month. 4)Add the month's key value: JFM AMJ JAS OND 144 025 036 146 5)Subtract 1 for January or February of a leap year. 6)For a Gregorian date, add 0 for 1900's, 6 for 2000's, 4 for 1700's, 2 for 1800's; for other years, add or subtract multiples of 400. 7)For a Julian date, add 1 for 1700's, and 1 for every additional century you go back. 8)Add the last two digits of the year. 9)Divide by 7 and take the remainder. Example : Let's take a date: 26/03/2027 Last two digit of the year = 27 Divide by 4 discard fraction = 27/4 = 6.75 = 6 Add day = 6 + 26 = 32 Month key = 4 + 32 = 36 Add year code = 36 + 6 = 42 Now add two digits of the first year = 42 + 27 = 69 Now get the remainder after dividing by 7 = 69%7=6 So 1 is Sunday so 6 is Friday So 27/03/2027 Program : import java.util.Scanner; public class daydate {     public static void main(String[] arg...
Read more