www.pudn.com > Vocabulary_python_mySQL.rar > t.py

import MySQLdb 
import sys 
try: 
        conn = MySQLdb.connect(host = "localhost", user = "root", passwd = "myDBpass", db = "abc")   
except MySQLdb.Error, e: 
        print "error %d: %s" % (e.args[0], e.args[1]) 
        sys.exit(1) 
try: 
    reload(sys) 
    sys.setdefaultencoding('gb2312') 
 
    cursor = conn.cursor() 
     
    cursor.execute("drop table t") 
    cursor.execute("create table t (id int(2),name varchar(20))") 
     
    #conn.begin() 
    cursor.execute('START TRANSACTION') 
     
    cursor.execute('insert into t (id,name) values (34,%s)',('²âÊÔ1')) 
    cursor.execute('insert into t (id,name) values (33,%s)',('²âÊÔ2')) 
     
    cursor.execute('commit') 
     
     
    cursor.execute("select id,name from t") 
    data = cursor.fetchall()  
    for i  in  data: 
        id,name = i 
        name = name.decode('utf-8') 
     
        print data 
        print id,name 
      
except MySQLdb.Error, e: 
         print "error %d: %s" % (e.args[0], e.args[1]) 
     
cursor.close()     
conn.close()