import MySQLdb

#!/usr/bin/python
# coding:utf-8

import MySQLdb

try:
    # 获取数据库连接
    conn = MySQLdb.connect(host='221.6.35.18',user='root',passwd='root',db='testdb',port=53306)
    # 可以在运行时指定db
    # conn.select_db('mydb')
    # 获取游标
    cur = conn.cursor()

    # --------- 查询 ---------
    posts = cur.execute('select * from account')
    # 这里只是输出总条目数
    print posts
    # 打印输出游标第一行数据
    print cur.fetchone()
    # 遍历游标所有结果集
    # postList = cur.fetchall()
    # postlist = cur.fetchmany(5)
    postList = cur.fetchmany(posts)
    for post in postList:
        print post

    # -------- 新增 ---------
    cur.execute('insert into account values (4, "ddd", "[email protected]")')
    # -------- 批量新增 ---------
    sql = 'insert into account values (%s, %s, %s)'
    cur.executemany(sql,[
        (5, 'eee', '[email protected]'),
        (6, 'fff', '[email protected]'),
        (7, 'ggg', '[email protected]')
    ])

    # -------- 更新 ---------
    cur.execute('update account set name = "ooo" where id = 7')
    # -------- 删除 ---------
    cur.execute('delete from account where id = 6')

    # 关闭游标
    cur.close()
    # 提交更新
    conn.commit()
    # 关闭数据库
    conn.close()
except MySQLdb.Error, e:
    print "Mysql Error %d: %s" % (e.args[0], e.args[1])