37,721
社区成员
发帖
与我相关
我的任务
分享
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import os, sys
import MySQLdb
# 连接数据库
try:
conn = MySQLdb.connect(host='192.168.xx.xxx',user='xxx',passwd='xxx',db='xxx')
except Exception, e:
print e
sys.exit()
cursor = conn.cursor()
sql = "insert into address(name, address) values (%s, %s)"
values = (("张小三", "北京海淀区"), ("李小四", "北京海淀区"), ("王小五", "北京海淀区"))
try:
cursor.executemany(sql, values) # 插入多条数据
except Exception, e:
print e
sql = "select * from country"
cursor.execute(sql) # 查询数据
data = cursor.fetchall()
if data:
for x in data:
print x[0], x[1]
cursor.close() # 关闭游标
conn.close() # 关闭数据库