PythonMySQLdb模塊連接操作mysql數(shù)據(jù)庫實例

#-*- encoding: gb2312 -*-
import os, sys, string
import MySQLdb

# 連接數(shù)據(jù)庫　
try:
 conn = MySQLdb.connect(host='localhost',user='root',passwd='xxxx',db='test1')
except Exception, e:
 print e
 sys.exit()

# 獲取cursor對象來進(jìn)行操作

cursor = conn.cursor()
# 創(chuàng)建表
sql = "create table if not exists test1(name varchar(128) primary key, age int(4))"
cursor.execute(sql)
# 插入數(shù)據(jù)
sql = "insert into test1(name, age) values ('%s', %d)" % ("zhaowei", 23)
try:
 cursor.execute(sql)
except Exception, e:
 print e

sql = "insert into test1(name, age) values ('%s', %d)" % ("張三", 21)
try:
 cursor.execute(sql)
except Exception, e:
 print e
# 插入多條

sql = "insert into test1(name, age) values (%s, %s)" 
val = (("李四", 24), ("王五", 25), ("洪六", 26))
try:
 cursor.executemany(sql, val)
except Exception, e:
 print e

#查詢出數(shù)據(jù)
sql = "select * from test1"
cursor.execute(sql)
alldata = cursor.fetchall()
# 如果有數(shù)據(jù)返回，就循環(huán)