Skip to main content

GRADE XII - COMPUTER NETWORK

 


LINK:

https://drive.google.com/file/d/1ahqTMxX1lv3G_3XkI6oRhKKRFpaZGvzj/view?usp=drive_link

Comments

Popular posts from this blog

GRADE XII - Python Connectivity with MySQL

  Python Connectivity with MySQL In real-life applications, the data inputted by the user and processed by the application needs to be saved permanently, so that it can be used for future manipulation. Usually, input and output data is displayed during execution but not stored, as it resides in main memory , which is temporary — i.e., it gets erased once the application is closed. This limitation can be overcome by sending the data to be stored in a database , which is made accessible to the user through a Front-End interface . Key Concepts Database A database is an organized collection of data that is stored and accessed electronically from a computer system. DBMS (Database Management System) A DBMS is software that interacts with end-users, applications, and the database to capture and analyze data. Front-End The Front-End is the user interface of the application, responsible for input/output interaction with the user. Back-End The Back-End refe...

GRADE XII - MYSQL CONNECTIVITY WITH PYTHON

  GRADE XII - MYSQL CONNECTIVITY WITH PYTHON SOURCE CODE : #ADD TO DATABASE import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) mycursor=mydb.cursor() v1=input("enter GROCERY ID:") v2=input("enter GROCERY NAME:") v3=int(input("enter PRICE:")) v4=int(input("enter QUANTITY:")) sql='insert into GRO values("%s","%s","%d","%d")'%(v1,v2,v3,v4)  #print(sql) mycursor.execute(sql) mydb.commit() print("*********Grocery Added To Database Successfully*****") #TO VIEW DATA sql="select * from gro" mycursor.execute(sql) res=mycursor.fetchall() print("The AVAILABLE GROCERY details are as follows : ") print("G_ID    NAME     PRICE   QUANTITY") print("\n##*************************************** ************ ##") for x in res:         print(x) print("\n##**...