Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymysql.cursors
- import pymysqlpool
- from tkinter import *
- from tkinter import messagebox
- connection = pymysql.connect(host='127.0.0.1',
- user='root',
- password='',
- db='python',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor,
- autocommit=True)
- def display_full_name():
- # Подключение к БД
- counter = True
- x=1
- while counter:
- text = name.get()
- x=x+1
- try:
- with connection.cursor() as cursor:
- # Отправка SQL запроса
- sql = "INSERT INTO `scaner` (`number`) VALUES (%s)"
- cursor.execute(sql, (text))
- # Сохранение изменения
- connection.commit()
- finally:
- print('Отправленно!')
- if x>1000000:
- counter=False
- connection.close()
- root = Tk()
- root.title("Считыватель Штрих кодов и комит в БД")
- name = StringVar()
- name_label = Label(text="Введите штрихкод:")
- name_label.grid(row=0, column=0, sticky="w")
- name_entry = Entry(textvariable=name)
- name_entry.grid(row=0,column=1, padx=5, pady=5)
- message_button = Button(text="Отправить", command=display_full_name)
- message_button.grid(row=2,column=1, padx=5, pady=5, sticky="e")
- root.mainloop()
Add Comment
Please, Sign In to add comment