pinyin.py

python_MySQL之间的几个小例子。对于python连接的数据库

#!/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()