使用mysql-connector-python操作MYSQL数据库

#!/usr/bin/python
# encoding:utf-8

# 需要依赖mysql客户端： pip install mysql-connector-python

import os, sys, string
import mysql.connector
import sys
sys.setdefaultencoding('utf-8')

def main():
# connect to mysql
try:
conn = mysql.connector.connect(host='10.201.*.*', user='root', passwd='root', db='dbname')
except Exception, e:
print e
sys.exit()

# get cursor
cursor = conn.cursor()
# create table
dropSql='drop table product'
createSql = 'create table if not exists product(Prd_name varchar(128) primary key, Count int(4))'
cursor.execute(dropSql)
cursor.execute(createSql)

# insert one data
sql = "insert into product(Prd_name, Count) values('%s', %d)" % ("ATG", 200)

try:
cursor.execute(sql)
except Exception, e:
print e

# insert some datas
sql = "insert into product(Prd_name, Count) values(%s, %s)"
val = (("PPS", 400), ("暗恋我", 150), ("你好测试1", 25))

try:
cursor.executemany(sql, val)
except Exception, e:
print e

conn.commit()
# quary data
sql = "select * from product"
cursor.execute(sql)
alldata = cursor.fetchall()
# print data
if alldata:
for rec in alldata:
print rec[0], rec[1]

cursor.close()
conn.close()

if __name__ == "__main__":
main()
print("\nIt's OK")