Python connection to MySQL database small phone book written

Source: Internet
Author: User

First of all, put the code here, and then have time to explain the problems in the program,

This small program knowledge to implement the function, and there is not much to the layout of the pursuit of

Some comments are not deleted, and there is no function to wrap up, looking at the whole

It should be a little messy.

The following is the complete code,

ImportTkinterImportPymysql fromTkinterImport* fromTkinterImportTtkwindow=tkinter. Tk ()#Create WindowWindow.title ("Phone book")#Set TitleWindow.geometry ('500x500+500+200')#Set the size offsetWindow.resizable (Width=false,height=false)#disable wide-heightDatabase = Pymysql.connect (host="localhost", user="Root", password="******", DB="Phonebook", port=3306, charset="UTF8") Listn=TTK. Treeview (window) listn=TTK. Treeview (window,show="headings", height=10,columns= ("a","b","C","D"))#listn["Columns"]= ("a", "B", "C", "D")Listn.column ("a", width=60) Listn.column ("b", width=100) Listn.column ("C", width=120) Listn.column ("D", width=200) listn.heading ("a", text="name") listn.heading ("b", text="Telephone") listn.heading ("C", text="Email") listn.heading ("D", text="Address") listn["SelectMode"]="Browse"defDeleteinfo (name,phone): Sql_delete=r"Delete from info where name= '%s '"R"and phone= '%s ';"%(name,phone) cur=database.cursor ()Try: Cur.execute (sql_delete) database.commit ()exceptException as E:database.rollback () cur.close ()defListall (): Sql_sel_all="SELECT * from info;"cur=database.cursor ()Try: Cur.execute (sql_sel_all) Results=Cur.fetchall ()#print ("name", "Phone", "Mailbox", "Address")        #first delete the original node data in the table         for_inchMap (Listn.delete,listn.get_children ("")):            PassII=0 forRowinchResults:name=row[0] Phone=row[1] Mail=row[2] Address=row[3]            #print (name,phone,mail,address)Listn.insert ("", ii,text=ii+1,values=(name,phone,mail,address)) II=ii+1exceptException as E:Raisee cur.close ()defInsertinfo (name,phone,mail=none,address=None): Sql_insert=r"INSERT INTO info (name,phone,"R"mail,address) VALUES ('%s ', '%s ', '%s ',"R"'%s ');"%(name,phone,mail,address) cur=database.cursor ()Try: Cur.execute (Sql_insert) database.commit ()exceptException as E:database.rollback () cur.close ()defNodes (): Notenote1="Description:"Notenote2="Enter your name and phone at least when you add a contact"Notenote3="mailbox and address can be omitted, you can add the same name"notenote4="but can not add the same name, the same telephone information"Notenote5="simply select the item you want to delete, then click"Notenote6="Delete contact button to delete"note1=label (window,text=notenote1) Note1.pack () Label (Window,text=notenote2). Pack () Label (Window,text=notenote3). Pack () Label (Window,text=notenote4). Pack () Label (Window,text=notenote5). Pack () Label (Window,text=notenote6). Pack ()Pass#Creating child windowsdefZwindow (): Zwin=Tkinter. Tk () Zwin.title ("Add") Zwin.geometry ('350x200+520+350') zwin.resizable (width=false,height=False) Ln=label (zwin,text="name") Lp=label (zwin,text="Telephone") Lm=label (zwin,text="Email") La=label (zwin,text="Address") Ln.grid (Row=0) Lp.grid (row=1) Lm.grid (Row=2) La.grid (Row=3) E1=Entry (Zwin) E2=Entry (Zwin) E3=Entry (Zwin) E4=Entry (Zwin) e1.grid (Row=0,column=1) E2.grid (Row=1,column=1) E3.grid (Row=2,column=1) E4.grid (Row=3,column=1)    defInserti (): Insertinfo (E1.get (), E2.get (), E3.get (), E4.get ()) Zwin.destroy () Listall () Ybutto N=button (zwin,text='Determine', command=Inserti) Nbutton=button (zwin,text='Cancel', command=Zwin.destroy) Ybutton.grid (Row=4,column=1,padx=3) Nbutton.grid (Row=4,column=2)defDelete ():#listn.Items=listn.selection ()#returns the ID of the selected rowDelete_name=listn.item (items) ["Values"][0] Delete_phone=listn.item (items) ["Values"][1]    #print (items)    #Print (Listn.item (items))    #print (delete_name)    #print (Delete_phone)deleteinfo (Delete_name,delete_phone) listall ()PassINSERTB=button (window,text='Add a contact person', command=Zwindow) Deleteb=button (window,text='Delete a contact', command=Delete) Listall () Listn.pack () Insertb.pack () Deleteb.pack () Nodes () Window.mainloop ()

Also attached is a code to practice connecting to the database:

#coding = Utf-8ImportPymysql#connecting to a databaseDatabase=pymysql.connect (host="localhost", user="Root", password="******", DB="Pydata", port=3306) cur=database.cursor ()Print("#1. Querying the database First") SQL="SELECT * FROM Info"Try: Cur.execute (SQL) Results=Cur.fetchall ()Print("name","ID")     forRowinchResults:name=row[0] ID=row[1]        Print(Name,id)exceptException as E:RaiseePrint("#2. Inserting Data") Sql_in_name=input ("Please enter the name you want to insert:") sql_in_id=input ("Please enter the ID you want to insert:") Sql_insert=r"INSERT into info (name,id) VALUES ('%s ', '%s ');"%(sql_in_name,sql_in_id)Try: Cur.execute (Sql_insert) database.commit ()exceptException as E:database.rollback ()Print("Verify Insert")Try: Cur.execute (SQL) Results=Cur.fetchall ()#print ("name", "ID")     forRowinchResults:name=row[0] ID=row[1]        Print(Name,id)exceptException as E:RaiseE

Python connection to MySQL database small phone book written

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.