python链接数据库

python链接数据库

import pymysql
import time
conn = pymysql.connect(host='localhost',user='root',password='123456',port=3306,db='gps_base')
cursor = conn.cursor()
if(cursor.execute('select version()')):
    print('连接数据库成功，版本号：',cursor.fetchone())
else:
    print('数据库连接失败')
cursor = conn.cursor()
f = open('D:/gps4.txt', "r",encoding = 'utf-8')
time_start=time.time()
print('插入数据')
while True:
    line = f.readline()
    if line:
        line = line.strip('\n')
        cursor.execute("insert into gps_base11 values(%s)" % line)
        conn.commit()
    else:
        break
f.close()
conn.commit()
cursor.close()
time_end=time.time()
conn.close()
print('插入数据结束')
print('总耗时分钟数：',(time_end-time_start)/60)