#!/usr/bin/env python
# -*- coding:utf8 -*-
import MySQLdb
conn = MySQLdb.connect(
host = '192.168.2.14',
port = 3306,
user = 'root',
passwd = '123456',
db = 'demo',
)
# 操作數(shù)據(jù)庫(kù)首先需要?jiǎng)?chuàng)建游標(biāo)
cur = conn.cursor()
# 通過(guò)游標(biāo)cur操作execute()方法可以寫(xiě)入純sql語(yǔ)句，如下：
# 創(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ù)【也可以用像下面這種寫(xiě)法】
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ù)庫(kù)連接
cur.close()
conn.commit()
conn.close()

#!/usr/bin/env python
# -*- coding:utf8 -*-
import MySQLdb
conn = 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 i
cur.close()
conn.commit()
conn.close()