## 增加 * 創建testInsert.py文件，向學生表中插入一條數據 * 下面是python2 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("insert into students(sname) values('張良')") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 修改 * 創建testUpdate.py文件，修改學生表的一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("update students set sname='劉邦' where id=6") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 刪除 * 創建testDelete.py文件，刪除學生表的一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("delete from students where id=6") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## sql語句參數化 * 創建testInsertParam.py文件，向學生表中插入一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() sname=raw_input("請輸入學生姓名：") params=[sname] count=cs1.execute('insert into students(sname) values(%s)',params) print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 其它語句 * cursor對象的execute()方法，也可以用于執行create table等語句 * 建議在開發之初，就創建好數據庫表結構，不要在這里執行 ## python3代碼 ~~~ #!/usr/bin/env python # -*- coding: utf-8 -*- ''' @Time : 5/14/18 11:17 PM @Author : haibo @File : Connection.py ''' from pymysql import * try: conn = connect(host="localhost", port=3306, user="root", passwd="haibo", db="python3", charset="utf8") cur1 = conn.cursor() # sql = "insert into student(name,birthday) values('李XX','1997-8-7')" # sql = "update student set name ='lihui' where id=7" sql = "delete from student where id=7" cur1.execute(sql) conn.commit() cur1.close() conn.close() except Exception as e: print(e.message) ~~~