物联网数据处理技术课程设计——基于python实现的智能图书馆借阅管理系统（OpenCV+MySQL）_图书管理系统python

再分割 ISBN 所在行：通过 split_col()函数将二值图像中的字符进行分割，并识别出每个字符。

def split_col(bin_img2):
    the_col = [0] * bin_img2.shape[1]
    for i in range(bin_img2.shape[0]):
        for j in range(bin_img2.shape[1]):
            if bin_img2[i, j] != 0:
                the_col[j] += 1
    a = [] num = 0
    for j in range(bin_img2.shape[1]):
        if the_col[j] >= 3 and num % 2 == 0:
            num += 1
            left_bound = j
            j += 2
        elif the_col[j] == 0 and num % 2 != 0:
            num += 1
            right_bound = j
            a.append((left_bound, right_bound))
            j += 2
    return a

def borrow_book(isbn_number):
    cursor = db.cursor()
    check_book_query = "SELECT * FROM book WHERE isbn = %s"          
    cursor.execute(check_book_query, (isbn_number,))
    book_exists = cursor.fetchone()
    if book_exists:
        print("书籍已找到！")
        borrow_choice = input("是否需要借阅该书籍？(y/n): ")
        if borrow_choice.lower() == 'y':
            borrower_name = input("请输入借阅者姓名: ")
            print('请输入借阅者姓名:',borrower_name)
            # 获取当前日期时间
            current_date_time = datetime.datetime.now()
            borrow_date = current_date_time.strftime('%Y-%m-%d %H:%M:%S')
            insert_query = "INSERT INTO borrow_records (isbn, borrower_name, borrow_date)VALUES (%s, %s, %s)" borrow_data = (isbn_number, borrower_name, borrow_date)
            cursor.execute(insert_query, borrow_data)
            db.commit()
            print("借阅记录已更新！")
    else:
        print("未找到该书籍，请检查 ISBN 码是否正确。")
    cursor.close()
    db.close()
borrow_book()

总而言之，以上期末项目虽还无法实际应用，但还是很好地训练和巩固了本人对于OpenCV库和搭建MySQL数据库的知识，以上代码非完整代码但所展示的模块代码经测试都可直接运行。