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

#!/usr/bin/python 
import MySQLdb  
#导入python2.4-mysqldb模块，以提供操作mysql的接口 
createTable=""" 
DROP TABLE IF EXISTS `cihui`; 
create table ciHui( 
 id int primary key auto_increment not null, 
 ciHui varchar(50) not null, 
 Len tinyint not null, 
 ciXing char(1), 
 priority float default 1.0) 
 TYPE=MyISAM; 
""" 
db_user = "root"  
db_pw = "myDBpass"  
conn = MySQLdb.connect("localhost", db_user, db_pw ,"xpower")  
cur= conn.cursor() 
sFileName=["cihui1.txt","cihui2.txt","cihui3.txt","cihui4.txt","cihui5+.txt"] 
for sf in sFileName: 
	fileHandle=open(sf) 
	for i in fileHandle: 
		i=i.strip() 
		s=i.split(" ") 
		for ss in s: 
			ss=ss.strip() 
			cur.execute("""insert into cihui(cihui,Len) values(%s,%s)""",(ss,len(ss))) 
			print ss+str(len(ss)) 
			conn.commit() 
	fileHandle.close() 
cur.close() 
conn.close()