python基本 -- mysql 的使用

# 引入 MySQLdb包
import MySQLdb

# 连接数据库
conn = MySQLdb.connect(
            host='localhost',         # 主机名
            user='root',              # 用户名
            passwd='12345',           # 密码
            db='douban',              # 数据库名
            port=3306,                # 端口
            charset='utf8'            # 编码
        )
# 获取数据库操作游标
cursor = conn.cursor()

# 写入数据
sql = 'insert into movie(name, score, time) values(%s, %s, %s)'
param = ('The Shawshank Redemption', 9.6, 1994)
n = cursor.execute(sql, param)        # 会返回执行操作的条数

# 更新数据
sql = 'update movie set name = %s where id = %s'
param = ('The Shawshank Redemption', 1)
n = cursor.execute(sql, param)

# 查询数据
sql = 'select * from movie'
n = cursor.execute(sql)
cursor.fetchall()                     # 会返回所有的结果集,tuple元组型 
for row in cursor.fetchall():
    for r in row:
        print r

# 删除操作
sql = 'delete from movie where id = %s'
param = (1)
n = cursor.execute(sql, param)

# 最后，关闭游标
cursor.close()
# 提交事务
conn.commit()
# 关闭连接
conn.close()