python增量爬虫_python增量爬虫

import pymysql

def insert_db(db_table, issue, time_str, num_code):

host = '127.0.0.1'

user = 'root'

password = 'root'

port = 3306

db = 'lottery'

data_base = pymysql.connect(host=host, user=user, password=password, port=port, db=db)

cursor = data_base.cursor()

try:

sql = "INSERT INTO %s VALUES ('%s','%s','%s')" % (db_table, issue, time_str, num_code)

cursor.execute(sql)

data_base.commit()

except ValueError as e:

print(e)

data_base.rollback()

finally:

cursor.close()

data_base.close()

def select_db(issue, db_table):

host = '127.0.0.1'

user = 'root'

password = 'root'

port = 3306

db = &#