• 论文爬取(四)


    关键字存储查询

    #!/usr/bin/python
    # -*- coding: UTF-8 -*-
    import traceback

    import pymysql

    import pymysql.cursors

    import time
    import Keyword


    # 获得conn cursor
    def get_conn():

    # 打开数据库连接
    conn = pymysql.connect(host='localhost',
    user='root',
    passwd='123',
    db='text3',
    port=3306,
    charset='utf8')

    # 创建游标,默认是元组型
    cursor = conn.cursor()
    return conn, cursor


    # 关闭conn cursor
    def close_conn(conn, cursor):
    if cursor:
    cursor.close()
    if conn:
    conn.close()


    def query(sql, *args):
    conn, cursor = get_conn()
    cursor.execute(sql, args)
    res = cursor.fetchall()
    close_conn(conn, cursor)
    return res


    def select_lunwenj(str, value):
    args = value
    sql = "select * from xiangxi where "+str+" = "+args
    # print(sql)
    res = query(sql)
    return res


    def select_lunwenm(str):
    # args = '%%' + value + '%%'
    # sql = "select * from xiangxi where " + str + " like '%s'" % args
    sql = "select * from xiangxi where " + str
    print(sql)
    res = query(sql)
    return res


    def select_ab():
    sql = "select abstract from xiangxi "
    res = query(sql)
    return res


    def insert_key(word, count):
    cursor = None
    conn = None
    try:
    print(f"{time.asctime()}开始插入历史数据")
    conn, cursor = get_conn()
    sql = "insert into keyword values(%s,%s)"
    cursor.execute(sql, [word, count]) # %Y-%m-%d %H:%M:%S

    conn.commit()
    print(f"{time.asctime()}插入历史数据完毕")
    except:
    traceback.print_exc()
    finally:
    close_conn(conn, cursor)

    def select_key():
    sql = "select * from keyword "
    res = query(sql)
    return res


  • 相关阅读:
    字串变换
    重建道路
    poj3278 Catch That Cow
    机器人搬重物
    [HNOI2004]打鼹鼠
    曼哈顿距离
    邮票面值设计
    poj1101 The Game
    解决了一个堆破坏问题
    模型资源从无到有一条龙式体验
  • 原文地址:https://www.cnblogs.com/mumulailai/p/14912277.html
Copyright © 2020-2023  润新知