pythondb操作

import MySQLdb# connect to dbconn = MySQLdb.connect("localhost","root","123456","test2")# create cursorcur=conn.cursor()username=raw_input("please input your name:")# sql sql ="select * from user"insert_sql="insert into user (username) values ('%s')" %(username)# executecur.execute(insert_sql)conn.commit()cur.execute(sql)# get the resultresult=cur.fetchall()for row in result:   print "id:"+str(row[0])+"---"+"username:"+str(row[1])+"---"+"password:"+str(row[2])conn.close()raw_input()