python进销存系统源码tkinter python仓库管理系统源码!
登录界面
主页

入库功能

卖出功能

销售数据查看

客户数据查看


设置密码修改


完整源码可以运行
网盘下载完整源码
链接：https://pan.baidu.com/s/1voJ1pcdvZEUqI0u6FFnR7A?pwd=w1t6
提取码：w1t6

MySQL+Python仓库管理系统 窗口可视化管理系统

这是连接MySQL数据库的小系统，可以实现在可视界面窗口对数据库进行操作

pycharm代码如下

// An highlighted block
import pymysql.cursors
from tkinter import ttk
import tkinter as tk
import tkinter.font as tkFont
from tkinter import *  # 图形界面库
import tkinter.messagebox as messagebox
import time

# 连接数据库
connect = pymysql.Connect(
    host='localhost',
    port=3306,
    user='root',
    passwd='dudu010112',# 这个是自己MySQL数据库密码
    db='仓库管理系统2', # 自己创建的数据库名称
    charset='utf8'
)
# 主页面
class StartPage:
    def __init__(self, parent_window):
        parent_window.destroy()  # 销毁子界面

        self.window = tk.Tk()
        self.window.title('仓库管理系统')
        self.window.geometry('700x600+70+50')

        def getTime():
            timeStr = time.strftime('%H:%M:%S')
            Rtime.configure(text=timeStr)
            self.window.after(1000, getTime)

        Rtime = Label(self.window, text='')
        Rtime.pack(pady=25)
        getTime()

        label = Label(self.window, text="仓库管理系统", font=("楷体", 30))
        label.pack(pady=10)  # pady=100 界面的长度

        # 按钮
        Button(self.window, text="入库操作", font=tkFont.Font(size=16), command=lambda: xinjian(self.window), width=20,
                height=2, fg='white', bg='gray').place(x=100, y=300)
        Button(self.window, text="仓库查询", font=tkFont.Font(size=16), command=lambda: cangkucha(self.window), width=20,
                height=2, fg='white', bg='gray').place(x=400, y=300)
        Button(self.window, text="出库操作", font=tkFont.Font(size=16), command=lambda: chuku(self.window), width=20,
                height=2, fg='white', bg='gray').place(x=100, y=400)
        Button(self.window, text="退出系统", font=tkFont.Font(size=16), command=self.window.destroy, width=20,
                height=2, fg='white', bg='gray').place(x=400, y=400)

        self.window.mainloop()

# 入库操作页面
class xinjian:
    def __init__(self, parent_window):
        parent_window.destroy()  # 销毁子界面

        self.window = tk.Tk()
        self.window.title('入库操作')
        self.window.geometry('700x600+70+50')

        self.top_title = Label(self.window, text='入库操作', bg='SkyBlue', font=('楷体', 20), width=70, height=2)
        self.top_title.pack()

        self.var_id = StringVar()
        self.var_name = StringVar()
        self.var_gender = StringVar()
        self.var_age = StringVar()
        self.var_gid = StringVar()
        self.right_top_id_label = Label(text="入库单号：", font=('楷体', 15)).pack(pady=15)
        self.right_top_id_entry = Entry(textvariable=self.var_id, font=('楷体', 15)).pack()

        self.right_top_name_label = Label(text="货物编号", font=('楷体', 15)).pack(pady=15)
        self.right_top_name_entry = Entry(textvariable=self.var_name, font=('楷体', 15)).pack()

        self.right_top_gender_label = Label(text="入库量", font=('楷体', 15)).pack(pady=15)
        self.right_top_gender_entry = Entry(textvariable=self.var_gender, font=('楷体', 15)).pack()

        self.right_top_gender_label = Label(text="货物名称", font=('楷体', 15)).pack(pady=15)
        self.right_top_gender_entry = Entry(textvariable=self.var_age, font=('楷体', 15)).pack()

        self.right_top_gender_label = Label(text="供应商编号", font=('楷体', 15)).pack(pady=15)
        self.right_top_gender_entry = Entry(textvariable=self.var_gid, font=('楷体', 15)).pack()

        self.right_top_button1 = ttk.Button(text='确定', width=20, command=self.new_row).pack(pady=30)
        self.right_top_button2 = ttk.Button(text='返回', width=20, command=self.back).pack()
        self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击

        self.id = []
        self.name = []
        self.gender = []
        self.age = []
        self.gid = []
        # 打开数据库连接
        db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
        cursor = db.cursor()  # 使用cursor()方法获取操作游标
        sql = "SELECT * FROM 入库"  # SQL 查询语句
        try:
            # 执行SQL语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            for row in results:
                self.id.append(row[0])
                self.name.append(row[1])
                self.gender.append(row[2])
                self.age.append(row[3])
                self.gid.append(row[4])
        except:
            print("Error: unable to fetch data")
            messagebox.showinfo('警告！', '数据库连接失败！')
        db.close()  # 关闭数据库连接

    def back(self):
        StartPage(self.window)  # 显示主窗口 销毁本窗口

    def new_row(self):

        if self.var_id.get() != '' and self.var_name.get() != '' and\
                self.var_gender.get() != '' and self.var_age.get() != '' and self.var_gid.get() != '':
            db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
            cursor = db.cursor()  # 使用cursor()方法获取操作游标
            sql = "INSERT INTO 入库(入库单号,货物编号,入库量,货物名称,供应商编号)  VALUES ('%s', '%s','%s','%s','%s')" % \
                    (self.var_id.get(), self.var_name.get(),self.var_gender.get(), self.var_age.get(),self.var_gid.get())  # SQL 插入语句
            try:
                cursor.execute(sql)  # 执行sql语句
                db.commit()  # 提交到数据库执行
                messagebox.showinfo('提示！', '入库成功！')
            except:
                db.rollback()  # 发生错误时回滚
                messagebox.showinfo('警告！', '数据库连接失败！')
            db.close()  # 关闭数据库连接
        else:
            messagebox.showinfo('提示！', '请填写入库信息')

# 仓库清单
class cangkudan:
    def __init__(self, parent_window):
        parent_window.destroy()  # 销毁子界面
        self.window = tk.Tk()
        self.window.title('仓库清单')
        self.window.geometry('1200x600+70+50')
        db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
        cursor = db.cursor()  # 使用cursor()方法获取操作游标
        sql = "SELECT * FROM 仓库"  # SQL 语句
        try:
            cursor.execute(sql)  # 执行sql语句
            results = cursor.fetchall()
            for row in results:
                self.name = '货物名称:' + row[0]
                self.id = '货物编号:' + row[1]
                self.num = '货物数量' + row[2]
                self.gid = '供应商编号' + row[3]

                db.commit()  # 提交到数据库执行

                Label(self.window, text=self.id + "\t" + self.name + "\t" + self.num+"\t"+
                                        self.gid ,font=('楷体', 18)).pack(pady=5)

        except:
            db.rollback()  # 发生错误时回滚
            messagebox.showinfo('警告！', '数据库连接失败！')
        db.close()  # 关闭数据库连接


        self.right_top_button4 = ttk.Button(text='返回', width=20, command=self.back).pack()
        self.window.protocol("WM_DELETE_WINDOW", self.back)
    def back(self):
        cangkucha(self.window)

# 仓库查询
class cangkucha:
    def __init__(self, parent_window):
        parent_window.destroy()  # 销毁子界面
        self.window = tk.Tk()
        self.window.title('库存查询')
        self.window.geometry('700x600+70+50')

        self.student_id = StringVar()
        self.id = '货物编号:' + ''
        self.name = '货物名称:' + ''
        self.num = '货物数量:' + ''
        self.gid = '供应商编号:' + ''

        Button(self.window, text="库存清单", font=tkFont.Font(size=12), command=lambda: cangkudan(self.window), width=20,
               height=2, fg='white', bg='gray').place(x=20, y=70)
        self.right_top_name_label = Label(text="库存查询", font=('楷体', 15)).pack(pady=15)
        self.right_top_name_entry = Entry(textvariable=self.student_id, font=('楷体', 15)).pack(pady=30)

        self.right_top_button3 = ttk.Button(text='确定', width=20, command=self.new_row).pack(pady=30)
        self.right_top_button4 = ttk.Button(text='返回', width=20, command=self.back).pack()
        self.window.protocol("WM_DELETE_WINDOW", self.back)

        # 打开数据库连接
        db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
        cursor = db.cursor()  # 使用cursor()方法获取操作游标
        sql = "SELECT * FROM 仓库 WHERE 货物编号 = '%s'" % (self.student_id.get()) # SQL 查询语句
        try:
            # 执行SQL语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            for row in results:
                self.id = '仓库编号:' + row[0]
                self.name = '货物名称:' + row[1]
                self.num = '货物数量:' + row[2]
                self.gid = '供应商编号:' + row[3]
        except:
            print("Error: unable to fetch data")
        db.close()  # 关闭数据库连接

    def back(self):
        StartPage(self.window)

    def new_row(self):

        if self.student_id.get() != '':
            db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
            cursor = db.cursor()  # 使用cursor()方法获取操作游标
            sql = "SELECT * FROM 仓库 where 货物编号 = '%s'" % (self.student_id.get())  # SQL 插入语句
            try:
                cursor.execute(sql)  # 执行sql语句
                results = cursor.fetchall()
                for row in results:
                    self.id = '仓库编号:' + row[0]
                    self.name = '货物名称:' + row[1]
                    self.num = '货物数量:' + row[2]
                    self.gid = '供应商编号:' + row[3]
                db.commit()  # 提交到数据库执行



                label = tk.Label(self.window, text='货物信息查看', bg='SkyBlue', font=('楷体', 20), width=70, height=2)
                label.pack(pady=20)
                Label(self.window, text=self.id, font=('楷体', 18)).pack(pady=5)
                Label(self.window, text=self.name, font=('楷体', 18)).pack(pady=5)
                Label(self.window, text=self.num, font=('楷体', 18)).pack(pady=5)
                Label(self.window, text=self.gid, font=('楷体', 18)).pack(pady=5)
                Button(self.window, text="返回首页", width=8, font=tkFont.Font(size=12), command=self.back_1).pack(
                        pady=150)
                self.window.protocol("WM_DELETE_WINDOW", self.back_1)
                self.window.mainloop()
            except:
                db.rollback()  # 发生错误时回滚
                messagebox.showinfo('提示', '数据库连接失败！')
            db.close()  # 关闭数据库连接
        else:
            messagebox.showinfo('提示', '请填写货物信息！')

    def back_1(self):
        cangkucha(self.window)

# 出库
class chuku:
    def __init__(self, parent_window):
        parent_window.destroy()  # 销毁子界面

        self.window = tk.Tk()
        self.window.title('出库表')
        self.window.geometry('700x600+70+50')

        self.top_title = Label(self.window, text='出库', bg='SkyBlue', font=('楷体', 20), width=70, height=2)
        self.top_title.pack()

        self.var_id = StringVar()  # 声明
        self.var_name = StringVar()  # 声明
        self.var_gender = StringVar()  # 声明
        self.var_age = StringVar()  # 声明
        self.right_top_id_label = Label(text="出库单号", font=('楷体', 15)).pack(pady=15)
        self.right_top_id_entry = Entry(textvariable=self.var_id, font=('楷体', 15)).pack()
        
        self.right_top_name_label = Label(text="货物编号", font=('楷体', 15)).pack(pady=15)
        self.right_top_name_entry = Entry(textvariable=self.var_name, font=('楷体', 15)).pack()

        self.right_top_gender_label = Label(text="出库量", font=('楷体', 15)).pack(pady=15)
        self.right_top_gender_entry = Entry(textvariable=self.var_gender, font=('楷体', 15)).pack()

        self.right_top_gender_label = Label(text="出库货物", font=('楷体', 15)).pack(pady=15)
        self.right_top_gender_entry = Entry(textvariable=self.var_age, font=('楷体', 15)).pack()

        self.right_top_button1 = ttk.Button(text='确定', width=20, command=self.new_row).pack(pady=30)
        self.right_top_button2 = ttk.Button(text='返回', width=20, command=self.back).pack()
        self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击

        self.id = []
        self.name = []
        self.gender = []
        self.age = []
        # 打开数据库连接
        db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
        cursor = db.cursor()  # 使用cursor()方法获取操作游标
        sql = "SELECT * FROM 出库"  # SQL 查询语句
        try:
            # 执行SQL语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            for row in results:
                self.id.append(row[0])
                self.name.append(row[1])
                self.gender.append(row[2])
                self.age.append(row[3])
        except:
            print("Error: unable to fetch data")
            messagebox.showinfo('提示', '数据库连接失败！')
        db.close()  # 关闭数据库连接

    def back(self):
        StartPage(self.window)  # 显示主窗口 销毁本窗口

    def new_row(self):
        if self.var_id.get() != '' and self.var_name.get() != '':
            db = pymysql.connect("localhost", "root", "dudu010112", "仓库管理系统2")
            cursor = db.cursor()  # 使用cursor()方法获取操作游标
            sql = "INSERT INTO 出库(出库单号,货物编号,出库量,出库货物)  VALUES ('%s', '%s','%s', '%s')" % \
                    (self.var_id.get(), self.var_name.get(),self.var_gender.get(),self.var_age.get())  # SQL 插入语句
            try:
                cursor.execute(sql)  # 执行sql语句
                db.commit()  # 提交到数据库执行
                messagebox.showinfo('提示！', '出库成功！')
            except:
                db.rollback()  # 发生错误时回滚
                messagebox.showinfo('警告！', '数据库连接失败！')
            db.close()  # 关闭数据库连接
        else:
            messagebox.showinfo('警告！', '填写出库信息')

if __name__ == '__main__':
        window = tk.Tk()
        StartPage(window)

界面样式
主界面

功能可以自己添加


功能界面不在一一展示

还有MySQL对应文件 这里我不太会发 可以私信我，也可以自己按照对数据库的连接自己做，很简单的，如果觉得有用请点一个赞吧，谢谢

注意：在Linux环境运行

代码

#!/usr/bin/env python
# -*- coding:utf-8 -*-
# @FileName  :store_system.py
# @Time      :2020/3/3 23:10
# @Author    :anqixiang
# @Function  :模拟仓库管理系统
'''
1.商品清单保存在/opt/shop_info.txt文件中
2.可以查看、增加、删除商品和修改商品价格
3.在任何位置输入b返回上级菜单，输入q退出
'''
import os
from subprocess import run

#输出颜色
def cecho(num,content):
    print('\033[%sm%s\033[0m' %(num, content))

#选b返回上一层，选q退出
def choice_action(action):
    while action != "b":
        if action == "q":
            exit(0)
        else:
            break
    return action

#展示商品
def view_shop(file_name):
    commodity = []              #所有商品保存到该列表
    if not os.path.isfile(file_name):
        os.mknod(file_name)
    else:
        with open(file_name, 'r') as file:
            for each in file:
                commodity.append(each.splitlines())
    if len(commodity) == 0:
        cecho(35, "货仓空空如也，请速速添加商品！")
        #打印商品信息
    else:
        print('%-10s%-8s%-12s' % ('序号', '名字', '价格'))
        for index, value in enumerate(commodity):
            alist = value[0].split(":")         #把字符串转成列表，以“:”分割
            print('%-12s%-10s%-8s' % (index + 1, alist[0], alist[1]))
    return commodity

#增加商品,每增加一个就保存到文件
def add_shop(file_name):
    while True:
        add_dict = {}
        shop_name = input(">>>输入商品名:").strip()
        if choice_action(shop_name) == "b":
            break
        shop_price = input(">>>输入商品价格(元):").strip()
        if choice_action(shop_price) == "b":
            break
        elif shop_price.isdigit():
            add_dict[shop_name] = shop_price        #商品名作key，价格作值，存入字典
            for i in add_dict:
                with open(file_name, 'a+')as file:
                    file.write('%s:%s\n' % (i, add_dict[i]))
                    print("\033[92m%s存入成功\033[0m" % shop_name)
                view_shop(file_name)
        else:
            cecho(31, "Invalid Option")

#删除商品
def del_shop(file_name):
    menu_info = "商品清单"
    print(menu_info.center(26,'-'))
    commodity = view_shop(file_name)
    while True:
        del_num = input(">>>商品序号:").strip()
        if choice_action(del_num) == "b":
            break
        elif del_num.isdigit():
            del_num = int(del_num)
            rc = run("sed -i '/%s/d' %s" % (commodity[del_num-1][0], file_name), shell=True)
            if not rc.returncode:
                cecho(92, "删除成功")
            else:
                cecho(31,"删除失败")
            view_shop(file_name)
        else:
            cecho(31, "Invalid Option")

#修改商品价格
def update_price(file_name):
    menu_info = "商品清单"
    print(menu_info.center(26,'-'))
    commodity = view_shop(file_name)
    while True:
        update_num = input(">>>商品序号:").strip()
        if choice_action(update_num) == "b":
            break
        elif update_num.isdigit():
            update_num = int(update_num)
        else:
            cecho(31, "Invalid Option")

        new_price = input(">>>新的价格(元):").strip()
        if choice_action(new_price) == "b":
            break
        elif new_price.isdigit():
            new_price = int(new_price)
            alist = commodity[update_num-1][0].split(':')   #将商品名和价格转成一个列表,如['coffee', '30']
            alist[1] = new_price        #修改价格
            rc = run("sed -i '/%s/c %s:%s' %s" % (alist[0], alist[0], alist[1], file_name), shell=True)
            if not rc.returncode:
                cecho(92, "修改成功")
            else:
                cecho(31,"修改失败")
            view_shop(file_name)
        else:
            cecho(31, "Invalid Option")

#主程序
def show_menu():
    cmds = {'0': view_shop, '1': add_shop, '2': del_shop, '3': update_price}
    prompt = '''(0)查看商品信息
(1)增加商品
(2)删除商品
(3)修改商品价格
(b)返回上级菜单
(q)退出
输入(0/1/2/3/b/q):'''
    fname='/opt/shop_info.txt'      #保存商品信息
    while True:
        choice = input(prompt).strip()
        if choice not in '0123bq':
            cecho(31, "Invalid Option")
        elif choice_action(choice) == "b":
            cecho(31, "已经是第一级菜单")
        else:
            cmds[choice](fname)

if __name__ == "__main__":
    try:
        show_menu()
    except KeyboardInterrupt as e:
        print()
        cecho(31, "非正常退出,请下次输入字母q进行退出！")

效果图