使用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")