python使用MySQLdb访问mysql数据库的方法
本文实例讲述了python使用MySQLdb访问mysql数据库的方法。分享给大家供大家参考。具体如下：
#!/usr/bin/python
importMySQLdb
defdoInsert(cursor,db):
#insert
#PrepareSQLquerytoINSERTarecordintothedatabase.
sql="UPDATEEMPLOYEESETAGE=AGE+1WHERESEX='%c'"%('M')
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
defdo_query(cursor,db):
sql="SELECT*FROMEMPLOYEE\
WHEREINCOME>'%d'"%(1000)
try:
#ExecutetheSQLcommand
cursor.execute(sql)
#Fetchalltherowsinalistoflists.
results=cursor.fetchall()
print'resuts',cursor.rowcount
forrowinresults:
fname=row[0]
lname=row[1]
age=row[2]
sex=row[3]
income=row[4]
#Nowprintfetchedresult
print"fname=%s,lname=%s,age=%d,sex=%s,income=%d"%\
(fname,lname,age,sex,income)
except:
print"Error:unabletofecthdata"
defdo_delete(cursor,db):
sql='DELETEFROMEMPLOYEEWHEREAGE>{}'.format(20)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
defdo_insert(cursor,db,firstname,lastname,age,sex,income):
sql="INSERTINTOEMPLOYEE(FIRST_NAME,\
LAST_NAME,AGE,SEX,INCOME)\
VALUES('%s','%s','%d','%c','%d')"%\
(firstname,lastname,age,sex,income)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
#Opendatabaseconnection
#changethistoyourmysqlaccount
#connect(server,username,password,db_name)
db=MySQLdb.connect("localhost","hunter","hunter","pydb")
#prepareacursorobjectusingcursor()method
cursor=db.cursor()
do_query(cursor,db)
doInsert(cursor,db)
do_query(cursor,db)
do_delete(cursor,db)
do_query(cursor,db)
do_insert(cursor,db,'hunter','xue',22,'M',2000)
do_insert(cursor,db,'mary','yang',22,'f',5555)
do_insert(cursor,db,'zhang','xue',32,'M',5000)
do_insert(cursor,db,'hunter','xue',22,'M',333)
do_query(cursor,db)
#disconnectfromserver
db.close()
希望本文所述对大家的Python程序设计有所帮助。
热门推荐
10 儿子立冬祝福语简短独特
11 对当兵的祝福语简短
12 侄儿高考试祝福语简短
13 伴郎红包祝福语朋友简短
14 媳妇生日简短祝福语朋友
15 公司年会祝福语简短最好
16 元旦感恩祝福语简短大全
17 红包祝福语简短10字
18 周六早晨祝福语简短