使用python访问文件，并存入数据库中

#使用python读取文件并存入数据库中。

#!/usr/local/bin/python
import os,MySQLdb
conn=MySQLdb.Connection('localhost','username','yourpasswd','test');
cur=conn.cursor();
cur.execute("drop table if exists new");
cur.execute("drop table if exists train");
cur.execute("create table new(id1 int(3) not null,id2 int(8),id3 int(50),primary key(id1,id2,id3))");
cur.execute("rename table new to train");
#cur.execute("alter table train add id4 datetime not null after");
targetLine="";
file=open('test.txt','r');
LineNo=0;
mLine=file.readline();
while 1:
 mLine=file.readline();
 if mLine=='/n' or mLine == '':
  break;
 parts=mLine.split(' ');
 numbers=[int(P) for P in parts];
 cur.execute("insert into txt (id1,id2,id3) values (%d,%d,%d)" % ( numbers[0],numbers[1],numbers[2]));
cur.execute("select * from txt where id1=96");
alldata=cur.fetchall();
# print mLine;
 print numbers;
# print LineNo;
#if(linecount==LineNo): targetLine=mLine;
#http://www.linuxidc.com/Linux/2007-12/9644.htm
#http://wenku.baidu.com/view/c375c000bed5b9f3f90f1c6a.html
#http://www.techweb.com.cn/news/2009-07-10/416053.shtml

#http://sislcb.blog.hexun.com/7133113_d.html