初级程序,没有用mysql。只导入了pandas库。
附上全代码与程序框架
import pandas as pd
goods_info=pd.DataFrame(None,columns=['id','sname','kcl','xsl','category'])
#goods_info= pd.read_excel(r'D:\VRP\logi_node.xlsx')
goods_info.set_index('id')
def add1(temp1,temp2,temp3,temp4,temp5): #1增加信息
goods_info.loc[temp1,'id']=temp1
goods_info.loc[temp1,'sname']=temp2
goods_info.loc[temp1,'kcl']=temp3
goods_info.loc[temp1,'xsl']=temp4
goods_info.loc[temp1,'category']=temp5
name=goods_info.loc[temp1,'sname']
print(f"{(name)}信息增加成功\n")
def delete1(temp): #2删除信息
name=goods_info.loc[temp,'sname']
goods_info.drop(index = temp, inplace = Tru