-
Notifications
You must be signed in to change notification settings - Fork 2
/
project1_backend.py
47 lines (45 loc) · 2.4 KB
/
project1_backend.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
import mysql.connector
#import project1_frontend
def studentData():
con = mysql.connector.connect(host="localhost",user="root",passwd="#password",database="project")
cur=con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS srikanth(id integer primary key AUTO_INCREMENT,StdID text,Firstname text,Surname text,DoB text,Age text,Gender text,Address text,Mobile text)")
con.commit()
con.close()
def addStdRec(StdID,Firstname,Surname,DoB,Age,Gender,Address,Mobile):
con=con = mysql.connector.connect(host="localhost",user="root",passwd="#password")
cur=con.cursor()
cur.execute("use project")
cur.execute("INSERT INTO srikanth VALUES(NULL,%s,%s,%s,%s,%s,%s,%s,%s)",(StdID,Firstname,Surname,DoB,Age,Gender,Address,Mobile))
con.commit()
con.close()
def viewData():
con=con = mysql.connector.connect(host="localhost",user="root",passwd="#password")
cur=con.cursor()
cur.execute("use project")
cur.execute("select * from srikanth")
row=cur.fetchall()
con.close()
return row
def deleteRec(id):
con=con = mysql.connector.connect(host="localhost",user="root",passwd="#password")
cur=con.cursor()
cur.execute("use project")
cur.execute("DELETE FROM srikanth WHERE id=%s",(id,))
con.commit()
con.close()
def searchData(StdID,Firstname,Surname,DoB,Age,Gender,Address,Mobile):
con=con = mysql.connector.connect(host="localhost",user="root",passwd="#password")
cur=con.cursor()
cur.execute("use project")
cur.execute("SELECT * FROM srikanth WHERE StdID=%s or Firstname=%s or Surname=%s or DoB=%s or Age=%s or Gender=%s or Address=%s or Mobile=%s",(StdID,Firstname,Surname,DoB,Age,Gender,Address,Mobile))
rows=cur.fetchall()
con.close()
return rows
def dataUpdate(id,StdID="",Firstname="",Surname="",DoB="",Age="",Gender="",Address="",Mobile=""):
con = mysql.connector.connect(host="localhost",user="root",passwd="#password")
cur=con.cursor()
cur.execute("use project")
cur.execute("UPDATE srkanth SET StdID=%s,Firstname=%s,Surname=%s,DoB=%s,Age=%s,Gender=%s,Address=%s,Mobile=%s WHERE id=%s",(StdID,Firstname,Surname,DoB,Age,Gender,Address,Mobile))
con.commit()
con.close()