python访问数据库文件_使用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