IronPython连接MySQL的方法步骤

import clr
clr.AddReference("MySql.Data.dll")
from MySql.Data.MySqlClient import * 

conStr = 'server=%s; user id=%s; password=%s; database=%s; pooling=false; charset=gbk' % (host, user, passwd, db) 
db = MySqlConnection(conStr) 
db.Open() 
 

sqlStr = "INSERT INTO ..." 
cmd = MySqlCommand(sqlStr, db) 
rows = cmd.ExecuteNonQuery() 

cmd = self.db.CreateCommand () 
cmd.CommandText = "SELECT ..." 
r = cmd.ExecuteReader () 
tagList = [] 
while r.Read (): 
  tagList.append(r['rfidLabel']) 
r.Close () 
return tag in tagList 

db.Close ()