Python 数据库操作

import MySQLdbconn=MySQLdb.connect(host='localhost',user='root',passwd='2077230',port=3306)conn.select_db('dept')cur=conn.cursor()value=[0,'hi rollen']cur.execute('insert into dept values(%s,%s)',value)conn.commit()count=cur.execute('select * from dept')print 'there has %s rows record' % countresult=cur.fetchone()print resultresults=cur.fetchmany(5)for r in results:    print r