#!/usr/bin/env python# -*- coding:utf8 -*-import MySQLdbconn = MySQLdb.connect(host = '192.168.2.14',port = 3306,user = 'root',passwd = '123456',db = 'demo',)# 操作數(shù)據(jù)庫首先需要?jiǎng)?chuàng)建游標(biāo)cur = conn.cursor()# 通過游標(biāo)cur操作execute()方法可以寫入純sql語句，如下：# 創(chuàng)建數(shù)據(jù)表# cur.execute("create table teacher (id int(5),name varchar(20),class varchar(20),age varchar(10))")# 插入數(shù)據(jù)# cur.execute("insert into teacher values(23,'zhangsan','science',15)")# 修改數(shù)據(jù)# cur.execute("update teacher set id=100 where name='zhangsan'")# 刪除數(shù)據(jù)# cur.execute("delete from teacher where id=100")#插入一條數(shù)據(jù)【也可以用像下面這種寫法】sqli="insert into teacher values(%s,%s,%s,%s)"cur.execute(sqli, (23,'zhangsan','science',15))# 使用executemany一次性向數(shù)據(jù)表中插入多條值,返回值為受影響的行數(shù)。sqli="insert into teacher values(%s,%s,%s,%s)"cur.executemany(sqli,[(11,'wangwu','art',23),(8,'john','math',22),(3,'Tom','physical',25),])# 最后關(guān)閉游標(biāo)，執(zhí)行提交操作，并關(guān)閉數(shù)據(jù)庫連接cur.close()conn.commit()conn.close()

#!/usr/bin/env python# -*- coding:utf8 -*-import MySQLdbconn = MySQLdb.connect(host = '192.168.2.14',port = 3306,user = 'root',passwd = '123456',db = 'demo',)cur = conn.cursor()# 獲得表中有多少條數(shù)據(jù)aa = cur.execute("select * from teacher")cur.fetchone() # fetchone()方法可以幫我們獲得表中的數(shù)據(jù)，但是每執(zhí)行一次輸出一行滿足條件的值cur.fetchone()......cur.scroll(0,'absolute')# 這樣能將游標(biāo)定位到表中的第一條數(shù)據(jù)info = cur.fetchmany(aa)for i in info:print icur.close()conn.commit()conn.close()