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

#!/usr/bin/python 
import MySQLdb 
import sys 
#导入python2.4-mysqldb模块，以提供操作mysql的接口 
initialize=""" 
drop database abc; 
create database if not exists abc; 
use abc; 
drop table if exists pinYin; 
create table pinYin( 
   id int primary key auto_increment not null, 
   hanZi varchar(8) not null, 
   pinYin varchar(10) not null, 
   shengDiao tinyint default 1, 
   priority float default 1.0); 
""" 
#conn = MySQLdb.connect("localhost", db_user, db_pw ,"abc") 
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("SET NAMES 'gbk'") 
       cursor.execute(initialize) 
       cursor.execute('START TRANSACTION') 
       f=open("d:\\cihui\\pinyin.txt") 
       for i in f: 
              i=i.strip() 
              s=i.split(" ") 
              #query="insert into pinYin  (hanzi,pinYin) values(%s,%s)" % (s[1],s[0]) 
              query="insert into pinYin  (hanzi,pinYin) values('我','wo')" 
              #query = unicode(query,'gb2312') 
              cursor.execute(query) 
              print s[0]+"="+s[1] 
              cursor.execute('commit') 
              #conn.commit() 
except MySQLdb.Error, e: 
       print "error %d: %s" % (e.args[0], e.args[1]) 
        
cursor.close() 
conn.close()