• 论文爬取(四)


    关键字存储查询

    #!/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


  • 相关阅读:
    scp上传服务器文件
    svn一次添加所有未添加的文件
    vue 去掉#和拼接参数
    vuex状态管理
    获取页面iframe里的元素
    angular 中ng-bind-html 、$scope服务
    心态崩了
    day 8
    day 7
    day6 angularjs学习
  • 原文地址:https://www.cnblogs.com/mumulailai/p/14912277.html
Copyright © 2020-2023  润新知