cihui.py

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

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