mysql

#coding=utf-8
try: 
  import xml.etree.cElementTree as ET 
except ImportError: 
  import xml.etree.ElementTree as ET 
import sys 




import MySQLdb


try: 
  tree = ET.parse("key.xml")     #打开xml文档 
  #root = ET.fromstring(country_string) #从字符串传递xml 
  root = tree.getroot()         #获得root节点  
except Exception, e: 
  print "Error:cannot parse file:country.xml."
  sys.exit(1) 
  
print "*"*10
for key_id in root.findall('ProductKeyID'):
  key_id = str(key_id.text) 
  print key_id
for key_state in root.findall('ProductKeyState'): 
  key_state = str(key_state.text)    
  print key_state 
for key_hash in root.findall('HardwareHash'):
  key_hash = str(key_hash.text)
  print key_hash 
print "*"*10


strr="ddd"


def create_table():    
    try:  
        create_tb_cmd='''
        CREATE TABLE IF NOT EXISTS PRODUCT_KEY 
        (ID TEXT, 
        STATE TEXT, 
        HASH TEXT); 
        '''  
        #主要就是上面的语句  
        cursor.execute(create_tb_cmd)  
    except:  
        pass
#print "Create table failed"  
        #return False  
#key_id="1"
#key_state="1"
#key_hash="1"

    insert_dt_cmd="INSERT INTO PRODUCT_KEY (ID, STATE, HASH) VALUES ('%s', '%s', '%s');" %(key_id, key_state, key_hash)
    cursor.execute(insert_dt_cmd)  
    db.commit()


    cursor.close()  


# 打开数据库连接
db = MySQLdb.connect("localhost","root","123456","TESTDB" )


# 使用cursor()方法获取操作游标 
cursor = db.cursor()


# 使用execute方法执行SQL语句
cursor.execute("SELECT VERSION()")


# 使用 fetchone() 方法获取一条数据
data = cursor.fetchone()


print "Database version : %s " % data


create_table();


# 关闭数据库连接
db.close()